- Lab
-
Libraries: If you want this lab, consider one of these libraries.
Compare Budget to Actual Performance in Power BI
In this lab, you'll practice modeling two fact tables at different grains and comparing budget to actual in Power BI. When you're finished, you'll have a quarterly business review report with variance measures and a what-if budget parameter.
Lab Info
Table of Contents
-
Challenge
Diagnose the Grain Mismatch
To start, you'll prepare Power BI Desktop for modeling, import the fitness retailer's workbook, and discover why relating its two fact tables directly produces totals nobody can trust.
-
Challenge
Build the Shared Dimension Model
You will turn the Date and Category tables into conformed dimensions that filter both fact tables, including an inactive ship date relationship for later use.
-
Challenge
Write Measures That Span the Grains
You will write the DAX that spans the grain mismatch: a virtual relationship for the budget, ship date reporting on demand, and variance measures that stay blank where budget or sales are missing.
-
Challenge
Add a What-If Budget Parameter
To finish things, you'll add a what-if parameter so leadership can move the budget on a slider and watch the quarterly review respond.
-
Challenge
Final Objective
This is your last chance to experiment in the environment.
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.