Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Introduction to Supply Chain Analytics using Microsoft Excel

via Udemy

Overview

Learn supply chain analytics with Excel: forecasting, optimization, and data-driven decisions without complex math

What you'll learn:
  • Fundamental tools of descriptive, predictive and descriptive analytics
  • How to answer the questions, "What happened?", "What will happen?", and "What should we do?"
  • Analytical tools for assessing demand forecasts, production outputs and product mix strategies
  • Introductory time series analysis tools
  • Baseline, Trend, Seasonality and Error
  • Linear programming using Excel Solver
  • Statistical tools in Excel like quartiles, the data analysis tool kit, Norminv, linear regression, mathematical programming, and more!
  • How to use the Economic Order Quantity (EOQ)
  • "Launch points" for further study in analytics

Learn the analytical tools that drive better decisions in supply chain and operations—without needing advanced math or specialized software. This practical, Excel-based course has helped over 7,300 students build real-world skills in analytics.

4.7 stars average rating
1,000+ five-star reviews
Designed for professionals in supply chain, inventory, or operations roles
Practice with Excel-based downloadable exercises

Why Take This Course?

Analytics and supply chain management are two of the most in-demand skills in today’s job market. This course helps you build capability in three key areas:

Descriptive Analytics – What happened?

  • Parametric and nonparametric statistics

  • Measures of central tendency and dispersion

  • Process capability using the normal distribution

  • Calculating process yield

  • Combining normal random variables

  • Practical applications in manufacturing and inventory

Predictive Analytics – What will happen?

  • Time series basics

  • Building linear regression models in Excel

  • Seasonality and trend analysis

  • Forecasting techniques using real data

  • Excel Data Analysis Add-in walkthroughs

Prescriptive Analytics – What should we do?

  • Introduction to optimization and mathematical programming

  • Excel’s Solver Add-in step-by-step

  • Objective functions, constraints, and real-world modeling

  • Economic Order Quantity (EOQ)

  • Policy-driven models and product mix problems

What You’ll Get:

  • 5+ hours of instructor-led content

  • Step-by-step walkthroughs in Microsoft Excel

  • Downloadable exercises for each major topic

  • A 110+ term glossary to reinforce your learning and support continued study

  • Lifetime access to the course and all future updates

What Students Are Saying:

Very great course if you are starting out in the Supply Chain field. Found it very informative and engaging.” – Isabel B.

“I’ve learned things about inventory I never heard of before. Outstanding course.”Jerry O.

“Easy to understand, recommended for beginners. One of the better courses on Udemy.”Clifford C.

“Great tools for the Supply Chain professional! Engaging and very knowledgeable of the overall subject.”Stephanie M.


Build Skills That Advance Your Career

Whether you're new to analytics or want to sharpen your decision-making tools, this course will help you:

  • Understand the numbers behind your supply chain

  • Use Excel to perform real-world analyses

  • Communicate more confidently with data

Introduction to Supply Chain Analytics using Microsoft Excel will serve as the starting point to your career in supply chain analytics and management. No intimidating math. No complicated jargon. Just practical analytics for real professionals.

Syllabus

  • Introduction to Supply Chain Analytics
  • Descriptive Analytics
  • Predictive Analytics
  • Prescriptive Analytics

Taught by

Ray Harkins, The Manufacturing Academy

Reviews

4.5 rating at Udemy based on 2431 ratings

Start your review of Introduction to Supply Chain Analytics using Microsoft Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.