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

Design and implement an interactive web-based dashboard to track COVID-19 in Colombia. 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 met...

Full description

Saved in:
Bibliographic Details
Published in:Revista de salud pública (Bogotá, Colombia) Colombia), 2020-03, Vol.22 (2), p.214-6
Main Authors: Aristizábal-Torres, Daniel, Peñuela-Meneses, Cesar A, Barrera-Rodríguez, Ana M
Format: Article
Language:English
Subjects:
Cities
Colombia - epidemiology
COVID-19
COVID-19 - epidemiology
Dashboards
Data analysis
Decision making
Disease control
Humans
Information management
Internet
Pandemics
Pandemics - prevention & control
Public policy
PUBLIC, ENVIRONMENTAL & OCCUPATIONAL HEALTH
Structured data
Trend analysis
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Design and implement an interactive web-based dashboard to track COVID-19 in Colombia. 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. 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. 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.
ISSN:0124-0064
2539-3596
DOI:10.15446/rsap.V22n2.87668