Sifting Through Lines, Events, and Trees: Stories of EHR Visual - - PDF document

▶
sifting through lines events and trees stories of ehr
SMART_READER_LITE
LIVE PREVIEW

Sifting Through Lines, Events, and Trees: Stories of EHR Visual - - PDF document

Aug 29, 2022 159 likes •262 views

5/28/2014 Sifting Through Lines, Events, and Trees: Stories of EHR Visual Exploratory Analysis Christopher Herrick, Vivian Gainer, Alyssa Goodson, Shawn Murphy Victor Castro, Kay Mahamaneerat, Yanbing Wang, and Taowei David Wang

slide-1
SLIDE 1

5/28/2014 1

Sifting Through Lines, Events, and Trees: Stories of EHR Visual Exploratory Analysis

Christopher Herrick, Vivian Gainer, Alyssa Goodson, Shawn Murphy Victor Castro, Kay Mahamaneerat, Yanbing Wang, and Taowei David Wang tdwang@partners.org May 29, 2014

  • Research Information Services & Computing (Shawn Murphy)
  • Curate clinical data for research
  • IRB-approved, HIPAA-compliant, auditable
  • i2b2, RPDR, mi2b2
slide-2
SLIDE 2

5/28/2014 2

  • Research Information Services & Computing
  • Curate clinical data for research
  • IRB-approved, HIPAA-compliant, auditable
  • i2b2, RPDR, mi2b2

Dynamic Query Lifelines2 EventFlow Treemap + Piccolo

  • Mediated access to clinical PACS
  • Cloud storage
  • Download to local machines
  • Research Information Services & Computing
  • Curate clinical data for research
  • IRB-approved, HIPAA-compliant, auditable
  • i2b2, RPDR, mi2b2

All data on this slide is de-identified

slide-3
SLIDE 3

5/28/2014 3

Dynamic Query

All data on this slide is de-identified

  • Research Information Services & Computing
  • Curate clinical data for research
  • IRB-approved, HIPAA-compliant, auditable
  • i2b2, RPDR, mi2b2

Filter All data on this slide is de-identified

Dynamic Query

  • Research Information Services & Computing
  • Curate clinical data for research
  • IRB-approved, HIPAA-compliant, auditable
  • i2b2, RPDR, mi2b2
slide-4
SLIDE 4

5/28/2014 4

Data Extract, Transform, Load (ETL)

  • Searching for the right patients for a comparison is difficult
  • SQL is complex, prone to mistakes
  • Mistakes are hard to spot

Lifelines2

Data ETL: Glargine & Pancreatic Cancer

  • Searching for the right patients for a comparison is difficult
  • SQL is complex, prone to mistakes
  • Mistakes are hard to spot

Order of Cancer and Glargine is not enforced. Nor is the time taken from Glargine to Cancer taken into account.

cancer glargine

Lifelines2

All data on this slide is simulated (i.e. made up) c

slide-5
SLIDE 5

5/28/2014 5

All data on this slide is simulated (i.e. made up)

Data ETL: Glargine & Pancreatic Cancer

  • Searching for the right patients for a comparison is difficult
  • SQL is complex, prone to mistakes
  • Mistakes are hard to spot

spike

Lifelines2

Order of Cancer and Glargine is not enforced. Nor is the time taken from Glargine to Cancer taken into account.

cancer glargine

c

Diabetes Treatment Progression: SGLT-2

  • Type 2 diabetes mellitus (DM2) has complex causes and treatments
  • New class of diabetes drug: SGLT-2
  • Interested in its usage, in particular:
  • Characteristics of patients on different drug classes
  • Demographics, measurements before/after taking a drug class, etc.
  • What drugs were used prior to prescribing SGLT-2
  • EventFlow
  • Phenotypes of patients on SGLT-2 vs other diabetes patients
  • Treemap
slide-6
SLIDE 6

5/28/2014 6

EventFlow

SGLT-2 Years Before 2 4 6 8 All data on this slide is simulated (i.e. made up)

EventFlow

SGLT-2 Years Before 2 4 6 8 All data on this slide is simulated (i.e. made up)

slide-7
SLIDE 7

5/28/2014 7

Comparing Large Trees: Diabetes Drugs

  • Two populations of patients (e.g. CGLT-2 vs Other)
  • Hierarchically organized diagnosis code (e.g. ICD9)

(SGLT-2) (Other) All data on this slide is simulated (i.e. made up)

Treemap+ Piccolo

All data on this slide is simulated (i.e. made up)

slide-8
SLIDE 8

5/28/2014 8

All data on this slide is simulated (i.e. made up)

Lifelies2 Treemap+ Piccolo

Thank you

tdwang@partners.org