Other than Flat Schema, Star Schema and Snowflake Schema, the two most common are: Relational schema. In a relational database schema, each object is assigned its table, and these tables all connect to each other. Hierarchical schema. In this schema, one root table connects to multiple child tables where each child has exactly one parent. Now, bear in mind that I don't think you will ever need these two in Power BI.
Youre welcome. In theory snowflake schema can be denormalized into a star schema. But sometimes, if you have loads of data, it's advisable to normalize the star schema into a snoflake schema, depending on what type of granularity you need to achieve.
Thanks a lot this is really helpful , brevity is at the maximum and key points are preserved, this is really great, I appreciate
You're very welcome! I'm very glad you liked it.
I 'am trying to keep everything to the point :)
Thank you!
Are there other types of data model schemas, such as hybrids, for example?
Other than Flat Schema, Star Schema and Snowflake Schema, the two most common are:
Relational schema. In a relational database schema, each object is assigned its table, and these tables all connect to each other.
Hierarchical schema. In this schema, one root table connects to multiple child tables where each child has exactly one parent.
Now, bear in mind that I don't think you will ever need these two in Power BI.
Thanks ! snowflake is like several star scheme together.
Youre welcome.
In theory snowflake schema can be denormalized into a star schema.
But sometimes, if you have loads of data, it's advisable to normalize the star schema into a snoflake schema, depending on what type of granularity you need to achieve.