SSAS 2014, Part 05 of 10: 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 the Tabular model, Data Connections, Import Tables, Views, Measures and Dimension Enhancements.

Lesson 1:

• Tabular History
• Getting Started
• Demo: Tabular Model.

Lesson 2:

• Adding Data
• Using Dimensions and Facts
• Demo: Connecting to Data.

Lesson 3:

• Tables/Queries
• Demo: Importing Data
• Demo: Filters.

Lesson 4:

• Two Views
• Grid (Table) View
• Demo: Grid View
• Relationship View
• Demo: Relationship View.

Lesson 5:

• Mark as Date
• Sorting
• Demo: Enhance Date
• Related Hierarchy
• Dimension Enhancements
• Demo: Dimension Enhancements
• Demo: Enhancements in Excel.

Lesson 6:

• Measures
• Examples
• Demo: Gross Profit Margin
• Using Multiple Fact Tables
• Adding Multiple Facts
• Demo: Multiple Fact Tables
• Demo: Fact Table Relationships.