Microsoft Power BI – Intermediate to Advanced

Power BI Desktop is a powerful report authoring tool that lets you connect to data, shape it with the Query Editor, and build insightful visualisations. This course expands on the fundamentals by introducing more advanced techniques in modelling, performance, and reporting.

Who Should Attend

Designed for those who have completed our Power BI Fundamentals course or have equivalent experience, this course is ideal for users ready to deepen their Power BI skills with more complex features.

Course Content

Model the data (Data Modelling in Power BI)

Learn how to shape and structure your data model to support meaningful insights. You’ll explore how to define relationships between tables, understand join types and cardinality, and work with more complex scenarios like many-to-many relationships. You’ll also learn how to design star schemas and create a dedicated date table to support time-based analysis.

(Includes: Relationships, cardinality, star schemas, date tables, many-to-many joins)

Enhance your model (Create Calculations using DAX)
Go beyond the basics by introducing calculated columns and quick measures using DAX (Data Analysis Expressions). You’ll see how to build reusable metrics and calculations that bring your data to life, enabling dynamic reporting tailored to your needs.

(Includes: Calculated columns, quick measures, DAX functions, join types)

Tell the story (Advanced Reporting Techniques)

Discover how to choose the right visuals to clearly communicate your insights. Learn how to enhance interactivity with drill-throughs and visual interactions, and make reports more dynamic with conditional formatting and filtering techniques. You’ll also explore how to highlight key performance indicators (KPIs) that matter most to your audience.

(Includes: Visual selection, custom visuals, drill-throughs, slicers, filters, KPIs, conditional formatting)