Building a Risk Intelligence Dashboard: KPIs Every Supply Chain Manager Should Track
KEY TAKEAWAYS - READ IN 30 SECONDS
Introduction
A risk intelligence dashboard succeeds or fails on which KPIs it’s built around, not on how much data it displays. Most supply chain teams don’t lack data - they lack a small, well-chosen set of numbers that reliably signal when something needs attention.
This guide covers the four KPIs that form a practical core for most operations, and how to think about the leading-versus-lagging distinction that separates a genuinely predictive dashboard from a rearview mirror.
The Core Four KPIs
On-Time-In-Full (OTIF) Rate
OTIF measures the percentage of orders delivered on time and complete. It’s the KPI most directly tied to commercial outcomes: every percentage point of improvement corresponds to fewer penalty charges, stronger retailer SLA compliance, and better customer retention.
The stakes are concrete - 65% of customers stop ordering from a retailer after two to three late deliveries, and 14% stop after just one.
Exception Rate
Exception rate tracks the percentage of shipments that trigger any deviation flag - delay, documentation issue, temperature excursion, route deviation - regardless of whether that exception ultimately caused a problem.
This is a leading indicator: a rising exception rate signals developing operational strain before it shows up in OTIF or claims data.
Dwell Time
Dwell time measures how long cargo sits at a given point - port terminal, warehouse, customs hold - without moving. Rising dwell time is one of the earliest signals of congestion or documentation problems, and it’s directly tied to cost: extended port dwell time is the leading driver of demurrage charges.
Claims Ratio
Claims ratio tracks the percentage of shipments resulting in a formal claim - damage, spoilage, shortage - relative to total shipment volume.
This is a lagging indicator: by the time a claim is filed, the loss has already occurred. Its value is in trend detection over time, not real-time intervention.
Leading vs. Lagging: Why the Mix Matters
| KPI | Leading or Lagging | What It Signals |
|---|---|---|
| Exception rate | Leading | Developing operational strain, before it becomes a delay or loss |
| Dwell time | Leading | Congestion or documentation friction building up |
| OTIF rate | Coincident | Real-time commercial performance |
| Claims ratio | Lagging | Confirmed losses, useful for trend analysis |
A dashboard weighted entirely toward lagging indicators like claims ratio tells a team what already went wrong last month.
A dashboard weighted toward leading indicators like exception rate and dwell time gives a team a chance to intervene before a shipment becomes a claim.
The strongest risk intelligence dashboards use both - leading indicators for daily operational attention, lagging indicators for monthly or quarterly trend review.
Why Fewer KPIs Beat More
The instinct when building a dashboard is often to track everything measurable. In practice, a dashboard with fifteen metrics gets glanced at and ignored; a dashboard with four well-chosen metrics gets checked daily and acted on.
The test for whether a KPI belongs on the dashboard: does a specific, predefined action happen when this number crosses a threshold?
If the answer is no, it’s a report metric, not a dashboard metric - useful for a monthly review, but noise in a real-time operational view.
Connecting KPIs to Action
A KPI dashboard without defined response actions is the same problem as a risk intelligence platform without actionability - a number that moves is only useful if someone knows what to do when it does.
For the alert categories that pair most directly with these KPIs, see Temperature Excursions, ETA Deviations & Missing Containers: The Five Risk Alerts Every Shipper Needs, and for how to evaluate whether a platform actually ties alerts to workflow rather than just displaying them, see Risk Intelligence Platforms Compared: What to Look for Before You Buy.
Build a Dashboard Around Your Own Risk Profile
Generic KPIs are a starting point; the right weighting depends on your specific cargo, lanes, and risk history.
Request a dashboard design session and we’ll help identify which four to six KPIs would actually move the needle for your operation.
Conclusion
A risk intelligence dashboard is a small set of carefully chosen numbers, not a data firehose.
OTIF, exception rate, dwell time, and claims ratio form a practical core for most supply chain teams - balancing leading indicators that enable intervention with lagging indicators that confirm trends.
The dashboards that actually change outcomes are the ones built around action, not just visibility.
Build the dashboard around action, not just visibility.
Dashboard design session
Identify the KPIs that matter for your lanes
FreshTrack helps supply chain teams define the four to six dashboard KPIs that reflect their cargo, lanes, risk history, and action thresholds.
FAQ - Frequently asked questions
What KPIs should a risk intelligence dashboard include?
A practical core includes OTIF (on-time-in-full) rate, exception rate, dwell time, and claims ratio - balancing real-time commercial performance, leading operational indicators, and lagging trend data.
What's the difference between a leading and lagging KPI in supply chain risk?
Leading indicators, like exception rate and dwell time, signal developing problems before they cause a loss. Lagging indicators, like claims ratio, confirm losses after they've already happened and are most useful for trend analysis.
How many KPIs should a risk intelligence dashboard track?
Fewer than most teams initially assume. Four to six well-chosen KPIs that trigger specific actions when they cross a threshold outperform dashboards with a dozen or more metrics that get glanced at rather than acted on.
Why is OTIF considered the most commercially important KPI?
Because it's directly tied to customer retention and penalty exposure - data shows a majority of customers stop ordering from a retailer after just two or three late deliveries.
What makes a KPI worth including on a real-time dashboard versus a monthly report?
Whether a specific, predefined action happens when the number crosses a threshold. If no action is triggered, it belongs in periodic reporting rather than a real-time operational dashboard.
References
- FourKites, 5 Ways Supply Chain Visibility Can Improve Your Business - https://www.fourkites.com/real-time-transportation-visibility-roi/
- nVision Global, The Perils of Port Congestion: How to Mitigate Demurrage and Detention Fees - https://corporate.nvisionglobal.com/the-perils-of-port-congestion-how-to-mitigate-demurrage-and-detention-fees/
- Gartner, Market Guide for Supply Chain Visibility Software - https://www.gartner.com/en/documents/3183220
Related reading: Temperature Excursions, ETA Deviations & Missing Containers: The Five Risk Alerts Every Shipper Needs · Risk Intelligence Platforms Compared