The quick adoption of data analytics and business intelligence tools has transformed inventory management practices in the manufacturing industry by improving inventory visibility, stock monitoring, and operational efficiency. This paper studies the application of a data analytics technique to tackle the challenges faced in the inventory management in ITC PPB Chennai. The analysis was based on structured inventory data collected from organizational records and ERP systems. Inventory levels, consumption trends, stock movement, inventory ageing and coverage days were analysed using Power BI dashboards, DAX measures, KPI cards and data visualisation techniques. The results indicate that interactive dashboards are useful for the visibility of inventory performance and in identifying slow-moving, non-moving, overstock and low-coverage inventory effectively. Inventory consumption analysis and movement classification were also found to be important indicators for improving inventory planning and stock control, highlighting the need for proper monitoring and data-driven decision-making. Customer-focused operational practices, continuous monitoring, and inventory visibility through dashboards play a major role in reducing inefficiencies and enhancing stock utilization. The study also found that analytical dashboards help to make faster managerial decisions and improve overall inventory efficiency across different plants and categories. This study provides useful insights into inventory behaviour and practical recommendations in improving the inventory management practices in manufacturing industries.
Article DOI: 10.62823/IJIRA/06.02(I).8853