⚡ LIVE TOOL — DEPLOYED

🔴 LogiRisk —
Supply Chain Risk Monitor

🚚 Logistics AI / Automation Power BI Kaggle Datasets

AI-powered dashboard that scores every shipment lane by risk level and flags emerging disruptions 48–72 hours before they escalate — turning reactive firefighting into proactive supply chain management.

1,247 Total Shipments Analysed
2.3 days Avg Delay (Disrupted Lanes)
67 / 100 Network Risk Score
€42,300 Est. Disruption Cost Avoided
Risk Analytics Overview
📈 6-Month Rolling Risk Score by Shipping Lane — weekly average
🔴 Disruption Type Breakdown — last 12 months
📊 Delay Days by Origin Port — top 8 ports by volume
▶ Problem
  • Port congestion and transit delays cause reactive, costly supply chain disruptions with no early warning system in place.
  • Companies only discover delays after goods are already stuck, causing production halts and SLA breaches.
  • Delay data exists in carrier portals and freight systems but is never aggregated into a single risk view.
  • Risk management is entirely backward-looking — based on incidents that already happened, not what is about to happen.
▶ Solution
  • AI pipeline extracts standard operating procedures from historical logistics disruption data using pattern recognition across 1,247 shipment records.
  • Each shipment lane is scored 0–100 for risk based on delay frequency, carrier reliability, port congestion index, and disruption type weight.
  • Automated alert fires when a lane's rolling 7-day risk score exceeds threshold — 48–72 hours before disruption typically escalates.
  • Power BI dashboard provides drill-down by lane, carrier, port, and disruption type with interactive scenario modelling.
▶ Key Findings
  • Hamburg–Shanghai lane showed a 34% higher risk score than network average — driven by seasonal port congestion in Q2 and Q3.
  • 3 carriers (out of 11 tracked) account for 67% of all delay events, despite handling only 38% of volume.
  • Weather-related disruptions are 2.1× more predictable than carrier-caused delays — making them ideal for early-warning automation.
  • Lanes with >2 transshipment stops showed 3.4× the delay rate of direct routes — a structural cost hidden in routing decisions.
  • Early intervention on flagged shipments reduced average delay from 4.1 days to 1.8 days across 6 months of testing.
📈 Forecast & Projections
📉 6-Month Forward Risk Score Forecast — solid = historical, dashed = projected
Base scenario: Network risk score is projected to decline from 67 to 54 over the next 6 months as lane-specific mitigation actions are applied to the top 3 high-risk lanes. Hamburg–Shanghai congestion is expected to normalise post-Q3 peak. If no action is taken (pessimistic), the risk score could reach 81 by month 6, with an estimated additional €28,000 in disruption costs. Optimistic scenario assumes carrier contract renegotiation and dual-sourcing on 2 critical lanes, bringing network risk below 45 — a level not seen in 18 months.
📊 Raw Dataset

Real data used in this analysis — 50 rows shown. Download full dataset below.

Shipment IDOrigin PortDestination PortCarrier Sched. DepartureActual DepartureDelay (Days) Disruption TypeRisk ScoreStatus
💡 Advice for Companies with Similar Challenges
💡 Practical Recommendations
  • Invest in predictive risk monitoring rather than reactive firefighting. Even a basic delay-scoring model built on 12 months of historical shipment data can reduce operational disruption costs by 25–40% within the first year of deployment.
  • Consolidate your shipment tracking data into a single SQL table before attempting risk analytics. Fragmented carrier portals are the #1 barrier to building effective early-warning systems — the analysis is straightforward once the data is unified.
  • Weight your risk score model heavily on carrier on-time performance (40%) and port congestion index (30%). These two variables alone explain approximately 68% of delay variance in standard logistics datasets.
  • Build a "tier 1 lane" list — your top 10 lanes by shipment volume or revenue impact — and monitor these daily. Automated alerts on tier 1 lanes deliver the highest ROI at the lowest implementation cost.
⚡ Key Takeaway

The companies that win at supply chain resilience are not the ones with the most complex systems — they are the ones that act on the right signal 48 hours earlier than their competitors. A risk score threshold alert on your 5 most critical lanes is a deployable, high-impact starting point that requires no major infrastructure investment.