Herramienta para identificar las inconsistencias entre los Sistemas Financiero y Académico utilizados en la Universidad la Gran Colombia

With this degree work, it was possible to build a tool that manages to identify the inconsistencies presented between the Academic and Financial Systems of the Universidad la Gran Colombia, in relation to the payment of registration receipts for applicants who wish to enter the institution. Accordin...

Full description

Autores:
Grandas Amado, Fabio
Vargas Zabala, Yennifer A.
Tipo de recurso:
Trabajo de grado de pregrado
Fecha de publicación:
2022
Institución:
Universidad Antonio Nariño
Repositorio:
Repositorio UAN
Idioma:
spa
OAI Identifier:
oai:repositorio.uan.edu.co:123456789/7144
Acceso en línea:
http://repositorio.uan.edu.co/handle/123456789/7144
Palabra clave:
Bases de datos
extracción de datos
modelo de datos
visualización de datos
Database
data extraction
data model
data visualization
Rights
openAccess
License
Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)
Description
Summary:With this degree work, it was possible to build a tool that manages to identify the inconsistencies presented between the Academic and Financial Systems of the Universidad la Gran Colombia, in relation to the payment of registration receipts for applicants who wish to enter the institution. According to the activities carried out, it will be possible to obtain the data from the registration forms and receipts generated between the years 2021 to 2022 from the Information Systems. The data extraction, transformation and loading was performed using an ETL, extracting this from the source sources, performing the corresponding data treatment and storing them in a destination source with a new model. From the development of the tool, it is intended to implement it to identify cases that present inconsistencies and thus solve them in a timely and agile manner to avoid inconveniences or complaints during the process. In addition, this application allows it to be adapted and implemented in other processes or areas of the institution and which in turn allows improving data analysis and information visualization