Budget vs Actual: Zero Complexity Model in Power BI

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

Francesco Puppini

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

  • 该图片无替代文字
Francesco Puppini

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.?

  • 该图片无替代文字
回复
Triparna Ray MCMI ChMC

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.

回复
Prince Sharma

BI Consultant | Senior Data Analyst | Corporate trainer | Azure Data Certified | SQL | R & Python

5 年

Good one!!!

Milad Mohammadi

Sr Data Engineer&Analyst

5 年

what if these two facts are related? for example you have a budget reference in every row of actual ?

回复

要查看或添加评论,请登录

Reza Rad的更多文章

社区洞察

其他会员也浏览了