All prices are in Canadian dollars.

Data Analytics & Technical Skills for SCM (Part 2)

Date:   Jun 10, 2024 - Jun 11, 2024
Time:   5:30 PM (MDT)

Virtual via MS Teams - All Provinces



Monday, June 10 &

Tuesday June 11, 2024


5:30 - 9:00 PM MST


5 Credits


Virtual via MS Teams


$425 +GST Members

$495 +GST Non-Members


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


Ian Gonzalez


Ian Gonzalez is a professional from two worlds: data and supply chain management. For 9 years, he’s taught analytics and supply chain courses for the institution, making him the longest-running PD instructor at SCC. Drawing from his 19 years of experience in oil & gas, aviation, and consulting, Ian has inspired hundreds from all over Canada to embrace data and use it to move the supply chain profession forward. Whether it’s in corporate or the academe, teaching and upskilling have always been his passion.


Registrants will receive a full refund for courses cancelled by Supply Chain Canada - West.

Registrants who have received written acceptance into a course and provided written notice to Supply Chain Canada - West of their withdrawal from the course 14 days before the first day of class, will be provided with a full refund. After 14 days, refunds will not be granted.

If you would like to withdraw from a course please send an e-mail to [email protected]. You are required to inform us of your intent as soon as possible. Clearly state your intention to withdraw and provide authorization for us to proceed.

SMT Diploma Program   l   SCMP Designation   l   PD & Webinars   l   Membership


To begin, please enter your email address below.

Should you not be able to complete the form in one sitting, any information you have entered will be saved and your form will continue from where you left off when you return.

By entering your email you are giving your consent to be contacted electronically by Supply Chain Canada on matters regarding the event and your registration/enrollment.


Have a promotional code? Enter it here.