Search icon

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.
  • Excellent training. Our trainer Lee was endlessly patient with questions and did not press on until we had understood. We covered everything needed to produce effective video posts in one day.

    Office for Students
    October 2026
  • Certificates sentThank you for the session on Captivate - very, very helpful! I would like to recommend this Training Centre and my tutor on providing great online courses, specifically Captivate!

    East and North Hertfordshire NHS Trust
    October 2026
  • A hugely valuable session last Friday. Our combined knowledge threw up some real discussions and challenges. A very stimulating day. Learnt new tricks, a huge time saver for myself and design team.

    Talking Tables
    September 2026
  • Lee was excellent - fantastic course!

    Make Architects
    July 2026
  • Excellent knowledge! Have to say a massive thanks to the team for my Photoshop course. They really are a great provider. 5 stars from me.

    KPMG
    October 2026
  • We did the intermediate Photoshop course and it was amazing! I learned so much and the teacher even took into account what we needed Photoshop for, to put the lessons into context. Highly recommended.

    Future PLC
    August 2026
  • Thank you! I learned a lot in just one day of Figma training; very practical, engaging and insightful!

    Cancer Research
    August 2026
  • We found it really informative and as it was catered to projects that we work on, it was extremely helpful. We ran out of time at the end, but we would most certainly like to do another one.

    Thames Valley Police
    October 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
    September 2026
  • I have been very impressed with the trainer and I thought the course was very good.

    Leaders Roman Group
    September 2026
  • An excellent course.

    Vodafone Ltd
    July 2026
  • Tutor was incredibly helpful and knowledgeable and the course helped me a lot.

    July 2026
  • Course was delivered very well, I absolutely learned some useful tricks and tools in order to improve my presentations

    September 2026
  • Really great Figma course. Our trainer was very knowledgeable and helpful. Thank you!

    CPL One Limited
    September 2026
  • We have worked with Transmedia for many years now and I can not recommend them highly enough! The work Anthony has done with us over the years has changed us as a business. He is a pleasure to work with!

    CIPA
    September 2026
  • Excellent training. Our trainer Lee was endlessly patient with questions and did not press on until we had understood. We covered everything needed to produce effective video posts in one day.

    Office for Students
    October 2026
  • Certificates sentThank you for the session on Captivate - very, very helpful! I would like to recommend this Training Centre and my tutor on providing great online courses, specifically Captivate!

    East and North Hertfordshire NHS Trust
    October 2026
  • A hugely valuable session last Friday. Our combined knowledge threw up some real discussions and challenges. A very stimulating day. Learnt new tricks, a huge time saver for myself and design team.

    Talking Tables
    September 2026
  • Lee was excellent - fantastic course!

    Make Architects
    July 2026
  • Excellent knowledge! Have to say a massive thanks to the team for my Photoshop course. They really are a great provider. 5 stars from me.

    KPMG
    October 2026
  • We did the intermediate Photoshop course and it was amazing! I learned so much and the teacher even took into account what we needed Photoshop for, to put the lessons into context. Highly recommended.

    Future PLC
    August 2026
  • Thank you! I learned a lot in just one day of Figma training; very practical, engaging and insightful!

    Cancer Research
    August 2026
  • We found it really informative and as it was catered to projects that we work on, it was extremely helpful. We ran out of time at the end, but we would most certainly like to do another one.

    Thames Valley Police
    October 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
    September 2026
  • I have been very impressed with the trainer and I thought the course was very good.

    Leaders Roman Group
    September 2026
  • An excellent course.

    Vodafone Ltd
    July 2026
  • Tutor was incredibly helpful and knowledgeable and the course helped me a lot.

    July 2026
  • Course was delivered very well, I absolutely learned some useful tricks and tools in order to improve my presentations

    September 2026
  • Really great Figma course. Our trainer was very knowledgeable and helpful. Thank you!

    CPL One Limited
    September 2026
  • We have worked with Transmedia for many years now and I can not recommend them highly enough! The work Anthony has done with us over the years has changed us as a business. He is a pleasure to work with!

    CIPA
    September 2026

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

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

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

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

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