Advanced Data Analysis Techniques
Next: 21 - 25 Dec 2026 · Barcelona
Barcelona, Amsterdam, London +2 more
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
- 14Upcoming dates
- 7Cities
- £2,850Fees from
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
-
1Day 1: Data Modelling
- Star schema
- Fact and dimension tables
- Relationships
- Cardinality
- Model best practice
- Lab: Building a model
-
2Day 2: DAX Fundamentals
- Measures versus columns
- Evaluation context
- CALCULATE
- Iterators
- Variables
- Lab: DAX measures
-
3Day 3: Time Intelligence
- Date tables
- YTD and prior period
- Rolling averages
- Custom calendars
- Lab: Time intelligence
-
4Day 4: Advanced Calculations and Performance
- Advanced DAX patterns
- Ranking and segmentation
- Performance analyser
- Optimisation
- Aggregations
- Lab: Optimisation
-
5Day 5: Security and Deployment
- Row-level security
- Workspaces
- Deployment pipelines
- Governance
- Capstone: Advanced model
Dates and fees
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.
How much does the course cost?
Fees start from £2,850 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
ArcGIS Pro: Essential Workflows
Next: 16 - 20 Nov 2026 · Barcelona
Barcelona, Dubai, Cape Town +11 more
Artificial Intelligence in Contract and Project Management
Next: 14 - 18 Dec 2026 · Kuala Lumpur
Kuala Lumpur, Barcelona, Paris +2 more