Forum Discussion

Konrad909090's avatar
Konrad909090
Helper II
1 year ago
Solved

How to build proper model

Hello experts, I wanted to practise building the model correctly a little. I have a sample data set of music reviews. I have tables such as: reviews, artist, content, genres, labels and in additi...
Need Help
  • Konrad909090's avatar
    Konrad909090
    1 year ago

    PijushRoy what you say about this model?
    I've created a "bridge table" between dimensionals tables and fact table review. 

     

  • PijushRoy's avatar
    PijushRoy
    1 year ago

    Hi Konrad909090 
    Bridge table or lookup table is also fine but when you are using a both way relationship and want to create visual with multiple table, there are chance to filter out other table data.
    Please validate, if works fine then stay with this approach

Konrad909090's avatar
Konrad909090
Helper II
1 year ago

PijushRoy what you say about this model?
I've created a "bridge table" between dimensionals tables and fact table review. 

 

PijushRoy's avatar
PijushRoy
Community Champion
1 year ago

Hi Konrad909090 
Bridge table or lookup table is also fine but when you are using a both way relationship and want to create visual with multiple table, there are chance to filter out other table data.
Please validate, if works fine then stay with this approach