Forum Discussion

Clay82's avatar
Clay82
Frequent Visitor
5 years ago
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 to get some help from the community.

 

I have this table with three columns that I have renamed to "Inventory_Lookup" (see pic) that I'm not able to connect correctly. I have listed my questions below. 

- Is this  a lookup/dimension table? Or is it actually a fact/data table?

- How do I connect it properly since there are no unique values in the table? Have I done it the right way as shown in the picture (both directions from sales table to product_lookup and one to many from product_lookup to Inventory_lookup)?

 

Thanks in advance.

 

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Clay82 ,

     

    1. 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.
    2. Product_Lookup to Inventory_Lookup relationship looks right.
    3. 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

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Clay82 ,

     

    1. 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.
    2. Product_Lookup to Inventory_Lookup relationship looks right.
    3. 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