Published

2020-03-01

An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities

Aplicativo web para el seguimiento del COVID-19 en Colombia. Estudio de caso: cinco ciudades principales

DOI:

https://doi.org/10.15446/rsap.v22n2.87668

Keywords:

Pandemics, Colombia, coronavirus infections (en)
Pandemia, Colombia, infecciones por coronavirus (es)

Downloads

Authors

Objective Design and implement an interactive web-based dashboard to track COVID-19 in Colombia.

Methods A tool was designed and implemented to analyze the data of Covid-19 positive cases in Colombia and published by the Instituto Nacional de Salud. The tool is based on the implementation of business intelligence methods with which you can understand the behavior of the pandemic in Colombia and generate structured data for decision-making by government levels. The tool displays, on a single screen, information on the number of cases, patient status, age ranges, city, location department, and gender. This information can be dynamically filtered and focus analyzes on the national, departmental, or municipal order. Additionally, methods are implemented for trend analysis, both on a linear and semi-log scale, as well as for calculating the case fatality rate in each of the municipalities.

Results A web-based data analysis dashboard is implemented for semi-continuous monitoring of the COVID-19 pandemic in Colombia. With the use of the tool, a situational analysis is carried out for five of the most important cities in Colombia.

Conclusions The application is effective, flexible, and easy to use. The situational analysis reflects that public policies for the control of the disease have been favorable for Medellín, but for Cartagena, Bogotá, Barranquilla, and Cali, complementary measures are required.

Objetivo Diseñar e implementar una herramienta dinámica web para el seguimiento de la COVID-19 en Colombia.

Métodos Se diseña e implementa una herramienta para el análisis de los datos de los casos positivos de COVID-19 en Colombia y publicados por el Instituto Nacional de Salud. La herramienta se basa en la implementación de métodos de inteligencia empresarial con los que se pueda entender el comportamiento de la pandemia en Colombia y generar datos estructurados para la toma de decisiones por parte de los estamentos gubernamentales. La herramienta despliega, en una sola pantalla, información sobre número de casos, estado de los pacientes, rangos de edad, ciudad y departamento de ubicación y género. Esta información puede ser filtrada de forma dinámica y enfocar los análisis en el orden nacional, departamental o municipal. Adicionalmente, se implementan métodos para el análisis de tendencia, tanto en escala lineal como en escala semilogarítmica, así como para el cálculo de la tasa de letalidad en cada uno de los municipios.

Resultados Se implementó una herramienta de análisis de datos basado en la web para el seguimiento semicontinuo de la pandemia de la COVID-19 en Colombia. A partir de la herramienta se realiza un análisis situacional para cinco de las ciudades más importantes de Colombia.

Conclusiones El aplicativo es eficaz, flexible y de fácil manejo. El análisis situacional refleja que las políticas públicas para el control de la enfermedad han sido efectivas para Medellín, pero, para Cartagena, Bogotá, Barranquilla y Cali, se requieren medidas complementarias.

References

Dong E, Du H, Gardner L. An interactive web-based dashboard to track COVID-19 in real time. Lancet Infect Dis [Internet]. 2020; 20(5):533-4. DOI:10.1016/S1473-3099(20)30120-1. DOI: https://doi.org/10.1016/S1473-3099(20)30120-1

González-Jaramillo, Valentina González-Jaramillo N, Gómez-Restrepo C, Palacio-Acosta C, Gómez-López A, Franco O. Proyecciones de impacto de la pandemia COVID-19 en la población colombiana, según medidas de mitigación. Datos preliminares de modelos epidemiológicos para el periodo del 18 de marzo al 18 de abril de 2020. Rev Salud Pública (Bogotá). 2020; 22(2):1-6. DOI:10.15446/rsap.v22n2.85789. DOI: https://doi.org/10.15446/rsap.v22n2.85789

Manrique-Abril FG, Agudelo-Calderon CA, González-Chordá VM, Gutiérrez-Lesmes O, Téllez-Piñerez CF, Herrera-Amaya G. Modelo SIR de la pandemia de Covid-19 en Colombia/SIR model of the COVID-19 pandemic in Colombia. Rev Salud Pública (Bogotá). 2020; 22(2):1-9. DOI:10.15446/rsap.v22.85977.

Berry I, Soucy JPR, Tuite A, Fisman D. Open access epidemiologic data and an interactive dashboard to monitor the COVID-19 outbreak in Canad. Cmaj. 2020; 192(15):E420. DOI:10.1503/cmaj.75262. DOI: https://doi.org/10.1503/cmaj.75262

Kamel Boulos MN, Geraghty EM. Geographical tracking and mapping of coronavirus disease COVID-19/severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) epidemic and associated events around the world: How 21st century GIS technologies are supporting the global fight against outbreaks and epidemics. Int J Health Geogr [Internet]. 2020; 19(1):1–12. DOI:10.1186/s12942-020-00202-8. DOI: https://doi.org/10.1186/s12942-020-00202-8

Kamadjeu R, Gathenji C. Designing and implementing an electronic dashboard for disease outbreaks response - Case study of the 2013-2014 Somalia Polio outbreak response dashboard. Pan Afr Med J. 2017;27(Supp 3):22. DOI:10.11604/pamj.supp.2017.27.3.11062. DOI: https://doi.org/10.11604/pamj.supp.2017.27.3.11062

Lachev T, Price E. Applied Microsoft Power BI (3rd Edition): Bring Your Data to Life! 3rd ed. Prologika Press; 2018.

Knight D, Pearson M, Quintana, M. Powell B. Microsoft Power BI Complete Reference. Birmingham: Packt Publishing; 2018.

Russo M, Ferrari A. The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel [Internet]. Pearson Education (Business Skills); 2019 [cited 2020 May 22]. Available from: https://bit.ly/3cncnkn.

Portafolio. Estas son las ciudades más pobladas del país. Portafolio; 2019 [cited 2020 May 22]. Available from: https://bit.ly/3hUwJTp.

How to Cite

APA

Aristizábal, D., Peñuela Meneses, C. A. and Barrera Rodríguez, A. M. (2020). An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities. Revista de Salud Pública, 22(2), 214–219. https://doi.org/10.15446/rsap.v22n2.87668

ACM

[1]
Aristizábal, D., Peñuela Meneses, C.A. and Barrera Rodríguez, A.M. 2020. An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities. Revista de Salud Pública. 22, 2 (Mar. 2020), 214–219. DOI:https://doi.org/10.15446/rsap.v22n2.87668.

ACS

(1)
Aristizábal, D.; Peñuela Meneses, C. A.; Barrera Rodríguez, A. M. An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities. Rev. salud pública 2020, 22, 214-219.

ABNT

ARISTIZÁBAL, D.; PEÑUELA MENESES, C. A.; BARRERA RODRÍGUEZ, A. M. An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities. Revista de Salud Pública, [S. l.], v. 22, n. 2, p. 214–219, 2020. DOI: 10.15446/rsap.v22n2.87668. Disponível em: https://revistas.unal.edu.co/index.php/revsaludpublica/article/view/87668. Acesso em: 18 jul. 2024.

Chicago

Aristizábal, Daniel, César Augusto Peñuela Meneses, and Ana María Barrera Rodríguez. 2020. “An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities”. Revista De Salud Pública 22 (2):214-19. https://doi.org/10.15446/rsap.v22n2.87668.

Harvard

Aristizábal, D., Peñuela Meneses, C. A. and Barrera Rodríguez, A. M. (2020) “An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities”, Revista de Salud Pública, 22(2), pp. 214–219. doi: 10.15446/rsap.v22n2.87668.

IEEE

[1]
D. Aristizábal, C. A. Peñuela Meneses, and A. M. Barrera Rodríguez, “An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities”, Rev. salud pública, vol. 22, no. 2, pp. 214–219, Mar. 2020.

MLA

Aristizábal, D., C. A. Peñuela Meneses, and A. M. Barrera Rodríguez. “An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities”. Revista de Salud Pública, vol. 22, no. 2, Mar. 2020, pp. 214-9, doi:10.15446/rsap.v22n2.87668.

Turabian

Aristizábal, Daniel, César Augusto Peñuela Meneses, and Ana María Barrera Rodríguez. “An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities”. Revista de Salud Pública 22, no. 2 (March 1, 2020): 214–219. Accessed July 18, 2024. https://revistas.unal.edu.co/index.php/revsaludpublica/article/view/87668.

Vancouver

1.
Aristizábal D, Peñuela Meneses CA, Barrera Rodríguez AM. An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities. Rev. salud pública [Internet]. 2020 Mar. 1 [cited 2024 Jul. 18];22(2):214-9. Available from: https://revistas.unal.edu.co/index.php/revsaludpublica/article/view/87668

Download Citation

CrossRef Cited-by

CrossRef citations2

1. Alexis Carbajal-Torres, Joseph Ninaquispe-Florez, Michael Cabanillas-Carbonell. (2023). Proceedings of Seventh International Congress on Information and Communication Technology. Lecture Notes in Networks and Systems. 464, p.425. https://doi.org/10.1007/978-981-19-2394-4_39.

2. Taleb Khodaveisi, Hossein Dehdarirad, Hamid Bouraghi, Ali Mohammadpour, Fereydun Sajadi, Mohammad Hosseiniravandi. (2024). Characteristics and specifications of dashboards developed for the COVID-19 pandemic: a scoping review. Journal of Public Health, 32(4), p.553. https://doi.org/10.1007/s10389-023-01838-z.

Dimensions

PlumX

Article abstract page views

690

Downloads

Download data is not yet available.

License

Copyright (c) 2020 Revista de Salud Pública

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

This journal provides immediate free access to its content under the principle that making research available to the public free of charge supports a greater exchange of global knowledge.

All contents of this journal, except where identified, are published under a Creative Commons Attribution 4.0 License