Data Analyst
From raw spreadsheets to decisions a business will actually make.
The complete analyst path: what analytics actually is, spreadsheets, SQL, Python, statistics you can defend, dashboards, and a taste of machine learning and big data - every topic explained, with free resources to go deeper.
Saved on this device — no account needed.
- 1
Introduction to Analytics
Understand the field before learning its tools.
1 week0/4 - 2
Spreadsheet Fluency
Handle any messy file a stakeholder emails you without panic.
2–3 weeks0/6Build: Clean a messy sales export
Take a raw CSV with duplicates, broken dates and inconsistent categories; produce a clean sheet, a pivot summary and a one-paragraph data-quality note.
- 3
SQL
Pull your own data instead of waiting on someone else.
3–4 weeks0/5Build: Answer five business questions in SQL
Load a public dataset into SQLite or Postgres and answer revenue, retention and top-N questions with documented queries.
- 4
Python for Analysis
Automate what spreadsheets can't and unlock the PyData stack.
3–4 weeks0/4 - 5
Getting & Cleaning Data
Master the unglamorous 70% of the job.
2–3 weeks0/4Build: API-to-clean-dataset pipeline
Pull data from a public API, clean and reshape it in pandas, and save an analysis-ready dataset with a short data dictionary.
- 6
Statistics That Survive Questions
Say 'this difference is real' and defend it.
3 weeks0/6 - 7
Visualisation & BI
Ship a dashboard a manager checks every Monday.
3–4 weeks0/4Build: Executive revenue dashboard
Build a one-page dashboard with trend, breakdown and a written insight; present it as if to a COO.
- 8
Machine Learning & Big Data (Awareness)
Speak the language of the teams next door.
2–3 weeks0/5 - 9
Portfolio & Career
Turn analyses into interviews.
2 weeks0/4