Data Analytics with SQL, Python and Power BI

A practical analytics programme built around the three tools employers actually ask for. You start with SQL because that is where the data lives, add Python for the work SQL cannot do, and finish with dashboards and written analysis that change decisions rather than decorate meetings.

8 weeks 48 guided hours Beginner to Intermediate

See membership

No account needed to buy. Pay with your card and we create your student account from the email you enter, with this programme ready inside it for twelve months.

Data Analytics with SQL, Python and Power BI course artwork

What you will achieve

Write joins, aggregates and window functions with confidence
Clean and reshape messy real-world data in Python
Choose the right chart for the question being asked
Build a dashboard around a decision rather than around available fields
Write up findings with caveats a reader can trust

Entry guidance

— Comfortable using a spreadsheet
— No programming experience required

Original Mai Studies learning material. This is a professional completion programme, not a regulated qualification or university accreditation.

Programme syllabus

3 applied modules

Lessons: 6
Assessed tasks: 3
Practice questions: 9
Timed mock papers: 0

SQL, properly

Where the data lives and how to ask it the right question.

2 lessons · 3 practice questions · 1 assessed task

1. Joins, aggregates and getting the grain right21 min study · 3 learning objectives · practical activity
Most wrong numbers in business come from one of these three.
2. Window functions and time comparisons21 min study · 3 learning objectives · practical activity
Running totals, rankings and like-for-like periods.

Query set with a control total — marked out of 100, pass at 80%

Python for the messy part

Cleaning, reshaping and automating what SQL should not do.

2 lessons · 3 practice questions · 1 assessed task

1. Cleaning real data21 min study · 3 learning objectives · practical activity
Duplicates, missing values, inconsistent categories and dates that lie.
2. Reshaping and automating21 min study · 3 learning objectives · practical activity
Group, pivot, join in code, and make it repeatable.

Cleaning and analysis pipeline — marked out of 100, pass at 80%

Presenting findings that change decisions

Dashboards and written analysis aimed at a decision, not at an audience.

2 lessons · 3 practice questions · 1 assessed task

1. Charts that tell the truth21 min study · 3 learning objectives · practical activity
Choosing the visual that answers the question.
2. Dashboards and the write-up21 min study · 3 learning objectives · practical activity
Build around a decision, then say what you actually found.

Analysis pack for a real decision — marked out of 100, pass at 80%

Lesson pages, assessed tasks and mock papers open the moment you join this programme. Teaching material is studied online; the notes you write are yours to download.

What students say

No ratings yet.