Master data analysis, dashboarding, and statistical validation using industry-standard tools
Module 1: Foundation – Data Thinking with an Impact Mindset (2 Weeks)
Introduction to data analytics, data ethics, problem framing, and the impact mindset.
Module 2: Excel – Beyond the Basics onto Business Logic (3 Weeks)
Data cleaning, advanced formulas, pivot tables, what-if analysis, and dashboarding.
Module 3: SQL – Querying with Business Questions (3 Weeks)
SQL fundamentals, filtering, joins, aggregation, window functions, and business queries.
Module 4: Power BI – Dashboards That Lead to Decisions (2 Weeks)
Power BI fundamentals, DAX, visualisations, and dashboard publishing.
Module 5: Tableau – Storytelling for Stakeholders (2 Weeks)
Tableau fundamentals, calculated fields, dashboards, and advanced visualisations.
Module 6: SPSS – Statistical Analysis for Informed, Better Decisions (3 Weeks)
SPSS fundamentals, descriptive statistics, hypothesis testing, correlation, and regression.
Module 7: Python for Data Analytics – NEW (3 Weeks)
Python fundamentals, data manipulation with pandas, and visualisation with Matplotlib and Seaborn.
Module 8: Integration – Impact Memo from Data (Capstone) (2 Weeks)
Capstone project, analysis, Impact Memo, and presentation.