Introduction to Supply Chain Analytics using Microsoft Excel
- Offered byUDEMY
Introduction to Supply Chain Analytics using Microsoft Excel at UDEMY Overview
Duration | 5 hours |
Total fee | ₹399 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Introduction to Supply Chain Analytics using Microsoft Excel at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 9 downloadable resources
Introduction to Supply Chain Analytics using Microsoft Excel at UDEMY Course details
- 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
- 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 statisticsMeasures of central tendency and dispersionHow to use the normal distribution to describe processesHow to combine the normal random variablesHow to calculate process yieldLots of practical applications for descriptive analyticsIn the predictive analytics section you will learn:The basics of time series analysisHow to build a linear regression model in ExcelHow to calculate seasonalityHow to combine baseline, trend and seasonality to build forecastsHow to use Excel Data Analysis Add-inReal life applications of time series forecastingIn the prescriptive analytics section you will learn:The basics of mathematical programmingHow to use Excel's Solver Add-inHow to build data models using objective functions and constraintsThe Economic Order Quantity and how to use it to cut your Total Inventory CostsHow to integrate management policies into your linear programsHow to apply linear programming in a "classic" product mix problemPlus 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!!
Introduction to Supply Chain Analytics using Microsoft Excel at UDEMY Curriculum
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 Exercises
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
Bonus Lecture
Introduction to Supply Chain Analytics using Microsoft Excel at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?
ManagementLogistics and Supply ChainSupply chain managementIntroduction to Supply Chain Analytics using Microsoft Excel