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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors