Designed to provide insights into the performance of business activities and how the business can optimize its operations to achieve more value.
The querying patterns of analytical models are not predictable, and it’s the reason why high normalization is needed to support flexible querying of the data.
Business intelligence (BI) reports - deliverable of the data analyst.
Table structure
Star schema
Star schema
Many-to-one relationship between the fact and dimensions.
Link to original
Snowflake schema
Snowflake schema
Multilevel dimensions (normalized into more fine-grained dimensions).
Link to original
- Uses less space to store dimensions data.
- Easier to maintain.
- Requires more computational resources because of the need to join more tables for the query.
