OPTIMIZATION TIPS AND TRICKS

[dilshad_ahmed]

What are the tips and tricks to create a more optimized model, report and dashboard?

Also Please share the known best practices

[Idrissshatila]

Hello @dilshad_ahmed ,

The ones I would Share with you are the following:

* always push your transformations backwards as much as you can, like if it could happen in the datasource then do it there, else in the power Query.
check this link https://youtu.be/OAlys79j81Q

* Perform a star schema model whenever possible.
chek this link https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

* If it can be a measure then don't do it as a calculated column, so it won't take space in the file.

* Minimise the objects you have in a reports, you could work the design on a seperate tool like figma or power point and the import the design as a background image to avoid high loading time.

check this link https://youtu.be/7ZPcXCfW-GM

and this is for best practices for report design and dax https://www.youtube.com/live/lEDdMKLDhOs?feature=share

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

Follow me on Linkedin