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

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.