Managing Tabular Data Models

SQL Server 2014    |    Expert
  • 10 Videos | 1h 4m 40s
  • Earns a Badge
Likes 23 Likes 23
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

BOOK SAP Analytics Cloud (Second Edition)
BOOK Core Data Services for ABAP Second Edition
COURSE Data Engineering on Microsoft Azure: The Serving Layer

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing BI Infrastructure
Likes 121 Likes 121  
BOOK Pro Power BI Desktop, Second Edition
BOOK Introduction to SQL and PL/SQL