After the core: specialise · The Intelligence and Data Roles · path 6 of 13

Data Analyst / Engineer

Collects, cleans and moves data, then turns it into answers and dashboards people can act on.

🔒 This path opens once you pass the final examination. You can read the path guide and module list now.

Choose this path if you want to clean raw records and turn them into reliable reports and dashboards that answer real questions.

Where you see it daily: Sales reports, "most popular" lists, and the dashboards that tell a business what is working.

Builds on: Level 3 (Programming Skills) and Level 5 (Databases and Data).

Start here

Ready

Path guide

Role, outcomes, prerequisites, setup, costs, hardware and workload. Open to everyone.

Entry diagnostic

10 questions on the core lessons this path builds on, with revision links. Optional.

Projects and capstone

4 briefs with starter files, acceptance tests and a saved self-check.

Completion record

Your lessons, quizzes, path test and project self-checks in one place.

What you'll focus on

Focus area 1

Data pipelines

Build reliable "pipelines" that pull data from many places, clean it and load it where it's needed, on a schedule or as a live stream.

Tools and ideas: ETL/ELT, Airflow, Prefect, Spark, Flink, Python with pandas

Focus area 2

Data warehousing

Run large cloud stores built for analysis, and organise them so questions over huge amounts of data stay fast and affordable.

Tools and ideas: Snowflake, BigQuery, lakehouse design, dbt

Focus area 3

Analytics and dashboards

Write advanced SQL, shape data so it's easy to question (dimensional modelling), and present it in interactive dashboards.

Tools and ideas: SQL window functions, dimensional modelling, Tableau, Power BI

What makes this path different

Data work turns a business's records into answers people trust. Unlike building apps, the product is the numbers and the dashboards, so checking that data is complete, correct and fairly presented matters as much as the code.

Modules

Opens after you pass the final examination.

Take the path test →

40 questions from every module, in new situations. Opens once you've passed the final examination and every module quiz in this path.

What you'll build

Projects you can show, because working software proves capability in a way tests alone can't.

An automated pipeline that loads messy raw data, cleans it and refreshes on a schedule.
A dashboard that answers real questions for colleagues who aren't technical.
A well-modelled warehouse schema, with personal data protected or left out.

📊 Data Analyst / Engineer