Programme outline
Learning objectives
- Formulate business questions, identify stakeholders, and communicate data analysis insights through visualisations.
- Explain data collection methods and identify data types and databases.
- Perform data profiling using descriptive statistics.
- Perform simple linear regression and interpret results.
Day 1
- Data Science Lifecycle (from business problem to data-driven decision)
- Business Question (Purpose, stakeholders and communicate)
- Data Acquisition (Types of data collection methods, types of data and database, data science acquisition architecture)
- Data Preparation – Data Profiling – Calculating simple statistics, checking inconsistent format, PivotTable, charts, descriptive statistics from Analysis ToolPak
Day 2
- Data Preparation – Data Profiling – Calculating simple statistics, checking inconsistent format, PivotTable, charts, descriptive statistics from Analysis ToolPak
- Data Science Modelling – Regression – Simple linear regression
- Data Science Modelling – Regression – Interpretation of regression results
- Data Visualisation – Creating visuals
Mode of assessment
- Quiz