Carrier OTIF, freight invoice audits, detention hot spots, cost-per-unit benchmarking, and multi-metric carrier scorecards — the full logistics & transportation analyst SQL curriculum across 30 missions.
30 missions|5 tables
“Meet the carrier network”
“Monthly shipment volume trend”
“Carrier OTD vs. target gap”
OTIF Compound Metric — Build the on-time AND in-full formula at PO-line grain — the exact logic Walmart enforces with a 3% COGS chargeback.
Freight Invoice Audits — Find overbilled invoices, accessorial overcharges, and contract rate violations across carriers and lanes.
Detention Analysis — Identify facilities where dwell time exceeds 2 hours on more than a third of shipments — the hidden cost every logistics manager wants to cut.
PO cycle time analysis, purchase price variance, maverick spend detection, three-way match exceptions, and supplier risk scorecards — the full procurement & sourcing analyst SQL curriculum across 30 missions.
30 missions|6 tables
“Category catalog”
“Top 10 suppliers by spend”
“Contract compliance rate”
PO Lifecycle Analysis — Trace the full req → PO → ASN → receipt → invoice cycle and measure cycle time at every stage.
Purchase Price Variance — Compare actual vs contracted unit price to surface PPV exceedances by category — the metric that drives finance escalations.
Maverick Spend Detection — Find POs with no contract_id — off-contract spend that bypasses negotiated pricing.
Units per labor hour, dock-to-stock decomposition, pick accuracy by zone, slotting recommendations, and wave analysis — the full warehouse operations analyst SQL curriculum across 30 missions.
30 missions|7 tables
“Worker roster”
“Pick accuracy”
“Labor by function”
UPLH by Zone and Shift — Compute units per labor hour across picking zones and shifts — the metric DC managers review every morning.
Dock-to-Stock Decomposition — Break the inbound cycle into unload, count, and putaway phases to find the bottleneck causing SLA breaches.
Pick Accuracy Heat Map — Rank zones by pick error rate — surface the OVERFLOW zone pattern where error rates are 4× higher than GOLDEN.
WMAPE calculation, forecast bias detection, tracking signal computation, consensus vs statistical forecast value-add, promo lift attribution, and ABC×XYZ segmentation — the full demand planning analyst SQL curriculum across 30 missions.
30 missions|6 tables
“Location count”
“WMAPE”
“Forecast value-add”
WMAPE vs MAPE — Learn why WMAPE (Σ|A−F|/ΣA) is the industry default — it weights by volume and avoids divide-by-zero on intermittent SKUs.
Forecast Bias Detection — Spot the systematic over-forecast on Category C that hides inside an acceptable WMAPE — the pattern demand planners escalate to leadership.
Tracking Signal — Compute rolling tracking signals and flag SKUs where |TS| > 4 — the statistical trigger for model recalibration.