Data Modeling
Common modelling use cases and solutions
- 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
- How to perform 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
- Trend Analysis
- Calculate MTD, QTD and YTD Values
- Data Relationships: Introduction to a Many-to-Many
- Creating Cohort Analysis With Sisense
- Link multiple columns in a table referencing the same table