DIGITAL DASHBOARD FOR MAPPING PATIENT DISTRIBUTIONS
Author(s)
Saunders WB1, Blanchette CM2, Satish Kumar H3, Jones PR4
1IBM Watson Health - Explorys, Charlotte, NC, USA, 2University of North Carolina, Charlotte, NC, USA, 3University of North Carolina at Charlotte, Charlotte, NC, USA, 4IBM Security Services, Cornelius, NC, USA
OBJECTIVES: Advances have been made in collecting and aggregating health care data from multiple data sources, however there has been less research on effective graphical methods that efficiently and nimbly describe mapped data. A flexible system can enable the user to see changes based on disease area and/or demographic factors in real time with contextualized data. In this study we examine disease distributions at a state and 3-digit zip code level. This is achieved by using an interactive dashboard which allows the user to select the type of view (State or Zip3) and choose across multiple diseases. METHODS: To create a dashboard with geographical data required specific geo location data from the US census department. Disease-specific patient counts are extracted from the IBM Explorys database. Additional variables used include the total patient count irrespective of the disease (from Explorys) and the total population by zip code (from US Census). The latest version of ‘Tableau desktop Professional’ was used, and the dashboard can be hosted on tableau server, with the appropriate credentials, or one can view the dashboard on a hand-held device. RESULTS: The toolkit developed using tableau gives an insight into the number of patients at the state and 3-digit zip code level across many common diseases, including Anxiety, CAD (Coronary Heart Disease), Hyperlipidemia, Hypertension, Hypothyroidism, Obesity, Pain, Respiratory/Chest Problems, Vitamin D deficiency and Diabetes. The interactive dashboard has a main screen giving the user the option to view graphically the data by 3-digit zip code, Region, and State, as well as estimated counts for each. CONCLUSIONS: Interactive digital dashboards are powerful tools and can be leveraged to effectively describe patient-level data. This Tableau dashboard can be presented "live" during the presentation, and offers a platform to build additional views using other data sources.
Conference/Value in Health Info
2018-11, ISPOR Europe 2018, Barcelona, Spain
Value in Health, Vol. 21, S3 (October 2018)
Code
PRM90
Topic
Real World Data & Information Systems
Topic Subcategory
Reproducibility & Replicability
Disease
Multiple Diseases