Professional training in London and 13 international cities info@llmi.uk +443300011190
Enquire

Professional training course · DMBI-022

Advanced Power BI: DAX and Data Modelling

Many Power BI users can build visuals but struggle with data models and DAX, which limits accuracy and performance. Advanced skills unlock reliable, scalable reports…

  • 5 daysClassroom or online
  • 14Upcoming dates
  • 7Cities
  • £2,750Fees from
View dates & register Get quotation Download PDF
Advanced Power BI: DAX and Data Modelling
Next classroom session Vienna 16 - 20 Nov 2026 · £4,250 Next in London London 12 - 16 Apr 2027 · £2,750

Course overview

Why Attend

Many Power BI users can build visuals but struggle with data models and DAX, which limits accuracy and performance. Advanced skills unlock reliable, scalable reports.

This LLMI course covers star schema modelling, relationships, DAX fundamentals and evaluation context, time intelligence, advanced calculations, performance optimisation, row-level security and deployment best practice. Participants build an advanced financial and operational model.

Course Objectives

Design star schema data models

Manage relationships and model properties

Write DAX measures with correct context

Apply time intelligence functions

Optimise model and report performance

Implement security and deployment best practice

Target Audience

Power BI developers

BI analysts

Finance and FP&A analysts

Data analysts

Reporting specialists

IT BI teams

Course Methodology

Hands-on labs

Modelling workshops

DAX exercises

Performance tuning practice

Capstone model

Course outline

  1. 1Day 1: Data Modelling
    • Star schema
    • Fact and dimension tables
    • Relationships
    • Cardinality
    • Model best practice
    • Lab: Building a model
  2. 2Day 2: DAX Fundamentals
    • Measures versus columns
    • Evaluation context
    • CALCULATE
    • Iterators
    • Variables
    • Lab: DAX measures
  3. 3Day 3: Time Intelligence
    • Date tables
    • YTD and prior period
    • Rolling averages
    • Custom calendars
    • Lab: Time intelligence
  4. 4Day 4: Advanced Calculations and Performance
    • Advanced DAX patterns
    • Ranking and segmentation
    • Performance analyser
    • Optimisation
    • Aggregations
    • Lab: Optimisation
  5. 5Day 5: Security and Deployment
    • Row-level security
    • Workspaces
    • Deployment pipelines
    • Governance
    • Capstone: Advanced model

Schedule

Dates and fees

14 upcoming dates in 7 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF
November 2026
16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext session
Austria flag ViennaAustria · Classroom
£4,250per delegate2+ people: £3,400 each
Register
December 2026
7DEC 7 - 11 Dec 2026Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
January 2027
11JAN 11 - 15 Jan 2027Mon to Fri · 5 days
Italy flag RomeItaly · Classroom
£4,250per delegate2+ people: £3,400 each
Register
February 2027
8FEB 8 - 12 Feb 2027Mon to Fri · 5 days
Germany flag MunichGermany · Classroom
£4,250per delegate2+ people: £3,400 each
Register
March 2027
8MAR 8 - 12 Mar 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
Register
April 2027
12APR 12 - 16 Apr 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
May 2027
10MAY 10 - 14 May 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
Register
June 2027
14JUN 14 - 18 Jun 2027Mon to Fri · 5 days
Austria flag ViennaAustria · Classroom
£4,250per delegate2+ people: £3,400 each
Register
July 2027
12JUL 12 - 16 Jul 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
August 2027
9AUG 9 - 13 Aug 2027Mon to Fri · 5 days
Italy flag RomeItaly · Classroom
£4,250per delegate2+ people: £3,400 each
Register
September 2027
13SEP 13 - 17 Sep 2027Mon to Fri · 5 days
Germany flag MunichGermany · Classroom
£4,250per delegate2+ people: £3,400 each
Register
October 2027
11OCT 11 - 15 Oct 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
Register
November 2027
8NOV 8 - 12 Nov 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
December 2027
13DEC 13 - 17 Dec 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
Register

Questions

Frequently asked questions

How long is the Advanced Power BI: DAX and Data Modelling course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Advanced Power BI: DAX and Data Modelling course?

The next public date is 16 - 20 Nov 2026 in Vienna. There are 14 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Vienna, Barcelona, Rome, Munich, Amsterdam, London, Istanbul.

Can I take Advanced Power BI: DAX and Data Modelling online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,750 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Related

More Data Management and Business Intelligence courses

View all

Training a team?

Any course in our catalogue can be delivered privately for your organisation, at your offices or in one of our cities, with content shaped around your goals.

Plan in-house training Speak to an advisor