Visualización de datos por canales de venta para la empresa PETITMODA C. LTDA ubicada en la ciudad de Guayaquil.

Abstract

This paper seeks to identify the sales values generated by the different channels of the company PETITMODA C. LTDA located in the city of Guayaquil through data analytics, to seek to optimize their income. This was done through the development of a business intelligence solution, which allows the company to make decisions quickly and efficiently, in addition to generating a competitive advantage. The qualitative research methodology was applied, and the requirements of the company were identified through interviews. For the development of the solution, an adaptation of the Kimball methodology was used, which allowed to build an adequate information infrastructure and offer a complete solution; Among the dashboards developed are: sales by channels (export, physical stores and web), sales by product category, performance of the channels and the main one. In addition, a comparison was made between the 3 main BI tools. The business intelligence tool selected for the development of this research work has been Microsoft Power BI, with which fact and dimensional tables were prepared from the records that were collected on sales. Finally, dashboards or dashboards were developed according to the established requirements that made it possible to meet the general objective and prepare a report that allowed to conclude that the web sales channel is one of those that the company would have to optimize.