Visual Analytics to Leverage Anesthesia Electronic Health Record

被引:4
|
作者
Kahn, Ronald A. [1 ]
Gal, Jonathan S. [1 ]
Hofer, Ira S. [1 ]
Wax, David B. [1 ]
Villar, Joshua, I [1 ]
Levin, Mathew A. [1 ]
机构
[1] Icahn Sch Med Mt Sinai, Dept Anesthesiol Perioperat & Pain Med, New York, NY 10029 USA
来源
ANESTHESIA AND ANALGESIA | 2022年 / 135卷 / 05期
基金
美国国家卫生研究院;
关键词
DASHBOARDS;
D O I
10.1213/ANE.0000000000006175
中图分类号
R614 [麻醉学];
学科分类号
100217 ;
摘要
BACKGROUND: Visual analytics is the science of analytical reasoning supported by interactive visual interfaces called dashboards. In this report, we describe our experience addressing the challenges in visual analytics of anesthesia electronic health record (EHR) data using a commercially available business intelligence (BI) platform. As a primary outcome, we discuss some performance metrics of the dashboards, and as a secondary outcome, we outline some operational enhancements and financial savings associated with deploying the dashboards. METHODS: Data were transferred from the EHR to our departmental servers using several parallel processes. A custom structured query language (SQL) query was written to extract the relevant data fields and to clean the data. Tableau was used to design multiple dashboards for clinical operation, performance improvement, and business management. RESULTS: Before deployment of the dashboards, detailed case counts and attributions were available for the operating rooms (ORs) from perioperative services; however, the same level of detail was not available for non-OR locations. Deployment of the yearly case count dashboards provided near-real-time case count information from both central and non-OR locations among multiple campuses, which was not previously available. The visual presentation of monthly data for each year allowed us to recognize seasonality in case volumes and adjust our supply chain to prevent shortages. The dashboards highlighted the systemwide volume of cases in our endoscopy suites, which allowed us to target these supplies for pricing negotiations, with an estimated annual cost savings of $250,000. Our central venous pressure (CVP) dashboard enabled us to provide individual practitioner feedback, thus increasing our monthly CVP checklist compliance from approximately 92% to 99%. CONCLUSIONS: The customization and visualization of EHR data are both possible and worthwhile for the leveraging of information into easily comprehensible and actionable data for the improvement of health care provision and practice management. Limitations inherent to EHR data presentation make this customization necessary, and continued open access to the underlying data set is essential.
引用
收藏
页码:1057 / 1063
页数:7
相关论文
共 50 条
  • [1] Design and Implementation of a Visual Analytics Electronic Antibiogram within an Electronic Health Record System at a Tertiary Pediatric Hospital
    Simpao, Allan F.
    Ahumada, Luis M.
    Martinez, Beatriz Larru
    Cardenas, Ana M.
    Metjian, Talene A.
    Sullivan, Kaede V.
    Galvez, Jorge A.
    Desai, Bimal R.
    Rehman, Mohamed A.
    Gerber, Jeffrey S.
    APPLIED CLINICAL INFORMATICS, 2018, 9 (01): : 37 - 45
  • [2] Frameworks for Integrating Learning Analytics With the Electronic Health Record
    Pusic, Martin V.
    Birnbaum, Robert J.
    Thoma, Brent
    Hamstra, Stanley J.
    Cavalcanti, Rodrigo B.
    Warm, Eric J.
    Janssen, Anna
    Shaw, Tim
    JOURNAL OF CONTINUING EDUCATION IN THE HEALTH PROFESSIONS, 2023, 43 (01) : 52 - 59
  • [3] Visual Analytics for Electronic Health Records: A Review
    Rostamzadeh, Neda
    Abdullah, Sheikh S.
    Sedig, Kamran
    INFORMATICS-BASEL, 2021, 8 (01):
  • [4] Leverage of the Electronic Health Record to Improve the Patient Experience and Bottom Line
    Quigley, Elizabeth
    Ruggiero, Joanne
    JOGNN-JOURNAL OF OBSTETRIC GYNECOLOGIC AND NEONATAL NURSING, 2019, 48 (03): : S70 - S70
  • [5] Representation of Visual Impairment in the Electronic Health Record
    Hribar, Michelle
    Baxter, Sally
    Goetz, Kerry
    INVESTIGATIVE OPHTHALMOLOGY & VISUAL SCIENCE, 2023, 64 (08)
  • [6] Developing Visual Thinking in the Electronic Health Record
    Boyd, Andrew D.
    Young, Christine D.
    Amatayakul, Margret
    Dieter, Michael G.
    Pawola, Lawrence M.
    MEDINFO 2017: PRECISION HEALTHCARE THROUGH INFORMATICS, 2017, 245 : 308 - 312
  • [7] -Omic and Electronic Health Record Big Data Analytics for Precision Medicine
    Wu, Po-Yen
    Cheng, Chih-Wen
    Kaddi, Chanchala D.
    Venugopalan, Janani
    Hoffman, Ryan
    Wang, May D.
    IEEE TRANSACTIONS ON BIOMEDICAL ENGINEERING, 2017, 64 (02) : 263 - 273
  • [8] PERFORMANCE ANALYTICS OF AN INTEGRATED ELECTRONIC HEALTH RECORD SEPSIS TRIGGER TOOL
    Bercier, John
    McNease, Brogan
    Musso, Mandi
    Caffery, Terrell
    O'Neal, Hollis
    Thomas, Christopher
    Hamer, Diana
    Jagneaux, Tonya
    CRITICAL CARE MEDICINE, 2021, 49 (01) : 13 - 13
  • [9] How to Fully Leverage the Power of Electronic Health Records for Research-Self-Service Analytics
    Ioerger, Patrick
    Munyemana, Marie-Ange
    Piccirillo, Jay F.
    JAMA OTOLARYNGOLOGY-HEAD & NECK SURGERY, 2023, 149 (09) : 771 - 772
  • [10] Medical Visual Analytics - An Interactive Approach for Analyzing Electronic Health Records
    Secco, Cristian A.
    Sina, Lennart B.
    Nazemi, Kawa
    2024 28TH INTERNATIONAL CONFERENCE INFORMATION VISUALISATION, IV 2024, 2024, : 143 - 149