Diseño e implementación de un data mart para el proceso de titulación de la escuela politécnica nacional aplicando un ciclo de vida de proyectos de inteligencia de negocios

Abstract

In this document we design and develop a Data Mart for the Escuela Politecnica Nacional’s (EPN) graduation process by the application of a Business Intelligence project life cycle. We used the Hefesto’s methodology for creating the Data Mart taking into consideration its four basic aspects: Requirement Analysis, OLTP Analysis, Data Mart’s Logical Model and Data Integration. The dimensions and measures used for the Data Analysis were generated based on the information gathered during the requirement’s eduction process. This process was done in such way that the business questions are answered and the institution’s specific needs are satisfied. Within the Data Integration aspect, a data quality and cleaning process was carried out over the data obtained from the different sources of the EPN. This task was followed by the analysis of the data required for the final results presentation. The result of this academic work allows the generation of statistical and quantitative data of the graduation process that can be visualized through graphs and presented to the final user by reports. The final part presents the interface that will be used to guide, facilitate and support the strategic decision-making process of the EPN.