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.