Tech track · 8 steps · 79 min
Data Analyst
“I want to become a data analyst”
From your first question to a portfolio project: spreadsheets, SQL, cleaning, honest charts, the statistics you actually use, dashboards, and how to use AI without leaking data or fooling yourself. For beginners who are comfortable with a spreadsheet and want job-ready basics.
2–3 hours a week for 4 weeks
Start step 1 0 of 8 steps ticked
01
The steps
Ticks and scores are saved in this browser only. No account.
- 01What data analysts actually doYou can describe the job in one sentence and turn a vague request into a clear question.7 min
- 02Spreadsheets done rightYou can set up a clean table, summarise it with a pivot table, and join two sheets with XLOOKUP.10 min
- 03SQL basicsYou can write queries that filter, group and join tables, and practise for free online.12 min
- 04Cleaning data without losing the truthYou can find duplicates, missing values and broken types, and write down every fix you make.9 min
- 05The statistics you actually needYou can pick the right average, describe change correctly, and avoid the most common false conclusions.11 min
- 06Charts that tell the truthYou can choose a chart from the question and avoid the tricks that mislead readers.9 min
- 07Dashboards and stakeholdersYou can design a focused dashboard around a few KPIs and present findings people act on.9 min
- 08Using AI safely, and your portfolio projectYou can use AI to speed up formulas and SQL without risking data, and you have a plan for a public project.12 min
02
Quiz and certificate
Data Analyst track quiz
Tick every step, then pass the 10-question quiz with 80% or more. The certificate comes with a link anyone can check.
- 0 of 8 steps ticked
- Pass the track quiz with 80%
Take the track quiz Certificate locked
03
Where to go next
Free, reputable resources for going deeper. They open on other sites.