Implementación de una solución de inteligencia de negocios para el análisis de datos relacionados con los proyectos de software del sector público en el Ecuador en la última década

Abstract

This document exposes a business intelligence solution for the analysis of data related to software projects in the public sector of Ecuador in the last decade (2010-2020), the data are in a digital repository in PDF format, this process (without the solution) delays the collection and processing of the information contained in these files, the ETL process (Extract-Transform-Load) was applied, The ETL (Extract-Transform-Load) process was applied to support the extraction, debugging and standardization of the data, in turn this information was loaded into a Data Warehouse, the dimensions and measures that make it up were analyzed by means of business intelligence based on factors of the software projects, this information is accessed through the Pentaho Community tool through which the creation and downloading of reports with relevant information for citizens is achieved.