Warehouse Operations Analytics

Pick rates, dock-to-stock, and slotting.
The SQL DC managers run at the morning stand-up.

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.

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

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.

Slotting Recommendation

Cross ABC velocity analysis with current zone assignments to identify misslotted A-class SKUs wasting travel time.

The Missions

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

Starter5 missions
1
Zone countFrom: DC Manager
Worker rosterFrom: DC Manager
Inbound receipt countFrom: Inbound Manager
Inventory snapshot top 10From: DC Manager
Dock-to-stock averageFrom: Inbound Manager
Easy5 missions
SKUs by velocity classFrom: Warehouse Engineer
UPLH by zoneFrom: DC Manager
Top SKUs by pick frequencyFrom: Warehouse Engineer
Inbound by day of weekFrom: Inbound Manager
Cycle count variance by zoneFrom: Inventory Control Manager
Medium5 missions
Pick accuracyFrom: DC Manager
Pick rate by zone and shiftFrom: DC Manager
Dock-to-stock 3-phaseFrom: Inbound Manager
Workers vs median LPHProFrom: DC Manager
Wave completion timeProFrom: Operations Supervisor
Hard5 missions
Accuracy root causeProFrom: DC Manager
SLA breachesProFrom: Inbound Manager
Labor by functionProFrom: DC Manager
Slotting mismatchProFrom: Warehouse Engineer
Shift handoff analysisProFrom: Operations Supervisor
Expert5 missions
UPLH normalized for travelProFrom: Industrial Engineer
Cycle count $$$ triageProFrom: Inventory Control Manager
Percentile distributionProFrom: Industrial Engineer
Zone utilizationProFrom: Warehouse Engineer
Wave failure analysisProFrom: Operations Supervisor
Master5 missions
Slotting recommendationProFrom: Warehouse Engineer
Tenure cohort productivityProFrom: DC Manager
Perfect inbound rateProFrom: Inbound Manager
Operations scorecardProFrom: DC Manager
DC capstoneProFrom: DC Director

The Database

A warehouse operations star schema: 5 zones (GOLDEN/STANDARD/BULK/COLD/HAZMAT), 20 workers, 40 SKUs, 80 inbound receipts, 500 pick tasks, 120 inventory positions, 90 cycle counts. Planted data-quality issues: NIGHT shift UPLH is 18% below DAY; OVERFLOW zone pick error rate 4× GOLDEN; dock door 3 has 2× average dock-to-stock time; 12 A-class SKUs currently in BULK zone (slotting mismatch).

dim_zones (5)dim_workers (20)dim_skus (40)fact_inbound_receipts (80)fact_pick_tasks (500)fact_inventory_positions (120)fact_cycle_counts (90)

●dimension tables  ● fact tables

Ship the SQL DC managers check every morning

UPLH, dock-to-stock, pick accuracy, slotting — the queries that keep the warehouse running on time.

Looking for something different?

|