Power BI

Power BI Intermediate

Master DAX calculations, relationships and advanced visuals to create reports that answer real business questions.

2 days Classroom — London NW10 Live online available

Format

Live instructor-led

Hands-on, question-led sessions

Location

London NW10 or online

9 Station Terrace, NW10 5RT

Level

Intermediate level

Small groups, hands-on, expert-led

Private / bespoke course

Select a date that suits you or your team.

Content fully customised. We'll quote based on group size, location and any bespoke material you'd like covered.

Book as team training Reserve a date for me 020 8269 4260

Invoice payment available · Prices subject to VAT

Who this course is for

This course is for data analysts, business intelligence professionals and report developers who have foundational Power BI experience and want to build more sophisticated reports using advanced DAX calculations, complex data relationships and enhanced visualisations to deliver deeper business insights.

Prerequisites

You should be comfortable with the fundamentals of Power BI, or have attended our Power BI Introduction course.

What you'll 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.

Course outline

What you’ll cover

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

Included

Live expert-led instruction
Practical exercises and workflow examples
Live Q and A and troubleshooting with the trainer
Follow-up support guidance

Frequently asked questions

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.

Reviews

Just finished a bespoke course in Photoshop and AI. Learned an awful lot. My trainer was very knowledgeable and was very happy to answer lots of questions that I had throughout. Highly recommend.

Rachel P — June 2026

Gorgeous premises and lovely, knowledgeable team. I really enjoyed my course - the tutor was friendly and professional and happy to answer any questions and tailor the course.

Quadrotech — June 2026

The trainer was excellent. He kept the course interactive and engaging. The small sessions made it easy to get clarifications. The pleasant office is well situated, so easy to find and get to.

UNICEF — June 2026

Fantastic and super valuable training! Our trainer shaped the training fully to our needs, adapted, accelerated and deep diving when needed. I learned so much these past days with tangible examples.

Adobe — June 2026

The training was great, thank you. My trainer was very thorough with everything and I definitely left with new knowledge and skills. And thanks for sending the materials across.

Live Union — June 2026

Our trainer was great. Very knowledgeable and also flexible with adjusting to our very specific questions and scenarios. I learned loads and look forward to using my new Figma skills.

Adobe — June 2026

One of the better training sessions I've had in years. I highly recommend anyone who wants to learn more about Figma, but also any other Adobe Creative Cloud application, to take courses here.

Adobe — June 2026

I wish all training courses were run this well!

RPS Design — June 2026

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

Hannah Griffiths — June 2026

First class - The trainer was extremely knowledgeable and answered all our questions.

MOD — June 2026

We found the course very useful and wished that we had more time. I was really impressed by our trainer's expertise in software that's being updated very frequently.

Baillie Gifford — May 2026

Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs.

NVIDIA — May 2026

Excellent training session with a knowledgeable instructor.

Gallagher — May 2026

Great course! Instructor went at a good pace and broke down complex functions into simple steps.

Adam W — May 2026

The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful.

VCCP — May 2026

Very helpful, informative training. Relaxed atmosphere and felt very comfortable asking questions.

The White Company — May 2026

Our trainer was very approachable and knowledgeable.

Bond Pearce — May 2026

Learnt so much - great training! Thank you

John R — May 2026

Probably the best course I have been on. Very thorough and entertaining.

Cancer Research UK — May 2026

10/10. Incredible knowledge, AMAZING hints and tips - Tony is a game changer, made everything so simple to understand but taught us so much that will really change the way we present!

Broadwick Studio — May 2026

Related courses