Treffer: Optimizing and Automating Aggregation and Visualization of COVID-19 Data in Metro Manila, Philippines, Through the Use of a Free Dashboard Software: A Case Study.
Title:
Optimizing and Automating Aggregation and Visualization of COVID-19 Data in Metro Manila, Philippines, Through the Use of a Free Dashboard Software: A Case Study.
Authors:
Ong KPS; Author Affiliations: Department of Health (Philippines), Manila, Philippines, and Monash University (Ong), Melbourne, Australia.
Source:
Journal of public health management and practice : JPHMP [J Public Health Manag Pract] 2025 Nov-Dec 01; Vol. 31 (6), pp. E361-E367. Date of Electronic Publication: 2025 Oct 21.
Publication Type:
Journal Article
Language:
English
Journal Info:
Publisher: Lippincott Williams & Wilkins Country of Publication: United States NLM ID: 9505213 Publication Model: Print-Electronic Cited Medium: Internet ISSN: 1550-5022 (Electronic) Linking ISSN: 10784659 NLM ISO Abbreviation: J Public Health Manag Pract Subsets: MEDLINE
Imprint Name(s):
Publication: 2003- : Hagerstown, MD : Lippincott Williams & Wilkins
Original Publication: Frederick, MD : Aspen Publishers, c1995-
Original Publication: Frederick, MD : Aspen Publishers, c1995-
MeSH Terms:
References:
Ansari B, Martin EG. Integrating human-centered design in public health data dashboards: lessons from the development of a data dashboard of sexually transmitted infections in New York State. J Am Med Inform Assoc. 2024;31(2):298-305. doi:10.1093/jamia/ocad102. (PMID: 10.1093/jamia/ocad102)
Rabiei R, Bastani P, Ahmadi H, Dehghan S, Almasi S. Developing public health surveillance dashboards: a scoping review on the design principles. BMC Public Health. 2024;24(1):392. doi:10.1186/s12889-024-17841-2. (PMID: 10.1186/s12889-024-17841-2)
Axelos. ITIL Foundation: ITIL 4 Edition. 1 st . 2019: The Stationery Office; United Kingdom.
Dixon BE, Dearth S, Duszynski TJ, Grannis SJ. Dashboards are trendy, visible components of data management in public health: sustaining their use after the pandemic requires a broader view. Am J Public Health. 2022;112(6):900-903. doi:10.2105/AJPH.2022.306849. (PMID: 10.2105/AJPH.2022.306849)
Fareed N, Swoboda CM, Chen S, Potter E, Wu DTY, Sieck CJ. U.S. COVID-19 state government public dashboards: an expert review. Appl Clin Inform. 2021;12(02):208-221. doi:10.1055/s-0041-1723989. (PMID: 10.1055/s-0041-1723989)
Schulze A, Brand F, Geppert J, Böl GF. Digital dashboards visualizing public health data: a systematic review. Front Public Health. 2023;11:999958. doi:10.3389/fpubh.2023.999958. (PMID: 10.3389/fpubh.2023.999958)
Dasgupta N, Kapadia F. The future of the public health data dashboard. Am J Public Health. 2022;112(6):886-888. doi:10.2105/AJPH.2022.306871. (PMID: 10.2105/AJPH.2022.306871)
Stahlman G, Yanovitzky I, Kim M. Design, application, and actionability of US public health data dashboards: scoping review. J Med Internet Res. 2025;27(1):e65283. doi:10.2196/65283. (PMID: 10.2196/65283)
Thorpe LE, Gourevitch MN. Data dashboards for advancing health and equity: proving their promise? Am J Public Health. 2022;112(6):889-892. doi:10.2105/AJPH.2022.306847. (PMID: 10.2105/AJPH.2022.306847)
Centers for Disease Control. 10 essential public health services. Public Health Professionals Gateway. May 31, 2024. Accessed June 24, 2025. https://www.cdc.gov/public-health-gateway/php/about/index.html.
Yanovitzky I, Stahlman G, Quow J, Ackerman M, Perry Y, Kim M. National public health dashboards: protocol for a scoping review. JMIR Res Protoc. 2024;13(1):e52843. doi:10.2196/52843. (PMID: 10.2196/52843)
GMA Integrated News. Philippines logs 1,171 new COVID-19 cases from March 13–19, 2023. GMA News Online. March 20, 2023. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/864488/philippines-logs-1-171-new-covid-19-cases-from-march-13-19-2023/story/.
GMA Integrated News. Philippines logs 1,721 COVID-19 cases March 27-April 2, 2023. GMA News Online. April 3, 2023. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/865881/philippines-logs-1-721-covid-19-cases-march-27-april-2-2023/story/.
Philippine Star. Philippines logs 3,148 COVID-19 cases from April 17 to 23. Philstar.com. June 25, 2025. https://www.philstar.com/headlines/2023/04/24/2261321/philippines-logs-3148-covid-19-cases-april-17-23.
GMA Integrated News. PH logs 2,386 new COVID-19 cases from April 10-16, 2023. GMA news online. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/867190/ph-logs-2-386-new-covid-19-cases-from-april-10-16-2023/story/.
Weir BS, Vordtriede C, Lee JE, Metter EJ, Talbot LA. An interdisciplinary dashboard to streamline medication processing at patient discharge: a quality improvement initiative. Mil Med. 2023;188(7-8):e1449–e1455. doi:10.1093/milmed/usab526. (PMID: 10.1093/milmed/usab526)
Wahi MM, Dukach N. Visualizing infection surveillance data for policymaking using open source dashboarding. Appl Clin Inform. 2019;10(03):534-542. doi:10.1055/s-0039-1693649. (PMID: 10.1055/s-0039-1693649)
Department of Health Philippines. COVID-19 Case Tracker. Department of Health Philippines. Accessed June 25, 2025. https://doh.gov.ph/diseases/covid-19/covid-19-case-tracker/.
Rabiei R, Bastani P, Ahmadi H, Dehghan S, Almasi S. Developing public health surveillance dashboards: a scoping review on the design principles. BMC Public Health. 2024;24(1):392. doi:10.1186/s12889-024-17841-2. (PMID: 10.1186/s12889-024-17841-2)
Axelos. ITIL Foundation: ITIL 4 Edition. 1 st . 2019: The Stationery Office; United Kingdom.
Dixon BE, Dearth S, Duszynski TJ, Grannis SJ. Dashboards are trendy, visible components of data management in public health: sustaining their use after the pandemic requires a broader view. Am J Public Health. 2022;112(6):900-903. doi:10.2105/AJPH.2022.306849. (PMID: 10.2105/AJPH.2022.306849)
Fareed N, Swoboda CM, Chen S, Potter E, Wu DTY, Sieck CJ. U.S. COVID-19 state government public dashboards: an expert review. Appl Clin Inform. 2021;12(02):208-221. doi:10.1055/s-0041-1723989. (PMID: 10.1055/s-0041-1723989)
Schulze A, Brand F, Geppert J, Böl GF. Digital dashboards visualizing public health data: a systematic review. Front Public Health. 2023;11:999958. doi:10.3389/fpubh.2023.999958. (PMID: 10.3389/fpubh.2023.999958)
Dasgupta N, Kapadia F. The future of the public health data dashboard. Am J Public Health. 2022;112(6):886-888. doi:10.2105/AJPH.2022.306871. (PMID: 10.2105/AJPH.2022.306871)
Stahlman G, Yanovitzky I, Kim M. Design, application, and actionability of US public health data dashboards: scoping review. J Med Internet Res. 2025;27(1):e65283. doi:10.2196/65283. (PMID: 10.2196/65283)
Thorpe LE, Gourevitch MN. Data dashboards for advancing health and equity: proving their promise? Am J Public Health. 2022;112(6):889-892. doi:10.2105/AJPH.2022.306847. (PMID: 10.2105/AJPH.2022.306847)
Centers for Disease Control. 10 essential public health services. Public Health Professionals Gateway. May 31, 2024. Accessed June 24, 2025. https://www.cdc.gov/public-health-gateway/php/about/index.html.
Yanovitzky I, Stahlman G, Quow J, Ackerman M, Perry Y, Kim M. National public health dashboards: protocol for a scoping review. JMIR Res Protoc. 2024;13(1):e52843. doi:10.2196/52843. (PMID: 10.2196/52843)
GMA Integrated News. Philippines logs 1,171 new COVID-19 cases from March 13–19, 2023. GMA News Online. March 20, 2023. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/864488/philippines-logs-1-171-new-covid-19-cases-from-march-13-19-2023/story/.
GMA Integrated News. Philippines logs 1,721 COVID-19 cases March 27-April 2, 2023. GMA News Online. April 3, 2023. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/865881/philippines-logs-1-721-covid-19-cases-march-27-april-2-2023/story/.
Philippine Star. Philippines logs 3,148 COVID-19 cases from April 17 to 23. Philstar.com. June 25, 2025. https://www.philstar.com/headlines/2023/04/24/2261321/philippines-logs-3148-covid-19-cases-april-17-23.
GMA Integrated News. PH logs 2,386 new COVID-19 cases from April 10-16, 2023. GMA news online. Accessed June 25, 2025. https://www.gmanetwork.com/news/topstories/nation/867190/ph-logs-2-386-new-covid-19-cases-from-april-10-16-2023/story/.
Weir BS, Vordtriede C, Lee JE, Metter EJ, Talbot LA. An interdisciplinary dashboard to streamline medication processing at patient discharge: a quality improvement initiative. Mil Med. 2023;188(7-8):e1449–e1455. doi:10.1093/milmed/usab526. (PMID: 10.1093/milmed/usab526)
Wahi MM, Dukach N. Visualizing infection surveillance data for policymaking using open source dashboarding. Appl Clin Inform. 2019;10(03):534-542. doi:10.1055/s-0039-1693649. (PMID: 10.1055/s-0039-1693649)
Department of Health Philippines. COVID-19 Case Tracker. Department of Health Philippines. Accessed June 25, 2025. https://doh.gov.ph/diseases/covid-19/covid-19-case-tracker/.
Contributed Indexing:
Keywords: COVID-19; Philippines; dashboard; public health; surveillance
Entry Date(s):
Date Created: 20250808 Date Completed: 20251021 Latest Revision: 20251022
Update Code:
20251022
DOI:
10.1097/PHH.0000000000002215
PMID:
40779696
Database:
MEDLINE
Weitere Informationen
In response to an increased demand for data, staff from the Regional Epidemiology and Surveillance Unit of the Department of Health Metro Manila developed an internal dashboard to automate the aggregation and visualization of COVID-19 data from multiple sources, thereby decreasing the time taken to complete the process by approximately 35 minutes, or more than half the duration of the original workflow. Time, financial, and human resource constraints were overcome with staff commitment and communication, and the approach was scaled to develop dashboards for other surveillance systems. Dashboards are useful for aggregation and visualization of data at the subnational level, but they are not replacements for critical review and effective communication of data. Further studies on dashboard development will help establish a framework and promote a new standard for public health organizations at the subnational level.
(Copyright © 2025 Wolters Kluwer Health, Inc. All rights reserved.)