Search icon

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.
  • Extremely good. Very knowledgeable, helpful and approachable.

    Hachette
    July 2026
  • As someone who has attended three courses now with Transmedia, I have always come away feeling more confident and knowledgeable. Lee happily recaps on any content students are unsure of. Thank you!

    Ministry Of Defence
    October 2026
  • I absolutely loved the course and found it SO useful and very inspiring. The team are so lovely and very accommodating! I would definitely recommend it.

    Florence W
    August 2026
  • All was great, learned lots of new things. Perfect.

    September 2026
  • The InDesign course was really great and I thoroughly enjoyed it. Our tutor couldn't have been a better teacher!

    Domus Nova
    September 2026
  • Following on from my recent course, I just wanted to say how much I enjoyed it.

    Balloon Dog TV
    October 2026
  • Excellent. The right pace, the right style - great overall!

    Goldsmiths University of London
    October 2026
  • The course was excellent - an in-depth curriculum with a relaxed and engaging delivery style. A perfect balance between structured learning and open discussion and directly relevant to our work.

    Grosvenor Technology
    September 2026
  • I had a fantastic time! My trainer was a great teacher - patient, clear and friendly. The rest of the team were also very welcoming and accommodating. I learned lots of tips and tricks. 10/10 :)

    Salesforce
    October 2026
  • Our trainer was hugely knowledgable and very patient. Learnt a lot of theory and then how to put into practice. Hugely helpful compared to a self taught online course. Would highly recommend.

    Planned 2 Perfection
    October 2026
  • The course was brilliant, thank you! Both Elise and I enjoyed the course and took a lot from it. Our tutor was very knowledgeable.

    Blake Envelopes and Packaging
    October 2026
  • Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs.

    NVIDIA
    October 2026
  • Excellent course provided by a knowledgeable trainer.

    Driver & Vehicle Standards Agency
    August 2026
  • Amazing, thank you for the slides! The course was great, it gave me a deeper understanding of how best to work with each social media channel and how that knowledge can help to elevate our company.

    MICROBIOLOGY SOCIETY
    July 2026
  • Excellent training session with a knowledgeable instructor.

    Gallagher
    September 2026
  • Extremely good. Very knowledgeable, helpful and approachable.

    Hachette
    July 2026
  • As someone who has attended three courses now with Transmedia, I have always come away feeling more confident and knowledgeable. Lee happily recaps on any content students are unsure of. Thank you!

    Ministry Of Defence
    October 2026
  • I absolutely loved the course and found it SO useful and very inspiring. The team are so lovely and very accommodating! I would definitely recommend it.

    Florence W
    August 2026
  • All was great, learned lots of new things. Perfect.

    September 2026
  • The InDesign course was really great and I thoroughly enjoyed it. Our tutor couldn't have been a better teacher!

    Domus Nova
    September 2026
  • Following on from my recent course, I just wanted to say how much I enjoyed it.

    Balloon Dog TV
    October 2026
  • Excellent. The right pace, the right style - great overall!

    Goldsmiths University of London
    October 2026
  • The course was excellent - an in-depth curriculum with a relaxed and engaging delivery style. A perfect balance between structured learning and open discussion and directly relevant to our work.

    Grosvenor Technology
    September 2026
  • I had a fantastic time! My trainer was a great teacher - patient, clear and friendly. The rest of the team were also very welcoming and accommodating. I learned lots of tips and tricks. 10/10 :)

    Salesforce
    October 2026
  • Our trainer was hugely knowledgable and very patient. Learnt a lot of theory and then how to put into practice. Hugely helpful compared to a self taught online course. Would highly recommend.

    Planned 2 Perfection
    October 2026
  • The course was brilliant, thank you! Both Elise and I enjoyed the course and took a lot from it. Our tutor was very knowledgeable.

    Blake Envelopes and Packaging
    October 2026
  • Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs.

    NVIDIA
    October 2026
  • Excellent course provided by a knowledgeable trainer.

    Driver & Vehicle Standards Agency
    August 2026
  • Amazing, thank you for the slides! The course was great, it gave me a deeper understanding of how best to work with each social media channel and how that knowledge can help to elevate our company.

    MICROBIOLOGY SOCIETY
    July 2026
  • Excellent training session with a knowledgeable instructor.

    Gallagher
    September 2026

This Power BI Advanced course includes

  • bullet point icon Authorised Certificate
  • bullet point icon Lifetime support after your course
  • bullet point icon Course materials
  • bullet point icon Live Instructor-led training
  • bullet point icon Refreshments all day
  • bullet point icon Latest Mac or PC ready to go
  • bullet point icon Authorised Trainers
  • bullet point icon 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

Sage Filming with a Smartphone
Adobe Rishi
Sage Francesca
Ellie from Sportd Industry Group
Annetta from The University of Westminster
Exeter University Gloria
Elena
James from Digital Catapult
Adobe Max
Adobe Sven and Stephane
Adobe Quintijn
NHM Emma
Roze and Erin
Danielle
Amari doing Illustrator
Zahra from The Hoffman Agency
Josie and Vanessa
Adobe Claudia
Julia from Letters by Julia
Adobe Carlo
Adobe Lemeeka

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
Show more

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

nhs logo university of cambridge logo usaid logo hiscox logo formula 1 logo apollo tyres logo hmpps logo wcrf logo banking standards board logo bbc logo victoria and albert museum logo five cowries logo university of oxford logo natural history museum logo hsbc logo clarks logo s4c logo rapha logo game of thrones logo dyson logo british library logo raf logo

Latest Blog Articles

Why Transmedia?

Icon of an activity line

Unlimited Training Support

We offer unlimited training support after your course.

Icon of an activity line

Bespoke Training Solutions

Customised training and software solutions based on your exact requirements.

Icon of an activity line

Worldwide Creative Skills Training

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

Icon of an activity line

Authorised Training Professionals

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