Microsoft and Office Tools
Power BI Intermediate
Master DAX calculations, relationships and advanced visuals to create reports that answer real business questions.
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 4260Invoice 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
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 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! Fantastic and super valuable training! Tony shaped the training fully to our needs, adapted, accelerated and deep diving when needed. I learned so much these past days with tangible examples Tony provided.
Adobe — June 2026
The trainer, Lee, was excellent. He rattled through the key elements of Premiere Pro while keeping the course interactive and engaging. The small sessions made it easy to get 1:1 support or clarifications. The pleasant and well equipped office is well situated in Kensal Rise, so easy to find and get to. I learnt a alot - and now feel up to date with latest Premiere Pro options and AI integrations.
UNICEF — 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
Hi Brook, Sorry for the delay - I was on AL yesterday! The training was great, thank you. Tony was very thorough with everything and I definitely left with some new knowledge and skills. I'll leave a review later today. Thanks for sending the materials across. Have a lovely rest of your day!
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
The Design and Development areas of Clarks shoes has been using Transmedia as a training partner for eight years now, mainly in the 'creative' Adobe applications - Photoshop, Illustrator, InDesign and Premiere. In that time we have built an excellent working relationship with the management and admin teams and several of their core trainers. This has had a major influence in raising the skill levels and quality of our artwork across our design teams- recently extending across the Atlantic, delivering training to our US based designers. Staying with Transmedia has given us continuity and enabled the trainers to really come to understand what Clarks require and thus able to deliver real value for money. The staff are always friendly and a pleasure to deal with - whilst being efficient and professional throughout. Nothing is ever too much trouble. I really can't recommend Transmedia highly enough.
Clarks International — 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
Wonderful trainer Lisa - fun, friendly, informative and comprehensive course! Thank you very much indeed.
Structural Soils Ltd — May 2026
Very much appreciated and enjoyed the introductory course. It was very in-depth and Tony did a fantastic job of covering each individual section of Figma in great detail; no stone was left unturned. Tony is clearly passionate about what he does, which made the course that much more enjoyable and valuable. Looking forward to the advanced course next month - eager to continue learning more from him.
Wren Kitchens — May 2026
I really enjoyed my course. Tony is a really good trainer and tailored the day according to my level and needs.
Delegate — May 2026
Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs.
NVIDIA — May 2026
Very helpful, informative training. Relaxed atmosphere and felt very comfortable asking questions.
The White Company — May 2026
Related courses
Delegates on this course also look at
Power BI Introduction
Connect data sources, build visual reports and create interactive dashboards that surface business insights clearly.
Power BI Advanced
Build enterprise-grade Power BI solutions with advanced DAX, performance tuning and automated workflows. 1 day.
Need a bespoke course or group booking?
We train teams at their offices across London and the UK. Call us or email to discuss.