Geração de indicadores de desempenho de negócio utilizando o Data Warehouse de uma grande rede de varejo

Abstract

The use of Key Performance Indicators (KPIs) is essential for companies as it allows them to evaluate the performance and outcome of processes, facilitate decision-making, identify patterns of sector performance, reduce unnecessary costs, and increase operational efficiency. However, it is important to take into account that the calculation of KPIs becomes more complex due to the company's growth and the arrival of new demands. This project was implemented in a large retail network that needed to reformulate the way it calculated its KPIs due to the emergence of new branches and an increase in employees. To improve performance, the centralization of calculations was performed through a Data Warehouse model (with Data Lakes), where calculations with changes are being performed in a single database instead of in each branch's individual database and later centralized. During the project's implementation, several challenges were faced, such as validating the result of each indicator, creating new features (such as cumulative calculation), and the need to create a specific procedure for each metric and indicator.