Data Modeling
Common modelling use cases and solutions
- Flattening out Multi Level Parent-Child Hierarchy for Hierarchical filtering
- Display values based on selected date for multiple time frames
- Time Calculations in Sequence of Events
- Unit conversion between Metric and Imperial (US)
- Enabling Timezone by User
- Historical Currency Conversion Using GoogleFinance
- Build A Flattened Hierarchy From 2 Levels
- Calculating Time differences Flexibly
- Time Dimension
- 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