Abstract
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.
Highlights
The objective of this study is to develop a dynamic tool for the updated report of the situation of Covid-19 in Colombia from the data provided by the Instituto Nacional de Salud (INS), where important characteristics are reflected to understand the behavior of the virus in Colombian society and visualize the effectiveness of public policies
The information reported by the INS within the Coronavirus portal in Colombia was reviewed, and it was decided to select all the variables included in the structured database, including case identification, location city, department, state of attention, age, sex and date of a web report
The data was exported as excel CSV files, and a cleaning and unification process was carried out to import it into PowerBi
Summary
The information reported by the INS within the Coronavirus portal in Colombia was reviewed, and it was decided to select all the variables included in the structured database, including case identification, location city, department, state of attention, age, sex and date of a web report. The variable of the number of national tests, and by the department, taken from the test section of the INS portal was included. Dashboard design and construction This process began with the purification of the information from the INS databases. The data was exported as excel CSV files, and a cleaning and unification process was carried out to import it into PowerBi. Once the data was imported, the corresponding connections were made between the variables of each of the databases
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
