effective data modelling for effective data visualization
play

Effective Data Modelling for Effective Data Visualization DV07 Eva - PowerPoint PPT Presentation

Effective Data Modelling for Effective Data Visualization DV07 Eva Kelty Consider Patients diagnosed with Cerebral Paresis experiencing Pain in thigh, what aid are they using? At the same time they are experiencing pain? What other pain


  1. Effective Data Modelling for Effective Data Visualization DV07 Eva Kelty

  2. Consider… Patients diagnosed with Cerebral Paresis experiencing Pain in thigh, what aid are they using? At the same time they are experiencing pain? What other pain are they experiencing?

  3. Understanding Cause and Effect

  4. A Patient-Centric Approach

  5. Content • Effective Visualization • Information Modelling • Exploiting the Model • Case Study – A Collaboration Project • More Examples • Conclusion

  6. What does this mean? EFFECTIVE VISUALIZATION Desired Effect

  7. Purpose of Visualization • Examining relationships • Explore differences • Visualizing patterns over time • Identify and explore outliers • Study subgroups Longitudinal vs Cross-Sectional Aggregate vs Individual

  8. Multi-Purpose Solution Data Static Presentation Harmonized Guided Analytics Standardized Self-Service Exploration Contextualized Flexibility Objectivity

  9. For the User • Data access • Proper functionality • Understandable data

  10. INFORMATION MODELLING Objective data in context as a prerequisite for efficient visualization

  11. Harmonization and Standardization • Naming and synonyms • Data type and content scale • Placement on timeline • Comparable values (units) and language • Standard value lists • Classification relative reference • Original values • Notes • Content validity

  12. Capish Ontology - Contextualization Hospital Health Center Private Doctor Mobile Device 体重 Date = 2010-01-05 Datum = 2015-10-12 Weight Weight = 150 pounds Vikt = 72 kg Height = 69.29 inches Sys BP = 140 mm Hg Systolic BP = 120 mmHg Dia BP = 110 mm Hg Diastolic BP = 90 mmHg Position = Liggande Position = Sitting Capish Ontology • Domain and Concept • Specification • Relations • Roles • Metadata and data

  13. Medical Messages as Holons Capish Ontology Systolic Blood Pressure = 140 mmHg Diastolic Blood Pressure = 110 mmHg Body Weight = 72 kg Body Position = Lying down Date = 2015-10-12 Date = 2015-10-12 Body Blood Weight Pressure Body Weight = 68 kg Systolic Blood Pressure = 120 mmHg Body Weight.Original = 150 pounds Diastolic Blood Pressure = 90 mmHg Date = 2010-01-05 Body Position = Sitting Date = 2010-01-05 Body Height = 176 cm Body Body Height.Original = 69.29 inches Height Date = 2010-01-05

  14. One Holon in XML-format Body Weight Body Weight = 68 kg Body Weight.Original = 150 pounds Date = 2010-01-05

  15. Holons are for Man and Machine Body Weight Body Weight = 68 kg Body Weight.Original = 150 pounds Date = 2010-01-05

  16. An Ontology Modelling the Real World Formal representation of a knowledge domain describing - its entities - events and processes - the relationships connecting these entities, events and processes Body Weight Body Weight = 68 kg Benefits Body Weight.Original = 150 pounds Date = 2010-01-05 Patient 1 - To share common understanding of the structure of Patient 2 information among people or software Patient 3 - To enable reuse of domain knowledge - To make domain assumptions explicit

  17. Data Quality Intrinsic Contextual Representational Accessible Accessibility Value –added Interpretability Accuracy Access security Relevance Ease of understanding Believability Timeliness Representational consistency Objectivity Completeness Concise representation Reputation Appropriate amount Data Model data Wang et al, J. Manage. Inf. Syst. 12, no. 4

  18. EXPLOITING THE MODEL

  19. Opportunities in Visualization • Application and graphics fit for different user groups • Graphics based on data • Selection of fields • Free-text search with a context • Exploration from different perspectives • Full picture of a patient

  20. Database Structure S 1 P P 1 2 V V V V 1 2 1 2 H H H H W W W W 1 1 2 2 2 2 1 1 20

  21. Reflective Logic New paradigm on how to effectively query and retrieve information from datasets in an easy and flexible way Without reflection With reflection in P S S 1 1 P P P P 1 2 1 2 V V V V V V V V 1 2 1 2 1 2 1 2 H H H H H H H H W W W W W W W W 1 2 1 2 1 2 1 2 1 2 1 2 1 2 1 2 = Holon matching query criteria = Holon in results = Reflection point Holon = Holon not in results 21

  22. CASE STUDY - Follow-up surveillance program for people with cerebral palsy (CP) - National Quality Register started in 1994 - Cooperative project between the pediatric orthopedics and child habilitation centers

  23. Step 1: Ensure Accuracy Data Quality Control  Duplicate entries  Conflicting answers Ensure  Comments in result fields accuracy  Differently spelled values  Dates

  24. Step 2: Make Comparable Harmonization and Standardization  Data was standardized to ISO, ICD10 etc. • • translated to a common language Make comparable • compared to references  A uniform terminology was used  Common measurement units were ensured  Coded values were mapped to understandable terms

  25. Step 3: Set Structure Contextualisation  Data was grouped into well-known concepts • • appended with metadata Set structure  Time was related to events for individual patients  Episodes were created  Summaries were created

  26. For Different Users

  27. Self-Service – Graphics and Field Selection

  28. Free-Text Search in Context

  29. Perspectives

  30. Full Patient Record

  31. MORE Patients on study drug in phase III program, with a specific AE, e.g. Headache, what medications are they EXAMPLES taking? At the time of the AE or ever? Before or after? What patients have ever had cancer? Identify similar patients, e.g. responders in same age group and sex, with same AE. Toggle between patients and explore differences. Find an outlier, and have immediate access to all their data.

  32. Conclusion: Achieving the Desired Effect • Understand the purpose • Ensure access to quality data • Apply effective data model • Exploit the model with appropriate technology

  33. Thank You! Contact information: eva.kelty@capish.com

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend


More recommend