Data Modeling
Common modelling use cases and solutions
- Advanced Analytics with Sisense
- "Filling" missing records in Fact table from Dim tables
- Presenting Time-frames in a Scatter Chart
- Running Sum on Distinct Values
- Splitting delimited strings into rows
- Service Level Analysis
- Calculate QTD (Quarter to date) flag
- 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
- 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