Microsoft and Office Tools Microsoft Power BI Courses Power BI Intermediate

Power BI Intermediate | Training Course

Develop advanced modelling, DAX and visual design skills to build dynamic, dataâ€‘driven reports that deliver deeper business insights.

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

What you will learn

Understanding how to transform complex, messy datasets into reliable analytical models, helping you deliver consistently accurate, business-ready insights.
Exploring advanced Power Query features, enabling you to merge, clean and reformat data efficiently from multiple, dynamic sources.
How to build high performance data models with calculated tables and relationships, optimising them for size, clarity and refresh speed.
Mastering DAX iterator functions such as SUMX and AVERAGEX, empowering you to create detailed measures for deeper business analysis.
Developing advanced time intelligence skills, enabling rolling averages, year-to-date summaries and insightful reporting across flexible timeframes.
How to design interactive visuals with bookmarks, tooltips and drill-throughs, transforming dashboards into engaging storytelling tools.
Enhancing collaboration in Power BI Service, helping teams share, refresh and secure reports seamlessly across departments or clients.
How to apply everything in a real-world dashboard challenge, reinforcing advanced Power BI techniques that directly improve workplace performance.

Book Now

Related Courses

Our tutor was great! He explained everything very clearly and the pace of the course was amazing! I feel that I learnt a lot and understood how great of a tool Figma can be to move our business forward.
The White Company
June 2026
Lee was incredibly helpful and we learnt a lot during our two day course. Lee answered all questions and was incredibly patient. Thank you!!
River Island
August 2026
Just dropping a line to thank you, our trainer and the team for the great Figma course delivered over the past couple of days.
Marcos A
July 2026
I've attended a few training days at Transmedia and I've found them really useful, with a good mix of theory and practice. They've also been super helpful with any queries before or after my training.
VISA Europe
July 2026
We had a great first session with our trainer Lee yesterday, looking forward to our follow up day.
GSK
August 2026
Brilliant centre with friendly and knowledgeable trainers. Would definitely recommend!
BBC
June 2026
Great service! The explanations were very helpful going forward. The trainer also helped us with understanding very advanced Figma files that we would need to be working with in the future.
Bauer Media
May 2026
It was an excellent experience to learn how to use Figma and our trainer was so kind and knowledgeable!
Junggun L
June 2026
Great delivery, was kept engaged the whole day.
Ogilvy
July 2026
A brilliant instructor! Very knowledgeable and patient. He covered and explained all the fundamentals, very clearly which made the whole learning experience very enjoyable.
The White Company
June 2026
Our trainer was amazing as always, I've had great feedback from the delegates.
Hachette UK
July 2026
Had an amazing Figma training with Transmedia. Really worth coming in and learning in person as the trainer was very hands-on and helps you with all your personalised questions!
Future Advocacy Ltd
August 2026
Just wanted to say thank you for the course yesterday. The trainer was great and the team got exactly what they needed.
Essex County Council
May 2026
Enjoyed a Zoom-led introduction to Premier Pro, instructed by Lee. The pace worked well for me - we could ask questions at any point. I got a lot out of it - I just need to keep practising! Thanks.
Mod
July 2026
Our trainer made everything clear, engaging and easy to follow. He really knows his stuff and made the training enjoyable and useful. The admin was organised smoothly and communication was spot on.
Hachette Partworks
June 2026

Our tutor was great! He explained everything very clearly and the pace of the course was amazing! I feel that I learnt a lot and understood how great of a tool Figma can be to move our business forward.
The White Company
June 2026
Lee was incredibly helpful and we learnt a lot during our two day course. Lee answered all questions and was incredibly patient. Thank you!!
River Island
August 2026
Just dropping a line to thank you, our trainer and the team for the great Figma course delivered over the past couple of days.
Marcos A
July 2026
I've attended a few training days at Transmedia and I've found them really useful, with a good mix of theory and practice. They've also been super helpful with any queries before or after my training.
VISA Europe
July 2026
We had a great first session with our trainer Lee yesterday, looking forward to our follow up day.
GSK
August 2026
Brilliant centre with friendly and knowledgeable trainers. Would definitely recommend!
BBC
June 2026
Great service! The explanations were very helpful going forward. The trainer also helped us with understanding very advanced Figma files that we would need to be working with in the future.
Bauer Media
May 2026
It was an excellent experience to learn how to use Figma and our trainer was so kind and knowledgeable!
Junggun L
June 2026
Great delivery, was kept engaged the whole day.
Ogilvy
July 2026
A brilliant instructor! Very knowledgeable and patient. He covered and explained all the fundamentals, very clearly which made the whole learning experience very enjoyable.
The White Company
June 2026
Our trainer was amazing as always, I've had great feedback from the delegates.
Hachette UK
July 2026
Had an amazing Figma training with Transmedia. Really worth coming in and learning in person as the trainer was very hands-on and helps you with all your personalised questions!
Future Advocacy Ltd
August 2026
Just wanted to say thank you for the course yesterday. The trainer was great and the team got exactly what they needed.
Essex County Council
May 2026
Enjoyed a Zoom-led introduction to Premier Pro, instructed by Lee. The pace worked well for me - we could ask questions at any point. I got a lot out of it - I just need to keep practising! Thanks.
Mod
July 2026
Our trainer made everything clear, engaging and easy to follow. He really knows his stuff and made the training enjoyable and useful. The admin was organised smoothly and communication was spot on.
Hachette Partworks
June 2026

This Power BI Intermediate 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 Intermediate 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 Intermediate

Recapping Core Concepts

Reviewing the end-to-end data flow
Reinforcing essential DAX and relationship knowledge

Advanced Data Transformation Techniques

Using parameters, conditional columns and groupings
Applying fuzzy matching for data quality improvement
Exploring M language through the Advanced Editor

Strengthening the Data Model

Building efficient star and snowflake schemas
Managing relationship ambiguity and direction
Creating and using calculated tables
Optimising model size and refresh performance

Expanding DAX Skills

Applying iterator functions: SUMX, AVERAGEX
Managing filter and row context with CALCULATE
Combining functions with variables for efficiency
Debugging calculations and logical validation

Applying Time Intelligence

Creating and managing Date tables
Using functions such as PREVIOUSYEAR, DATEADD, TOTALYTD
Developing rolling averages and period comparisons

Designing Interactive Visuals

Using drillthroughs, bookmarks and tooltips
Creating dashboard navigation with buttons
Integrating KPI cards, conditional formatting and themes

Collaboration and Publishing

Building workspaces and shared environments
Using Power BI Apps for team collaboration
Scheduling data refreshes and workspace permissions

Workshop Challenge

Building a multi-source interactive dashboard using dynamic visuals

FAQs about the Power BI Intermediate course

Is this Power BI Intermediate 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 Intermediate course?

Our Power BI Intermediate 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 Intermediate course?

For private classes in Power BI Intermediate, 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 Intermediate 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 Intermediate course?

We offer ongoing support to our Power BI Intermediate 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 Intermediate course?

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

Power BI Intermediate — 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.