ISO 9001:2015

International Journal of Innovations & Research Analysis (IJIRA) [ Vol. 6 | No. 2(I) | April - June, 2026 ]

A Data Analytics Approach towards Challenges in Inventory Management in ITC PPB Chennai

Vijay Gokulan. D & Dr. S. Preetha

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.

Gokulan, V. & Preetha, S. (2026). A Data Analytics Approach towards Challenges in Inventory Management in ITC PPB Chennai. International Journal of Innovations & Research Analysis, 06(02(I)), 93–99. https://doi.org/10.62823/IJIRA/06.02(I).8853
  1. Karel Genotiva (2025). Enhancing Financial Visibility: A Proposal to Implement Power BI for Group Accounting Analysis and Reporting. International Journal of Financial Analytics, 8(3), 120- 134.
  2. Grace Omotunde Osho, Julius Olatunde Omisola, & Joseph Oluwasegun Shiyanbola (2024). An Integrated AI-Power BI Model for Real-Time Supply Chain Visibility and Forecasting. Journal of Supply Chain Analytics, 12(2), 210-225.
  3. M. Saravana Priya, Keren Lois Daniel, Dr. M. Ananthi, Dr. P. Rajkumar, & S. Sharmi Jenitha (2024). Retail Store Sales Analysis: Unveiling Insights Through Power BI Business Analytics. International Journal of Business Intelligence Research, 10(4), 98-112.
  4. Siddhartha Das, Dr. Kallal Banerjee, Soumen Nath, & Sourav Chatterjee (2023). Data Visualization Approach for Business Strategy Recommendation Using Power BI Dashboard. International Journal of Data Science and Analytics, 7(1), 55-69.
  5. Waltteri Yliranta (2023). Data-Driven Performance Optimization and Reporting in Supply Chain Management. Journal of Operations and Supply Chain Management, 9(2), 145-159.

DOI:

Article DOI: 10.62823/IJIRA/06.02(I).8853

DOI URL: https://doi.org/10.62823/IJIRA/06.02(I).8853


Download Full Paper:

Download