Sourcing Analytics Course

Lesson 1 • Key Data Sources in Procurement

Maps the primary internal and external data sources used in sourcing. Students learn to evaluate data relevance and reliability before analysis.

Lesson 2 • Metrics That Drive Sourcing Decisions

Introduces the core KPIs used to measure sourcing performance. Provides a reference framework applied throughout the entire course.

Lesson 3 • Stakeholders and Analytics Roles

Identifies who produces and consumes sourcing analytics within an organization. Clarifies role boundaries between analysts, category managers, and executives.

Lesson 4 • What Is Sourcing Analytics

Defines sourcing analytics and its role in procurement decision-making. Establishes the conceptual baseline for all subsequent analytical work in the course.

Lesson 1 • Building an Analysis-Ready Dataset

Integrates cleansing steps into a repeatable pipeline that produces a structured spend dataset. Students apply all prior section skills in a unified workflow.

Lesson 2 • Supplier Name Normalization

Focuses on resolving supplier name variants that fragment spend visibility. Teaches fuzzy matching and rules-based consolidation approaches.

Lesson 3 • Understanding Raw Spend Data

Examines the structure and common defects of raw spend extracts. Prepares students to diagnose data quality issues before cleansing begins.

Lesson 4 • Data Governance for Spend Files

Establishes policies and controls that sustain data quality over time. Connects governance practices to ongoing analytics reliability.

Lesson 1 • Standard Taxonomy Frameworks

Reviews widely adopted commodity and category coding systems used in procurement. Students evaluate which framework best fits their organizational context.

Lesson 2 • Machine Learning-Assisted Classification

Introduces text classification models that automate spend categorization at scale. Students learn to train, validate, and monitor a classification model.

Lesson 3 • Validating and Maintaining the Taxonomy

Covers processes for auditing classification quality and evolving the taxonomy as spend changes. Ensures the taxonomy remains accurate and strategically relevant.

Lesson 4 • Manual and Rule-Based Classification

Teaches keyword mapping, supplier-to-category rules, and exception handling for classification. Builds the skill set needed before introducing automated methods.

Lesson 1 • Communicating Insights to Stakeholders

Translates analytical findings into concise narratives tailored to procurement and finance audiences. Bridges the gap between data output and strategic action.

Lesson 2 • Price and Cost Benchmarking

Compares internal unit prices against market benchmarks to quantify savings potential. Teaches data sourcing and normalization for valid price comparisons.

Lesson 3 • Supplier Spend Concentration Analysis

Examines how spend is distributed across the supplier base to identify consolidation opportunities. Directly informs supplier rationalization and negotiation strategies.

Lesson 4 • Designing Effective Spend Dashboards

Covers dashboard layout, chart selection, and interactivity principles for procurement audiences. Students build a spend dashboard that drives executive decisions.

Lesson 1 • Building Supplier Scorecards

Guides students through designing, populating, and automating supplier scorecards. Produces a reusable scorecard template applicable across categories.

Lesson 2 • Collecting and Integrating Performance Data

Covers data collection methods from ERP systems, surveys, and third-party sources. Teaches integration techniques that produce a unified supplier performance record.

Lesson 3 • Supplier Performance Measurement Frameworks

Introduces balanced scorecard and weighted KPI models for evaluating suppliers. Establishes the measurement architecture used throughout this chapter.

Lesson 4 • Identifying and Resolving Performance Gaps

Applies root-cause analysis to supplier performance deficiencies identified in scorecards. Connects analytical findings to corrective action planning.

Lesson 1 • Should-Cost Analysis

Deconstructs a product or service cost into its component drivers to establish a fair target price. Equips students to challenge supplier pricing with data-backed arguments.

Lesson 2 • Commodity Price Modeling

Builds regression and index-linking models to explain and forecast commodity price movements. Directly supports should-cost modeling and negotiation preparation.

Lesson 3 • Integrating Market Data into Sourcing Strategy

Combines internal spend data with external market intelligence to produce a comprehensive category strategy. Students synthesize all chapter skills into a market-informed sourcing plan.

Lesson 4 • Supply Market Competitive Analysis

Assesses supplier market structure, concentration, and competitive dynamics to inform sourcing strategy. Connects market power analysis to negotiation leverage decisions.

Lesson 1 • Risk Taxonomy for Sourcing

Defines the categories of risk relevant to procurement, from supply disruption to financial and compliance risk. Provides the classification structure used throughout this chapter.

Lesson 2 • Risk Monitoring and Early Warning Systems

Designs automated monitoring dashboards that alert procurement teams to emerging risk signals. Integrates internal and external data streams into a continuous risk view.

Lesson 3 • Supplier Financial Health Analysis

Uses financial ratios and credit signals to assess supplier viability and default risk. Teaches students to interpret financial data without requiring accounting expertise.

Lesson 4 • Supply Concentration and Dependency Risk

Measures single-source dependency and geographic concentration to expose hidden vulnerabilities. Connects concentration metrics to diversification strategy decisions.

Lesson 1 • Procurement Analytics Roadmap and Maturity

Synthesizes all course learning into a strategic roadmap for advancing analytics capability. Students assess their organization's maturity and design a prioritized improvement plan.

Lesson 2 • Sourcing Scenario and Sensitivity Analysis

Models multiple sourcing scenarios under varying assumptions to stress-test decisions. Teaches sensitivity analysis to identify which variables most influence outcomes.

Lesson 3 • Savings Identification and Tracking

Establishes a rigorous methodology for identifying, classifying, and tracking procurement savings. Produces a savings pipeline and reporting framework aligned to finance standards.

Lesson 4 • Competitive Bidding Analytics

Analyzes RFQ and auction data to evaluate bid competitiveness and supplier pricing behavior. Supports post-event analysis and future event design improvements.