Home
/
Procurement & Sourcing Analytics
/
Mission 17
caseSQL
Procurement & Sourcing Analytics · Mission 17 of 30
Hard
Lead-time CV by supplier
Coefficient of variation
Unlock with Pro
→
Back to Procurement & Sourcing Analytics
The Brief
You'll practice
SQL practice
← Previous
Mission 16
Next →
Mission 18
All 30 missions in Procurement & Sourcing Analytics
↓
1.
First look at suppliers
2.
Category catalog
3.
Open POs count
4.
Active contract count
5.
Top 10 invoices by amount
6.
Spend by category
7.
Supplier PO volume
8.
On-time delivery per supplier
9.
Average lead time
10.
ATF detection
11.
Top 10 suppliers by spend
12.
PO cycle time
13.
Preferred vs non-preferred share
14.
Invoice payment timing
15.
Purchase price variance
16.
3-way match
17.
Lead-time CV by supplier
18.
Contract compliance rate
19.
Spend under management %
20.
Single-source category risk
21.
Supplier scorecard
22.
PPV walk by month
23.
Maverick spend share
24.
Apex supplier dedup
25.
Apex consolidated spend
26.
Category x spend-type cube
27.
Category HHI concentration
28.
Dual-source coverage
29.
Supplier risk score
30.
Procurement capstone