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