Data Modeling
Common modelling use cases and solutions
- Generating a Numeric Key
- Analyzing Measures Between Two Dates
- Cumulative Count Distinct
- Conditional Lookups
- Modelling Different Granularity Levels
- Modelling Aggregate Facts
- Not all dimensions relate to all facts
- Analyze Period over Period - MoM / WoW / DoD
- Multiple Dates in a fact table
- Multi Fact Data Security
- Advanced Data Security - Organizational Hierarchy
- Switch Between Metrics
- Many to Many by Design (Relationship Table)
- Avoiding complex calculations in the dashboard - Derived Fact
- Slowly Changing Dimension
- How to connect tables with more than one field in common - Surrogate Key
- Get measures from 2 facts without duplications - Fact Attribution
- Fiscal Year Adjustments
- Design a schema with more than one fact - Multi Fact Schema
- Design a schema with one fact - Star Schema
- Table Types
- Simple Left Join in the Dashboard
- Data Relationships: One-to-Many Relationship
- Data Relationships: Many-to-Many Relationship Resolutions
- The Invisible Many to Many
- Forecasting using Macro Trend and Seasonality
- Data Relationships: Check Type of Relationship
- Market Basket Analysis
- The Funnel Analysis
- Key Table: Store data relationships between primary key values