Spend concentration
A small group of suppliers accounts for a disproportionate share of total spend — making them the highest-leverage relationships to manage.
All projects
Procurement Analytics
Procurement Spend Analytics
A single, drillable view of organisational spend.
- Power BI
- DAX
- Power Query
- Star Schema
- Tabular Editor
Overview
Procurement spend was reported through disconnected spreadsheets, with each stakeholder maintaining their own version of the numbers. This project consolidated spend reporting into one governed Power BI model.
The report gives category managers and leadership an interactive view of total spend, spend mix and supplier performance — with drill-down filtering across categories, suppliers and regions.
The business problem
Spend data lived in multiple systems and formats. Supplier names were inconsistent, categories were classified differently across business units, and every reporting cycle meant hours of manual consolidation in Excel.
Leadership could not confidently answer basic questions — where the money goes, how spend splits between direct and indirect, and which suppliers concentrate the most volume.
Spend by category
Drill-down
Direct 62%
Indirect 38%
Objectives
- Consolidate spend data into a single, governed semantic model
- Enable drill-down analysis across categories, suppliers and regions
- Separate direct vs indirect and recurring vs non-recurring spend
- Track realised savings and supplier concentration KPIs
- Replace manual Excel reporting with an automated refresh
Data architecture
- 01
Source systems
Spend transactions extracted from ERP and procurement records into consistent staging tables.
- 02
Power Query transformation
Supplier name standardisation, category mapping and data cleansing applied before loading.
- 03
Star schema model
A central spend fact table surrounded by supplier, category, region and date dimensions.
- 04
DAX measure layer
Measures for total spend, spend mix, savings rate and supplier concentration.
- 05
Dashboard layer
Drill-down pages with bookmarks, tooltips and cross-filtering tuned for category managers.
Dashboards
Spend by category
Drill-down
Direct 62%
Indirect 38%
Spend by category
Drill-down
Direct 62%
Indirect 38%
Key insights
Direct vs indirect split
Direct spend dominates the mix, but indirect categories show the fastest growth — an early signal for policy attention.
Category hotspots
A handful of categories drive most of the month-to-month variance, focusing review meetings on where it matters.
Outcomes
Single source of truth
One governed model replaced scattered spreadsheet reporting across teams.
Faster reporting
Manual consolidation cycles became scheduled, automated refreshes.
Self-service insight
Category managers drill into any category, supplier or region without analyst support.
See the report in action
Live report coming soon — this case study will link directly to the published report.