Supply Chain Analytics


What is Supply Chain Analytics and Why it is essential for career growth?

  • Supply Chain Analytics has the power to completely transform your business, especially if you are in the manufacturing, automotive, retail, FMCG, IT sectors …
  • Supply chain analytics lets you make sense of the data in your supply chain, so you can make better decisions.
  • In most organizations, the supply chains have grown and evolved over many years. Each one is a potentially data-creating monster and data can be in all sorts of places and in all sorts of formats
  • The global nature of today’s business has led modern supply chains to become more intricate and diverse than anyone could have dreamed of only a few decades ago
  • Most organizations have a network of supply chains connecting various suppliers and partners

This complex environment presents a number of critical challenges for a business, including

  • Lack of real-time visibility across supply chain operations
  • Lack of synchronization between business strategy and execution
  • Inability to properly schedule production, leading to costly asset under-utilization
  • Poor forecast accuracy, resulting in frequent stock-outs or excess inventory levels
  • Lack of flexibility in the manufacturing, distribution and logistics
  • Inability to properly assess and prepare for supply chain risks

Applying intelligent analytics is the key to addressing all these challenges

Taking a 360-degree view of the Supply Chain is the only way to collaborate effectively with top performing partners, improve business operations and drive revenue. That’s the high level. At the day-to-day level, it’s simply about getting your questions answered – questions like the following;

  • Which material will become shortage for next week?
  • What is optimized inventory level for product X/Customer Y?
  • What is a better forecast for product X for next year?
  • Why Inventory accuracy is poor?
  • Which warehouse operatives will be absent on Monday?
  • Which SKU will become obsolete?

Benefits of Supply chain analytics;

  • Planning & Scheduling
  • Improved responsiveness
  • Improved demand planning
  • Order optimization
  • Real time supply chain execution
  • Inventory management
  • Replenishment planning
  • Improved partner performance
  • Improved cash performance

What Will I Learn?

  • New career opportunities & Career growth

Topics for this course

88 Lessons101h 20m 48s

Session 1 Supply Chain Analytics Introduction

Supply Chain Evolution35:47

Session 2 Multi-enterprise Supply Chain

Session 3 Global Optimisation

Session 4 Operating environment

Session 5 Manufacturing strategies

Session 6 Challenges

Session 7 Inputs to Material Planning

Session 8 Production Planning System

Session 9 Strategic Planning

Session 10 Strategic Business Plan

Session 11 Sales & Operations Planning

Session 12 Where does S&OP fit

Session 13 S&OP Processes

Session 14 MPS & MRP

Session 15 Capacity planning and other steps

Session 16 Time fences

Session 17 MPS algorithm using excel

Session 18 MRP

Session 19 Bill of Materials concepts

Session 20 MRP Logic

Session 21 Lead time offsetting

Session 22 Capacity Management

Session 23 Capacity terms

Session 24 Capacity vs load

Session 25 Capacity closed loop

Session 26 Case study

Session 27 Purchasing

Session 28 Types of enquires

Session 29 Purchasing functions

Session 30 Selecting Suppliers

Session 31 Forecasting & demand management

Session 32 Excel case study

Session 33 Forecasting techniques

Session 34 Quantitative methods

Session 35 Forecasting workout in excel?

For template, pl refer google folder

Session 36 Excel Forecasting methods

Session 37 Winter method of Forecasting

Session 38 Forecasting exercise contd..

Session 39 MySQL Exercises

Session 40 Inventory Fundamentals

Session 41 Flow of materials

Session 42 Inventory functions

Session 43 Financial reports

Session 44 Inventory costs

Session 45 Order quantities

Session 46 SQL Exercise

Session 47 SQL workout continued

Session 48 Project work in SQL

Session 49 Forecasting in the presence of special events

Session 50 Centered MA Forecasting method

Session 51 SQL exercise

Session 52 Python Introduction

Session 53 Ordering Systems

Session 54 Standard Deviation

Session 55 Python exercise

Session 56 Python datatypes

Session 57 Python exercises

Session 58 Python workout contd..

Session 59 Physical inventory & warehouse management

Session 60 Warehouse activites

Session 61 Python working

Session 62 Python exercises contd..

Session 63 Python exercise contd…

Session 64 Python exercises contd..

Session 65 Physical distribution

Session 66 Channels of Distribution

Session 67 Warehouse location problem

Session 68 Warehouse location exercise contd..

Session 69 Distribution exercise

Session 70 Vehicle routing problem

Session 71 Workforce allocation problems

Session 72 Inventory optimization problem

Session 73 Python Exercise continued

Session 74 Machine Learning basics

Session 75 Machine learning concepts

Session 76 Visualization

Session 77 Visualization contd…

Session 78 Data Science for Supply chain

Session 79 Data collection

Session 80 Visualization basics

Session 81 Machine learning

Session 82 Statistics by Dr Gita

Session 83 Data science for Supply chain

Session 84 Optimisation

Session 85 Supply chain metrics

Session 86 Python practice

Session 87 Supply chain metrics

Session 88 Statistics by Dr Gita

Session 89 Statistics contd

About the instructor

I am a Supply Chain / Logistics / Sourcing Professional. Trainer and consultant. Worked in large MNCs in Supply Chain, Logistics for nearly 3 decades and have in-depth practical knowledge in each of the sub-domains Currently engaged in consultation, training and certification programs of world's leading Supply Chain Institutes. Also have our own job oriented programs. Sub domains includes Materials, Logistics, Supply Chain Analytics, Purchasing/Sourcing, Warehousing, Transportation, Inventory Optimization etc Saved in Millions for organisations, in Inventory optimizations and improved all related processes Improved customer fill rates and reduced cost of operations Solved work-place issues / problems in their occupation of Supply Chain professionals Specialties: Supply Chain Management, Logistics, Sourcing, Material Planning, Forecasting, Production scheduling, Warehouse management, Picking and line feeding, Logistics, Imports, exports, EOU, Lean, Operational Excellence, Productivity Improvement, employee & contractor management, Legal compliance ASCM, APICS, ISM
4.32 (139 ratings)

24 Courses

151 students

Student Feedback


Total 8 Ratings

2 ratings
2 ratings
0 rating
0 rating
0 rating

It was a really good program, and the team helped me with installing software and further enquires, Thanks to the Exxpertscm team

There are teaching everything using a real-time database for all projects also am a fresher their provided me internship unpaid only but worked in real-time project which has given me added advantage in my cv.

I have done so much research from this sca syllabus with others found this is best from others I took one month to do research and purchased this program really excellent syllabus and teaching.

I was in search of a course for my career change. Exxpert SCM gave me an opportunity to learn and supported me by assisting in placement. The course is easy to understand and it is fruitful, It's one of the excellent courses in the supply chain. Thank you Raman sir for directing me to this course according to my profile.

. This course did a great job explaining the assignments and had thorough explanations of the weekly concepts. I am interested to learn more about supply chain-related courses as I grow further in my career. Great course and the live recorded videos were well explained!

Very informative course on Supply Chain Analytics which clears SCM concepts in a clear and easy way. Also gives clarity on how data analytics can be used in making supply chain-related decisions.


Material Includes

  • Videos, Excel, SQL & Python Templates with solutions
  • Reference materials


  • Graduates with intermediate excel & good English communications

Target Audience

  • All levels
Open chat
Can we help you?