How to build a efficient relationship between tables

[sivarajan21]

Hi,

I have a below table with columns source_table and source_id. This table is connected to other tables using source_id.

Now, I am trying to find the best way to create relationship between these tables. We tried to unpivot the 'source_table' & 'source_id' column like below:

As a result of this, there are multiple relationship coming to communication table and our relationship looks like below:

Is there any possibility that we can split the table into small tables to create relationship?

Please can you suggest some efficient ways to create relationships between tables?

Please let me know if you need further info!

Thanks in advance!

@Greg_Deckler @Ahmedx @Ashish_Mathur @grantsamborn @amitchandak 

[Idrissshatila · Accepted solution]

Hello @sivarajan21 ,

I suggest you take a look at the star schema Data Model.

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[sivarajan21]

Hi Guys,

Thanks for helping out!

[Dhairya · Accepted solution]

Hey @sivarajan21 
To efficiently manage tables and their relationship, you can create a star schema with one center table having numerical values and related with different dimension tables having categorical values.

you can refer below link to learn more about star schema
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If you found this useful then please mark my solution as accepted so that others can find it quickly while facing similar issue. Thank You!

[Idrissshatila · Accepted solution]

Hello @sivarajan21 ,

I suggest you take a look at the star schema Data Model.

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡