Visualize your Super Model Webinar Recap – The Data Model Qualities and Best Practices

| Last Updated August 4, 2021 - by corey m turner under data visualization

Main Highlights

Supermodels and You
- As we progress towards the era of self-service data, our deliveries should become architecturally relevant in their ability to provide solutions: not just to the current requirements of the business, or to our specific question but also to the future questions that the business doesn’t yet know how to ask.
Model Qualities
- Dimensions & Facts
Star, Snowflake, Denormalized: Which Model is for You?
- Super Model, Super Star: What is Star Schema
- Snowflake Schema
- Denormalized Schema
Best Practices for Star Schema & Power Platform
- Vital Information
- Multiple Facts
- Model Relationships
- Surrogate Keys
- Snowflake Dimensions
- Slowly Changing Dimensions
- Role-playing dimensions
- Junk Dimensions
- Factless Fact Tables
- Degenerate Dimensions