Procurement & Sourcing Analytics

PO cycle time, PPV, and supplier risk.
The SQL procurement analysts run before every QBR.

PO cycle time analysis, purchase price variance, maverick spend detection, three-way match exceptions, and supplier risk scorecards — the full procurement & sourcing 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

PO Lifecycle Analysis

Trace the full req → PO → ASN → receipt → invoice cycle and measure cycle time at every stage.

Purchase Price Variance

Compare actual vs contracted unit price to surface PPV exceedances by category — the metric that drives finance escalations.

Maverick Spend Detection

Find POs with no contract_id — off-contract spend that bypasses negotiated pricing.

Three-Way Match Exceptions

Join PO + receipt + invoice to find quantity and price mismatches that stall AP automation.

The Missions

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

Starter5 missions
1
First look at suppliersFrom: Procurement Director
Category catalogFrom: Category Manager
Open POs countFrom: Procurement Manager
Active contract countFrom: Sourcing Manager
Top 10 invoices by amountFrom: AP Manager
Easy5 missions
Spend by categoryFrom: CFO
Supplier PO volumeFrom: Procurement Manager
On-time delivery per supplierFrom: Sourcing Manager
Average lead timeFrom: Procurement Manager
ATF detectionFrom: CPO
Medium5 missions
Top 10 suppliers by spendFrom: CPO
PO cycle timeFrom: Procurement Director
Preferred vs non-preferred shareFrom: Category Manager
Invoice payment timingProFrom: AP Manager
Purchase price varianceProFrom: Risk Manager
Hard5 missions
3-way matchProFrom: Finance Controller
Lead-time CV by supplierProFrom: Category Manager
Contract compliance rateProFrom: AP Manager
Spend under management %ProFrom: Procurement Director
Single-source category riskProFrom: CPO
Expert5 missions
Supplier scorecardProFrom: Supply Planner
PPV walk by monthProFrom: CPO
Maverick spend shareProFrom: Risk Manager
Apex supplier dedupProFrom: Finance Controller
Apex consolidated spendProFrom: Procurement Director
Master5 missions
Category x spend-type cubeProFrom: CFO
Category HHI concentrationProFrom: Risk Manager
Dual-source coverageProFrom: Procurement Director
Supplier risk scoreProFrom: VP Supply Chain
Procurement capstoneProFrom: CPO

The Database

A procurement star schema: 12 suppliers (3 name-variant aliases for the same entity), 8 spend categories, 14 contracts, 95 POs with 22% off-contract (null contract_id), 88 receipts, 82 invoices. Planted data-quality issues: 3 after-the-fact POs where invoice precedes PO date; 5 PPV exceedances where unit_price > contracted_price; preferred supplier with worst lead-time performance.

dim_suppliers (12)dim_categories (8)dim_contracts (14)fact_purchase_orders (95)fact_receipts (88)fact_invoices (82)

●dimension tables  ● fact tables

Ship the SQL every supplier QBR demands

PPV, maverick spend, cycle time, three-way match — the queries procurement directors ask for every quarter.

Looking for something different?

|