SSAS 2014, Part 03 of 10: Relationships
Interactive

SSAS 2014, Part 03 of 10: Relationships

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 the tools to build data warehousing and decision support system solutions.


Lesson 1:

  • Hierarchies & Attributes
  • Dimension Hierarchies
  • Demo: Attribute Relationships
  • Demo: Key Columns.

Lesson 2:

  • Dimension Properties
  • Demo: Dimension Properties
  • Demo: Visibility
  • Demo: Sorting.

Lesson 3:

  • Measure Calculations
  • Calculations
  • Ratio or Percentage
  • Demo: Calculations
  • Demo: Fixing Calculations
  • Demo: Slicing and Dicing.

Lesson 4:

  • Key Performance Indicators
  • Defining a KPI
  • Demo: KPIs
  • Demo: Displaying KPIs
  • Demo: Components
  • Named Sets
  • Demo: Named Sets.

Lesson 5:

  • Perspectives
  • Demo: Perspectives
  • Demo: Displaying Perspectives
  • Creating Translations
  • Demo: Translations.