Power BI Master Class-Data Models and DAX Formulas

This course contains the use of artificial intelligence.

Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.

Your report looks right and the numbers are wrong. The total does not match the sum of the rows, the percentage changes when somebody clicks a slicer, and last year's comparison quietly stops working in January.

That is a data model and DAX problem, and this course is about fixing it properly rather than working around it. You will build the model, write the measures, and understand well enough why a number comes out the way it does that you can debug the next one yourself.

COURSE CONTENT AND OUTCOME

• Write DAX measures with CALCULATE, ALL and ALLEXCEPT so your numbers respect the filters you intend and ignore the ones you do not

• Build time intelligence measures for year-to-date, prior period and year-on-year comparisons

• Use the iterator functions - SUMX, MAXX and RANKX - for calculations that work row by row

• Create relationships between tables, and use USERELATIONSHIP when one relationship is not enough

• Build virtual tables and cross-table calculations for questions a single table cannot answer

• Segment customers and build scenario models using SWITCH and What If Parameters

• Design a date master table and a star schema so the model stays fast as the data grows

• Work through case studies on DirectQuery, Quick Measures, Performance Analyzer and the DAX Query View

A NOTE ON COPILOT AND AI

You may be wondering where Copilot fits in. Copilot in Power BI runs on a Microsoft Fabric capacity, which is something your organisation buys and switches on - not something you can enable yourself. Most people learning Power BI do not have it, and will not have it for a while.

There is a second reason it matters less here than you might think. DAX is where reports go wrong quietly, and a wrong measure does not look wrong - it looks like a number. Whether you write it yourself or something writes it for you, you still have to be able to read it and say whether it is right. That is what this course teaches.

ABOUT THE TRAINER

I have been training business people to work with data since 2008, and publishing on Udemy since 2013. I now have 16 live courses with more than 450,000 students and more than 139,000 reviews, at an average rating of 4.6.

I teach Microsoft Power BI, Microsoft Excel, Copilot in Excel, Looker Studio and Amazon QuickSight. What makes my courses different is that I teach the analysis, not just the tool - every lesson starts with a business question someone actually asks, and shows you how to answer it with software you already have.

WHAT STUDENTS ARE SAYING

• This course is great, it revealed to me functions that I never thought existed. I cannot wait to apply these in real time scenarios. Thanks Ian you are doing a great job.

• Coming from Spotfire (after company decided PowerbI is cheaper) with its slightly different approach, this course helped to gain some traction with PowerBI

• I felt quite comfortable using Power BI, but this course opened my eyes to many more possibilities the tool offers. I really appreciate the straightforward, no-nonsense and easy to follow teaching style from the instructor. Highly recommended to all who have been using Power BI and are ready for the next step.

The training data files, the practical activities and the case studies are all included. Enrol now and by the end you will be writing measures you can explain to somebody who asks where the number came from.