All learning paths
Learning path
A step-by-step path to the core data analyst skills: Python basics, cleaning and analysing data with pandas, querying databases with SQL, and practising the SQL questions analyst interviews ask.
- 4 steps
- 42 lesson days
- 50 interview questions
Who it's for
Beginners, and people moving into data from Excel, finance, marketing or operations.
What you'll be able to do
- Write Python scripts to load, clean and reshape data
- Analyse and summarise data with pandas, and chart it
- Query, join and aggregate data in PostgreSQL
- Answer common SQL interview questions with confidence
The path, step by step
- 1Course 14 days · ~30 min/day
Python
Python is the language most analysts use. Learn variables, loops, functions and files: everything pandas builds on.
Free, no sign-up - 2Course 14 days · ~30 min/day
Data Analysis with pandas
Load CSV and Excel files, clean messy data, group and summarise it, and make charts.
Free account - 3Course 14 days · ~30 min/day
PostgreSQL
Most company data lives in databases. Learn to query, join and aggregate it with SQL.
Free account - 4Interview questions50 questions
SQL interview questions
Practise the SQL questions analyst interviews ask, with queries you can run in your browser.
Free, no sign-up