PProtokol
Start free
← All paths

Data Analyst

SQL, analysis and visualisation that drives decisions.

Your progress

0/49 lessons · 0%

Next up: Programming Foundations

Start path
4 courses49 lessons7 projects~40h

Roadmap

Each step unlocks when the one before it is done.

  1. Programming Foundations

    Think like a programmer: values, logic, loops, functions and problem solving in JavaScript.

    ~14h17 lessons3 projectsbeginner

  2. Python Foundations

    Locked

    Learn Python from zero: syntax, data, control flow, functions, errors, and files.

    ~10h12 lessons2 projectsbeginner

  3. Databases and SQL

    Locked

    Learn how real applications store and query data: tables, SELECT, JOINs, aggregates, and how to design a simple schema.

    ~6h10 lessons1 projectbeginner

  4. Data Analysis Foundations

    Locked

    Learn to think like a data analyst: ask sharp questions, clean data, summarize it, and communicate findings.

    ~10h10 lessons1 projectbeginner

  5. Projects you'll build

    • Score Tracker

      Turn variables and types into a working score tracker used by a small games night app.

    • Practice Log Cleanup

      Use lists and dictionaries to clean up a messy practice log.

    • Design and Query a Bookings Database

      Design a schema for a small bookings app (customers, services, staff, bookings) and write the SQL to query it.

    • Sales Data Analysis Capstone

      Analyze a small sales dataset end to end: clean it, summarize it, find trends, and write a stakeholder-ready recommendation.

    • Number Guessing Engine

      Build the logic engine behind a guessing game using conditions and loops.

    • Build a Class Grade Report

      Model a Python program that reads student score records, validates them, computes averages, and produces a simple pass/fail summary report.

    • Study Coach

      Final project: a study coach that summarises practice sessions and reports back in plain English.

Skills you'll build

Computational ThinkingVariablesConditionalsLoopsFunctionsProblem SolvingPython BasicsPython Data Handling