Procurement Spend Analysis for Procurement Analysts Training Course

Course overview

Procurement analysts are often asked to explain where money is going, which suppliers or categories are driving cost, and where savings opportunities exist—using data that is fragmented across ERP extracts, P-cards, invoices, purchase orders, contracts and supplier files. This course addresses the practical work behind a defensible spend view: resolving duplicate suppliers, normalising descriptions and units, mapping transactions to categories, testing data quality, and distinguishing genuine sourcing opportunities from one-off or non-addressable spend. Participants learn to produce analysis that procurement leaders, finance teams and category managers can act on.

The course covers the full spend-analysis workflow, from defining the business question and data requirements through cleansing, enrichment, classification, dashboarding and opportunity prioritisation. Participants use Excel and Power BI techniques to profile datasets, standardise supplier masters, apply UNSPSC-based category structures, calculate spend concentration, measure contract compliance, identify tail spend, and create price and volume variance views. They also learn how to frame findings using practical measures such as addressable spend, supplier consolidation potential, maverick spend, savings pipeline value and category risk indicators.

Instruction is built around a realistic multi-source procurement dataset containing purchase-order, invoice, supplier and contract records. Each day combines short technical demonstrations with guided analysis, peer review and decision-focused case discussions. By the end of the week, participants produce a documented spend-analysis pack: a cleansed data model, supplier and category taxonomy, dashboard, opportunity register and stakeholder-ready recommendations. This makes the course suitable for analysts who need to move from producing reports to influencing sourcing priorities and procurement performance decisions.

The programme serves procurement analysts, spend analysts and category-support professionals with working exposure to purchasing data who need a repeatable method for turning raw transaction data into a credible savings and compliance agenda.

Course objectives

By the end of this course, participants will be able to:

• Define a spend-analysis scope, business questions and data-request specification for a procurement category or enterprise spend review
• Profile procurement transaction data to identify missing fields, duplicate records, inconsistent units and unreliable supplier identifiers
• Clean and standardise supplier master data using parent-child supplier mapping, legal-entity rules and duplicate-detection logic
• Classify purchase transactions into a fit-for-purpose category taxonomy using UNSPSC mapping and controlled exception handling
• Calculate spend concentration, tail spend, addressable spend and supplier rationalisation indicators from a cleansed dataset
• Build Excel and Power BI dashboards that segment spend by supplier, category, business unit, geography and time period
• Identify contract-leakage, maverick-spend and price-variance opportunities using purchase-order, invoice and contract data
• Produce a prioritised spend-opportunity register with quantified value, assumptions, owners, risks and recommended next actions

Benefits of attending

Target competencies

Who should attend

• Procurement Analysts — who turn purchasing and supplier data into category, savings and compliance recommendations
• Spend Analysts — who need a repeatable process for cleansing, classifying and visualising enterprise spend
• Category Analysts — who support category managers with supplier concentration, demand and sourcing opportunity evidence
• Strategic Sourcing Analysts — who need fact-based baselines before supplier negotiations and sourcing events
• Procurement Operations Analysts — who investigate purchase-order compliance, P-card spend and process leakage
• Supply Chain Data Analysts — who combine supplier, materials and transaction data to support procurement decisions

Requirements and prerequisites

Participants should have experience working with procurement, finance or supply-chain data and be comfortable with Excel tables, filters, formulas and pivot tables. Familiarity with purchase orders, invoices, suppliers, contracts, cost centres and basic procurement categories is assumed. Participants should understand the difference between direct and indirect spend and be able to interpret simple totals, percentages and variances. Prior Power BI experience is helpful but not essential; guided exercises cover the required features. SQL, programming, advanced statistics, data-science tools and prior experience administering an ERP or e-procurement system are not required.

Training methodology

The instructor uses a working procurement dataset with deliberately flawed supplier names, incomplete category fields, off-contract purchases and inconsistent descriptions. Participants alternate between instructor-led demonstrations in Excel and Power BI, individual data-cleaning tasks, and small-group reviews of sourcing implications. Case discussions test whether a pattern represents a real opportunity, a data issue or a stakeholder dependency. Each day closes with an applied output that feeds the final spend-analysis pack. On day five, participants present their dashboard and opportunity register, receive structured feedback, and prepare an application plan for their own spend environment.

Course outline

Day 1: Building a trustworthy spend baseline

• Spend-analysis objectives, decision questions and stakeholder use cases
• Procurement data sources across ERP, P2P, invoice, contract and P-card systems
• Required data fields for supplier, category, cost centre and transaction analysis
• Data-profiling checks for completeness, validity, uniqueness and consistency
• Spend universe definition and exclusions for taxes, intercompany charges and non-addressable spend
• Direct, indirect, addressable and managed-spend segmentation rules
• Excel Power Query import, column profiling and repeatable transformation steps

Workshop: Participants profile a multi-source spend extract and produce a data-quality scorecard with documented scope assumptions.

Day 2: Cleansing suppliers and classifying spend

• Supplier-name standardisation rules and legal-entity identification
• Duplicate supplier detection using fuzzy matching and common identifier fields
• Parent-child supplier hierarchy construction for concentration analysis
• Transaction-description cleansing, unit normalisation and free-text controls
• UNSPSC structure, category levels and fit-for-purpose taxonomy design
• Rules-based and manual-exception approaches to spend classification
• Classification confidence testing and audit-trail documentation

Workshop: Participants create a supplier cross-reference table and classify a sample of unstructured transactions into an agreed category taxonomy.

Day 3: Analysing spend patterns and sourcing leverage

• Pareto analysis for supplier concentration and category spend prioritisation
• Tail-spend thresholds, transaction frequency and low-value purchase patterns
• Spend segmentation by business unit, geography, plant, cost centre and requester
• Time-series analysis for seasonality, demand shifts and purchasing trends
• Price-volume-mix analysis using quantity, unit price and extended-spend fields
• Supplier consolidation indicators and addressable-demand aggregation
• Opportunity sizing assumptions for sourcing, demand management and process compliance

Workshop: Participants segment a cleansed spend file and produce a ranked shortlist of sourcing and supplier-rationalisation opportunities.

Day 4: Contract compliance and decision-ready dashboards

• Contract-to-transaction matching using supplier, category, date and item attributes
• Maverick-spend detection and off-contract purchase analysis
• Contract utilisation, preferred-supplier compliance and negotiated-rate testing
• Power BI data model relationships for supplier, category, contract and transaction tables
• DAX measures for total spend, addressable spend, compliance rate and variance
• Interactive dashboard design for procurement leadership and category managers
• Chart selection, drill-through paths and evidence-based dashboard commentary

Workshop: Participants build a Power BI compliance dashboard that identifies off-contract spend and the business units driving it.

Day 5: Prioritising action and presenting recommendations

• Opportunity-register structure for value, confidence, effort, owner and timeline
• Savings calculation methods for price reduction, consolidation and demand reduction
• Risk assessment for supplier dependency, data limitations and implementation barriers
• Stakeholder validation questions for finance, category management and business units
• Recommendation narratives that separate findings, assumptions and proposed actions
• Spend-analysis governance, refresh cycles and KPI ownership
• Ninety-day implementation planning for a live procurement spend review

Workshop: Participants complete and present a stakeholder-ready spend-analysis pack containing a dashboard, opportunity register and 90-day action plan.

Tools & standards covered

Microsoft Excel, Microsoft Power BI Desktop, SAP Ariba Spend Analysis, UNSPSC

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions