Data Analytics

Preview this course

A short look at what a class is actually like.

What you'll learn

Clean and interrogate messy real-world data, documenting every decision you make
Query databases in SQL from SELECT through window functions and cohort logic
Build dashboards in Power BI or Tableau that a manager reads without help
Analyse in Python with pandas, and say what a sample supports and what it does not
Turn analysis into a recommendation and hold it under challenge

Week by week

Every week, what you can do by the end of it.

1Data literacy & the analyst's role5h
What analytics is; types of data; the data lifecycle; the question-first mindset
2Spreadsheets I5h
Formulas & functions (SUM, AVERAGE, IF, VLOOKUP); accounting/number formats
Excel/Sheets AI copilots
3Spreadsheets II + descriptive stats5h
Descriptive stats — mean/median/mode, spread, distributions
ChatGPT Advanced Data Analysis for quick EDA
4

What you'll build

You leave with work you can show, not only a certificate.

P1 — Spreadsheet analysis + dashboard (Wk 6)
P2 — SQL business-analysis project (Wk 12)
P3 — Python EDA + insight report (Wk 18)
Capstone — end-to-end analysis for a real brief (Wk 24)

Tools you'll use

Excel/Sheets
SQL
Python (pandas)
Power BI / Tableau
Statistics

Afterwards

Graduate can source, clean, query (SQL), analyse (Python), visualise (Power BI/Tableau), and communicate data to drive decisions, with an AI-accelerated workflow and a 4-piece portfolio. Junior-ready for Data Analyst / BI roles (employed, remote, freelance). (Honest framing: a strong junior foundation + portfolio, not a senior claim.)