Skip to content
AiX
AiX Academy

Data analytics with SQL and Power BI

Answer business questions with SQL queries and dashboards that people actually read.

Beginner
4.34.3 out of 5 stars from 8 ratings(8 ratings) 22 learners

Created by Sipho Ndlovu

  • Last updated November 2026
  • English
  • Certificate of completion

What you'll learn

  • Write SQL queries that filter, group and join several tables
  • Use window functions to rank results and calculate running totals
  • Clean text and date columns in SQL before analysis
  • Build a star schema and relationships in Power BI
  • Write DAX measures for totals, averages and year-on-year change
  • Design and publish a dashboard for a non-technical audience

Skills you'll gain

  • SQL
  • Window functions
  • Power BI
  • DAX
  • Data modelling
  • Dashboard design

Part of these pathways

Course content

4 sections · 12 lectures · 3.7 total hours · ≈ 1.4 GB to download

SQL foundations 3 lectures · 54 min

Selecting, filtering and summarising data.

  • Select, filter and sort Preview 14 min · 105 MB
  • Aggregates and grouping Locked until you enrol 18 min · 135 MB
  • Joining tables Locked until you enrol 22 min · 165 MB
Window functions and clean data 3 lectures · 54 min

Advanced SQL for ranking, trends and messy columns.

  • Ranking and running totals Locked until you enrol 20 min · 150 MB
  • Common table expressions Locked until you enrol 16 min · 120 MB
  • Cleaning text and dates in SQL Locked until you enrol 18 min · 135 MB
Power BI modelling 3 lectures · 1 h 2 min

Shape the data so that the measures are correct.

  • Importing data and building a star schema Locked until you enrol 22 min · 165 MB
  • Measures with DAX Locked until you enrol 25 min · 188 MB
  • Relationships and calculated columns Locked until you enrol 15 min · < 1 MB
Dashboards and storytelling 3 lectures · 53 min

Present the results so the decision is obvious.

  • Designing a dashboard people will read Locked until you enrol 16 min · 120 MB
  • Publishing and sharing a report Locked until you enrol 12 min · 90 MB
  • Portfolio project: retail sales analysis Locked until you enrol 25 min · < 1 MB

Requirements

  • Comfortable with Excel formulas
  • A Windows laptop for Power BI Desktop
  • No prior SQL needed

Description

Every business has questions that sit in a database: which products sell in which region, which customers stop buying, where the margin goes. This course teaches SQL to answer those questions and Power BI to show the answers in a dashboard that a manager can read in two minutes.

The practice data is a retail sales database with customers, stores, products and returns. You work from simple selects to window functions and common table expressions, then build a star schema in Power BI and write DAX measures. The final project is a sales analysis that you can show to an employer.

Instructor

Sipho Ndlovu

Data analytics lead, SQL and Power BI

  • 5 courses
  • 110 learners

Sipho runs the AiX data work, from database design to dashboards for provincial reporting. Courses start with the question, then the data, then the chart.

4.3 course rating · 8 ratings

4.34.34.3 out of 5 stars from 8 ratings8 ratings
  • 5 stars50%
  • 4 stars25%
  • 3 stars25%
  • 2 stars0%
  • 1 star0%
  • Zanele Nkosi
    5.05.0 out of 5 stars from 1 ratings

    Clear exercises, and the final dashboard is a real portfolio piece.

  • Lindiwe Sithole
    4.04.0 out of 5 stars from 1 ratings

    Good for finance clerks moving into analysis. The DAX section is tough but fair.

  • Aisha Hendricks
    4.04.0 out of 5 stars from 1 ratings

    Covers the basics well, though I wanted more on query performance.

  • Kagiso Molefe
    3.03.0 out of 5 stars from 1 ratings

    I could not finish the second module because of the software licence on my work laptop.

  • Thabo Mokoena
    5.05.0 out of 5 stars from 1 ratings

    The Power BI dashboards are shown step by step. My first report went live at work in week four.

  • Pieter van der Merwe
    5.05.0 out of 5 stars from 1 ratings

    Sipho's notes on data modelling were practical. I now build star schemas instead of one giant table.

Frequently asked questions

Does this work on a Mac?

Power BI Desktop runs on Windows only. Mac users can work in the browser with Power BI Service, and the course notes show the differences.

Which database do the examples use?

MySQL and MariaDB. The SQL is standard enough to run on PostgreSQL with small changes.

Is there a certificate?

Yes. You receive an AiX certificate on completing the four modules and the portfolio project.

Learners also bought

Browse all courses
R2 750Data analytics with SQL and Power BI