Data Analytics and Visualization Dashboard for Supply Chain and Procurement as a Performance Assessment Tool


Authors : Doyin Oguntiloye

Volume/Issue : Volume 10 - 2025, Issue 8 - August


Google Scholar : https://tinyurl.com/bdz45dnz

Scribd : https://tinyurl.com/ye4dcrvk

DOI : https://doi.org/10.38124/ijisrt/25aug975

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.

Note : Google Scholar may take 30 to 40 days to display the article.


Abstract : Business owners, managers, and policymakers are overwhelmed by the volume of data available in their company’s internal databases and external sources. The ability to represent meaningful and concise information that facilitates decision-making is challenging. Consider a technology firm such as Company A, where a large quantity of data is generated across numerous data sources covering all the North American locations. Traditionally, these data come in different formats such as email attachments (.pdf, .xlsx, .docx, etc.) and at different time intervals, e.g., daily, weekly, and some non-periodic. The data arrives at the team’s folder on the Microsoft SharePoint platform, where team members calculate key metrics. This existing process is tedious, manual, and prone to computation or latency errors due to database refresh. Data visualization design and automation serve as a solution to these issues by creating a method through which large volumes of data can be easily aggregated, represented, consumed, and understood. When data is visualized correctly, it is easy to draw simple, actionable conclusions. This study will explore how modern data visualization tools can be used to help policymakers and managers understand supply chain operations and performance in a relatively short time, as well as make strategic plans by interacting with the dashboard. This would be achieved by creating a visualization dashboard for the real-time monitoring of Company A North America Supply Chain data across all departments using the Microsoft Power BI tool. This would help to see the big picture all at once and enable business owners, key managers, and policymakers to make sound business choices and judgments. The overarching goal of this project is to automate the data collection and visualization process to help key business owners make informed decisions. This will allow the team managers to spend less time compiling large volumes of data and leverage the visualization tool to better identify and mitigate risk as well as proactively uncover valuable opportunities that lie in their databases.

References :

  1. Janvier-James, A.M. (2012). A new introduction to supply chains and supply chain management: Definitions and theories perspective. International Business Research, 5(1), 194-207. doi:/10.5539/ibr.v5n1p194
  2. Nozari, H., Fallah, M., Kazemipoor, H., & Najafi, S.E. (2021). Big data analysis of IoT-based supply chain management considering FMCG industries. Business Informatics, 15(1), 78–96. doi:10.17323/2587-814X.2021.1.78.96
  3. Mishra, D., Gunasekaran, A., Papadopoulos, T., & Childe, S.J. (2018). Big Data and supply chain management: A review and bibliometric analysis. Ann Oper Res 270, 313–336. doi:10.1007/s10479-016-2236-y
  4. Ali, S.M., Gupta, N., Nayak, G.K., & Lenka, R.K. (2016). Big data visualization: Tools and challenges. 2016 2nd International Conference on Contemporary Computing and Informatics (IC3I), 656-660. doi:10.1109/IC3I.2016.7918044
  5. Bikakis, N. (2018). Big data visualization tools systems. Encyclopedia of Big Data Technologies, Springer. ATHENA Research Center, Greece. doi:10.48550/arXiv.1801.08336
  6. Po, L., Bikakis, N., Desimoni, F., & Papasteranatos, G. (2020). Linked data visualization: Techniques, tools, and big data. Synthesis Lectures on the Semantic Web: Theory and Technology. Morgan & Claypool Publishers. doi:10.2200/S00967ED1V01Y201911WBE019
  7. Chae, B.K. (2009). Developing key performance indicators for supply chain: An industry perspective. Supply Chain Management, 14(6), 422-428. doi:10.1108/13598540910995192
  8. Elrod, C., Murray, S., & Bande, S. (2015). A review of performance metrics for supply chain management. Engineering Management Journal, 25(3), 39-50. doi:10.1080/10429247.2013.11431981
  9. Edcuba. (2022). (Dashboard Sample).
  10. Victor & Sandberg (2022).

Business owners, managers, and policymakers are overwhelmed by the volume of data available in their company’s internal databases and external sources. The ability to represent meaningful and concise information that facilitates decision-making is challenging. Consider a technology firm such as Company A, where a large quantity of data is generated across numerous data sources covering all the North American locations. Traditionally, these data come in different formats such as email attachments (.pdf, .xlsx, .docx, etc.) and at different time intervals, e.g., daily, weekly, and some non-periodic. The data arrives at the team’s folder on the Microsoft SharePoint platform, where team members calculate key metrics. This existing process is tedious, manual, and prone to computation or latency errors due to database refresh. Data visualization design and automation serve as a solution to these issues by creating a method through which large volumes of data can be easily aggregated, represented, consumed, and understood. When data is visualized correctly, it is easy to draw simple, actionable conclusions. This study will explore how modern data visualization tools can be used to help policymakers and managers understand supply chain operations and performance in a relatively short time, as well as make strategic plans by interacting with the dashboard. This would be achieved by creating a visualization dashboard for the real-time monitoring of Company A North America Supply Chain data across all departments using the Microsoft Power BI tool. This would help to see the big picture all at once and enable business owners, key managers, and policymakers to make sound business choices and judgments. The overarching goal of this project is to automate the data collection and visualization process to help key business owners make informed decisions. This will allow the team managers to spend less time compiling large volumes of data and leverage the visualization tool to better identify and mitigate risk as well as proactively uncover valuable opportunities that lie in their databases.

CALL FOR PAPERS


Paper Submission Last Date
30 - November - 2025

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