IN08
Course Contents
Module 1 -Introduction, Overview and Data Preparation
Key Topics
Introduction and overview
- Introductions
- Overview of contents
- The need and the process of data analysis
How to prepare Data before analysis?
- Ensuring that data conforms to quality criteria, e.g. ensuring uniformity of measurement, removal of repeated data, etc.
- Checklist for ensuring that the data is “clean”
- Data Sampling
- Data sorting and filtering
Module 2 - Variance, Standard Deviation and Graphs
Key Topics
Variance and standard deviation manually and using Excel
- How to calculate variance and standard deviation manually
- How to calculate variance and standard deviation in Excel
- Other basic and important statsitics like mode, median, etc
Creating and using graphs
This session introduces graphs and explains what they are and what they are used for. There is an explanation of how to construct each graph:
- Histogram/ Pareto Analysis
- Scatter plot
- Normal probability plot
- Maximum-minimum-average chart
Module 3 -Control Charts and Data Representation
Key Topics
Control charts for variable dataThis session begins by introducing a number of control charts and explains what they are and what they are used for. There is an explanation of how to construct each chart:
- X bar and R
- X bar and S
- Individuals and moving range chart
- Explanation of the median and range
- The importance of distinguishing between causes of variation
- Examples of common cause and special cause variation
Advanced Charts and data visualization
This session begins by introducing the different charts to represent data
- X-Y charts
- Bar and Pie charts
- Examples of common cause and special cause variation
Module 4 - Data Datamining Techniques & Regression Analysis
Key Topics
Introduction to Datamining Techniques
- The association pattern analysis
- Clustering
- Classification
- Decision Tree analysis
- KNN method to visually classify new data
Simple Regression Analysis
- What is regression analysis and what is it used for?
- Regression analysis examples
Module 5 -Usage of Tables, Reports and Process Improvements
Key Topics
Cross Tables, Pivot Tables, and Chi Test
- Pivot Tables and Pivot Charts
- Chi-test – calculation, and interpretation
- Dashboards
- Slicers
- Timeline
Define, Measure, Analyse, Improve, Control
- An introduction to DMAIC
- Fishbone Diagram (FBD)