Multidimensional queries

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Module 1: Introduction to Multidimensional Queries
Overview of Multidimensional Data Models Star Schema Snowflake Schema Galaxy Schema OLAP and Its Importance Types of OLAP (ROLAP, MOLAP, HOLAP) OLAP Operations (Slice, Dice, Roll-up, Drill-down, Pivot)

  • Overview of Multidimensional Data Models
    00:00
  • Star Schema
    00:00
  • Snowflake Schema
    00:00
  • Galaxy Schema
    00:00
  • OLAP and Its Importance
    00:00
  • Types of OLAP (ROLAP, MOLAP, HOLAP)
    00:00
  • OLAP Operations (Slice, Dice, Roll-up, Drill-down, Pivot)
    00:00

Module 2: Multidimensional Data Structures
Facts and Dimensions Understanding Fact Tables Understanding Dimension Tables Measures and Metrics Hierarchies and Levels Creating and Managing Hierarchies Levels of Granularity

Module 3: Query Languages for Multidimensional Data
SQL Extensions for OLAP Introduction to OLAP Functions in SQL Window Functions MDX (Multidimensional Expressions) Basics of MDX MDX Syntax and Queries MDX Functions and Operators DAX (Data Analysis Expressions) Introduction to DAX DAX Syntax and Queries DAX Functions and Calculations

Student Ratings & Reviews

No Review Yet
No Review Yet
wpChatIcon
    wpChatIcon