Modeling in power bi for more tables

[Heena_9980400]

Hi Experts,

I will be working on the modeling part in power bi and the data source will be ADW, and it will be having more tables. I am just worried about how to start as it has many tables.

I need help or suggestions on how to start the modeling part in power bi if we have more tables and how to do it.

I would be grateful for a prompt response.

Thanks & Regards,

Hk

[Idrissshatila · Accepted solution]

Hello @Heena_9980400 ,

what you can do is build your model as a star schema model, Refer to the following link for a detail preview
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[pratyashasamal · Accepted solution]

Hi @Heena_9980400 ,
You can refer to these links :-
https://www.youtube.com/watch?v=FMR4ZAWjvBE

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view

To optimize your model here are Some best practices:

• Tables or columns that are unused should be removed if possible. 
• Avoid distinct counts on fields with high cardinality – that is, millions of distinct values.  
• Take steps to avoid fields with unnecessary precision and high cardinality. For example, you could split highly unique datetime values into separate columns – for example, month, year, date, etc. Or, where possible, use rounding on high-precision fields to decrease cardinality – (for example, 13.29889 -> 13.3).
• Use integers instead of strings, where possible.
• Be wary of DAX functions, which need to test every row in a table – for example, RANKX – in the worst case, these functions can exponentially increase run-time and memory requirements given linear increases in table size.

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Idrissshatila · Accepted solution]

Hello @Heena_9980400 ,

what you can do is build your model as a star schema model, Refer to the following link for a detail preview
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin