Course Outline

Module 1: Introduction to Procurement Analytics

• What is Procurement Analytics?
• Why is Procurement Analytics Important to My Business?
• Value of Analytics in Procurement
• Case Study: Impact of Procurement Analytics on Cost Reduction in a Manufacturing Company

Module 2: Excel Refresher 1: Introduction to Advanced Excel

• Introduction to Excel Shortcuts
• Understanding Various Excel Settings
• Understanding the Excel Layout
• Fundamentals and Numeric Data
• Saving Excel in Different Formats
• Importing Data into Excel
• Practical Component: Hands-on Exercise on Importing and Formatting Procurement Data

Module 3: Excel Refresher 2: Advanced Excel Formulas and Macros

• Working with Various Advanced Excel Data Functions
• Learning How to Work with Arrays and Lists
• Advanced Logical Formulas in Excel
• Advanced Text Formulas in Excel
• Understanding the Basics of VBAs and Macros
• Practical Component: Creating a Macro to Automate Procurement Data Analysis

Module 4: Procurement KPIs and Metrics

• Spend Under Management
• Spend vs. Budget
• The Total Cost of Ownership
• Cost Savings
• Cost Avoidance
• Average Payment Terms
• Number of Suppliers
• Contract Coverage
• Exchange Rate Exposure
• Vendor Accountability
• Case Study: Measuring and Improving Supplier Performance Using KPIs

Module 5: How to Use Excel for Procurement Analytics

• Analytics in Category Management
• Analytics in Strategic Sourcing
• Analytics in Contract Management
• Practical Component: Building an Excel Dashboard for Procurement Analysis

Module 6: Procurement Analytics Process

• Extracting Data from Different Sources
• Data Cleansing, Categorization, and Enrichment
• Reporting and Analysis
• Procurement Dashboard
• Supplier Segmentation
• Geo-Spatial Analytics
• Practical Component: Conducting Supplier Segmentation Using Excel

Module 7: Case Study: Procurement Analytics Using Excel

• Spend Analytics
• Contract Analytics
• Supplier Analytics
• Savings Lifecycle Analytics
• Spend Forecasting
• Material Forecasting
• Procurement Benchmarking
• Case Study: Comprehensive Procurement Analysis Using Excel

Module 8: Machine Learning for Supply Chain

• Introduction to Machine Learning
• Clustering
• Forecasting
• Classification
• Practical Component: Applying Machine Learning Techniques for Procurement Forecasting

Module 9: Practical Applications and Implementation

• Real-World Examples of Procurement Analytics
• Implementing Analytics in Your Organization
• Tools and Technologies for Procurement Analytics
• Practical Component: Developing a Procurement Analytics Implementation Plan

Module 10: Future Trends and Advanced Topics in Procurement Analytics

• Predictive Analytics in Procurement
• AI and Automation in Procurement
• Blockchain and Procurement
• Ethical Considerations in Procurement Analytics
• Practical Component: Exploring the Impact of AI and Blockchain on Procurement Strategies