Pandemic Response in the Clinical Laboratory: The Utility of Interactive Dashboards

Abstract

The ability to access and analyze data is critical to manage a laboratory and respond and adapt to changes, particularly during a pandemic. Data analytic tools can not only improve laboratory operations, but also increase the visibility of the laboratory in the healthcare system and demonstrate the positive impact of the laboratory on patient care. In this article, we describe the creation and utility of laboratory dashboards. Several dashboards were designed to assist with pandemic response. For each dashboard, a stored procedure was created that performed a SQL query of our laboratory information system mirror database. We utilized the business analytics platform, Tableau, for data visualization. Users could modify the data by selecting a specific date range, time window, work shift, institution(s), specific test(s), and/or testing platform(s). Access was controlled by OKTA integration to the host server over the web, behind the hospital firewall. During the April 2020 surge, we saw an increase in blood gas testing and corresponding decrease in non-critical testing such as Vitamin D. At our institution, SARS-CoV-2 molecular testing was performed using four primary platforms, four in-house and one send-out. Weekly and hourly testing volumes as well as turnaround times fluctuated based on reagent availability, new testing requests, staffing, and operational changes. Productivity dashboards indicated that coagulation testing volumes were highest on the third shift and that all three analyzers may not be necessary. Further, specimen volumes and productivity of accessioning staff varied throughout the day. Phlebotomy venipuncture volumes and patient wait times also varied throughout the pandemic. A decrease in ambulatory draws was seen during the surge but after reopening draw volumes, particularly at offsite locations, surpassed prepandemic volumes. We demonstrate that data analytics and interactive dashboards are powerful tools, are helpful in response to a pandemic and lead to improved TAT, supply utilization, staffing and workflows. Furthermore, dashboards provide objective data to review with hospital leadership and promote collaboration.