Desarrollo de un sistema aplicando inteligencia de negocios al SGIA-ALPA para facilitar la toma de decisiones.

Abstract

The Research in Management Models and Computing Systems Center (CIMOGSYS) of the Escuela Superior Politécnica de Chimborazo (ESPOCH) developed the Management Accreditation Indicators System (SGIA-ALPA) based on the generic assessment model which was published by the council of Evaluation Accreditation and Quality Assurance of Higher Education of Ecuador (CEAACES). The SGIA-ALPA was implemented to automate the evaluation process of learning environments in the ESPOCH, which collects, stores and modifies the data, but does not allow the observation of information that facilitates decision making. Therefore, the SGIA-Dashboard which stands for business system was designed by using the Hephaestus v2 methodology and Pentaho 8.1 suite tools. Through the stages of the methodology, the data warehouse and tools of the Pentaho suite were designed, the extraction, loading and data loading (ETL) processes, the OLAP cube and the control panel for the analysis and data interpretation. Finally, it was determined through the chi-square test statistic that the function of the business intelligence system satisfies the user requirements in accordance with ISO / EIC 25010. In addition, according to the results of the survey, 83% of the users state that the system facilitates the decision-making process, allows them to obtain historic information about specific periods and can be analyzed from different perspectives of time (day, month, and year) through the OLAP cube. It is recommended to continue with the development of the datamarts of the different management systems that were developed by CIMOGSYS. They will let users to analyze a situation from different perspectives that positively contribute in the decision-making process.