Skip to main content

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.

  1. Series: Python from zero

    1. 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

    2. 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

    3. 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

    4. 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

    5. 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

  2. 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

  3. 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.

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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.

  1. 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

  2. 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

  3. 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