Home
/
Procurement & Sourcing Analytics
/
Mission 16
caseSQL
Procurement & Sourcing Analytics · Mission 16 of 30
Hard
3-way match
Validate PO/receipt/invoice consistency
Unlock with Pro
→
Back to Procurement & Sourcing Analytics
The Brief
You'll practice
WHERE
← Previous
Mission 15
Next →
Mission 17
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