An advanced understanding of Microsoft Excel. The completion of Data Analytics and Technical Skills for SCM (Part 1) is recommended, but not required. 

Supply Chain Management (SCM) is swiftly advancing and increasingly recognized as a vital driver of value creation. To meet the demand for shorter turnover times, waste reduction, and optimized performance while fostering strong supplier relationships, SCM organizations are undergoing modernization. This evolution necessitates a new breed of analysts who possess adept technical skills, and are capable of swiftly processing complex data sets, automating data mining and analysis, and effectively communicating results. Whether you're an aspiring SCM professional or seeking to enhance your existing skill set, this course offers an opportunity to augment your knowledge by harnessing the analytical power of Excel.  

Part 2 of Data Analytics and Technical Skills for SCM focuses specifically on predictive and prescriptive analytics, equipping participants with essential expertise in these domains. 

Who Should Attend?

SCM Professionals who want to become more tech-savvy and supply their companies with advanced analysis to help optimize performance and maximize savings. 

Why This Workshop?

This is a HANDS-ON, EXERCISE-HEAVY workshop where you will learn analytical techniques for the SCM profession. Although there are many online Excel courses, this workshop is unique in that:

• You get to hone your Excel skills in a classroom setting where you have the chance to ask questions, get one-on-one time with the instructor, and learn from fellow participants,
• All the examples, challenges and tools in this workshop are designed for SCM roles – from procurement to inventory management to strategic sourcing to category management and more, and
• Participants will be given a host of real and powerful Excel tools that they can immediately use in their day-to-day work. 

What Value Can I Expect?  

You will acquire enhanced proficiency and analytical capabilities in Excel. Aside from SCM-related exercises, this workshop provides tools and templates you can use immediately upon your return to work. 

What Version of Excel Will We Be Using?

The standard version that most corporations use today is MS Excel 365, which we’ll use throughout this workshop. Don’t worry if you’re using Excel 2013 or 2016, the workshop facilitator will help you bridge the gap between versions, which aren’t that much different from each other.

By attending this workshop, participants will:

• Apply multiple forecasting methods – useful for making better supply chain strategies
• Present your data professionally through conditional formatting and advanced charting techniques
• Create beautiful and effective dashboards
• Harness the power of advanced analytical methods, including the famous Monte Carlo Simulation method

Some of the topics covered:

Day 1: Reporting in Excel

• Forecasting
  - Identify and deal with outliers
  - Regression Analysis
• Advanced Conditional Formatting
• Advanced Charting
• Dashboard Design
  -Introduction to MS Power BI

Day 2: Advanced Analysis

• What-if Analysis
  - Data Modelling in Excel
  - Data Tables
  - Goal Seek
• The Monte Carlo Simulation method
  - Statistical Analysis Theory
  - Advanced Scenario Analysis