TY - JOUR T1 - An automated Dashboard to improve laboratory COVID-19 diagnostics management JF - medRxiv DO - 10.1101/2021.03.20.21253624 SP - 2021.03.20.21253624 AU - Emma Maury AU - Marc-Olivier Boldi AU - Gilbert Greub AU - Valérie Chavez AU - Katia Jaton AU - Onya Opota Y1 - 2021/01/01 UR - http://medrxiv.org/content/early/2021/03/24/2021.03.20.21253624.abstract N2 - 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. Thanks to our automated molecular diagnostic platform, more than 140’000 SARS-CoV-2 RT-PCR tests were achieved over 12 months, with peaks higher than 1’500 daily tests. A 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. Important KPIs were identified and the visualization was achieved using an in-house dashboard based on the open-source language R (Shiny). Information is updated every 4 hours.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, or a requester for instance. The “Comparison” page allows a custom charting of all the available variables, which represents more than 182 combinations. The “Data” page gives the user access to the raw data in table format, with the possibility of filtering, allowing for a deeper analysis and data download in Excel format.Conclusions The dashboard, that gives a rapid access to a huge number of up-to-date information, represents a reliable and user-friendly tool improving the decision-making process, resource planning and quality management. The dashboard represent an added value for diagnosric laboratories during a pandemic, where rapid and efficient adaptation is mandatory.Competing Interest StatementThe authors have declared no competing interest.Funding StatementNo external funding was receivedAuthor DeclarationsI confirm all relevant ethical guidelines have been followed, and any necessary IRB and/or ethics committee approvals have been obtained.YesThe details of the IRB/oversight body that provided approval or exemption for the research described are given below:The regional ethic committee, Ethics Committee Vaud (CER-VD, Av. de Chailly 23, 1012 Lausanne Switzerland, http://www.cer-vd.ch/) on the 28.04.2020 considered that this project, fall under quality projects, quality assurance projects (comparisons of diagnostic tests, quality study and accuracy tests, laboratory management and activity rate) and considered that these projects do not fall within the scope of the law on human research and do not require the authorization of CER-VD to be carried out and published as such.All necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived.YesI understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).YesI have followed all appropriate research reporting guidelines and uploaded the relevant EQUATOR Network research reporting checklist(s) and other pertinent material as supplementary files, if applicable.YesThe data were obtained during a quality enhancement project at our institution and cannot be used for any other purpose ER -