Skip to content

Advanced DAX and Data Modelling in Power BI

Analysts who move beyond basic Power BI dashboards quickly hit the limits of simple measures and flat tables. This course develops the data modelling and DAX skills needed to build fast, accurate and reusable analytical models. Delegates practise on realistic business scenarios and learn to structure models that scale as reporting needs grow.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Design star schema data models that perform well and stay maintainable.
  • Write advanced DAX measures for complex business calculations.
  • Apply time intelligence to analyse trends and period comparisons.
  • Use calculation context and filter logic with confidence.
  • Optimise models to improve refresh speed and report responsiveness.
  • Establish reusable modelling standards for reporting teams.

Course outline

  1. 01Data Modelling Foundations
  2. 02Star Schema Design in Practice
  3. 03Advanced DAX Measures
  4. 04Filter and Calculation Context
  5. 05Time Intelligence Techniques
  6. 06Model Performance Optimisation
  7. 07Reusable Modelling Standards

Who should attend

Power BI report builders, data analysts and business intelligence professionals ready to move beyond basic dashboards.

Dates, venues and fees

DatesVenueDaysFeeCalendarRegister
27 to 28 Oct 2026Johannesburg2R10,000Register
28 to 29 Oct 2026Cape Town2R10,000Register
29 to 30 Oct 2026Durban2R10,000Register
2 to 3 Nov 2026Pretoria2R10,000Register
3 to 4 Nov 2026Windhoek2US$1,100Register
4 to 5 Nov 2026Gaborone2US$1,100Register
5 to 6 Nov 2026Maseru2US$1,100Register
9 to 10 Nov 2026Mbabane2US$1,100Register
10 to 11 Nov 2026Lusaka2US$1,100Register
11 to 12 Nov 2026Harare2US$1,100Register
12 to 13 Nov 2026Lilongwe2US$1,100Register
16 to 17 Nov 2026Blantyre2US$1,100Register
17 to 18 Nov 2026Mozambique2US$1,100Register
18 to 19 Nov 2026Nairobi2US$1,100Register
19 to 20 Nov 2026Dar es Salaam2US$1,100Register
23 to 24 Nov 2026Kigali2US$1,100Register
24 to 25 Nov 2026Kampala2US$1,100Register
25 to 26 Nov 2026Accra2US$1,100Register
26 to 27 Nov 2026Lagos2US$1,100Register
30 Nov to 1 Dec 2026Cairo2US$1,100Register
1 to 2 Dec 2026Mauritius2US$1,100Register
2 to 3 Dec 2026Dubai2US$1,100Register
3 to 4 Dec 2026Online2US$900Register

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Data, Digital and Cyber Security

Data, Digital and Cyber Security

Cyber Security Fundamentals for Business Teams

Most breaches begin with an ordinary employee making a reasonable decision on incomplete information.

Next session
29 Sep to 1 Oct 2026
Venue
Mbabane
3 day programme
FromR13,000
Data, Digital and Cyber SecurityNew

Artificial Intelligence for Business Managers

Artificial intelligence has moved from novelty to something managers are expected to have an opinion on.

Next session
29 Sep to 1 Oct 2026
Venue
Maseru
3 day programme
FromR13,000
See all Data, Digital and Cyber Security courses