Intermediate Power BI Training | DATAMetrics Business Intelligence

Strengthen your Power BI knowledge

This intermediate Power BI workshop is ideal for users who already understand the basics and want to take their skills to the next level. The course builds on foundational knowledge and focuses on improving data models, creating more dynamic visualisations, and applying best-practice design techniques. Participants will learn how to use DAX more effectively, build interactive reports with drill-throughs and bookmarks, and apply custom visuals and themes to enhance user experience.

Audience

This one-day, in-person course is designed for Power BI users who have basic experience and want to expand their skills. Participants should already be familiar with importing data, using simple visuals, and publishing reports.

Course format

One-day, in-person workshop led by an experienced Business Intelligence consultant and Power BI expert. Includes guided instruction, practical exercises, real-world scenarios, and opportunities for Q&A throughout, including a final wrap-up session.

Learning outcomes

By the end of this course, you will be able to:

Choose the right import mode and create effective data relationships.

Reshape messy source data with Power Query, including unpivoting wide tables

Use key DAX functions and quick measures to analyse data

Know when to use calculated columns and measures for accurate, efficient reporting

Use drill-throughs, bookmarks, and navigation techniques to enhance reports

Apply themes and custom visuals to create polished, professional dashboards

Set up alerts in Power BI Service to monitor key metrics and receive notifications

Key learning areas

Data Import and Modelling

Compare Import and DirectQuery modes
Build relationships using star schema principles
Manage relationship types and directions
Optimise your model in the Model view

Data Preparation with Power Query

Remove unnecessary rows and columns
Split and merge columns
Fill down and replace values
Unpivot wide tables
Apply best practices for clean, tidy datasets

Basic DAX & Quick Measures

Use common DAX functions like SUMX and CALCULATE
Create Quick Measures for fast insights
Apply visual-level logic with SELECTEDVALUE, ISBLANK

Calculated Columns vs. Measures

Understand the difference between calculated columns and measures
Know when to use each in your data model
Recognise how each impacts report performance

Drill-through and Navigation Features

Create interactive drill-through pages
Use bookmarks for navigation and storytelling
Navigate Report, Data, and Model views effectively

Custom Visuals & Report Themes

Apply themes and custom visuals
Creating and arranging dashboards
Organising KPIs on a dashboard

Dashboards and Alerts

Publishing reports to Power BI Service (refresher)
Building KPI Dashboards (refresher)
Understand where and when alerts can be created
Configure alerts to receive notifications via email

Final review and open Q&A session

Bring Your Own Device: Participants will need a laptop with Power BI Desktop installed (free from Microsoft). Instructions will be sent before the course.
‍
What You’ll Leave With: Practical knowledge you can apply immediately to create more insightful and interactive Power BI reports that support business decision-making.

Ready to go further?

See if our Advanced workshop is the right fit.

Advanced workshop

Learn from BI consultants who use Power BI to solve real business problems, daily.

Build practical skills through hands-on exercises you can apply immediately.

Small workshop sizes (4–8 people) ensure personalised support and discussion.

See how Power BI fits into your existing tools and drives more intelligent decisions.

Gain practical skills that you can apply right away in your everyday tasks.

FAQs

Do you have Questions? Below are answers to some common questions about our training workshops.

Custom Training

If our pre-built workshops don't quite meet your needs, we can design a tailored training session to address your specific requirements. Whatever business challenge you're trying to solve, a custom session will ensure the training is relevant, practical, and aligned with your team's priorities.
Contact us today to discuss your requirements.

Intermediate Power BI