Development of a Dashboard for the Antimicrobial Stewardship Program in a Hospital: A Case Study of Angthong Hospital

Main Article Content

Damphawan Thongmun
Suang Rungpragayphan

Abstract

Objective: To develop a dashboard to support antimicrobial stewardship activities at Ang Thong Hospital. Methods: Relevant indicators for monitoring appropriate antimicrobial use were identified from three main sources: 1) antimicrobial stewardship programmes in health-care facilities in low- and middle-income countries: a WHO practical toolkit; 2) indicators of Ministry of Public Health for antimicrobial resistance management; and (3) in-depth interviews with five pharmacists responsible for antimicrobial stewardship at Ang Thong Hospital.  The interview also explored their perspectives and requirements for dashboard development. The essential indicators and required data elements to be shown on the dashboard were then consolidated. Data were retrieved from the hospital information system, and additional data collection tools were developed for information not available in the system. All data were stored in Google Sheets and subsequently used to develop the dashboard using Looker Studio. The developed dashboard was then evaluated for functional performance by three expert pharmacists on the following areas--infectious diseases and antimicrobial use, general informatics, and hospital informatics. Subsequently, the dashboard was pilot-tested by five pharmacists responsible for antimicrobial stewardship at Ang Thong Hospital over a three-month period, during which user satisfaction with the system was also assessed. Results: Ten key indicator domains were identified as necessary for dashboard display: 1) overall antimicrobial stewardship performance summary; 2) appropriateness assessment at first review (within 7 days); 3) appropriateness assessment at second review (after 7 days); 4) DDD per 1,000 patient-days; 5) annual antimicrobial consumption volume; 6) annual antimicrobial expenditure; 7) incidence of Clostridium difficile infection; 8) multidrug-resistant infections according to the Ministry of Public Health AMR service plan; 9) 30-day readmission rate due to infections; and 10) in-hospital mortality related to infections. User satisfaction (mean ± SD, on a 5-point scale) was reported as follows: dashboard content 3.93±0.80, data accuracy 4.30±0.35, dashboard design 4.10±0.74, ease of use 3.80±0.84, and timeliness of data updates 4.00±0.71, with an overall satisfaction score of 4.00±0.71. Conclusion: The developed dashboard demonstrated high levels of satisfaction among pharmacist users in terms of content, data accuracy, visual design, usability, and update frequency. The dashboard has potential to support decision-making in antimicrobial stewardship programs

Article Details

Section
Research Articles

References

Murray CJL, Ikuta KS, Sharara F, Swetschinski L, Aguilar GR, Gray A, et al. Global burden of bacterial antimicrobial resistance in 2019: a systematic analysis. Lancet. 2022; 399: 629-55.

Ministry of Public Health and Ministry of Agriculture and Cooperatives. Thailand's national strategy for antimicrobial resistance management 2017-2021[online]. 2016 [cited Dec 24, 2025]. Available from: resolution.soc.go.th/PDF_UPLOAD/2559/9932 076744.pdf

Phumart P, Phodha T, Thamlikitkul V, Riewpaiboon A, Prakongsai P, Limwattananon S. Health and economic impacts of antimicrobial resistant infections in Thailand: A preliminary study. Journal of Health Systems Research. 2012; 6: 352-60.

World Health Organization, Antimicrobial stewardship programmes in health-care facilities in low- and middle-income countries: a WHO practical toolkit [online]. 2019 [cited Dec 24, 2025]. Available from: www.who.int/publications/i/item/9789241515481

Santimaleeworagun W, Nulsopapon P. A review of metrics in antimicrobial stewardship program. Thai Journal Pharmacy Practice 2020; 12: 411-20.

Department of Medical Services, Ministry of Public Health. Guide for evaluating integrated antimicrobial resistance management in hospitals. Bangkok: Ngaanpim; 2022.

Smith VS. Data dashboard as evaluation and research communication tool. New Directions for Evaluation 2013; 140: 21-45.

Slade J, Lee M, Park J, Liu A, Heidenreich P, Allaudeen N. Harnessing the potential of primary care pharmacists to improve heart failure management. Jt Comm J Qual Patient Saf 2022; 48: 25-32.

Rittel AG, Highland KB, Maneval MS, Bockhorst AD, Moreno A, Sim A, et al. Development, implementa- tion, and evaluation of a clinical decision support tool to improve naloxone coprescription within military health system pharmacies. Am J Health Syst Pharm. 2022; 79: e58-e64.

Ly W, Murray B, Parish K, Burnette C, Lee L. Development of a pharmacy-driven dashboard to impact medication utilization in the operating room. Indian J Crit Care Med. 2022; 50: 157.

de Lusignan S, Hinton W, Seidu S, Mathew M, Feher M, Munro N, et al. Dashboards to reduce inappropriate prescribing of metformin and aspirin: A quality assurance programme in a primary care sentinel network. Prim Care Diabetes. 2021; 15: 1075-79.

Taber P, Weir C, Butler JM, Graber CJ, Jones MM, Madaras KK, et al. Social dynamics of a population-level dashboard for antimicrobial stewardship: A qualitative analysis. Am J Infect Control. 2021; 49: 862-7.

Yan LD, Dean K, Park D, Thompson J, Tong I, Liu C, et al. Education vs clinician feedback on antibiotic prescriptions for acute respiratory infections in telemedicine: A randomized controlled trial. J Gen Intern Med. 2021; 36: 305-312.

Dolan JG, Veazie PJ, Russ AJ. Development and initial evaluation of a treatment decision dashboard. BMC Med Inform Decis Mak. 2013; 13: 51. doi:10.1186/1472-6947-13-51

Ang Thong Provincial Public Health Office. Medical and health data center (HDC): Information to support the RDU branch's service plan [online]. 2023 [cited Dec 24, 2025]. Available from: hdc.moph.go.th/atg/ public/standard-subcatalog/03b912ab9ccb4c07280a 8 9bf05e5900e

Strategy and Planning Division, Office of the Permanent Secretary, Ministry of Public Health. Details of the Ministry of Public Health's performance indicators for fiscal year 2024 [online]. 2024 [cited Dec 24, 2025]. Available from: spd.moph.go.th/wp-content/uploads/2023/11/KPI_template_672.pdf

Rouhani S, Zamenian S, Rotbie S. A prototyping and evaluation of hospital dashboard through end-user computing satisfaction model (EUCS). J Inf Technol Manag. 2018; 10: 43-60.