Prakash Srivastava Data & AI Platform Architect

Enterprise Data Modelling

Below are the most commonly used techniques:
  1. Multidimensional Cubes
    1. Star
    2. Snowflake
    3. Cubes
    4. Dimensions
    5. Mining Structures
    6. ROLAP (Like DirectQuery for Tabular)
  2. Tabular
    3. In SSAS : Tabular model is based on xVelocity for Business Intelligence engine
    1. Relational as Source
    2. Multidimensional DB Schemas
    3. Table
    4. In-Memory Mode : Processing & Caching
    5. Direct Query Mode: No Processing & Caching. Model will query the data from Source

    Note: DAX (Defining & Querying) & MDX (Querying): Both can be used in SSAS Tabular models with limited functions or workaround via SQL views when used in DirectQuery (DirectQuery not supported in Standard Edition) mode
    As on July 18 2020: Multidimensional models and PowerPivot for SharePoint are not supported in Azure Analysis Services
    SQL Server Analysis Services Features
    1. Tabular vs Multidimensional
    2. Tabular vs Multidimensional vs PowerPivot
    3. Tabular Features
    4. Tabular Features in SQL Standard