Office Tools Microsoft Power BI Courses

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

I came away full of knowledge and confidence. A thoroughly enjoyable course ran by a very experienced tutor who made me feel at ease from the get go. I will be booking more courses in the near future.
Leah P
September 2025
Fantastic course with so much detail and an excellent teacher. I found everything really easy to follow and lots of room to try everything out when needed.
Wren Kitchens
August 2025
Brilliant centre with friendly and knowledgeable trainers. Would definitely recommend!
BBC
August 2025
I'd recommend Transmedia to jump start your Prem Pro journey!!!
Brett L
August 2025
It was interesting to see how I can take Excel beyond basic functions and find lots of shortcuts that will make normal use easier and quicker.
Structural Soils Ltd
August 2025
I genuinely enjoyed the content. It was incredibly useful. I would definitely be interested in doing another one. The content was very well explained and I was offered help when I needed it.
Structural Soils Ltd
September 2025
Five Star training… Engaging, well-paced, easy to follow, open to questions and all rooted in solid experience and a very coherent knowledge base - would totally recommend!
Motion Marketing
August 2025
Thanks again for the session last week. I've received more glowing feedback about how inspired and engaged the team felt.
Molson Coors
August 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
August 2025
Our trainer was amazing. The course was very well structured, and a nice amount of time was given to each task. Looking forward to the next one!
House of Commons
August 2025
The After Effects Introduction course at Transmedia is a brilliant, well-thought-out course that is informative and fun at the same time. I will be visiting Transmedia again and recommend them to all!
Minnow Films
September 2025
Great course. Our trainer worked hard to tailor the course to our specific needs and work through the content at our pace.
Saffery Champness
August 2025
It was great, I learned a lot of useful things I didn't know about previously.
Square Enix Europe Ltd
August 2025
Thank you! I learned a lot in just one day of Figma training; very practical, engaging and insightful!
Cancer Research
August 2025
The course was great and featured lots of new skills that I can use. The trainer was great at delivering each section and really attentive in making sure I was keeping up and getting the answers I needed.
Lintbells
September 2025

I came away full of knowledge and confidence. A thoroughly enjoyable course ran by a very experienced tutor who made me feel at ease from the get go. I will be booking more courses in the near future.
Leah P
September 2025
Fantastic course with so much detail and an excellent teacher. I found everything really easy to follow and lots of room to try everything out when needed.
Wren Kitchens
August 2025
Brilliant centre with friendly and knowledgeable trainers. Would definitely recommend!
BBC
August 2025
I'd recommend Transmedia to jump start your Prem Pro journey!!!
Brett L
August 2025
It was interesting to see how I can take Excel beyond basic functions and find lots of shortcuts that will make normal use easier and quicker.
Structural Soils Ltd
August 2025
I genuinely enjoyed the content. It was incredibly useful. I would definitely be interested in doing another one. The content was very well explained and I was offered help when I needed it.
Structural Soils Ltd
September 2025
Five Star training… Engaging, well-paced, easy to follow, open to questions and all rooted in solid experience and a very coherent knowledge base - would totally recommend!
Motion Marketing
August 2025
Thanks again for the session last week. I've received more glowing feedback about how inspired and engaged the team felt.
Molson Coors
August 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
August 2025
Our trainer was amazing. The course was very well structured, and a nice amount of time was given to each task. Looking forward to the next one!
House of Commons
August 2025
The After Effects Introduction course at Transmedia is a brilliant, well-thought-out course that is informative and fun at the same time. I will be visiting Transmedia again and recommend them to all!
Minnow Films
September 2025
Great course. Our trainer worked hard to tailor the course to our specific needs and work through the content at our pace.
Saffery Champness
August 2025
It was great, I learned a lot of useful things I didn't know about previously.
Square Enix Europe Ltd
August 2025
Thank you! I learned a lot in just one day of Figma training; very practical, engaging and insightful!
Cancer Research
August 2025
The course was great and featured lots of new skills that I can use. The trainer was great at delivering each section and really attentive in making sure I was keeping up and getting the answers I needed.
Lintbells
September 2025

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

Google Reviews

Everything was great, it was interesting and I learned a lot about Excel! I had a great time and learned so much and I am excited to put It all into practice.

TGI Sport Media LLP

September 2025

Course Outline for Power BI Intermediate

Understanding the Power BI Ecosystem

Introducing self-service Business Intelligence concepts
Exploring Power BI Desktop, Service and Mobile platforms
Understanding Power BI data flow from source to dashboard

Connecting and Discovering Data

Importing data from files, databases and the web
Connecting to Excel, SharePoint and cloud sources
Refreshing and managing connections effectively

Transforming Data with Power Query

Cleaning and shaping data using Query Editor
Handling missing values, data types and duplicates
Combining queries: merge, append and transform
Adding and modifying columns

Building Effective Data Models

Understanding relationships and cardinality
Formatting columns, categories and summarisation options
Creating hierarchies for structured navigation

Introducing DAX (Data Analysis Expressions)

Writing simple measures and calculated columns
Applying basic logic (IF, AND, OR)
Performing basic aggregations such as SUM, AVERAGE, COUNT

Visualising Data

Designing tables, cards and standard chart types
Enhancing visuals with formatting, titles and labels
Using slicers to filter interactively

Creating Interactive Dashboards

Designing multi-page dashboards for storytelling
Using images, text boxes and buttons for layout
Applying responsive design principles

Publishing and Sharing Reports

Publishing to Power BI Service
Sharing dashboards within an organisation
Managing refresh and access permissions

Hands-On Project

Creating and presenting a complete sales or marketing dashboard

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.

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