Gestión avanzada de inventarios de productos terminados mediante Business Intelligence con power BI en la microempresa productos lácteos Marlen

Abstract

This degree project was developed with the purpose of designing an advanced inventory management model for finished products through the use of Business Intelligence tools in Power BI, applied to the microenterprise Productos Lácteos Marlen. The research began with an analysis of the current inventory management process, which revealed weaknesses in the manual recording of product inflows and outflows, limited traceability of information, and the absence of indicators to support operational decision-making. In addition, the ABC classification was applied to identify the products with the highest relevance for inventory control. To build the proposed model, the inventory data were first structured in Excel and then processed in Power Query to clean, organize, and standardize the information. After this stage, the data were connected to Power BI through a relational model that allowed the calculation of inventory control parameters using DAX formulas. These parameters included minimum stock, safety stock, reorder point, and maximum stock. Likewise, performance indicators were defined to evaluate inventory level, stock duration, turnover, the relationship between outputs and inputs, and compliance with established control parameters. The developed control panels allowed a clearer interpretation of inventory behavior by showing the condition of each product according to its availability level. This made it possible to distinguish products that required immediate attention, timely replenishment, regular monitoring, or adjustments due to excess stock. Based on these results, operational actions were proposed to support production planning, replenishment, and dispatch activities. Therefore, the proposed model contributes to improving inventory control, reducing dependence on empirical decisions, and promoting a more organized, preventive, and data-oriented management system.