Diseño de una arquitectura de solución de inteligencia de negocios aplicado a los procesos académicos para la toma de decisiones en una institución de educación superior. Caso de estudio, Universidad Central del Ecuador.

Abstract

The research work describes the process to achieve the design of a BI solution architecture that adapts to the needs and specifications of the Higher Education Institution, to be used as a basis for future analysis in terms of academic management. For which a technological structure is chosen that involves Oracle BI, Pentaho, and a Data Warehouse processing methodology based on the following principles: Identification of the business line: determine the requirements, need, and specifications of the institution. Design of the solution architecture: determine a BI solution architecture, based on the technologies and tools used to collect process, and present data. Data extraction, transformation, and loading (ETL): analyze, process, and store data coming from different sources. Data visualization: displaying the information obtained in a way, so that it is easy to understand for end users. Monitoring and maintenance: monitor and keep the BI solution up to date, so that it works properly and improves over time.