Diseño de un modelo de inteligencia de negocios para la visibilidad y trazabilidad del flujo de inventarios en mi tienda deportiva S.A.S.

Abstract

This project proposes the design of a digital transformation model to strengthen inventory management and business intelligence at Mi Tienda Deportiva S.A.S. through the use of automation and data analytics tools aimed at improving information flow, operational traceability, and decision-making within the organization. As part of the methodology, the current process was analyzed and modeled using BPMN 2.0, identifying problems related to manual records, dispersed information, and lack of inventory control. Subsequently, a digital ecosystem based on Google Forms, Google Sheets, Excel with Python, and Power BI was designed to automate the capture, consolidation, and visualization of operational information. In addition, a process of organizing and cleaning historical data related to inventory entries, outputs, and sales was carried out, allowing the creation of indicators and interactive dashboards for real-time monitoring and analysis. Finally, it is concluded that the use of business intelligence and automation tools contributes to improving traceability, operational efficiency, and digital transformation within the organization through accessible and low-cost technological solutions.