Creación de una solución de inteligencia de negocios para la generación de reportes con información relevante del proceso de titulación de los estudiantes de la Carrera de Ingeniería de Sistemas de la Universidad Politécnica Salesiana Sede Quito

Abstract

This document presents the development of a Business Intelligence solution for the management of the Titling process of the Systems Engineering degree in Quito, it is known that the information of this process is handled in documents dispersed in different repositories in addition to containing files of different extensions, for this reason the treatment of information is delayed to reach decisions.Reason why a data management system is necessary with the use of an ETL (Extract-Transform-Load), which was developed following a linear-sequential methodology by having the requirements set out specifically, together with a database of multidimensional data (data mart) that is based on the Kimball methodology which is based on the dimensional business cycle. The modules described interact with the Pentaho tool to make queries of the multidimensional database using different parameters aligned to the business in order to provide value reports for process management.