Early rounds win
Most of the achievable savings are captured in the first one or two rounds — later rounds return diminishing value.
All projects
Procurement Analytics
Procurement Negotiation Analytics
Measuring what negotiation actually delivers.
- Power BI
- DAX
- Power Query
- Star Schema
Overview
Negotiation outcomes were tracked anecdotally — savings were claimed, but rarely verified against a consistent baseline. This report measures negotiation savings, savings percentage and negotiation performance with a clear before/after methodology.
Savings are tracked alongside supporting business KPIs so sourcing teams can see whether negotiated outcomes hold up in actual spend.
The business problem
Every negotiator counted savings differently. Without a shared baseline, results could not be compared, aggregated or defended — and the true contribution of sourcing work was invisible to leadership.
Negotiation savings
Before / after
Savings rate
8.4%
Round 1
3.1%
Round 2
2.9%
Round 3
2.4%
Objectives
- Establish a consistent before/after savings baseline
- Measure savings rate by negotiation round and category
- Track negotiation performance over time
- Connect negotiated savings to realised spend
Data architecture
- 01
Source systems
Contracts, price baselines and spend transactions brought into one model.
- 02
Power Query transformation
Baseline alignment — matching negotiated line items to their pre-negotiation reference prices.
- 03
Star schema model
Savings events as facts, with supplier, category, negotiation round and date dimensions.
- 04
DAX measure layer
Savings amount, savings percentage and annualised-impact measures with a consistent baseline definition.
- 05
Dashboard layer
Round-by-round and category views connecting negotiated savings to realised spend.
Dashboards
Negotiation savings
Before / after
Savings rate
8.4%
Round 1
3.1%
Round 2
2.9%
Round 3
2.4%
Negotiation savings
Before / after
Savings rate
8.4%
Round 1
3.1%
Round 2
2.9%
Round 3
2.4%
Key insights
Savings persistence
A meaningful share of negotiated savings erodes over time as volumes and prices drift — persistence tracking keeps them honest.
Category differences
Savings percentages differ sharply by category, so flat targets across categories systematically over- or under-shoot.
Outcomes
Consistent measurement
A shared baseline definition made savings results comparable and defensible.
Credible reporting
Sourcing contribution became visible to leadership in one view.
Sharper strategy
Round-by-round views show where negotiation effort actually pays off.
See the report in action
Live report coming soon — this case study will link directly to the published report.