Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano

Business intelligence programs represent highly beneficial tools that facilitate the work of managers by allowing them to effectively interpret sales behaviors and compliance with other indicators. The adoption of Power BI will prove to be a highly efficient solution, providing decision-makers with...

Descripción completa

Detalles Bibliográficos
Autores principales:	Lazo, Carlos E., Ortiz G., Mauricio H.
Otros Autores:	Calix, Marvin
Formato:	Tesis
Lenguaje:	Español
Publicado:	Zamorano: Escuela Agrícola Panamericana 2023
Materias:	Decisión ETL elaboración Interactivo precisión innovación
Acceso en línea:	https://bdigital.zamorano.edu/handle/11036/7570

id	ZAMORANO7570
record_format	dspace
spelling	ZAMORANO75702023-11-27T13:56:14Z Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano Lazo, Carlos E. Ortiz G., Mauricio H. Calix, Marvin Leal, Martín Decisión ETL elaboración Interactivo precisión innovación Business intelligence programs represent highly beneficial tools that facilitate the work of managers by allowing them to effectively interpret sales behaviors and compliance with other indicators. The adoption of Power BI will prove to be a highly efficient solution, providing decision-makers with not only a more agile process but also a more accurate one. A meeting was held to clarify the operations performed by Z-Market, which helped identify its challenges and the important data to be projected on the interactive Dashboard. Giving way to the receipt of data to start the ETL process (extraction, transformation, and loading of data), a process that is done to load the data to the Power Bi (Power Business Intelligence) tool. The main distinguishing feature of Power BI lies in its ability to handle large volumes of data, which could be verified with data granted from 2018 to July 2023. Followed by the development of the interactive Dashboard, where it was possible to accurately visualize the best-selling products in each internal production plant and make exhaustive sales comparisons between different months, quarters, and years. In addition, we obtained a detailed average of target achievement and the ability to formulate queries through natural language to generate instant and highly informative graphics. It was concluded that the implementation of this tool has proven to be highly effective in avoiding the stagnation of "old" methods and fostering innovation. Not only by simply interpreting behaviors, but also by identifying market trends that will drive sales and, consequently, generate significant growth in profits. 2023-11-27T19:54:33Z 2023-11-27T19:54:33Z 2023 Thesis https://hdl.handle.net/11036/7570 spa Copyright Escuela Agrícola Panamericana, Zamorano https://creativecommons.org/licenses/by-nc-nd/3.0/es/ application/pdf Zamorano: Escuela Agrícola Panamericana
institution	Universidad Zamorano
collection	Biblioteca Digital Zamorano
language	Español
topic	Decisión ETL elaboración Interactivo precisión innovación
spellingShingle	Decisión ETL elaboración Interactivo precisión innovación Lazo, Carlos E. Ortiz G., Mauricio H. Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
description	Business intelligence programs represent highly beneficial tools that facilitate the work of managers by allowing them to effectively interpret sales behaviors and compliance with other indicators. The adoption of Power BI will prove to be a highly efficient solution, providing decision-makers with not only a more agile process but also a more accurate one. A meeting was held to clarify the operations performed by Z-Market, which helped identify its challenges and the important data to be projected on the interactive Dashboard. Giving way to the receipt of data to start the ETL process (extraction, transformation, and loading of data), a process that is done to load the data to the Power Bi (Power Business Intelligence) tool. The main distinguishing feature of Power BI lies in its ability to handle large volumes of data, which could be verified with data granted from 2018 to July 2023. Followed by the development of the interactive Dashboard, where it was possible to accurately visualize the best-selling products in each internal production plant and make exhaustive sales comparisons between different months, quarters, and years. In addition, we obtained a detailed average of target achievement and the ability to formulate queries through natural language to generate instant and highly informative graphics. It was concluded that the implementation of this tool has proven to be highly effective in avoiding the stagnation of "old" methods and fostering innovation. Not only by simply interpreting behaviors, but also by identifying market trends that will drive sales and, consequently, generate significant growth in profits.
author2	Calix, Marvin
author_facet	Calix, Marvin Lazo, Carlos E. Ortiz G., Mauricio H.
format	Tesis
author	Lazo, Carlos E. Ortiz G., Mauricio H.
author_sort	Lazo, Carlos E.
title	Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
title_short	Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
title_full	Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
title_fullStr	Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
title_full_unstemmed	Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano
title_sort	implementación de inteligencia de negocios con power bi en el z-market de la escuela agrícola panamericana zamorano
publisher	Zamorano: Escuela Agrícola Panamericana
publishDate	2023
url	https://bdigital.zamorano.edu/handle/11036/7570
work_keys_str_mv	AT lazocarlose implementaciondeinteligenciadenegociosconpowerbienelzmarketdelaescuelaagricolapanamericanazamorano AT ortizgmauricioh implementaciondeinteligenciadenegociosconpowerbienelzmarketdelaescuelaagricolapanamericanazamorano
_version_	1808118782572363776

Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano

Ejemplares similares