Impact dashboards of Coronavirus Covid-19 data in Latin America and the world using Power BI as a visualization tool
DOI:
https://doi.org/10.5377/reice.v8i15.9946Keywords:
power BI, dashboard, data analysis, coronavirus, visualization and KPI.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.
Downloads
1431
References
Johns Hopkins University. “COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University”. 2020. Disponible en: https://github.com/CSSEGISandData/COVID-19. Consultado en mayo de 2020.
Power BI (2019). Transforme datos en oportunidades. Disponible en: http://powerbi.microsoft.com/es-es/ . Consultado en mayo 2020.
Ramos, S. (2016). BI & Analytics: El arte de convertir datos en conocimiento. (Vol. 1). Disponible en: http://www.solidq.com . Consultado el 26 de mayo de 2020.
Stein, Ernesto. 2020. “¿Cómo salvar vidas y evitar el colapso hospitalario? Una receta del Reino Unido para combatir el coronavirus.” Ideas que cuentan (blog), Banco Interamericano de Desarrollo, 20 de marzo. Disponible en: https://blogs.iadb.org/ideas-que-cuentan/es/como-salvar-vidas-y-evitar-el-colapso-hospitalario-una-receta-del-reino-unido-para-combatir-el-coronavirus/.Consultado en Mayo de 2020.
Walker, P., C. Whittaker, O. Watson et al. 2020. The Global Impact of COVID-19 and Strategies for Mitigation and Suppression. Imperial College London. Disponible en https://doi.org/10.25561/77735 . Consultado en mayo de 2020.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) Revista Electronica de Investigacion en Ciencias Economicas
The rights to the articles published in REICE are from the journal, in order to be able to manage their best dissemination. However, since the purpose of the same is the dissemination of knowledge, this journal provides immediate free access to its content, under the principle that making research available to the public free of charge, which fosters a greater exchange of global knowledge.
The opinions expressed by the authors do not necessarily reflect the position of the publisher of the publication or of the UNAN-Managua. Its reproduction and distribution is authorized (in any type of support) provided that the following indications are fulfilled:
- The authorship of the work
- Indicate its origin (REICE magazine, volume, number and electronic address of the document)
