Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling
For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to design a good performing Power BI model. I will be writing about some of the concepts in an easy-to-understand way in some articles, here is the first one; What is a shared dimension, and why do you need that in your Power BI model? In this blog post, I will explain how it can prevent many issues, as well as the need for both directional relationship.
Read the rest of the article from here: https://radacad.com/creating-a-shared-dimension-in-power-bi-using-power-query-basics-and-foundations-of-modeling
Technical Architect at Hexaware Technologies
6 年I like your article so much
Analytics, AI & Cloud Data Architect | Solutions Whisperer | Tech Writer
6 年Here is the load script which uses pretty much same syntax as T-SQL. Most of of it Copy, Paste, Alias & UnComment.
Analytics, AI & Cloud Data Architect | Solutions Whisperer | Tech Writer
6 年Resulting model can be used to create a simple dashboard in few minutes. Free form analysis of combination of items at a time becomes very easy since everything is bidirectional & all charts are linked together automatically.
Analytics, AI & Cloud Data Architect | Solutions Whisperer | Tech Writer
6 年Great write up. It is a fairly common problem in BI. #qliksense solves it with fewer steps.? Even though you can use UI driven data modeller, I find it easier to write SQL like write queries against files using #Qlik.?? 1. Simply load each table with a new concat key column (Product + Date) and comment out the same shared dimensions.? 2. Load the same set of of 3 tables using the same concat Key column, but this time comment out everything else but the shared columns. (Qlik will automatically concatenate tables with same columns so 3 tables from this step will be single table that has shared dimension + Key. 3. Qlik also automatically joins tables with matching columns (Key) and all joins are automatically Outer bi-directional. Then you end up with a data model in less than a minute.
Helping businesses to gain valuable insights from data.
6 年This happens to be useful for a use case I'm currently working on, great timing :)