Supply chain calculations for Amazon QuickSight

Jill Hays, Amazon Web Services (AWS)

December 2022 (document history)

Amazon QuickSight is a business intelligence service that can help you understand your supply chain data through interactive dashboards and visualizations. QuickSight is powered by machine learning (ML) and artificial intelligence (AI), which can provide advanced analytics and predictive insights into your supply chain, such as accurate forecasting and analysis of what-if scenarios.

Supply chain metrics, also known as key performance indicators (KPIs), are the specific parameters that you use to quantify and define supply chain performance. Working with the right metrics helps supply chains be more productive, more transparent, and ultimately, more profitable. Metrics are often quantitatively measured by using one or more calculations in a business intelligence service.

Digital supply chain technologies and processes use metrics and the predictive insights provided by ML and AI to define, measure, analyze, improve, and control the supply chain. Supply chain metrics provide a solid foundation to measure and communicate performance for a number of essential processes and activities.

If a supply chain lacks structure, vision, and efficiency, or if it is fragmented, costs escalate unnecessarily, and commercial growth suffers. Properly defining, monitoring, and analyzing metrics is critical to a healthy supply chain. Metrics are invaluable tools for measuring the growth, evolution, development, and success of supply, fulfillment, and delivery operations. By analyzing key supply chain metrics, organizations can identify potential bottlenecks and sustainably improve their supply chain functions.

This guide documents standard calculations you can use for your supply chain metrics in QuickSight. Unlike many other visualization tools, QuickSight also supports calculations and scenarios.

Intended audience

This guide is intended for anyone who is creating dashboards, reports, or charts in QuickSight and uses standard supply chain metrics. This guide assumes a general understanding of supply chain management and principals, and it assumes that you have access to the necessary data.