⚠ Official Notice: www.ijisrt.com is the official website of the International Journal of Innovative Science and Research Technology (IJISRT) Journal for research paper submission and publication. Please beware of fake or duplicate websites using the IJISRT name.



Supply Chain Bottleneck Analysis Dashboard Using Power BI


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 :

  1. S. Chopra and P. Meindl, Supply Chain Management: Strategy, Planning, and Operation, 7th ed. Pearson, 2019.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. H. Stadtler, C. Kilger, and H. Meyr, Supply Chain Management and Advanced Planning: Concepts, Models, Software, and Case Studies, 5th ed. Springer, 2015.
  9. 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.

Paper Submission Last Date
30 - April - 2026

SUBMIT YOUR PAPER CALL FOR PAPERS
Video Explanation for Published paper

Never miss an update from Papermashup

Get notified about the latest tutorials and downloads.

Subscribe by Email

Get alerts directly into your inbox after each post and stay updated.
Subscribe
OR

Subscribe by RSS

Add our RSS to your feedreader to get regular updates from us.
Subscribe