Managing Tabular Data Models

SQL Server 2014    |    Expert
  • 10 Videos | 1h 8m 10s
  • Earns a Badge
Likes 11 Likes 11
Tabular modeling in SQL Server Analysis Services (SSAS) lets users access data using DAX queries. Learn how to create calculations and DAX queries, and how to create and manage partitions in a tabular model.

WHAT YOU WILL LEARN

  • create calculated columns to aggregate data, including using DAX expressions
    create measures using a table's measure grid, including using DAX to create the formula
    create Key Performance Indicators, KPIs
    create DAX expressions to implement tabular objects into a tabular model
    implement time intelligence using different functions to support BI analysis, including specifying a Mark Table
  • implement context modification
    create partitions using Partitions Manager
    manage partitions using Partitions Manager
    process partitions using different modes
    configure the mode for data access for a tabular model

IN THIS COURSE

  • Playable
    1. 
    Creating Calculated Columns
    5m 23s
    UP NEXT
  • Playable
    2. 
    Implementing Measures in a Tabular Model
    7m 40s
  • Locked
    3. 
    Implementing KPIs in a Tabular Model
    5m 44s
  • Locked
    4. 
    Creating DAX Expressions for Tabular Objects
    6m 7s
  • Locked
    5. 
    Implementing Time Intelligence
    9m 2s
  • Locked
    6. 
    Implementing Context Modification
    6m 59s
  • Locked
    7. 
    Creating Partitions in a Tabular Model
    5m 45s
  • Locked
    8. 
    Managing Partitions in a Tabular Model
    5m 37s
  • Locked
    9. 
    Processing a Partition in a Tabular Model
    6m 30s
  • Locked
    10. 
    Configuring In-Memory or DirectQuery Access
    5m 52s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 38 Likes 38  
Likes 39 Likes 39  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 121 Likes 121