Please use this identifier to cite or link to this item:
http://hdl.handle.net/10609/147353
Title: | Aplicación de Inteligencia Empresarial para el análisis del comportamiento de incidencias de una Plataforma de Gestión y Tarificación de Usuarios de Operadoras de Telefonía Móvil |
Author: | Guerrero Hernández, Julio Pedro |
Tutor: | Andrés Sanz, Humberto |
Others: | Daradoumis, Thanasis |
Abstract: | The main purpose of this project is to analyze the behavior of the incidents generated by the platform that manages and rates everything related to mobile telephony subscribers for 16 operators in America and Europe. To comply with the commercial protection of the data, no commercial name will be mentioned, nor will any reference be made to personal data. For the development of this project, we will use the methodology and tools that would be used in a real working environment, so first, we proceeded to extract the data from a relational database remotely, after this they were transformed and loaded using an ETL tool, the final repository will be a data warehouse configured locally using a database manager. With the data loaded, we proceeded to use a business analysis tool to capture the information that will reveal the data, generating a main scorecard as a summary and five reports each with a defined category. These are criticality, country, status, reopened, patches, and root causes associated with the incidents. The results were as expected. We have achieved everything related to the technical aspects, a warehouse with the transformed data and we have been able to visualize the reports and generate the necessary graphs to understand or to be able to analyze the behavior of the incidents. |
Keywords: | business intelligence ETL data warehouse |
Document type: | info:eu-repo/semantics/bachelorThesis |
Issue Date: | 15-Jan-2023 |
Publication license: | http://creativecommons.org/licenses/by-nc-nd/3.0/es/ |
Appears in Collections: | Bachelor thesis, research projects, etc. |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
jguerreroheTFG0123memoria.pdf | Memoria del TFG | 6,61 MB | Adobe PDF | View/Open |
Share:
This item is licensed under aCreative Commons License