Forum Discussion

Konrad909090's avatar
Konrad909090
Icon for Helper II rankHelper 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