Budget vs Actual: Zero Complexity Model in Power BI
When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this needs complex DAX calculation! My answer is: That can be also solved with a zero complexity model. In this article, I’m going to explain through an example, how two tables with different granularity (like budget and actual) can be modeled easily using Power BI. To learn more about Power BI, read the Power BI book from Rookie to Rock Star.
Read the rest of the article from here: https://radacad.com/budget-vs-actual-zero-complexity-model-in-power-bi
Author, keynote speaker, teacher, data modeling innovator. R&D engineer
5 年... And here you find a picture of the Tableau data model that sits behind... Just a star schema. This is the Unified Star Schema #UnifiedStarSchema
Author, keynote speaker, teacher, data modeling innovator. R&D engineer
5 年Thanks for the post! As promised, here is my version in Tableau. I have built an unified Star Schema with all the tables.?
Senior Solution Architect - MS Analytics and Power BI, Community Speaker and Trainer
5 年I have dealt with 2 facts data model with different granularity and deriving one single measure calculated from both facts.
BI Consultant | Senior Data Analyst | Corporate trainer | Azure Data Certified | SQL | R & Python
5 年Good one!!!
Sr Data Engineer&Analyst
5 年what if these two facts are related? for example you have a budget reference in every row of actual ?