Learning path
Become a data analyst
Learn to collect, clean and read data honestly, and to turn it into findings people can act on.
You will be able toYou'll finish able to gather data, clean it, analyse it and report what it does and does not show.
Stage 01
Foundations
Assumes: Nothing. A computer you can install software on.
Learn a first language for data work and how to collect good data in the first place.
Series: Python from zero
How to Install Python 3.15 and Run Your First Script
You will install uv 0.13 from a checksum-verified release on Ubuntu 26.04, use it to install Python 3.15 next to the system Python, and write and run your first script.
Beginner · 12 min
How to Use Virtual Environments and Install Packages in Python
You will create an isolated Python 3.15 environment for a project, install a package into it with pip, record the exact versions, rebuild the environment from that record, and then manage the same project with uv.
Beginner · 14 min
How to Read and Write Files and JSON in Python
You will read and write text files with pathlib, convert Python data to JSON and back, and use both to build a small task list that keeps its data in a JSON file and survives a damaged file.
Beginner · 16 min
How to Call a Web API from Python with httpx
You will install httpx 0.28, write a small local API to practise on, then call it from Python by fetching JSON, add query parameters and a reusable client, handle bad statuses, timeouts and network failures, send JSON in a POST request, and make several requests at once with async code.
Beginner · 18 min
How to Write and Run Tests in Python with pytest
You will install pytest 9.2 in a uv project, write tests for a small price-parsing module, run many cases from one test with parametrize, read a failure and fix the code, and use a fixture that gives each test its own temporary folder.
Intermediate · 18 min
Design a short survey people will finish
You will have a survey that takes under five minutes, built from a short list of questions that each feed a decision, piloted with three people, sent, and reported with an honest completion rate.
Beginner · 13 min
Write unbiased survey questions and answer scales
You will have a corrected set of survey questions, each with an answer scale that fits what it measures and a one-line reason for every change you made.
Beginner · 14 min
Stage 02
Core skills
Assumes: You can write simple Python and know how your data was collected.
Clean data, code free-text answers and read results without overclaiming.
How to Clean and Summarise a CSV File with pandas
You will take a messy orders CSV with stray spaces, mixed spellings, money written as text, odd dates, missing values and a duplicate row, and clean it with pandas 3.1 on Python 3.15 into a tidy file plus per-country and per-month summaries.
Beginner · 22 min
How to Process JSON on the Command Line with jq
You will install jq 1.8, read values out of a JSON file, filter and reshape arrays, total and group data, turn JSON into CSV, pass shell values in safely, change a document, work with files of one JSON object per line, and use jq's exit status in scripts.
Beginner · 18 min
Code open-ended survey answers into themes
You will have around 200 free-text survey answers coded against a written codebook that you and a colleague tested for agreement, and a theme table with counts and example quotes.
Intermediate · 16 min
Read survey results without fooling yourself
You will check who answered your survey, put a margin of error on each headline number, decide which group differences are too small to report, and write a results summary that states its own limits.
Intermediate · 15 min
Score a design with the System Usability Scale
You will have SUS scores for two versions of a design, worked out by hand and in a spreadsheet, with confidence intervals and a written statement of what the numbers do and do not show.
Intermediate · 16 min
Stage 03
Build projects
Assumes: You can clean a dataset and summarise it.
Use product data to answer real questions alongside research teams.
Use analytics to decide what to research next
You will turn a booking flow's funnel and event data into two or three research questions, each tied to a specific number, a specific group of people and a method that can answer it.
Intermediate · 14 min
Combine interview and analytics findings into one story
You will have one finding that rests on both interviews and product data, with a confidence level, the reason for any disagreement between the two, and a note on what evidence would change it.
Advanced · 17 min
How to Build Your First Grafana Dashboard from Prometheus Data
You will install Grafana 13.3 from its apt repository on Ubuntu 26.04, set the admin password before the first start, keep it on localhost, connect it to Prometheus, and build a server overview dashboard with uptime, memory and CPU panels that lives in a file you can keep in Git.
Intermediate · 25 min