![Page 1: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/1.jpg)
Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate
Multicenter Sleep ResearchRic Miller
COMET - Director of Informatics
Stanford Sleep Medicine Center
![Page 2: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/2.jpg)
Conflict of Interest Disclosures for SpeakersX 1. I do not have any relationships with any entities producing, marketing, re-
selling, or distributing health care goods or services consumed by, or used on, patients, OR
2. I have the following relationships with entities producing, marketing, re-selling, or distributing health care goods or services consumed by, or used on, patients.
Type of Potential Conflict Details of Potential Conflict
Grant/Research Support
Consultant
Speakers’ Bureaus
Financial support
Other
3. The material presented in this lecture has no relationship with any of these potential conflicts, OR
4. This talk presents material that is related to one or more of these potential conflicts, and the following objective references are provided as support for this lecture:
1.
2.
3.
![Page 3: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/3.jpg)
COMET
Comparative Outcomes Management with Electronic data Technology
supported by AHRQ Grant number 1R01HS019738
![Page 4: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/4.jpg)
COMET
1. Multicenter research (Stanford, University of Pennsylvania, University of Wisconsin‐Madison, Harvard) randomized trial comparing obstructive sleep apnea treatments: positive airway pressure (PAP) vs. oral appliance (OA) therapy in 196 randomized participants
2. Informatics platform that facilitates electronic data management for multicenter clinical trials, enabling the generation of meaningful, well‐defined outcomes structured for use with business intelligence (BI) tools
![Page 5: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/5.jpg)
Self-Service Business Intelligence
• Business intelligence (BI) is a set of tools and techniques used to transform datasets into information that is frequently visual in nature.
• “Self-service” refers to the ability of researchers to create their own data visualizations after a dataset has been provided which facilitates low cost, high quality clinical analytics.
• Interactive data visualizations, produced with BI tools are useful in bringing the data closer to the researcher and providing unique insights into the data but require standardized methods to be effective.
![Page 6: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/6.jpg)
Self-Service Business Intelligence
1. Data Pipeline
2. Terminology
3. Data Visualization
![Page 7: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/7.jpg)
Data Pipeline
![Page 8: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/8.jpg)
Data Pipeline
![Page 9: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/9.jpg)
ETL (Extract Transform Load)
Flat File Star Schema
Data Pipeline
RelationalDatabase
ETL (Extract Transform Load)
![Page 10: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/10.jpg)
Terminology
![Page 11: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/11.jpg)
TerminologyHow many SDID by VisitName?
-vs-How many patients by visit?
![Page 12: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/12.jpg)
Terminology
![Page 13: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/13.jpg)
Data Visualization
• Dashboards• KPI (Key Performance Indicators)• Printable Reports• Interactive Data Visualizations
![Page 14: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/14.jpg)
Data Visualization
![Page 15: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/15.jpg)
Data Visualization
![Page 16: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/16.jpg)
Data Visualization
![Page 17: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/17.jpg)
Data Visualization
![Page 18: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/18.jpg)
Data Visualization
Dimensions - Filters Facts - Measures
![Page 19: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/19.jpg)
Data Visualization
![Page 20: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/20.jpg)
Data Visualization
![Page 21: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/21.jpg)
Data Visualization
![Page 22: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/22.jpg)
Data Visualization
![Page 23: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/23.jpg)
Data Visualization
![Page 24: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/24.jpg)
Data Visualization
![Page 25: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/25.jpg)
Data Visualization
![Page 26: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/26.jpg)
![Page 27: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/27.jpg)
COMET Hub
![Page 28: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/28.jpg)
Acknowledgements
• Authors: Miller RA, Nichols, DA, Griffin KS, Benca RM, Kuna ST, Mignot E, Pack AI, Redline S, Yang P, Hyde, PR, Walsh JK, Kushida, CA
• COMET: Supported by AHRQ Grant number 1R01HS019738, Clete Kushida, M.D., Ph.D. ,PI
• SMART DOCS: Supported by PCORI, Clete Kushida, M.D., Ph.D. ,PI
• COMET Hub: Pending evaluation by AHRQ for support, Miller RA, PI
![Page 29: Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate Multicenter Sleep Research Ric Miller COMET - Director of Informatics](https://reader035.vdocuments.us/reader035/viewer/2022081519/56649dd45503460f94acb9aa/html5/thumbnails/29.jpg)
Using Self-Service Business Intelligence Tools and Data Visualizations to Facilitate
Multicenter Sleep ResearchRic Miller
COMET - Director of Informatics
Stanford Sleep Medicine Center