Cassim Naseem, Tepper Manfred E, Coetzee Lindi M, Glencross Deborah K
National Health Laboratory Service (NHLS), Johannesburg, South Africa.
Department of Molecular Medicine and Haematology, Faculty of Health Sciences, University of the Witwatersrand, Johannesburg, South Africa.
Afr J Lab Med. 2020 Apr 29;9(2):947. doi: 10.4102/ajlm.v9i2.947. eCollection 2020.
Mean turn-around time (TAT) reporting for testing laboratories in a national network is typically static and not immediately available for meaningful corrective action and does not allow for test-by-test or site-by-site interrogation of individual laboratory performance.
The aim of this study was to develop an easy-to-use, visual dashboard to report interactive graphical TAT data to provide a weekly snapshot of TAT efficiency.
An interactive dashboard was developed by staff from the National Priority Programme and Central Data Warehouse of the National Health Laboratory Service, Johannesburg, South Africa, during 2018. Steps required to develop the dashboard were summarised in a flowchart. To illustrate the dashboard, one week of data from a busy laboratory for a specific set of tests was analysed using annual performance plan TAT cut-offs. Data were extracted and prepared to deliver an aggregate extract, with statistical measures provided, including test volumes, global percentage of tests that were within TAT cut-offs and percentile statistics.
Nine steps were used to develop the dashboard iteratively with continuous feedback for each step. The data warehouse environment conformed and stored laboratory information system data in two formats: (1) fact and (2) dimension. Queries were developed to generate an aggregate TAT data extract to create the dashboard. The dashboard successfully delivered weekly TAT reports.
Implementation of a TAT dashboard can successfully enable the delivery of near real-time information and provide a weekly snapshot of efficiency in the form of TAT performance to identify and quantitate bottlenecks in service delivery.
国家网络中检测实验室的平均周转时间（TAT）报告通常是静态的，无法立即用于有意义的纠正措施，也不允许逐测试或逐站点查询单个实验室的性能。
本研究的目的是开发一个易于使用的可视化仪表板，以报告交互式图形化TAT数据，提供TAT效率的每周快照。
2018年期间，南非约翰内斯堡国家卫生实验室服务中心国家优先计划和中央数据仓库的工作人员开发了一个交互式仪表板。开发仪表板所需的步骤总结在一个流程图中。为了说明仪表板，使用年度绩效计划TAT截止值分析了一个繁忙实验室一周内特定一组测试的数据。提取并准备数据以提供汇总提取物，并提供统计措施，包括测试量、在TAT截止值内的测试的全球百分比和百分位数统计。
通过九个步骤迭代开发仪表板，并对每个步骤进行持续反馈。数据仓库环境符合要求，并以两种格式存储实验室信息系统数据：（1）事实数据和（2）维度数据。开发查询以生成汇总的TAT数据提取物以创建仪表板。该仪表板成功提供了每周TAT报告。
TAT仪表板的实施可以成功实现近实时信息的传递，并以TAT性能的形式提供每周效率快照，以识别和量化服务交付中的瓶颈。
