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

  • 5m 23s
    In this video, you will learn how to create calculated columns to aggregate data, including using DAX expressions. FREE ACCESS
  • 7m 40s
    In this video, learn how to create measures using a table's measure grid, including using DAX to create the formula. FREE ACCESS
  • Locked
    3.  Implementing KPIs in a Tabular Model
    5m 44s
    Find out how to create Key Performance Indicators (KPIs). FREE ACCESS
  • Locked
    4.  Creating DAX Expressions for Tabular Objects
    6m 7s
    In this video, you will learn how to create DAX expressions to implement tabular objects into a tabular model. FREE ACCESS
  • Locked
    5.  Implementing Time Intelligence
    9m 2s
    In this video, you will learn how to use different time intelligence functions to support BI analysis, including how to specify a Mark Table. FREE ACCESS
  • Locked
    6.  Implementing Context Modification
    6m 59s
    In this video, learn how to modify context. FREE ACCESS
  • Locked
    7.  Creating Partitions in a Tabular Model
    5m 45s
    In this video, you will create partitions using the Partitions Manager. FREE ACCESS
  • Locked
    8.  Managing Partitions in a Tabular Model
    5m 37s
    In this video, find out how to manage partitions using the Partitions Manager. FREE ACCESS
  • Locked
    9.  Processing a Partition in a Tabular Model
    6m 30s
    During this video, you will learn how to process partitions using different modes. FREE ACCESS
  • Locked
    10.  Configuring In-Memory or DirectQuery Access
    5m 52s
    Learn how to configure the data access mode for a tabular model. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Tableau for Data Visualization: Exploring Visualizations & Data Formats
Likes 71 Likes 71  
Course PL-300: Applying the DAX Formula Language in Power BI
Book Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Objects & Retrieving Data
Likes 121 Likes 121  
Course PL-300: An Overview of Data Modeling in Power BI
Course Multiple SQL Tables
Likes 122 Likes 122