Introduction to Supply Chain Analytics using Microsoft Excel

Your first steps in descriptive, predictive and prescriptive analytics to solve your toughest supply chain problems

4.61 (996 reviews)
Udemy
platform
English
language
Operations
category
4,430
students
5 hours
content
Feb 2024
last update
$94.99
regular price

What you will 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

Description

Many industry analyst predict that both supply chain management and analytic will be among the most in-demand workplace skills the coming years. This class, "Introduction to Supply Chain Analytics using Microsoft Excel" will teach you many of the fundamental tools of descriptive (What happened?), predictive (What will happen?), and prescriptive (What should we do?) analytics, all within the familiar context of Excel.

In the descriptive analytics section you will learn:

  • Example of parametric and nonparametric statistics

  • Measures of central tendency and dispersion

  • How to use the normal distribution to describe processes

  • How to combine the normal random variables

  • How to calculate process yield

  • Lots of practical applications for descriptive analytics

In the predictive analytics section you will learn:

  • The basics of time series analysis

  • How to build a linear regression model in Excel

  • How to calculate seasonality

  • How to combine baseline, trend and seasonality to build forecasts

  • How to use Excel Data Analysis Add-in

  • Real life applications of time series forecasting

In the prescriptive analytics section you will learn:

  • The basics of mathematical programming

  • How to use Excel's Solver Add-in

  • How to build data models using objective functions and constraints

  • The Economic Order Quantity and how to use it to cut your Total Inventory Costs

  • How to integrate management policies into your linear programs

  • How to apply linear programming in a "classic" product mix problem

Plus for each section -- descriptive, predictive, and prescriptive -- you will have a chance to practice your newly learned skills with Excel-based, downloadable practice exercises covering all the major tools within each section.

The class "Introduction to Supply Chain Analytics using Microsoft Excel" will serve as the starting point to advance your analytical problem solving skills. No need to feel intimidated by statistics or heavy-duty math ... this class will step you through a power selection of analytical tools at a pace and level that any professional can handle.


Here's what Udemy students are saying about "Introduction to Supply Chain Analytics using Microsoft Excel":

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

  • "The course was outstanding, I've learnt things about inventory that I never heard of before." - Jerry O.

  • "A well-designed course... Very helpful to start learning Supply Chain diagnostics. Thank you, Ray!" - Nakul T.

  • "It's my first course about supply chain analytics and I love it! Easy to understand, recommended for beginners." - Haidar A.

  • "One of the best courses I have taken on Udemy." - Laxman S.

  • "Great tools for the Supply Chain professional! Engaging and very knowledgeable of the overall subject." - Stephanie M.

  • "I love how topics are being explained in a very easy to understand manner. Attended a few Udemy courses and this is one of the better ones. Kudos." - Clifford C.

  • Plus Over 400 5-star Reviews!!

Sign up today!!

Content

Introduction to Supply Chain Analytics

Introduction
What is a Supply Chain?
What is Supply Chain Management?
What is Analytics?

Descriptive Analytics

Case Study #1, Descriptive Analytics
Descriptive Analytics in Excel, Pt 1
Quartiles
Quartiles in Excel
Histograms in Excel
From Data to Distributions
Comments on Distributions
Data Models
The Normal Distribution
Descriptive Analytics in Excel, Pt 2
The Norminv Function
Summing Normal Distributions
Summing Normal Distributions in Excel
Calculating Process Yield
Descriptive Analytics Quiz
Wrap Up and Launch Points from Descriptive Analytics
Descriptive Analytics Practice Exercises

Predictive Analytics

Case Study #2, Predictive Analytics
Approaches to Demand Forecasting
Introduction to Time Series Analysis
Excel Add-ins
Baseline Analysis in Excel, Pt 1
Baseline Analysis in Excel, Pt 2
Analyzing Seasonality
Upper and Lower Forecast Estimates
Algebraic Properties of a Line
Linear Trend Analysis
Excel's Regression Analysis Tool
Analyzing Seasonality and Growth Combined
Review of Analysis Methods
Predictive Analytics Quiz
Wrap Up and Launch Points from Predictive Analytics
Predictive Analytics Practice Excercises

Prescriptive Analytics

Introduction to Prescriptive Analytics
Case Study #3, Prescriptive Analytics
EOQ, Pt 1
EOQ, Pt 2
EOQ in Excel
Building an EOQ Data Model
Mathematical Programming, Pt 1
Mathematical Programming, Pt 2
Adding Constraints
Case Study #4, The Product Mix Problem
Solving the Product Mix Problem, Pt 1
Solving the Product Mix Problem, Pt 2
Solving the Product Mix Problem, Pt 3
Prescriptive Analytics Quiz
Wrap Up and Launch Points from Prescriptive Analytics
Prescriptive Analytics Practice Problems
Conclusion

Screenshots

Introduction to Supply Chain Analytics using Microsoft Excel - Screenshot_01Introduction to Supply Chain Analytics using Microsoft Excel - Screenshot_02Introduction to Supply Chain Analytics using Microsoft Excel - Screenshot_03Introduction to Supply Chain Analytics using Microsoft Excel - Screenshot_04

Reviews

David
October 7, 2023
The Excel files are missing data & tabs as they do not match what is being shown but besides that, this was a great course.
Tanishq
September 27, 2023
it is a good course but it would be more help full if they give example in a numerical form because it is easy to understand, at all it is good course .
Sowmya
September 16, 2023
The course was excellent and its beginner friendly. I really enjoyed learning a new topic which completely out of domain and it was eye opening into the world of supply chain. I enjoy the problem solving ability that is out there in the manufacturing world.
Karthik
September 9, 2023
Audio is little muffled sometimes. And the video ends abruptly , would love to have a small recap and then end the video.
Guilherme
September 8, 2023
This course is above 99% of the courses in Supply Chain at Udemy. He really goes in depth on the topics.
Monika
September 8, 2023
I liked the course, but not the minus point for the Excel sheets. It would help a bit if they looked exactly like the one the teacher is using + they shouldn't be solved. I love how it's explained, but sometimes it's too detailed and gets boring.
Aristo
September 7, 2023
It would have been an extraordinary course if the materials ( the PDF file ) had been provided besides xlsx file. Other than that, I truly appreciate that the instructor delivered the material clearly and plainly. Hopefully, the material will be provided.
Abdoul
August 20, 2023
Very captivating training and I learned new things about forecasting and analysis. I recommend this course
Faizan
August 17, 2023
The lectures are extensively good adding to that its a practical one does not make me feel even monotonous during the coursework.
Himangki
August 4, 2023
As a beginner to all the topics I did find a little hard to understand the problems but given some time and practice on the worksheets helped a lot. I was looking for a course like this where I can have worksheets to solve problems and this one was as expected. Thank you Ray for this course.
Leo
July 27, 2023
This course has enhanced my understanding on solving manufacturing problems. Also, it gives me the clue to solving and analyzing analytical problems. Thanks to Udemy for such a fabulous course.
Akshay
July 4, 2023
Nice, course. gave a good beginner level understanding of few Supply chain metrics and how to solve them using Excel
Rabi
June 28, 2023
The lecturer is very engaging. I also like his method, it helps me understand the point he is trying to make.
Alicia
June 20, 2023
The material was not only interesting but also easy to follow and understand. Ray does a great job of showing the concept from definition, mathematical calculation to excel application. He takes the time to give quick reminder sessions of various statistic and mathematical concepts that bring the information together. The practice problems were super helpful too, in order to apply what we learned and practice what was learned as we went. Great course that can be easily applied and used on a day to day!
Mazen
May 17, 2023
I really enjoyed this fantastic course. I learned a lot about how to use Excel to analyze supply chain data, and I think it will be a valuable tool in my career.

Charts

Price

Introduction to Supply Chain Analytics using Microsoft Excel - Price chart

Rating

Introduction to Supply Chain Analytics using Microsoft Excel - Ratings chart

Enrollment distribution

Introduction to Supply Chain Analytics using Microsoft Excel - Distribution chart
4109922
udemy ID
6/8/2021
course created date
6/29/2021
course indexed date
Bot
course submited by