Course
Skills Expanded
Organizational BI With SSAS 2012 Tabular - Introduction
This course introduces the creation and querying of basic SQL Server Analysis Services 2012 Tabular models.
What you'll learn
This course introduces SQL Server Analysis Services 2012 Tabular to deliver corporate-level business intelligence solutions. The course helps those new to SSAS Tabular assemble and relate data from diverse sources, and to then build and query basic Tabular models.
Table of contents
Introduction and Foreword
6mins
Getting Started With SSAS 2012 Tabular
38mins
- Introduction and Overview of Tabular 5m
- 10,000 Ft. Overview: Intro and Create New Project 3m
- 10,000 Ft. Overview: Add Data 4m
- 10,000 Ft. Overview: Basic Preparation 3m
- 10,000 Ft. Overview: Create Relationships 3m
- 10,000 Ft. Overview: Create Calculated Columns 2m
- 10,000 Ft. Overview: Create Measures 3m
- 10,000 Ft. Overview: Perform Analysis in the Tabular Model 3m
- 10,000 Ft. Overview: Deploy the Tabular Model 1m
- SSAS Options: Architectural Comparison 3m
- SSAS Options: More Comparison and Making the Choice 5m
- More General Considerations 4m
- Module Summary 1m
Building the SSAS Tabular 2012 Foundation
41mins
- Introduction and Objectives 1m
- Environment Components: Development Workstation 2m
- Development Workstation Details 2m
- Environment Components: Development / Workspace Database Servers 3m
- Create a New Tabular Project 4m
- Configure Default Properties 3m
- Configure Project Properties 6m
- Configure Model Properties 4m
- Configure Global Default Settings 2m
- Import a Deployed SSAS 2012 Tabular Model 5m
- Create a New Tabular Model From an Imported Deployed Model 2m
- Examine the Tabular Model Object Inventory 3m
- Looking Ahead and Module Summary 4m
Creating and Managing the SSAS 2012 Tabular Model
39mins
- Introduction and Objectives 2m
- PowerPivot vs. Tabular: Outgrowing PowerPivot, Part 1 3m
- PowerPivot vs. Tabular: Outgrowing PowerPivot, Part 2 3m
- Migrate, Deploy, and Review the PowerPivot Model 3m
- Convert a PowerPivot Model to an SSAS Tabular Model 3m
- Create and Deploy the Basic Tabular Model 3m
- Relationships and Overview of Measures 4m
- Work With Measures 2m
- Work With Hierarchies 5m
- Work With Calculated Columns 3m
- Deploy the Tabular Model 3m
- Manage a Tabular Model in SQL Server Management Studio 4m
- Looking Ahead and Module Summary 2m
Introducing Data Analysis eXpressions (DAX)
49mins
- Introduction and Objectives 1m
- Overview of Data Analysis eXpressions (DAX) 3m
- Introduction to DAX Functions 4m
- Create a New Tabular Environment 4m
- Verify the New Tabular Environment and Review Calculated Columns 2m
- DAX Calculations: Simple Examples 4m
- DAX Calculations: More Simple Examples 3m
- DAX RELATED() Function 6m
- DAX Text-Type Functions 3m
- DAX Date/Time-Type Functions 3m
- DAX Logical-Type Functions 2m
- DAX Aggregate and Table Functions 3m
- Time Intelligence Functions Overview 3m
- Review Measures and Evaluation Context 3m
- Manipulating Context via the CALCULATE() Function 4m
- Module Summary and Looking Ahead 1m
Querying SSAS 2012 Tabular
45mins
- Introduction and Objectives 2m
- Language Options and Editors Overview 4m
- Language Options: DAX and MDX 5m
- Query With Excel: Basics and Browsing 4m
- Query With Excel: PivotTables 4m
- Work With PivotTables: Create With Tabular Data 3m
- Work With PivotTables: Slice, Sort, and Filter 3m
- Work With PivotTables: Named Sets Overview 3m
- Work With PivotTables: Named Sets in Action 3m
- Work With PivotTables: Excel Cube Formulas 4m
- Query With Excel: Power View Intro and Connections 3m
- Query With Excel: Create the Basic Power View Report 2m
- Query With Excel: Work With Power View Reports 3m
- Module Summary 1m