ESTABLISHING A WEEKLY COMPACT DASHBOARD OF KEY QUALITY INDICATORS BASED ON R LANGUAGE

Đỗ Văn Niệm, Lê Thị Châu, Lê Thị Thu Thúy

##plugins.themes.vojs.article.main##

Abstract

Introduction: Quality indicator is an essential methodology for quality measurements and its suitable presentation format supplies hospital managers more information for making decisions. Method: Existing data on process supervision and outcome measurements were standardized and transformed to panel format which were then utilizied to develop a compact dashboard based on R language (packages were used: flexdashboard, knitr, tidyverse, readxl, reshape2, lubridate, qicharts2, qcc, ggQC, gridExtra, plotly, DT) and .html layout for releasing easily. Users were asked for their needs and comments to revise the design, and guarantee that the dashboard was user-friendly, supplied enough necessary information, allowed for tracing the origin of problems and searching information easily. Results: Contents of the dashboard included a summary of weekly and current year’s indicators, weekly indicator control charts by groups accompanied with the last year’s one. Pareto diagram indicated most non-compliance steps and negative feedback events, grid-plotting analysis by departments and procedures for benchmarking. A weekly summary data table of compliance proportion by departments and procedures with searching option helped users accessing information rapidly. Two surveys were deployed during designing and developing dashboard period
that had the result of more than 75% user-accepted. Conclusion: The compact dashboard not only helps hospital managers easily capture the overview of service qualities but also supply enough information for every department to make decisions for
quality improvement. 

##plugins.themes.vojs.article.details##

References

1. Bộ Y tế (2013). Thông tư số 19/2013/TT-BYT ngày 12/7/2013 của Bộ trưởng Bộ Y tế hướng dẫn thực hiện quản lý chất lượng dịch vụ khám bệnh, chữa bệnh tại bệnh viện.
2. Bộ Y tế (2016). Tiêu chí chất lượng bệnh viện Việt Nam, phiên bản 2.0 ban hành theo Quyết định số 6858/QĐ-BYT ngày 18/11/2016 của Bộ
trưởng Bộ Y tế.
3. Tổng cục Đo lường chất lượng (2016). Tiêu chuẩn Việt Nam TCVN ISO 9001:2015 (phiên bản 4).
4. DataCampTeam (2020). Choosing Python or R for Data Analysis? An Infographic: https://www.datacamp.com/community/tutorials/r-or-python
-for-data-analysis.
5. Anne Marie JWM, Weggelaar - Jansen, Damien SE, Broekharst, Martine de Bruijne (2018). Developing a hospital - wide quality
and safety dashboard: a qualitative research study. BMJ Qual Saf; 27: 1000-1007. doi: 10.1136/bmjqs - 2018-007784 .
6. Diego AM, Erin MK, Mehdi J, James C, Hetal R, Rohit T, Charles B, Bree B, Scott R, Levin (2018). An Electronic Dashboard to Monitor Patient Flow
at the Johns Hopkins Hospital: Communication of Key Performance Indicators Using the Donabedian Model. Journal of Medical Systems, 42: 133; https://doi.org/10.1007/s10916-018-0988-4.
7. Rebecca R, Natasha A, Lynn M, Roy AR, Dawn D (2016). Requirements for a quality dashboard: Lessons from National Clinical Audits. NIHR project number 16/04/06.