SSAS 2014, Part 06 of 10: Enhancing the Tabular Model
Interactive

SSAS 2014, Part 06 of 10: Enhancing the Tabular Model

Biz Library
Updated Feb 04, 2020

In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer information on Advanced DAX, Time Intelligent KPI, Advanced Degenerate Dimensions and Performance Security.


Lesson 1:

  • Using DAX for Measures
  • Measures
  • Context
  • Where Can It Be Used
  • Demo: Advanced DAX.

Lesson 2:

  • Calculate & Time Intelligence
  • Calculate
  • Ratios
  • Ratios - Excel
  • Demo: Calculation
  • Demo: Calculation Cont.
  • Time Intelligence
  • Requirement
  • Time Intelligence - To Date
  • Time Intelligence - Previous
  • Demo: Time Intelligence
  • KPI
  • Demo: KPI.

Lesson 3:

  • Degenerate Dimension
  • Demo: Degenerate Dimension
  • Role Playing
  • New Dimension
  • Demo: Role Playing.

Lesson 4:

  • Perspectives
  • Demo: Perspectives
  • Security - Roles
  • Roles
  • Row Level
  • Demo: Roles.