Propuesta de Mejora para la Empresa Homecenter en el Área de Retail Digital

Abstract

During the professional internship with the Homecenter Colombia team, an opportunity for optimization was identified in the operations and dispatch process. Specifically, it was observed that the monitoring of pending dispatch statuses, carried out monthly by the team leader, was a repetitive and manual process, which resulted in limited use of time and a potential negative impact on key performance indicators (KPIs). With the objective of streamlining and optimizing the generation of monthly reports in the dispatch area, a dynamic dashboard was designed and implemented in Power BI. The methodology employed included the identification of the crucial data required by the leader, the development of the visual interface with interactive filters, and the execution of exhaustive tests to ensure the accuracy of the information. The results achieved were significant: the time dedicated to creating the monitoring report was reduced by 66%, from approximately 15 to 5 minutes. In addition, a visual tool was obtained that not only facilitates the monitoring of pending dispatches by region and line of business, but also enables the timely identification of causes of delay and the formulation of simpler action plans. In conclusion, the implementation of this dashboard improved team efficiency by providing a key tool for data-driven decision-making, which is essential to maintaining competitiveness and customer relationships.