Desenvolvimento e Aplicação de um Sistema de Business Intelligence Para Gestão de Estoque e Vendas em uma Distribuidora de Rochas Ornamentais

Abstract

The ornamental stone sector is characterized by a complex production chain, marked by unique logistical challenges, such as the technical breakdown of materials and the difficulty in standardizing units of measurement, which frequently results in operational inefficiencies and loss of profitability. Given this scenario, management based purely on empirical experience proves insufficient to guarantee competitiveness in the current market. This work aimed to develop and apply a customized Business Intelligence (BI) system, specifically focused on optimizing inventory management and sales analysis in a distributor of marble and granite slabs. The methodology adopted consisted of applied quantitative research, operationalized through the complete development of a web application. The system was designed to perform extraction, transformation, and loading (ETL) of real sales and material movement data, covering the period from January to December 2025. The results obtained through interactive dashboards allowed for an in-depth diagnosis of the operation's financial health, highlighting the concentration of revenue in specific product lines and the impact of exotic material storage time on the company's cash flow. Bottlenecks in replenishment processes that generated stockouts during peak demand periods were also identified. Additionally, the system's economic engineering module enabled sensitivity simulations, correlating variations in freight and input costs with the actual contribution margin per m². It is concluded that the developed tool not only automated information processing but also transformed raw data into strategic assets, providing management with a robust analytical capacity for cost reduction and maximization of operational results.