Skip to content

Data Analysis with SQL and Python

Learn to answer real business questions with data: clean it with SQL, explore it with Python, and present it in a dashboard your manager will actually open.

See dates and enrol Ask an advisor

Curriculum

Twelve weeks, six units

6 modules 120 hours of teaching

  1. Weeks 1–2 From spreadsheets to tables 18 h
    • Cleaning messy data in a spreadsheet
    • Pivot tables and lookups you can trust
    • What a relational database is, and why it helps
    • Your first SELECT queries

    OutcomeYou will be able to clean a messy export and describe it as a set of related tables.

  2. Weeks 3–4 SQL for analysis 22 h
    • Joins, and how they go wrong
    • Grouping and aggregates
    • Window functions for running totals and rankings
    • Readable queries with CTEs

    OutcomeYou will be able to answer a business question with one clear, reviewed SQL query.

  3. Weeks 5–6 Python and pandas 20 h
    • Notebooks and a clean project folder
    • DataFrames: filter, reshape, merge
    • Reading data straight from SQL
    • Automating a weekly report

    OutcomeYou will be able to turn a manual weekly report into a script that runs in seconds.

  4. Weeks 7–8 Statistics you will actually use 20 h
    • Averages, medians and the outliers between them
    • Distributions and sampling
    • A/B tests and confidence intervals
    • When a difference is not a difference

    OutcomeYou will be able to say how sure you are about a result, in one sentence a manager understands.

  5. Weeks 9–10 Dashboards and data stories 18 h
    • Choosing the right chart
    • Building a dashboard people open twice
    • Writing a one-page summary
    • Presenting numbers to non-analysts

    OutcomeYou will be able to build a small dashboard and explain what changed and why.

  6. Weeks 11–12 Portfolio project 22 h
    • Your own dataset, or one from a partner company
    • Two reviews with a working analyst
    • Final presentation to the cohort

    OutcomeYou will be able to show a finished, reviewed analysis in a job interview.

Dates

Choose your date

Each date has its own place, schedule and seats. Past dates leave the list on their own.

    Students

    In their words

    • I already used spreadsheets every day. The SQL weeks changed how I work: I now pull my own numbers instead of waiting two days for them.

      Sofia Marin Data analyst, now at a logistics company Data Analysis with SQL and Python, 2026

    • Day three, we tested our prototype with real participants. It was uncomfortable and it was the most useful day of the week.

      Tomasz Nowak Product designer, Berlin UX Research in Practice, 2025

    • I came for the frameworks and stayed for the other managers in my group. Eight of us still meet once a month.

      Grace Adeyemi Engineering manager, Toronto New Manager Programme, 2025

    Questions

    Before you enrol

    Still unsure? Write to an advisor: we answer within one working day.

    Enrolment and funding

    How do I enrol?

    Pick a date on the programme page and fill in the application form. An advisor calls you within one working day to check the programme fits. You then confirm your seat with a deposit.

    Can my employer pay for the programme?

    Yes. Most of our students are funded by their employer. We can send an invoice, accept a purchase order, and give you a syllabus and a training agreement for your manager.

    Ask your advisor for the employer pack.

    Can I get a refund?

    You get a full refund if you cancel up to 14 days before the start date. After that, we refund half the fee until the end of the first week, or move you to a later cohort at no cost.

    During the programme

    How many hours a week should I plan for?

    About ten hours a week for part-time programmes: two live evening classes, plus exercises in your own time. On-campus days in London, Berlin and Toronto are listed with each date.

    What if I miss a class?

    Every live class is recorded and posted the same evening. Watch it, do the exercise, and bring your questions to the weekly office hour. If you miss more than three classes, we can move you to the next cohort.

    Do I get a certificate?

    Yes. You receive a Pellam Institute certificate when you attend at least 80% of the classes and hand in the final project. It lists the hours and the skills covered.

    Enrol

    Pick a date, leave your details, and an advisor confirms your seat within one working day. Nothing to pay yet.

    Questions first? Read the FAQ or book a 15-minute call with an advisor.