Star schema is simple — one fact table directly connected to dimension tables.
Snowflake schema normalizes dimensions into multiple related tables.
Star schema advantages: faster query performance and easier for business users.
In my Power BI report, star schema reduced dashboard load time significantly.
It also required less complex DAX calculations.
Star schema disadvantages: more data redundancy and slightly higher storage.
Snowflake advantages: better data integrity and less duplication.
Useful when dimensions like geography need strict hierarchy control.
Snowflake disadvantages: slower performance due to multiple joins and harder maintenance.