Procurement Analytics with Power BI and Tableau Training Course

Duration 5 days 10 modules · 33 contact hours
Level Intermediate Certificate on completion
Who attends Procurement Analysts, Category Managers and others
Fee from USD 1,100 KSh 95,000 for Kenyan organisations
Where 52 cities + online See dates by city
Next start 16 Nov 2026 Course code SD-P-124

Before you join: Participants should understand core procurement terms such as purchase orders, suppliers, contracts, invoices, categories and savings.

Dates & prices

Two start dates a month in every city, and live online on weekdays or weekends. Fees are per participant; classroom fees include tuition, materials, lunch and refreshments, and the certificate.

Suggest a date or city

Showing the next six months. Later dates, other cities and private deliveries for your team are available on request.

Course overview

Procurement teams hold large volumes of spend, supplier, contract, purchase-order and invoice data, yet many reports remain fragmented, manually prepared or focused only on historical totals. Decision-makers need clear evidence on price variance, maverick spend, contract compliance, supplier performance, savings delivery and supply risk. Procurement analysts must also explain what the data means, identify exceptions worth investigating and present findings in forms that category managers, finance teams and executives can act upon.

This course teaches participants to build procurement analytics in Microsoft Power BI and Tableau from source-to-pay data. Participants define meaningful procurement KPIs, prepare and model purchasing data, create calculated measures, analyse spend and supplier performance, and design interactive dashboards for different decision audiences. The course covers spend classification, Pareto analysis, price and volume variance, purchase-order compliance, contract utilisation, supplier scorecards, savings tracking and procurement risk indicators. Participants also learn how to test data quality, document metric definitions and avoid misleading visual conclusions.

Instruction combines short technical briefings with procurement cases, guided dashboard builds, group analysis and structured review of reporting choices. Cases use realistic data patterns from corporate, public-sector and regulated procurement environments, including fragmented supplier masters, off-contract buying and incomplete savings records. Participants leave with a reusable procurement analytics pack containing a KPI dictionary, data model design, dashboard wireframes, calculation patterns and a reporting implementation plan.

The course is suited to procurement professionals who already work with purchasing data and need stronger analytical and visual reporting capability. It is particularly relevant where procurement must demonstrate measurable contribution to cost control, compliance, supplier resilience and working-capital performance.

What you will be able to do

  • Define a procurement KPI hierarchy covering spend, compliance, savings, supplier performance and risk
  • Prepare purchase-to-pay data using Power Query transformations and documented quality checks
  • Build a procurement data model using fact tables, dimensions, relationships and date tables
  • Create DAX measures for spend variance, contract utilisation, savings and supplier performance
  • Develop Tableau calculations, parameters and dashboards for category and supplier analysis
  • Analyse spend concentration, price variance, maverick buying and purchase-order compliance
  • Design role-based procurement dashboards using effective visual hierarchy and exception cues
  • Produce a procurement analytics implementation plan with metric ownership and refresh controls

Benefits of attending

For you

  • Build credible procurement dashboards for category, supplier and executive reviews
  • Reduce manual spreadsheet reporting through reusable Power BI and Tableau models
  • Explain savings, compliance and variance results with traceable calculations
  • Identify off-contract buying and supplier concentration risks from transactional data
  • Create a practical portfolio of procurement analytics templates for workplace use

For your organisation

  • Improves visibility of spend leakage, contract non-compliance and unmanaged categories
  • Creates consistent KPI definitions across procurement, finance and business stakeholders
  • Strengthens supplier performance reviews with timely evidence and exception reporting
  • Reduces reporting effort through reusable data models and scheduled dashboard refreshes
  • Supports better sourcing, negotiation and demand-management decisions with quantified insights

Course modules

10 modules over 5 days

Participants can translate procurement decisions into measurable KPIs, analytical questions and reporting requirements.

  • Procurement decision questions translated into measurable analytical requirements
  • Spend, supplier, contract and purchase-order data mapped to process stages
  • Source-to-pay controls linked to analytical measures and exception signals
  • Kraljic portfolio positions connected to sourcing and supplier-risk metrics
  • Procurement KPI hierarchy distinguishing operational, tactical and strategic decisions
  • Metric definitions documented with owners, formulas, grain and refresh frequency
  • Leading and lagging indicators selected for savings, compliance and continuity

Participants can prepare procurement data and apply quality checks before analytical modelling.

  • Purchase-order, invoice and supplier extracts assessed for analytical fitness
  • Power Query transformations standardise dates, currencies, categories and supplier names
  • Duplicate suppliers identified through matching rules and master-data review
  • Missing purchase-order fields profiled using completeness and validity tests
  • Three-way-match exceptions classified by quantity, price and invoice discrepancies
  • Category taxonomies aligned across spend files, contracts and supplier records
  • Data-quality scorecards report accuracy, completeness, timeliness and consistency

Participants can build a Power BI procurement model that supports reliable filtering, comparison and drill-through.

  • Star schema separates transactional facts from supplier and category dimensions
  • Purchase-order and invoice facts connected through conformed procurement dimensions
  • Date tables support fiscal periods, rolling comparisons and delivery analysis
  • Relationship cardinality checked to prevent duplicated spend and incorrect totals
  • Role-playing dates manage order, receipt, invoice and payment analyses
  • Model granularity documented for line-level, order-level and supplier-level metrics
  • Drill-through paths connect executive summaries to transaction-level exceptions

Participants can create DAX measures for core procurement performance indicators and variance analysis.

  • DAX measure structure separates base spend, filters and comparison logic
  • Total spend calculated from invoice value, purchase-order value and committed spend
  • Year-to-date and prior-period comparisons use time-intelligence functions
  • Price variance isolates negotiated-price, invoice-price and quantity effects
  • Contract utilisation measures compare contracted spend against addressable expenditure
  • Maverick-spend rate identifies off-contract purchases within eligible categories
  • CALCULATE and filter context applied to category, supplier and business-unit metrics

Participants can create Tableau calculations and interactive views for procurement investigation.

  • Tableau data connections configured for procurement extracts and published sources
  • Calculated fields derive savings rates, compliance ratios and delivery variances
  • Parameters switch analysis between spend, savings, risk and supplier metrics
  • Level-of-detail expressions calculate supplier totals independent of visual filters
  • Sets identify strategic suppliers, high-value categories and exception populations
  • Actions connect category summaries with supplier and transaction detail
  • Table calculations reveal period trends, rankings and cumulative spend concentration

Participants can identify sourcing opportunities through structured spend, demand and price analysis.

  • Pareto analysis identifies suppliers and categories driving cumulative spend
  • Tail-spend analysis separates low-value suppliers from strategic sourcing priorities
  • Spend cubes segment expenditure by category, supplier, business unit and geography
  • Price-volume-mix analysis explains changes in category expenditure
  • Demand fragmentation measured through supplier counts, transaction frequency and order values
  • Should-cost indicators compare price dispersion within comparable purchased items
  • Savings opportunity pipeline ranks initiatives by value, feasibility and implementation timing

Participants can measure procurement compliance and pinpoint control failures requiring action.

  • Contract coverage measures addressable spend placed against active agreements
  • Purchase-order compliance tracks orders raised before invoice receipt
  • Non-catalogue purchasing analysed by requester, category and approval route
  • Invoice exceptions segmented by tolerance breach, supplier and payment impact
  • Approval-cycle analysis measures requisition-to-order elapsed time and bottlenecks
  • Contract expiry calendars flag spend exposed to renewal and sourcing risk
  • Control exceptions prioritised using spend value, recurrence and business criticality

Participants can develop supplier scorecards and interpret risk, service and savings indicators.

  • Supplier scorecards combine quality, delivery, cost, compliance and responsiveness measures
  • On-time-in-full performance calculated from promised and actual receipt dates
  • Supplier concentration ratios quantify dependency within critical categories
  • Risk heat maps combine supply criticality, performance trends and exposure indicators
  • Savings baselines distinguish budget, negotiated, avoided-cost and realised savings
  • Savings validation links initiatives to finance-approved baseline and actual spend
  • Trend analysis separates one-off gains from recurring procurement benefits

Participants can design procurement dashboards that communicate priorities, exceptions and actions clearly.

  • Dashboard audiences defined for executives, category managers and operational buyers
  • Visual hierarchy places decisions, exceptions and actions before supporting detail
  • KPI cards paired with targets, trends and variance explanations
  • Colour conventions distinguish positive performance, warnings and control breaches
  • Scatterplots expose supplier segmentation through spend, risk and performance
  • Tooltip design provides metric definitions, context and transaction-level evidence
  • Narrative annotations explain material changes without overstating causal conclusions

Participants can establish governance controls and plan a practical procurement analytics implementation.

  • Metric governance assigns business owners, data stewards and approval responsibilities
  • Refresh schedules align dashboard availability with procurement review cycles
  • Row-level security restricts supplier, category and business-unit data access
  • Reconciliation controls compare dashboard totals with finance and ERP records
  • Dashboard adoption tracked through usage metrics, feedback and decision outcomes
  • Analytical backlog prioritised using value, effort, data readiness and stakeholder demand
  • Ninety-day application plan defines deliverables, milestones and review points

Exercises and examples are adapted to each cohort's sectors and roles.

What you take back to work

  1. Procurement KPI dictionary template
  2. Source-to-pay data quality checklist
  3. Power BI procurement data model
  4. DAX procurement measures library
  5. Tableau procurement dashboard wireframes
  6. Ninety-day analytics implementation plan

Who should attend

  • Procurement Analysts — need repeatable methods for turning purchasing data into decisions
  • Category Managers — need evidence on spend, supplier performance and sourcing opportunities
  • Strategic Sourcing Specialists — need fact-based support for negotiations and category strategies
  • Procurement Managers — need dashboards that monitor compliance, savings and operational performance
  • Supply Chain Analysts — need to connect supplier, purchasing and service-level data
  • Finance Business Partners — need reliable procurement measures for budget and savings assurance

Skills and tools covered

Spend analyticsProcurement KPI designPower BI modellingTableau dashboardingSupplier performance analysisData quality controls

Tools and standards

Microsoft Power BI, Tableau, Power Query, DAX

How the course runs

Training methodology

The course uses short instructor briefings followed by guided builds in Power BI and Tableau. Participants work with realistic procurement datasets to prepare data, define measures, investigate exceptions and construct dashboards. Individual and group activities examine spend leakage, supplier performance, contract utilisation and savings claims. Facilitated reviews compare alternative visual designs and calculation choices. A procurement reporting simulation tests how analysts respond to stakeholder questions. The final application-planning segment translates course methods into participants' own data, reporting priorities and governance requirements.

Requirements and prerequisites

Participants should understand core procurement terms such as purchase orders, suppliers, contracts, invoices, categories and savings. Experience using Excel tables, filters, pivot tables or basic charts is expected. Participants should be comfortable interpreting percentages, variances, averages and simple ratios. Prior use of Power BI or Tableau is helpful but not required; the course introduces the required interface and calculation concepts. Programming, SQL, advanced statistics and prior dashboard-development experience are not required. Participants gain most value when they can relate the methods to their own purchasing, supplier or contract reporting challenges.

A typical training day

08:30 – 10:30First session
10:30 – 10:45Refreshment break
10:45 – 12:30Second session
12:30 – 13:30Lunch and networking
13:30 – 15:00Third session
15:00 – 15:15Refreshment break
15:15 – 16:30Workshop and daily review

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

What the fee includes

  • Instruction by a practitioner facilitator
  • Full course workbook and materials
  • Exercise files, templates and case studies
  • Refreshments and lunch on classroom deliveries
  • Certificate of completion
  • Post-course application plan

Frequently asked questions

Participants need practical familiarity with procurement processes and basic spreadsheet analysis. Prior Power BI or Tableau experience is useful but not required, and no coding or SQL knowledge is assumed.

Participants should bring a laptop capable of running Power BI Desktop and accessing Tableau where course licensing permits. They may also bring non-sensitive examples of current procurement reports, KPI definitions or reporting problems for application planning.

The course is designed for procurement analysts, category managers, sourcing specialists, procurement managers and finance partners supporting procurement. It suits professionals who need to move from spreadsheet-based reporting to controlled, interactive analysis.

General visualisation courses teach software functions across many business uses. This course applies those functions to source-to-pay data, procurement KPIs, contract compliance, supplier scorecards, savings assurance and sourcing decisions.

Participants can use the KPI dictionary, data model patterns, calculation approaches and dashboard wireframes with their own procurement data. The application plan helps them prioritise an initial dashboard or analytical improvement with defined owners and controls.

The programme runs from 08:30 to 16:30 each day, providing about 6.5 contact hours daily and approximately 32.5 contact hours overall. Time is divided across ten modules covering procurement metrics, data preparation, Power BI, Tableau, spend analysis, compliance, supplier analytics, dashboard design and implementation planning.

Questions about this course?

Ask about dates, fees, group bookings or running it for your team. Our training team replies by email.

Ask on WhatsApp info@skillsetdevelopment.com

More courses in Procurement

Procurement Mini MBA in Procurement Training Course 10 days · from USD 2,200 · next 16 Nov Procurement Predictive Procurement Analytics Training Course 10 days · from USD 2,200 · next 16 Nov Procurement Principles of Procurement Training Course 5 days · from USD 1,100 · next 16 Nov Procurement Procurement Analytics Using Excel Training Course 5 days · from USD 1,100 · next 16 Nov Procurement Procurement Best Practice Training Course 5 days · from USD 1,100 · next 16 Nov Procurement Procurement Contract Management Training Course 10 days · from USD 2,200 · next 16 Nov Procurement Procurement Function Transformation Training Course 10 days · from USD 2,200 · next 16 Nov Procurement Procurement for Project Teams Training Course 5 days · from USD 1,100 · next 16 Nov