Business Intelligence & Data Analytics applied to the curricular monitoring process at the UPEC university

Abstract

The research highlights the importance of applying new trends, such as Business Intelligence & Data Analytics, within organizations and institutions to solve strategic and managerial decision-making problems. Based on this concept, a solution was developed for the curricular follow-up process in the Academic Direction of the Polytechnic State University of Carchi; in this sense, quantitative methodologies and Ralph Kimball's method were created for storage and analysis; and the ETL process was designed for the processing of the data obtained from the databases of the integrated computer system. Finally, control panels were developed through the Power BI tool to create dashboards. BI strategies were applied to deliver accurate information in real-time, easy to interpret, and oriented to satisfy the institutional requirements for the academic area.