An Automated Dashboard to Improve Laboratory COVID-19 Diagnostics Management
Authors:
Open Access
- 6 December 2021
- journal article
- research article
- Published by Frontiers Media SA in Frontiers in Digital Health
- Vol. 3, 773986
Abstract
Background: In response to the COVID-19 pandemic, our microbial diagnostic laboratory located in a university hospital has implemented several distinct SARS-CoV-2 RT-PCR systems in a very short time. More than 148,000 tests have been performed over 12 months, which represents about 405 tests per day, with peaks to more than 1,500 tests per days during the second wave. This was only possible thanks to automation and digitalization, to allow high throughput, acceptable time to results and to maintain test reliability. An automated dashboard was developed to give access to Key Performance Indicators (KPIs) to improve laboratory operational management.Methods: RT-PCR data extraction of four respiratory viruses—SARS-CoV-2, influenza A and B and RSV—from our laboratory information system (LIS), was automated. This included age, gender, test result, RT-PCR instrument, sample type, reception time, requester, and hospitalization status etc. Important KPIs were identified and the visualization was achieved using an in-house dashboard based on the open-source language R (Shiny).Results: The dashboard is organized into three main parts. The “Filter” page presents all the KPIs, divided into five sections: (i) general and gender-related indicators, (ii) number of tests and positivity rate, (iii) cycle threshold and viral load, (iv) test durations, and (v) not valid results. Filtering allows to select a given period, a dedicated instrument, a given specimen, an age range or a requester. The “Comparison” page allows a custom charting of all the available variables, which represents more than 182 combination. The “Data” page, gives the user an access to the raw data in tables format, with possibility of filtering, allowing for a deeper analysis and data download. Informations are updated every 4 h.Conclusions: By giving a rapid access to a huge number of up-to-date information, represented using the most relevant visualization types, without the burden of timely data extraction and analysis, the dashboard represents a reliable and user-friendly tool for operational laboratory management. The dashboard represents a reliable and user-friendly tool improving the decision-making process, resource planning and quality management.Keywords
All Related Versions
This publication has 35 references indexed in Scilit:
- Balanced scorecard: application in the General Panarcadian Hospital of Tripolis, GreeceInternational Journal of Health Care Quality Assurance, 2013
- Measuring Productivity in BioanalysisBioanalysis, 2012
- Digital Dashboard Design Using Multiple Data Streams for Disease Surveillance With Influenza Surveillance as an ExampleJournal of Medical Internet Research, 2011
- Visual Analytics: Definition, Process, and Challenges2008
- The effects of alternative supplementary display formats on balanced scorecard judgmentsInternational Journal of Accounting Information Systems, 2005
- How information systems influence user decisions: a research framework and literature reviewInternational Journal of Accounting Information Systems, 2000
- Productivity of Information Systems in the Healthcare IndustryInformation Systems Research, 2000
- Decisional guidance and end-user display choicesAccounting, Management and Information Technologies, 1999
- Cognitive Fit: A Theory‐Based Analysis of the Graphs Versus Tables Literature*Decision Sciences, 1991
- Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information TechnologyMIS Quarterly, 1989