Career path · Beginner level

Analytics Engineer & Data Analyst

Turn raw data into trusted models, metrics, and dashboards that teams use to decide.

For analysts, business graduates, and SQL users who want to own the data model.

  • Step-by-step milestones
  • Hands-on lessons
  • Capstone project
  • Interview preparation

Your learning journey

Follow the milestones in order. Each one builds on the skills from the last.

  1. Milestone 1 · SQL

    SQL

    67 lessons · about 18 hours

    From SELECT to window functions and query performance.

    0/67
    Hide lessonsShow all 67 lessons
  2. Milestone 2 · Python

    Python basics

    19 lessons · about 13 hours

    Automate small data tasks in Python.

    0/19
    Hide lessonsShow all 19 lessons
  3. Milestone 3 · Data Analytics & Statistics

    Analyst toolkit

    4 lessons · about 3 hours

    Spreadsheets, analytical SQL, pandas, and exploratory data analysis.

    0/4
    Hide lessonsShow all 4 lessons
  4. Milestone 4 · Data Analytics & Statistics

    Statistics, metrics and experiments

    7 lessons · about 4 hours

    Descriptive statistics, hypothesis tests, KPIs, and A/B testing.

    0/7
    Hide lessonsShow all 7 lessons
  5. Milestone 5 · Data Engineering

    Data modelling and warehousing

    8 lessons · about 8 hours

    Dimensional models, star schemas, and warehouse design.

    0/8
    Hide lessonsShow all 8 lessons
  6. Milestone 6 · dbt

    Transformation with dbt

    23 lessons · about 25 hours

    Model, test, and document warehouse transformations.

    0/23
    Hide lessonsShow all 23 lessons
  7. Milestone 7 · Snowflake

    Cloud warehouse: Snowflake

    22 lessons · about 26 hours

    Load, transform, secure, and tune a cloud warehouse.

    0/22
    Hide lessonsShow all 22 lessons
  8. Milestone 8 · Data Analytics & Statistics

    BI and data storytelling

    3 lessons · about 2 hours

    Build dashboards people use and present findings that drive decisions.

    0/3
    Hide lessonsShow all 3 lessons

Prove it

Capstone: Metrics layer and dashboard

A tested dbt project feeding a dashboard with documented metric definitions.

Project brief coming soon

Get hired

Interview preparation

← All career paths