Herramienta de inteligencia de negocios aplicada a datos recolectados acerca del impacto del virus sars cov-2 (Covid-19) a nivel social y de salud en el Ecuador

Abstract

This degree project is based on the analysis and development of a business intelligence tool, which supports the analysis of data extracted from the three main axes of analysis, positive cases, deaths and vaccinated people related to the SARS-COV-2 virus within from the territory of Ecuador, the data is extracted from reports generated by the National Risk Management System of Ecuador (SNGRE) and the Ministry of Public Health (MSP). The business intelligence tool provides three graphical and intuitive views each for each axis of analysis. Each axis of analysis facilitates the identification of different perspectives such as: provinces with constantly high rates of registration levels of positive cases, provinces with the highest rate of positive cases, deaths and vaccinated by region, making comparisons of social and medical problems for each result identified under The filters described as dimensions, cantons with a low response to the health emergency when verifying their curve of positive, dead and vaccinated cases between different periods of time, make it easier to check the results with the reports generated by the SNGRE and MSP. As a result of the analysis generated for each axis, the province of Pichincha was obtained as the province that represents 35.7% of the registry as positive cases. In addition to presenting the sierra region with the highest death rate, focusing on the capital as the province with the highest number of registered deaths.