cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Best-practice modeling

Hi,

I have a question with regard to best-practice modeling in PowerBI.
These are the best-practices I’m using;

1 Convert relational models to star model.
2 Convert snowflake models to star model.
3 Transfer facts from dimension tables to the fact table.
4 Use bi-directional relations instead of flattening tables.
5 Flatten tables if the model is too complex(Too many dimensions/facts and relations). Make joins to reduce the number of dimensions, facts and relations.
6 Set the right data types.
7 Data cleansing. 

Is the list correct? Am I missing any?

1 ACCEPTED SOLUTION
LivioLanzo
Solution Sage
Solution Sage

They're all valid points, except for number 4.

I would discourage the use of bi-directional filters unless you've a very solid understanding of DAX 

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

2 REPLIES 2
LivioLanzo
Solution Sage
Solution Sage

They're all valid points, except for number 4.

I would discourage the use of bi-directional filters unless you've a very solid understanding of DAX 

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

Anonymous
Not applicable

Hi LivioLanzo,

Thanks for the reply. Right now, I'm testing bi-directional filters in different situations.
To increase my understandig of how exactly it works.

Thanks again.

Regards,

Giovanni

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!