Module 3.1: Exploratory Data Analysis

  • Statistical measures: mean, median, mode, standard deviation
  • Understanding distributions and histograms
  • Identifying patterns and trends
  • Correlation analysis
  • Pivot tables and cross-tabulation

Module 3.2: Supply Chain Reporting

  • Designing effective reports
  • Operational vs. strategic reporting
  • Automated reporting techniques
  • Report scheduling and distribution
  • Creating executive summaries

Module 3.3: Root Cause Analysis

  • The 5 Whys technique
  • Fishbone diagrams for supply chain issues
  • Pareto analysis (80/20 rule)
  • Using data to identify bottlenecks
  • Process mining for supply chain workflows

Hands-On Exercise:

  • Perform exploratory analysis on shipping delay data
  • Create a monthly performance report with pivot tables
  • Conduct Pareto analysis to identify top delay causes

Tools Covered: Excel, Power BI basics

PreviousNext