Description
Introduction to Supply Chain Analytics using Microsoft Excel. This comprehensive course is designed to empower supply chain, inventory, and operations professionals and teaches participants how to use the powerful and accessible tools of Excel to gain real-world skills in three key areas of descriptive, predictive, and prescriptive analytics. In the descriptive analytics section, learners will be introduced to parametric and nonparametric statistics, indices of central tendency, measuring process capability, and calculating process efficiency. In the predictive analytics section, topics such as time series, linear regression models in Excel, trend and seasonality analysis, and forecasting techniques with real data are examined. In the prescriptive analytics section, optimization concepts, mathematical programming, Excel Solver, objective functions, constraints, and economic order quantity are taught in detail so that professionals can implement data-driven and optimal decision-making in their organizations.
What you will learn
-
Mastery of fundamental tools of descriptive, predictive, and prescriptive analytics
-
How to answer key business questions including what happened, what will happen, and what to do next
-
Use Excel statistical tools such as linear regression, quartiles, and advanced statistical functions
-
Implementing Linear Programming Models Using the Solver Tool in Excel
-
Calculating and applying economic order quantity for optimal inventory management
-
Time series analysis, seasonal trends analysis, and demand forecasting techniques
This course is suitable for people who:
-
Supply chain and inventory analysts and managers
-
Demand, logistics, materials and production planners
-
Business, Manufacturing, Data, and Forecasting Analysts
-
Supply chain coordinators and operations and continuous improvement analysts
-
Planning, logistics, inventory control and purchasing managers
-
Industrial and quality engineers and Six Sigma black belt specialists
Course Description: Introduction to Supply Chain Analytics using Microsoft Excel
- Publisher: Udemy
- Instructor: Ray Harkins, The Manufacturing Academy
- Training level: Beginner to advanced
- Training duration: 4 hours and 57 minutes
- Number of lessons: 53
Course syllabus in 2026/8
Prerequisites for the Introduction to Supply Chain Analytics using Microsoft Excel course
- Basic Microsoft Excel skills
- Basic understanding of manufacturing or logistics
- Basic business acumen
- Some supply chain or operations experience would be helpful.
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
Rapidgator link
File(s) password: www.downloadly.ir
File size
1.2 GB