Microsoft and Office Tools Microsoft Power BI Courses Power BI Advanced

Power BI Advanced | Training Course

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

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

What you will learn

Understanding robust dataset design, enabling accurate data profiling, transformations and scalable modelling for reliable Power BI analytics.
How to apply Power Query parameters, enabling flexible models that accelerate scenario testing and improve reporting productivity.
Applying field parameters and numeric controls, empowering users to explore measures dynamically and tailor analytical perspectives.
How to create groups, bins and multivariate clusters, helping professionals segment data and uncover actionable patterns.
Building forecast charts with confidence intervals, enabling informed planning through predictive analytics and trend analysis.
How to use the Analytics pane, enabling anomaly detection, outlier analysis and faster evidence-based decision making.
Leveraging AI visuals and Q and A, empowering teams to generate insights, explain differences and communicate findings clearly.

Book Now

Related Courses

I was having a FileMaker issue and as always, Transmedia was able to sort it out in minutes. I cannot recommend this company enough. I have had nothing but excellent swift service from them.
Beaulieu Settled Estate
July 2026
The session on the 25th was brilliant, thank you. The SEs found it very useful and loved the trainer's tips and tricks to help us update our prototypes quickly.
Salesforce
July 2026
Great 2 day course. Our instructor was really good - patient, clear and informative. Everything was well organised. The small class size was great, it was well-paced and the content easy to follow.
Charcoal Blue
May 2026
Really informative. Training style was great. Good amount of time using the application. Ability to ask questions as we went along was great.
Investigo
August 2026
The most useful training I have had in a decade. The trainer was very knowledgeable and used very practical exercises to show theory and functionality. The training venue was great. Highly recommend.
Chance UK (Charity)
August 2026
The session was really good, thank you. Everyone enjoyed it and found it very useful. Thanks so much for all your help.
Kingfisher Drinks
August 2026
Our tutor was very good at covering the course content. He was also very good at explaining what we had to do and very patient. Overall I thought the course was run really well.
East and North Hertfordshire NHS Trust
June 2026
I thought Tony's training on Friday was excellent, he has great depth of knowledge and explains logically and clearly as we stepped through some of the Photoshop capabilities I need to learn.
Peter M
June 2026
We really enjoyed the course, thank you!
Morgan Lovell
June 2026
Absolutely top quality training and facilities.
National Museum of Wales
July 2026
A huge thank you to the whole team at Transmedia - everyone we dealt with was extremely helpful and highly responsive with any queries we had. We felt like we were in safe hands from start to finish.
Cambridge University Press
May 2026
Our trainer was calm, reassuring and passionate about the course.
Torpedo Group
July 2026
I found the After Effects course for Beginners very good. Lee was a great tutor and very patient. I feel much more confident now as I start to work in After Effects after attending this course.
National Army Museum
August 2026
Amazing! Learnt so much.
Paulina M
July 2026
A pleasure! Really enjoyed Day 1 - looking forward to Day 2 on Thursday. Hope all is well at Transmedia!
NHS Counter Fraud Authority
May 2026

I was having a FileMaker issue and as always, Transmedia was able to sort it out in minutes. I cannot recommend this company enough. I have had nothing but excellent swift service from them.
Beaulieu Settled Estate
July 2026
The session on the 25th was brilliant, thank you. The SEs found it very useful and loved the trainer's tips and tricks to help us update our prototypes quickly.
Salesforce
July 2026
Great 2 day course. Our instructor was really good - patient, clear and informative. Everything was well organised. The small class size was great, it was well-paced and the content easy to follow.
Charcoal Blue
May 2026
Really informative. Training style was great. Good amount of time using the application. Ability to ask questions as we went along was great.
Investigo
August 2026
The most useful training I have had in a decade. The trainer was very knowledgeable and used very practical exercises to show theory and functionality. The training venue was great. Highly recommend.
Chance UK (Charity)
August 2026
The session was really good, thank you. Everyone enjoyed it and found it very useful. Thanks so much for all your help.
Kingfisher Drinks
August 2026
Our tutor was very good at covering the course content. He was also very good at explaining what we had to do and very patient. Overall I thought the course was run really well.
East and North Hertfordshire NHS Trust
June 2026
I thought Tony's training on Friday was excellent, he has great depth of knowledge and explains logically and clearly as we stepped through some of the Photoshop capabilities I need to learn.
Peter M
June 2026
We really enjoyed the course, thank you!
Morgan Lovell
June 2026
Absolutely top quality training and facilities.
National Museum of Wales
July 2026
A huge thank you to the whole team at Transmedia - everyone we dealt with was extremely helpful and highly responsive with any queries we had. We felt like we were in safe hands from start to finish.
Cambridge University Press
May 2026
Our trainer was calm, reassuring and passionate about the course.
Torpedo Group
July 2026
I found the After Effects course for Beginners very good. Lee was a great tutor and very patient. I feel much more confident now as I start to work in After Effects after attending this course.
National Army Museum
August 2026
Amazing! Learnt so much.
Paulina M
July 2026
A pleasure! Really enjoyed Day 1 - looking forward to Day 2 on Thursday. Hope all is well at Transmedia!
NHS Counter Fraud Authority
May 2026

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

Video success stories

Course Outline for Power BI Advanced

Dataset Design

Data profiling
Data model planning
Data transformations

Parameters in Power Query

Creating parameters
ConfiguringÂ parameters

Field Parameters

Numeric parameters
Field parameters

Groups, Bins and Clusters

Creating groups
Creating bins
Creating clusters
Multivariate cluster

Forecast Charts

Configuring forecast charts
Assigning forecast units
Confidence intervals

The Analytics Pane

Finding anomalies
Detecting outliers

Customising Q and A

Tweak your data for Q and A
Sharing Q and A synonyms

AI Visual Capabilities

Generate insights
The analyse feature
Key influencer visual
Decompression visual
The narrative visual

AI Features in Charts

Distribution differences
Explaining difference

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.

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

Our Clients

Who we work with

Latest Blog Articles

Power BI training abstract illustration representing data models, dashboards, measures and reporting workflows

Power BI Data Modelling for Finance: A Simple Explanation of Relationships and Measures

Google Guide to Generative AI: Tips for UX Designers and Content Teams

Claude Connectors: What Every Creative Professional Should Know

Why Transmedia?

Unlimited Training Support

We offer unlimited training support after your course.

Bespoke Training Solutions

Customised training and software solutions based on your exact requirements.

Worldwide Creative Skills Training

Join our authorised training courses live online from anywhere in the world.

Authorised Training Professionals

Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.

Transmedia is a leading UK provider of Authorised Adobe, Apple, and Claris FileMaker training, and a specialist in Artificial Intelligence training for business teams.

With over 32 years' experience and 150,000+ people trained, we deliver live online or in-classroom courses from our London training centre, including ChatGPT, Claude, Adobe Firefly, and generative AI for creative and marketing teams, alongside Adobe Creative Cloud, animation and video, coding, Figma, Google, Microsoft Office, and business skills: for individuals, corporate teams, and charities across the UK and worldwide.