cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cheredia
Helper I
Helper I

Star or snowflake model

Hello, I will develop a bi with more than 100 reports and many data. In principle I started designing the model in star but I have doubts if snowflake is better? What do you think? On the other hand, you could have several pbix files with star model and others in snowflake not? Or you see a problem. Thanks a lot. A greeting

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@cheredia 
It is really depended on your data itself, you can say Snowflake is the extension of the star schema. Snowflake schema is easy to maintain, lessen the redundancy hence consumes less space but complex to design. Whereas star schema is simple to understand and design, uses less number of joins and simple queries but have some issues such as data redundancy and integrity.


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@cheredia 
It is really depended on your data itself, you can say Snowflake is the extension of the star schema. Snowflake schema is easy to maintain, lessen the redundancy hence consumes less space but complex to design. Whereas star schema is simple to understand and design, uses less number of joins and simple queries but have some issues such as data redundancy and integrity.


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

adetogni
Solution Sage
Solution Sage

Quite often is a matter of data. Sometimes you can't reduce a model to a complete Star. Very often my models are snowflaked





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

Proud to be a Super User!




spg_vizcube
Helper II
Helper II

Hi @cheredia 

 

Once you have your model ready (preferably in Star), you can run several reports on it. Start schema has been most efficient. 

 

Appreciate your Kudos!

 

If I solve your problem, please accept this as a Solution

 

Add me on Linked In , Visit my blog vizcube.biz
Subscribe to my youtube channel 

amitchandak
Super User IV
Super User IV

@cheredia , Power Bi recommend Star Schema. Any DW/BI system will prefer that. But Snowflake will work.

 

refer

https://docs.microsoft.com/en-us/power-bi/guidance/

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors