Managing Tabular Data Models

SQL Server 2014
  • 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
    FREE ACCESS
  • Locked
    4. 
    Creating DAX Expressions for Tabular Objects
    6m 7s
    FREE ACCESS
  • Locked
    5. 
    Implementing Time Intelligence
    9m 2s
    FREE ACCESS
  • Locked
    6. 
    Implementing Context Modification
    6m 59s
    FREE ACCESS
  • Locked
    7. 
    Creating Partitions in a Tabular Model
    5m 45s
    FREE ACCESS
  • Locked
    8. 
    Managing Partitions in a Tabular Model
    5m 37s
    FREE ACCESS
  • Locked
    9. 
    Processing a Partition in a Tabular Model
    6m 30s
    FREE ACCESS
  • Locked
    10. 
    Configuring In-Memory or DirectQuery Access
    5m 52s
    FREE ACCESS

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

COURSE Working with Data & Fields in Tableau Desktop
Likes 22 Likes 22  
COURSE Tableau for Data Visualization: Introduction
Likes 16 Likes 16  
COURSE MDX Queries & Database Deployment
Likes 5 Likes 5  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Warehousing with Azure: Analytics & Reporting
Likes 15 Likes 15  
COURSE Data Warehouse Essential: Concepts
Likes 85 Likes 85  
COURSE BI Reporting & Analysis
Likes 52 Likes 52