Diseño e Implementación de un Datamart para las Notas Históricas de los Estudiantes en la Universidad Distrital Francisco José de Caldas

Abstract

The aim of this internship work was to design and subsequently implement a Datamart in charge of administering the historical notes at the Francisco José de Caldas District University with the data from 1960 to 1972 of the faculties of environment and engineering that were in books physical of the university archive, therefore the information that was physically found and that was difficult to access with respect to the search and in the logistics of transporting the books to issue a required certification, or data requested by planning, became in digitized input data that nourish the Datamart of historical notes, preserving the quality and integrity of the information and supporting decision-making under the concept of Business Intelligence with respect to the data duly organized in the Data Base and visualized in the portals of the District University. For the tests carried out, 462 input records were taken digitized in Excel tables and the digitization of each of the sheets to preserve the tangible evidence. The first step corresponds to the lifting of requirements, which basically leads to the understanding of the business and the needs of the area. The process of enlistment of information sources that in this case corresponded to physical books, and be converted into flat files represents in abstmal improvement response times eliminating manual processes to turn them into automatic as the search of students with registered notes. The integration with the different open source tools used by the Systems Advisory Office (OAS) allows an effective synchronization between the data and the transactional operations that are carried out with them, which allows integrity and quality of the data. The ETL process developed in Talend Open Studio, the process of saving the information in the Posgrest databases and the process of visualizing the information to the end users from SPAGO BI are therefore mutually inclusive processes where the output of a represents under the general theory of systems the entrance of the other. A datamart that supports and nourishes the Datawarehouse of the District University is of vital importance and supports the planning of the university, likewise it improves the process in which certificates are issued on the historical notes of the students.