SSAS 2014, Part 03 of 10: Relationships

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.