Business Intelligence para indicadores de produtividade em um centro de distribuição logística

Abstract

The objective of this technological report was to describe the development and implementation of a Business Intelligence (BI) solution to support productivity management in a logistics distribution center located in Uberlândia-MG. The identified problem situation consisted of the use of manually populated spreadsheets based on daily data extractions, making the operational process susceptible to rework, delays in updating information, and analytical limitations. As the adopted intervention, Azure Databricks resources, VBA scripts, and dashboards developed in Power BI were utilized, aiming to automate data processing and expand the capacity for visualizing managerial information. As achieved results, greater agility in data processing and availability was observed, along with the creation of previously nonexistent indicators and analytical views, providing enhanced support for the managerial decision-making process.