PProtokol
← all paths

Data Analyst

SQL, analysis and visualisation that drives decisions.

4 courses7 projects49 lessons~40h

Skills you'll build

Computational ThinkingVariablesConditionalsLoopsFunctionsProblem SolvingPython BasicsPython Data Handling

Your progress

0/49 lessons · 0%

Next step

Programming Foundations

start path

Courses in this path

  1. 01

    Programming Foundations

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

    ~14h17 lessons3 projectsbeginner

    start
  2. 02

    Python Foundations

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

    ~10h12 lessons2 projectsbeginner

    Finish Programming Foundations first.

    locked
  3. 03

    Databases and SQL

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

    ~6h10 lessons1 projectbeginner

    Finish Programming Foundations first.

    locked
  4. 04

    Data Analysis Foundations

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

    ~10h10 lessons1 projectbeginner

    Finish Programming Foundations first.

    locked

Projects you'll complete

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

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

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