Indicative Content
Module 1: Introduction to Procurement Analytics: General Overview of procurement analytics, Significance of Procurement Analytics, Basics of Data in Procurement, The Data Challenge in procurement analytics, Building insights from Procurement Data, Classification of Procurement Data, Challenges faced in procurement analytics
Module 2: Introduction to Data Analytics: Overview of Data Analytics, Types of analytics and their relationships, Data Pre-processing, Conducting Exploratory Data Analysis, Basic Practices for data visualization, Building Dashboards, Identifying and analysing Key Performance Indicators, Mitigating the Risks involved in Procurement
Module 3: Program Management: Tools and Techniques for tracking of Procurement projects, Management of Procurement tasks and activities, Activities affecting procurement projects, Creating progress reports for procurement projects, Identifying performance risks across procurement projects, Market trends
Module 4: Performance Evaluation: Evaluating and analysing performance data on suppliers, Evaluating operational performance (buyers on workload, productivity, procurement cycle time), Management tools for evaluation, Techniques for data analysis during performance evaluation, Identifying performance risks across multiple dimensions, Mitigating performance risks.
Module 5: Software for Procurement Analytics: Introduction to various software used for procurement analytics, Typical features and functionality of an analytics software, BI Tools and Advanced Analytical Tools, Procure-to-pay and Strategic sourcing tools, Introduction to SAP Ariba and a case study, Introduction to GEP Smart and a case study, Introduction to Procurify and a case study
Module 6: Procurement Analytics with Microsoft Excel: Introduction to Microsoft Excel for procurement analytics, Overview of cost models, Developing cost models, Assessing supplier pricing, Developing weighted average supplier scorecards, Application of Macros for Strategic purchasing work
Module 7: Procurement Analytics with Microsoft Excel II: Spend Analysis, Development of charts to compare bids and track performance, Pivot Tables, Functions, and Subtotals for purchasing data, Developing Target Pricing Models, Improving Negotiation strategies through target costing models, Filtering, Conditional Formatting, and VLOOKUP
Module 8: Statistical Analysis: Measures of Central Tendency, Measures of Variance, Confidence Interval, Skewness, Normalisation through Log Transformation
Module 9: Statistical Analysis II, Hypothesis Testing (One-tailed test), Hypothesis Testing (2-tailed test), Predictive Analytics for decision making
Module 10: Business Analytics: Understanding decision making in business, Maturity Stage in Analytics, Analytics Techniques in Use, Analytics Lifecycle, Data Visualization