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...
| Main Authors: | , |
|---|---|
| Other Authors: | |
| Format: | Tesis |
| Language: | Español |
| Published: |
Zamorano: Escuela Agrícola Panamericana
2023
|
| Subjects: | |
| Online Access: | https://hdl.handle.net/11036/7570 |
| _version_ | 1855500559821307904 |
|---|---|
| author | Lazo, Carlos E. Ortiz G., Mauricio H. |
| author2 | Calix, Marvin |
| author_browse | Calix, Marvin Lazo, Carlos E. Ortiz G., Mauricio H. |
| author_facet | Calix, Marvin Lazo, Carlos E. Ortiz G., Mauricio H. |
| author_sort | Lazo, Carlos E. |
| collection | Biblioteca Digital 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. |
| format | Tesis |
| id | ZAMORANO7570 |
| institution | Universidad Zamorano |
| language | Español |
| publishDate | 2023 |
| publishDateRange | 2023 |
| publishDateSort | 2023 |
| publisher | Zamorano: Escuela Agrícola Panamericana |
| publisherStr | Zamorano: Escuela Agrícola Panamericana |
| 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 |
| 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 |
| title | 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_short | Implementación de inteligencia de negocios con Power BI en el Z-Market de la Escuela Agrícola Panamericana Zamorano |
| title_sort | implementacion de inteligencia de negocios con power bi en el z market de la escuela agricola panamericana zamorano |
| topic | Decisión ETL elaboración Interactivo precisión innovación |
| url | https://hdl.handle.net/11036/7570 |
| work_keys_str_mv | AT lazocarlose implementaciondeinteligenciadenegociosconpowerbienelzmarketdelaescuelaagricolapanamericanazamorano AT ortizgmauricioh implementaciondeinteligenciadenegociosconpowerbienelzmarketdelaescuelaagricolapanamericanazamorano |