Home
/
Warehouse Operations Analytics
/
Mission 17
caseSQL
Warehouse Operations Analytics · Mission 17 of 30
Hard
SLA breaches
Threshold filter with date diff
Unlock with Pro
→
Back to Warehouse Operations Analytics
The Brief
You'll practice
Date arithmetic
WHERE
← Previous
Mission 16
Next →
Mission 18
All 30 missions in Warehouse Operations Analytics
↓
1.
Zone count
2.
Worker roster
3.
Inbound receipt count
4.
Inventory snapshot top 10
5.
Dock-to-stock average
6.
SKUs by velocity class
7.
UPLH by zone
8.
Top SKUs by pick frequency
9.
Inbound by day of week
10.
Cycle count variance by zone
11.
Pick accuracy
12.
Pick rate by zone and shift
13.
Dock-to-stock 3-phase
14.
Workers vs median LPH
15.
Wave completion time
16.
Accuracy root cause
17.
SLA breaches
18.
Labor by function
19.
Slotting mismatch
20.
Shift handoff analysis
21.
UPLH normalized for travel
22.
Cycle count $$$ triage
23.
Percentile distribution
24.
Zone utilization
25.
Wave failure analysis
26.
Slotting recommendation
27.
Tenure cohort productivity
28.
Perfect inbound rate
29.
Operations scorecard
30.
DC capstone