All prices are in Canadian dollars.

Excel Reporting Part 3: Prescriptive Analytics (120 mins)

Date:   Mar 28, 2020 - Mar 28, 2020
Time:   10:00 AM (MDT)

Adobe Connect link to be provided 48 hours prior to session

CPD:     2 Credits
Price:     Member: $95

Non-member: $199

       Read Cancellation policy
Why this Webinar?


After exploring the world of Descriptive and Predictive analytics, you’re now ready for the highest and most advanced form of analytics: Prescriptive analytics. Here, you’ll synthesize your knowledge of historical data with forecasts of the future and then come up with valuable recommendations and action plans. For this to happen, you’ll need some new tools in your Excel toolbox: Data modelling, Scenario analysis, and Monte Carlo simulation.

Key Learning Outcome(s):

  • Basic and advanced data visualization in Excel
    • Introduction to MS Power BI
  • How to use Data Tables for Optimization and What-If analysis
    • Data modelling in Excel
    • 1-way Data Tables
    • 2-way Data Tables
    • Goal Seek
  • The Monte Carlo Simulation Method
    • Statistical analysis theory
    • Advanced scenario analysis
Instructions to join the meeting:    
  • Upon Clicking the link to attend, select Enter As A Guest. Type the name to be used as your identifier in the meeting.
  • If your connection to the server fails, Adobe Connect displays an error message. It provides a link to a test wizard, which leads you through a series of steps to test your connection status.

  • High speed internet connection
  • Microphone
  • Speakers

Ian Gonzalez

About the Instructor:

Ian Gonzalez, MBA, CIPS is a Senior Supply Chain Analytics & Stewardship Specialist with 16 years of experience in the aviation and oil and gas industries. He’s worked with companies such as Lufthansa, Shell, Suncor and Cenovus and has developed and implemented ground-breaking SCM and Finance solutions using Excel, Power BI, and VBA. He has a passion for teaching and does so from the perspective of an SCM professional, engineer, and computer programmer.


Refund and Cancellation Policy: 



  • Registrants will receive a full refund to courses cancelled by Supply Chain Canada, Alberta Institute.
  • Registrants who have received written acceptance into a course and provide written notice to Supply Chain Canada, Alberta Institute of their withdrawal from the course 14 days or more prior to the first day of class, will be provided a full refund. After 14 days prior up to 2 days prior to the start of the class, Supply Chain Canada, Alberta Institute will refund half the course registration fee. After the 2- day period, refunds will not be granted.


Due to unforeseen circumstance if Supply Chain Canada - Alberta Institute cancels an event all registrants will be offered the option to transfer the registration to a future event or receive a refund.

Please send cancellation request, questions or concerns to Millete Gutierrez (


To start the registration process please enter your email address.

This attendee is the primary registrant and their contact information will be kept on file.

Should you not be able to complete the registration process in one sitting, any information you have entered will be saved and your registration 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.


Have a promotional code? Enter it here.