ConductScience Proceedings

ConductScience Proceedings
ConductScience Proceedings

Consortium for Health Innovation Partnerships Conference I

The Emergency Leadership Dashboard: A Comprehensive System for Visualizing Operations across Educational, Administrative, and Research Sectors

Tareq Al Salamah

King Saud University
Avatar
Massachusetts General Hospital
Massachusetts General Hospital
Northwestern University Depart...
King Saud University
Massachusetts General Hospital

Emergency Medicine operations

Data Science

Digital transformation

30 April 2024

4 October 2024

Introduction

Managing patient care and fulfilling administrative tasks are challenges facing healthcare systems [1]Herd P, Moynihan D. Health care administrative burdens: Centering patient experiences. Health Serv Res. 2021 Oct;56(5):751-754. doi: 10.1111/1475-6773.13858. Epub 2021 Sep 13. PMID: 34515996; PMCID: PMC8522557.. Particularly at university hospitals, emergency departments (EDs) must carry out research and fulfill educational responsibilities. As a result of these responsibilities, educators can develop educator burnout [2]Tierney, Aaron A, and Benjamin I Rosner. “Clinical Assessment of Residents: A Survey of Clinician Educators Regarding Resident Assessment Burden and Modifiable Factors.” Journal of graduate medical education vol. 15,1 (2023): 92-97. doi:10.4300/JGME-D-22-00188.1. Providers must additionally maintain accreditation by completing continuous education and certification. Using new technology and automation, clinicians can focus on patient care and quality service, reducing administrative burdens. The goal of this study is to introduce an ED leadership dashboard that optimizes ED operational efficiency across the administrative, educational, and research areas.

Methodology

The digital dashboard was developed with Microsoft Teams, Forms, Excel, and Power BI. The system combines multiple datasets to create a comprehensive visual dashboard. The first database queries information about ED physicians and updates the related datasets, including ED research, administrative tasks, student evaluations, and performance metrics. The real-time updates and visualization on the dynamic Power BI dashboard facilitate the shift from the current paper-based data collection to an electronic workflow. Implementation includes utilizing standardized forms for data inputs about research projects, educational assessments, and administrative tasks, such as complaint management and credential monitoring. These inputs cause updates in the respective datasets and dashboard output in real time, which enhances the decision-making process by providing immediate access to performance metrics such as patient throughput. The dashboard ensures consistency, improves administrative efficiency, and supports a proactive approach to management and educational evaluations within the ED.

Results

The research dashboard monitors research activities, allows users to select by year and quarter, and displays interactive visualizations. Projects are categorized into "Original Research" and "Case Report," with Original Research being more common. The stages of research (Writing, Analysis, and Data Collection) are depicted in a donut chart, where Data Collection was found to be the most prevalent. The status of the projects is shown as "On Track," "Completed," or "Delayed," with most projects currently on track. An analysis of research types showed that Retrospective studies were the most frequent (Figure 1). The physician's involvement in each project is also tracked to distribute the project load among faculty. The training and certification dashboard shows completion rates for certifications such as Basic Life Support and Advanced Cardiovascular Life Support, with most completion rates near perfect. Safety training showed a low completion rate of 35%. 574 certifications were completed, and 10 were pending, for an overall 98% completion rate. (Figure 2)

Research Dashboard

Figure 1: Research Dashboard

Certification Dashboard

Figure 2: Certification Dashboard

Conclusion

The implementation of an ED leadership dashboard in university hospital emergency departments has markedly enhanced operational efficiency across administrative, educational, and research functions. Utilizing technologies like Microsoft Teams, Forms, Excel, and Power BI, the dashboard has transitioned from paper-based systems to a streamlined electronic workflow, enabling real-time data visualization and updates. This has improved decision-making processes, optimally distributed faculty workloads, and maintained high certification completion rates, while also highlighting areas for improvement such as safety training. Overall, the dashboard has effectively managed patient care and administrative tasks, reducing burdens and supporting proactive management within the emergency department.

References

  1. Herd P, Moynihan D. Health care administrative burdens: Centering patient experiences. Health Serv Res. 2021 Oct;56(5):751-754. doi: 10.1111/1475-6773.13858. Epub 2021 Sep 13. PMID: 34515996; PMCID: PMC8522557.
  2. Tierney, Aaron A, and Benjamin I Rosner. “Clinical Assessment of Residents: A Survey of Clinician Educators Regarding Resident Assessment Burden and Modifiable Factors.” Journal of graduate medical education vol. 15,1 (2023): 92-97. doi:10.4300/JGME-D-22-00188.1

© 2024 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).

Share

View statistic