Data analytics with SQL and Power BI
Answer business questions with SQL queries and dashboards that people actually read.
Created by Sipho Ndlovu
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
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
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
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
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
-
Zanele Nkosi
Clear exercises, and the final dashboard is a real portfolio piece.
-
Lindiwe Sithole
Good for finance clerks moving into analysis. The DAX section is tough but fair.
-
Aisha Hendricks
Covers the basics well, though I wanted more on query performance.
-
Kagiso Molefe
I could not finish the second module because of the software licence on my work laptop.
-
Thabo Mokoena
The Power BI dashboards are shown step by step. My first report went live at work in week four.
-
Pieter van der Merwe
Sipho's notes on data modelling were practical. I now build star schemas instead of one giant table.
-
Johan Botha
Power BI Desktop versions differ, which caused confusion. Check the version in the course notes.
-
Nomsa Khumalo
Joins, window functions and CTEs explained with real retail sales data. The best SQL teaching I have seen locally.
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.