Supply Chain, Inventory & Procurement Analytics

Instructor: Alaa Hady · Language: English or Arabic · Suggested duration: 2 days · Level: Intermediate (Level 200)

Objectives

• Model end-to-end supply chain operations spanning Procurement, Inventory Management, Warehousing, and Logistics/Fulfillment.
• Calculate industry-standard supply chain KPIs: OTIF (On-Time In-Full), Inventory Turnover, Days Inventory Outstanding (DIO), Stockout rates, and Purchase Price Variance (PPV).
• Perform dynamic ABC-XYZ Inventory Segmentation in DAX to optimize safety stock and working capital.
• Build supplier scorecards and supply chain exception monitors.

Outline and contents

1. Supply Chain data architecture: Purchase Orders (PO), Goods Receipts, Inventory Daily Snapshots, Bill of Materials (BOM), and Sales Shipments
2. Procurement & Supplier Performance: Spend cube analysis, tail-spend identification, Purchase Price Variance (PPV), Lead-Time variability, and Supplier Scorecards
3. Inventory & Working Capital Analytics:
   • Modelling semi-additive inventory balance snapshots (CLOSINGBALANCEMONTH, Average Inventory)
   • Inventory Turns, Days of Supply / DIO, GMROI, Slow-Moving & Obsolete (SLOB) aging buckets, and Stockout frequency
   • Dynamic ABC-XYZ Matrix Segmentation in DAX: combining value contribution (ABC Pareto) with demand volatility (XYZ Coefficient of Variation)
4. Order Fulfillment & Logistics: calculating OTIF (On-Time In-Full) at line and order level, fill rate, backorder aging, and freight cost per unit/lane
5. Supply Chain Risk & What-If simulation: modeling lead-time spikes and safety stock buffer adjustments
6. Hands-on Lab: Building an End-to-End OTIF, Supplier Scorecard & ABC-XYZ Inventory Optimization Dashboard

Target audience

Supply chain analysts, procurement specialists, inventory planners, logistics managers, manufacturing teams, and ERP BI developers.

Expected outcomes

Participants can connect procurement, inventory, and fulfillment data into actionable dashboards that free up trapped working capital, reduce stockouts, and hold suppliers accountable.