Authors :
Gautham Krishna; Nihal Hussain; Newslin S.; Balaji A.
Volume/Issue :
Volume 11 - 2026, Issue 4 - April
Google Scholar :
https://tinyurl.com/y8b4aefk
Scribd :
https://tinyurl.com/2p75t68s
DOI :
https://doi.org/10.38124/ijisrt/26apr410
Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.
Abstract :
Contemporary supply chains produce massive amounts of operational data in the areas of procurement, storage,
logistics, and order fulfillment. Unfortunately, many organizations face the challenge of transforming operational data into
valuable insights that can help detect inefficiencies and bottlenecks within the supply chain. This paper proposes a datadriven analytical approach for supply chain bottleneck analysis through the use of Microsoft Power BI. The proposed
methodology combines structured supply chain data and leverages systematic data preprocessing, feature development, and
key performance indicator modeling to assess performance from a multi-stage operational perspective. Interactive
dashboards are designed to display key performance indicators such as order cycle time, on-time delivery rate, supplier
delay percentage, and warehouse processing efficiency. Through the assessment of these KPIs within an integrated platform,
the methodology facilitates the detection of suppliers with high delay risks, capacity-limited warehouses, and inefficient
transportation. The findings of the paper illustrate the potential of business intelligence tools to improve operational
visibility and facilitate data-driven evaluation. The findings illustrate the potential of dashboard analytics to improve supply
chain visibility and performance analysis. This paper makes a significant contribution to the increasing use of business
intelligence and data visualization tools in supply chain management and operational optimization. The system successfully
identifies bottlenecks across suppliers, transportation, and locations using interactive KPI-based visualization.
Keywords :
Supply Chain Analytics, Business Intelligence, Power BI, Bottleneck Analysis, KPI Modeling, Data Visualization, Decision Support.
References :
- S. Chopra and P. Meindl, Supply Chain Management: Strategy, Planning, and Operation, 7th ed. Pearson, 2019.
- A. Gunasekaran, T. Papadopoulos, R. Dubey, S. F. Wamba, S. J. Childe, B. Hazen, and S. Akter, “Big data and predictive analytics for supply chain and organizational performance,” Journal of Business Research, vol. 70, pp. 308–317, 2017.
- M. A. Waller and S. E. Fawcett, “Data science, predictive analytics, and big data: A revolution that will transform supply chain design and management,” Journal of Business Logistics, vol. 34, no. 2, pp. 77–84, 2013.
- D. Ivanov, “Viable supply chain model: Integrating agility, resilience, and sustainability perspectives—lessons from and thinking beyond the COVID-19 pandemic,” Annals of Operations Research, vol. 319, pp. 141–166, 2022.
- M. Gupta, A. Kumar, and P. Singh, “KPI-based performance evaluation framework for supply chain optimization,” International Journal of Production Economics, vol. 193, pp. 1–12, 2017.
- H. Chen, R. H. Chiang, and V. C. Storey, “Business intelligence and analytics: From big data to big impact,” MIS Quarterly, vol. 36, no. 4, pp. 1165–1188, 2012.
- R. Kumar and V. Sharma, “Data-driven bottleneck identification in logistics systems using business intelligence tools,” International Journal of Logistics Management, vol. 30, no. 2, pp. 456–472, 2019.
- H. Stadtler, C. Kilger, and H. Meyr, Supply Chain Management and Advanced Planning: Concepts, Models, Software, and Case Studies, 5th ed. Springer, 2015.
- P. Singhal and S. Agarwal, “Supply chain analytics: A review of trends and applications,” International Journal of Supply Chain Management, vol. 8, no. 3, pp. 1–10, 2019.
Contemporary supply chains produce massive amounts of operational data in the areas of procurement, storage,
logistics, and order fulfillment. Unfortunately, many organizations face the challenge of transforming operational data into
valuable insights that can help detect inefficiencies and bottlenecks within the supply chain. This paper proposes a datadriven analytical approach for supply chain bottleneck analysis through the use of Microsoft Power BI. The proposed
methodology combines structured supply chain data and leverages systematic data preprocessing, feature development, and
key performance indicator modeling to assess performance from a multi-stage operational perspective. Interactive
dashboards are designed to display key performance indicators such as order cycle time, on-time delivery rate, supplier
delay percentage, and warehouse processing efficiency. Through the assessment of these KPIs within an integrated platform,
the methodology facilitates the detection of suppliers with high delay risks, capacity-limited warehouses, and inefficient
transportation. The findings of the paper illustrate the potential of business intelligence tools to improve operational
visibility and facilitate data-driven evaluation. The findings illustrate the potential of dashboard analytics to improve supply
chain visibility and performance analysis. This paper makes a significant contribution to the increasing use of business
intelligence and data visualization tools in supply chain management and operational optimization. The system successfully
identifies bottlenecks across suppliers, transportation, and locations using interactive KPI-based visualization.
Keywords :
Supply Chain Analytics, Business Intelligence, Power BI, Bottleneck Analysis, KPI Modeling, Data Visualization, Decision Support.