Rapid Development and Utilization of a Clinical Intelligence Dashboard for Frontline Clinicians to Optimize Critical Resources During Covid-19

INTRODUCTION: The COVID-19 pandemic has created an unprecedented situation where sudden and prolonged surges of critically ill patients have disrupted healthcare systems worldwide A major concern for hospitals worldwide is how to best manage large numbers of COVID-19 infected and non-infected patients, while still maintaining high-quality clinical care. AIM: This manuscript describes the system development, collaborative efforts and the challenges encountered in developing an in-house clinical intelligence dashboard. METHODS: Through a longitudinal, interdepartmental collaboration, a COVID-19 clinical intelligence dashboard was created using Microsoft Power BI and Cerner Computer Language (CCL) to demonstrate clinical severity of patients and patient location in a single screen. A color-coding schema was applied to produce a red highlight for patients whose condition is deteriorating, whether due to increasing oxygen demand or worsening laboratory values. An additional function enabled users to drill down into the patient’s clinical and laboratory parameters for the past 5 days, and ultimately to the respective patient chart for further assessment. RESULTS: The development of an in-house clinical intelligence dashboard is a feasible, effective tool to allow frontline clinicians to monitor patient status in multiple wards and proactively intervene as clinically necessary and transfer patients to the appropriate level of care. Comparing the 30 days before and 30 days after the implementation of the dashboard, the percentage of patients who required urgent intubation or cardiac resuscitation on the general medical ward, rather than a critical care setting, declined by over 50% (8 out of 34, 33% vs. 7 out of 55, 13%; two-tailed p < 0.05 by Fisher’s exact test; OR 3.43; CI 1.07 to 10.95). CONCLUSION: The dashboard has enabled physicians to efficiently assess patient volumes and case severity to prioritize clinical care and appropriately allocate scarce resources. The dashboard can be replicated by developing healthcare systems that are continuing to grapple with the pandemic.