Logo
  • Documentation
  • Developers
  • Support
    • Knowledge Base
    • Support Overview
    • Submit a Ticket
  • Forums
    • Getting Started
    • Community ROE
    • Forum Topics
    • Start a Discussion
  • Sign in
  1. Sisense Community
  2. Knowledge Base
  3. Data Modeling

Data Modeling

Follow New articles New articles and comments

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
  • 1
  • 2
  • ›
  • »

Follow Us

  • Sisense on Linkedin
  • Sisense on Twitter
  • Sisense on Facebook

Get our monthly newsletter!

  • Copyright © 2020 Sisense Inc. All rights reserved.
  • About Sisense
  • Whitepapers
  • Blog
  • Documentation
  • Developers
  • Contact Us
  • Free Trial
  • Terms of Use