Microsoft and Office Tools Microsoft Power BI Courses

Power BI Advanced | Training Course

Master complex DAX, performance tuning and automation to build secure, scalable, enterprise‑level Power BI reporting solutions.

2 day course 10am - 5pm Live Online or Classroom-based

What you will learn

Understanding how to design enterprise-level data models, enabling you to build robust, high-performance reporting systems for large organisations.
Exploring complex DAX techniques, empowering you to create sophisticated calculations that deliver precise results for critical business metrics.
How to optimise model performance through query folding and aggregations, helping your dashboards load faster and operate more efficiently.
Mastering advanced Row-Level Security settings, enabling you to manage data access confidently and maintain compliance in professional environments.
How to enhance visual storytelling with corporate themes and AI-powered visuals, transforming dashboards into insightful business communication tools.
Integrating Power BI across Teams, SharePoint and cloud platforms, allowing seamless collaboration and automated report sharing within wider workflows.
How to implement governance and deployment pipelines, helping teams version-control reports safely and streamline enterprise-wide analytics publishing.
Working through a real-world project challenge, reinforcing advanced modelling, automation and security skills that enhance professional capability immediately.

Book Now

Related Courses

Informative, educational and well delivered.
Ernst & Young
September 2025
The lesson was structured so you revised and carry out small tasks independently to memorise and learn. I've come away far more confident and supported, it was an engaging lesson and friendly host!
Rosie D
November 2025
Incredible experience with Transmedia. The trainer was diligent, engaging and clearly a huge subject matter expert. We walked away with highly applicable new skills. Couldn't recommend highly enough.
Aurora Healthcare
November 2025
The course was exactly what I needed at this point and our trainer was superb. But I've come to expect this from Transmedia who I've used for at least 20 years now.
Rolls Royce
November 2025
Instructor was very patient and explained all aspects of Premiere Pro clearly. The support during the two days was fantastic.
Kofo K
October 2025
Big thank you from me to Transmedia for making it happen and to your trainer for their excellent delivery. Everyone was very complementary. When asked by other forces we will recommend yourselves!
Hampshire Police
November 2025
The Figma course was great! Tony was very good at explaining and had great patience even when you didn't understand something. I feel much more confident using Figma now
Fremantle Media Group Ltd
October 2025
The course was really useful and our trainer was a great instructor. The course went at a good pace and there was lots of useful information here for us.
Artful Dog Publishing
November 2025
I found the training extremely useful! Our trainer was brilliant. She gave me lots of advice and tips that I will act upon to improve what we're doing. We're currently looking at other courses to do!
Lincolnshire Police
September 2025
I thoroughly enjoyed the course. We really got to focus on the areas we needed. I really liked our teacher's style of teaching. I left feeling really inspired, with regained confidence and new skills.
Oliver Bonas
November 2025
Thanks so much for the invaluable training I received on Premiere Pro. I really enjoyed the two days and learnt a lot. I'm excited to create my own videos using all the skills and techniques taught!
MAF UK
August 2025
The tutor went carefully over the basics of Photoshop, which I plunged into several years ago when it was much simpler than it is now. This information has been a life changer and I am very grateful.

November 2025
Lovely staff, easy to follow tutorials.
Newton Investment Management
October 2025
Just wanted to say it was a pleasure meeting you all over the last couple of days, I was very impressed with the course. Our trainer was a great guy, very knowledgeable and a good trainer.
We Are Shard
November 2025
Lovely accommodation and atmosphere. The training was well structured and clear.
Alistair Sawday Publishing
November 2025

Informative, educational and well delivered.
Ernst & Young
September 2025
The lesson was structured so you revised and carry out small tasks independently to memorise and learn. I've come away far more confident and supported, it was an engaging lesson and friendly host!
Rosie D
November 2025
Incredible experience with Transmedia. The trainer was diligent, engaging and clearly a huge subject matter expert. We walked away with highly applicable new skills. Couldn't recommend highly enough.
Aurora Healthcare
November 2025
The course was exactly what I needed at this point and our trainer was superb. But I've come to expect this from Transmedia who I've used for at least 20 years now.
Rolls Royce
November 2025
Instructor was very patient and explained all aspects of Premiere Pro clearly. The support during the two days was fantastic.
Kofo K
October 2025
Big thank you from me to Transmedia for making it happen and to your trainer for their excellent delivery. Everyone was very complementary. When asked by other forces we will recommend yourselves!
Hampshire Police
November 2025
The Figma course was great! Tony was very good at explaining and had great patience even when you didn't understand something. I feel much more confident using Figma now
Fremantle Media Group Ltd
October 2025
The course was really useful and our trainer was a great instructor. The course went at a good pace and there was lots of useful information here for us.
Artful Dog Publishing
November 2025
I found the training extremely useful! Our trainer was brilliant. She gave me lots of advice and tips that I will act upon to improve what we're doing. We're currently looking at other courses to do!
Lincolnshire Police
September 2025
I thoroughly enjoyed the course. We really got to focus on the areas we needed. I really liked our teacher's style of teaching. I left feeling really inspired, with regained confidence and new skills.
Oliver Bonas
November 2025
Thanks so much for the invaluable training I received on Premiere Pro. I really enjoyed the two days and learnt a lot. I'm excited to create my own videos using all the skills and techniques taught!
MAF UK
August 2025
The tutor went carefully over the basics of Photoshop, which I plunged into several years ago when it was much simpler than it is now. This information has been a life changer and I am very grateful.

November 2025
Lovely staff, easy to follow tutorials.
Newton Investment Management
October 2025
Just wanted to say it was a pleasure meeting you all over the last couple of days, I was very impressed with the course. Our trainer was a great guy, very knowledgeable and a good trainer.
We Are Shard
November 2025
Lovely accommodation and atmosphere. The training was well structured and clear.
Alistair Sawday Publishing
November 2025

This Power BI Advanced course includes

Authorised Certificate
Lifetime support after your course
Course materials
Live Instructor-led training

Refreshments all day
Latest Mac or PC ready to go
Authorised Trainers
Hands-on exercises

Book this course

We offer Power BI Advanced as a private course.

You can select a date which suits you or your team.

The course content can be fully customised to your exact learning requirements.

Request dates

Google Reviews

The course was very well structured and communication was very effective. Everything appeared to build well upon knowledge previously gained and the instructor made the course enjoyable.

Structural Soils Ltd

November 2025

Course Outline for Power BI Advanced

Advanced Data Architecture and Integration

Implementing composite and incremental data models
Using DirectQuery vs Import mode strategically
Managing performance through data view options
Integrating cloud and on-premises sources via gateways

Mastering Complex DAX

Working with virtual tables and context transition
Creating advanced filters using CALCULATE, SUMMARIZE, ADDCOLUMNS
Leveraging SWITCH, SELECTEDVALUE and dynamic titles
Building dynamic security expressions for Row-Level Security (RLS)

Performance and Optimisation

Understanding query folding and its impact
Using Performance Analyser and DAX Studio
Optimising datasets and refresh strategies
Managing large models with aggregations

Enterprise Design and Visual Excellence

Applying corporate branding, themes and templates
Developing user-driven reports with parameters
Using AI visuals: Key Influencers, Decomposition Tree and Smart Narrative
Creating app-based dashboards with advanced navigation

Automation and Integration

Using Power Automate to schedule report distribution
Embedding Power BI in Teams, SharePoint and external web portals
Creating data-driven alerts and automated tasks

Governance, Security and Deployment Pipelines

Implementing RLS and sensitivity labelling
Managing workspaces, model versioning and access control
Publishing enterprise reports via deployment pipelines

Class Project

Designing an enterprise-scale report system incorporating advanced DAX, automation and security best practices

FAQs about the Power BI Advanced course

Is this Power BI Advanced course suitable for me?

This course is designed for people who have experience in Power BI or have already attended one of our Power BI training courses or who would like to further their knowledge of best practice in the use of Power BI. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.

How is the content taught throughout the Power BI Advanced course?

Our Power BI Advanced course is extremely interactive. You will be using Power BI throughout the day, working through examples and live projects under the guidance of our trainer, who will be inviting questions and supporting you through each step.

How many people are likely to be in the class when I attend the Power BI Advanced course?

For private classes in Power BI Advanced, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.

Should I attend the Power BI Advanced course in person or live online?

For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.

What support is available after I attend the Power BI Advanced course?

We offer ongoing support to our Power BI Advanced course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.

Will I receive a certificate upon completion of my Power BI Advanced course?

Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our Power BI Advanced course. Our certificates note our Authorised Training Centre status.

Power BI Advanced — Team and Bespoke Training

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

Sessions can be run online or in person, on your site or at our London training centre.
We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
We offer a free consultation service to work out every detail of your course.

Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Book Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Book Now