Estudio de las defunciones fetales de los últimos 4 años

Abstract

The degree project that has been developed consists of the generation of a business intelligence tool that facilitates the analysis of data in relation to fetal deaths in the last 4 years in the entire territory of Ecuador reported by the INEC on its portal web, and, through the Power BI tool, views made with the information from the data warehouse are presented graphically and intuitively. This analysis made it possible to identify the possible causes of fetal mortality and determine the associated factors, facilitating the review of the data and the actions to be followed. Due to the importance of the information from the statistics, it is essential to evaluate the quality of the records, so that it becomes a truly effective tool in the search for solutions to fetal mortality. As a result of this project based on the agile SCRUM methodology, statistically detailed information was obtained by province, canton, parish, year, sex, ethnicity, marital status, and level of preparation of the mother, thus fulfilling the proposed objective of analyzing the information Based on these axes of analysis and concluding that the highest number of fetal deaths in Ecuador is focused on the province of Guayas with 43% of the total fetal deaths from 2014 to 2017 and that, of this number, 97% it is located in the parishes of Tarqui and Rocafuerte.