Impact dashboards of Coronavirus Covid-19 data in Latin America and the world using Power BI as a visualization tool

Abstract

The current research describes the evolution of the new coronavirus Covid-19 through the creation of two impact dashboard for its data both globally and in detail for the Latin American and Caribbean region. The outbreak of the new coronavirus began in Wuhan, a city of 11 million people in the central Chinese province of Hubei. In order to describe the evolution of the virus through the creation of impact dashboards, the Microsoft Power BI business intelligence tool was implemented, where 4 stages were carried out, including the analysis of case system requirements, design of the architecture to be used, data integration and, as a final stage, the visualization and analysis of the data. After the creation of the impact tables, the numbers of confirmed cases, deaths, recovered cases and active cases were shown by region, country and globally. The creation of these impact dashboard allows good decision-making based on data such as the creation of policies public and fiscal measures by governments to ensure humanitarian risk and impact on the countries' economies.