Operations & Supply Chain Analytics

Inventory, lead times, supplier scorecards.
The SQL ops analysts ship every week.

Inbound purchase orders, supplier on-time delivery, inventory health, days-of-supply alerts, demand-forecast accuracy, SCD2 supplier-history reconstruction, and capstone multi-CTE scorecards — the full 30-mission operations & supply-chain analyst SQL curriculum.

See All Missions

30 missions · 13 free + 17 Pro · Starter → Master

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Real Supplier Scorecards

On-time delivery, lead time, and chronic-late-shipment patterns across 8 suppliers and a ghost row.

Inventory Health Queries

Latest-snapshot dedup, days-of-supply alerts, stock-out risk — the queries warehouse leads run every morning.

Demand vs Plan

MAPE forecast accuracy, the S&OP-review metric every demand planner ships weekly.

Planted Dirty Data

Trailing whitespace on supplier names, casing drift on SKU categories, duplicate snapshot rows, ghost suppliers — the data-quality bugs you actually fight.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

Starter5 missions
1
How many suppliers do we work with?From: Ops Director
Show me the warehousesFrom: Ops Director
How many SKUs do we stock?From: Ops Director
List our SKU categoriesFrom: Procurement Manager
Show the 5 most recent purchase ordersFrom: Ops Director
Easy5 missions
Total units ordered per category last quarterFrom: Procurement Manager
On-time delivery rate per supplierFrom: Procurement Manager
Top 5 SKUs by purchase valueFrom: CFO
Stock-out risk: SKUs with under 7 days of supplyFrom: Warehouse Lead
Late shipments this quarterFrom: Ops Director
Medium5 missions
Average lead time per supplierFrom: Procurement Manager
Latest inventory on hand per warehouseFrom: Warehouse Lead
Forecast accuracy by SKU last weekFrom: Demand Planner
Lead-time consistency per supplierProFrom: Procurement Manager
Overstocked SKUs (over 15 days of supply)ProFrom: Warehouse Lead
Hard5 missions
Top 3 SKUs per category by purchase valueProFrom: CFO
Supplier scorecard (lead time + on-time + cancellation)ProFrom: Ops Director
Demand week-over-week changeProFrom: Demand Planner
Stockout root cause: SKUs with no incoming POProFrom: Warehouse Lead
Inventory turnover ratio (last week)ProFrom: CFO
Expert5 missions
Point-in-time supplier on-time target (SCD2 reconstruction)ProFrom: Ops Director
Lead-time trend per supplier (monthly average)ProFrom: Procurement Manager
ABC analysis: classify SKUs by spend shareProFrom: CFO
Forecast accuracy decomposition (bias + precision per SKU)ProFrom: Demand Planner
Reorder-point breach: SKUs below their ROPProFrom: Warehouse Lead
Master5 missions
Supplier health capstone (multi-CTE scorecard)ProFrom: Ops Director
Multi-warehouse rebalancing planProFrom: Warehouse Lead
Demand stability per SKU (coefficient of variation)ProFrom: Demand Planner
Supplier concentration risk per category (Herfindahl index)ProFrom: CFO
Operations KPI capstone (board scoreboard)ProFrom: Ops Director

The Database

An inbound supply-chain star schema: 25 SKUs across 5 categories, 8 active suppliers (one ghost), 4 warehouses, 79 POs spanning Nov 2025 – Apr 2026 (mix of received / in_transit / cancelled), 85 weekly inventory snapshots with planted duplicates, and 40 demand rows for forecast-accuracy missions. Planted data-quality issues: trailing whitespace on supplier name, casing drift on category, duplicate sku_code, ghost supplier row, duplicate snapshot rows.

dim_skus (30)dim_suppliers (9)dim_warehouses (4)fact_purchase_orders (79)fact_inventory_snapshots (85)fact_demand (120)fact_supplier_changes (13)

●dimension tables  ● fact tables

Ship the SQL ops analysts run every morning

Lead-time variance, supplier on-time scorecards, days-of-supply alerts, MAPE — the queries that decide where inventory goes.

Looking for something different?

|