Implementation of the ETL process and analysis with real-time visualization of data from UPC infrastructure

Abstract

The project implements from scratch the whole process of data extraction, transformation and loading to perform a set of descriptive and predictive analyses that will be visualized in a report with several graphics. The data used in this study contains information from the UPC related to the users accessing each UPC resource. Once the entire infrastructure is created through which the data from different sources passes, the client has access to a report with several pages, where there are a series of visualizations that are updated in real time so that it is simple, easy to understand and intuitive to interact with the report and obtain the desired information for the client.