Forum Discussion
Solved
Data modelling issue
Hi all, New to Power BI and have come across a dataset that I am exploring and have an issue that I don't know how to solve when it comes to modelling and building relationships. I was hoping t...
Hi Clay82 ,
- The Inventory_Lookup is not a dimension table. A dimension table only rows with unique key values. It is a FACT table I would say.
- Product_Lookup to Inventory_Lookup relationship looks right.
- Sales to Product_Lookup relationship depends on what you want to retrieve based on this relationship? Do you want to access details in SALES table using Product_ID from PRODUCT_LOOKUP table? If yes then this relationship will work. But suppose you are planning to retrive "Stock_On_Hand" information in Sales table then you can also consider a direct relationship between SALES and Inventory_Lookup.
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
Hi Clay82 ,
- The Inventory_Lookup is not a dimension table. A dimension table only rows with unique key values. It is a FACT table I would say.
- Product_Lookup to Inventory_Lookup relationship looks right.
- Sales to Product_Lookup relationship depends on what you want to retrieve based on this relationship? Do you want to access details in SALES table using Product_ID from PRODUCT_LOOKUP table? If yes then this relationship will work. But suppose you are planning to retrive "Stock_On_Hand" information in Sales table then you can also consider a direct relationship between SALES and Inventory_Lookup.
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
