Moreno, D. (2021). Implementación de una solución business intelligence para mejorar la eficiencia de la toma de decisiones en la gestión de cobranzas de multas del servicio de administración tributaria de Trujillo [Trabajo de suficiencia profesional, Universidad Privada Antenor Orrego]. https://hdl.handle.net/20.500.12759/7301
Moreno, D. Implementación de una solución business intelligence para mejorar la eficiencia de la toma de decisiones en la gestión de cobranzas de multas del servicio de administración tributaria de Trujillo [Trabajo de suficiencia profesional]. PE: Universidad Privada Antenor Orrego; 2021. https://hdl.handle.net/20.500.12759/7301
title = "Implementación de una solución business intelligence para mejorar la eficiencia de la toma de decisiones en la gestión de cobranzas de multas del servicio de administración tributaria de Trujillo",
author = "Moreno Atoche, David Daniel",
publisher = "Universidad Privada Antenor Orrego",
year = "2021"
The present work is the description regarding my professional experience in the elaboration of the Business Intelligence project for the Trujillo Tax Administration Service (SATT). This project is based on the continuous need of municipal managements as end users, which request before the SATT to access the information of the collections of their respective concepts regarding administrative fines in a fast and secure way to consult their income and speed up taking of decisions. The implementation of this solution arises in the process of collecting administrative fines from the different directions and / or municipal managers as owners of the process, these users constantly request information regarding the income of each of their concepts, as they are not directly in The entity, send their requests by means of a letter and / or request taking an unwise time to reach the SATT and have an immediate response, because there is no direct platform to access the information. This process is executed by the transactional systems that the organization has, which is an administrative fines module developed in Access and recently migrated to Visual Studio with a SQL Server database manager, which produces a large amount of data. The biggest problem is that all this volume of data is not used efficiently and quickly. Being isolated, important users of this process spend more time reporting manually rather than analyzing key business indicators, either to meet their strategic objectives or increase revenue. Given this, the need arises to streamline this process, for which I made the proposal to implement a Business Intelligence (BI) / Datawarehouse (DWH) solution that consolidates all the data sets that the entity through integration processes allows to extract, transform and load the data into our DWH. This will help reduce operational work since users will no longer have to wait for the data in a spreadsheet file and consolidate the data manually, but from now on they will be able to take advantage of the data much more quickly and efficiently to generate relevant information. and provide support to decision making for the organization. The development of the project was guided by Ralph Kimbal's methodology called dimensional business life cycle, which focuses on the development of DW / BI projects and as BI tools, I used Microsoft's business intelligence suite package (SQL Server Integration services, SQL server Analysis Services, SQL Server reporting services and Power BI). The report is divided into three chapters. The first chapter is based on my professional experience. The second chapter describes the objectives of this project, the methodology and the theoretical framework. The third chapter is based on the development of this project, where the scope, the resources used and the results achieved are defined.
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.