Design of an academic data repository applying data warehouse technology

Abstract

This article presents the proposal for the design and construction of an academic data repository under data warehouse technology. The initiative of the study arises from the identification of large volumes of data and the importance of combining them to analyze relevant indicators in decision-making by managers in higher-level educational institutions. The applied research proposes the use and implementation of the Hefesto v2.0 methodology capable of guiding step by step in the development of the data warehouse ensuring its start-up. As an added value, emerging technologies are integrated, particularly Microsoft SQL Server 2019 and Visual Studio 2019. The exposed results will serve as an applied study case for information systems administrators, administrative personnel and directors of educational institutions who wish to implement strategies with the aim of optimizing and make more efficient the analysis of data oriented to the benefit of educational processes that allow discerning relevant findings for decision-making.