A reference guide to rapidly implementing an institutional dashboard for resource allocation and oversight during COVID-19 pandemic surge

Jawa, Randeep S; Tharakan, Mathew A; Tsai, Chaowei; Garcia, Victor L; Vosswinkel, James A; Rutigliano, Daniel N; Rubano, Jerry A

OBJECTIVES: We develop a dashboard that leverages electronic health record (EHR) data to monitor intensive care unit patient status and ventilator utilization in the setting of the COVID-19 pandemic. MATERIALS AND METHODS: Data visualization software is used to display information from critical care data mart that extracts information from the EHR. A multidisciplinary collaborative led the development. RESULTS: The dashboard displays institution-level ventilator utilization details, as well as patient-level details such as ventilator settings, organ-system specific parameters, laboratory values, and infusions. DISCUSSION: Components of the dashboard were selected to facilitate the determination of resources and simultaneous assessment of multiple patients. Abnormal values are color coded. An overall illness assessment score is tracked daily to capture illness severity over time. CONCLUSION: This reference guide shares the architecture and sample reusable code to implement a robust, flexible, and scalable dashboard for monitoring ventilator utilization and illness severity in intensive care unit ventilated patients.