2015
Pluralsight
Bill Pearson
4:41
English

SQL Server MVP and Business Intelligence Architect Bill Pearson leads this hands-on, intermediate-level collection of topics surrounding the use of SQL Server Analysis Services 2012 Tabular ("SSAS Tabular") to deliver corporate-level business intelligence solutions. Beginning with intermediate Data Analysis eXpressions (DAX), we move into intermediate SSAS Tabular data modeling. We then work with time and dates in the model and introduce the powerful Time Intelligence functions, which debuted in DAX and have no formal Excel counterpart. Finally, in a capstone module comprised of assorted solutions to common challenges we find in the business environment, we reason within the context of SSAS Tabular and DAX to develop successful outcomes. This course applies equally to SSAS Tabular 2012 and 2014.

Introduction and Foreword
Introduction and Intended Audience
Course Objectives and Assumptions
Getting Help with Preparation
Intermediate Data Analysis eXpressions (DAX)
Introduction and Overview
Quick Review of DAX Basics
General Considerations and Tools
Working with DAX Studio
It All Begins With EVALUATE
EVALUATE Options
Controlling Query Row Output: The Basics
Controlling Query Row Output: More About Filters
Controlling Column Output and Grouping Basics
Controlling Output Grouping: More with SUMMARIZE
Special Output Needs: Cartesian Products
More Sophisticated Cartesian Products
Special Output Needs: Scalar Values
Working with Inline Measures
Summary
Intermediate Modeling in SSAS Tabular
Introduction
Overview of Modeling with SSAS Tabular
Review Basic Tabular Models
Intermediate Modeling: Calculation Dimension
More About Calculation Dimension
Calculation Dimension in Action
Ratios
Steps for Creating Ratios
Ratios in Action
Ranked Bucketization: Introduction to Ranking
Basic Ranking in Action
Introduction to Bucketization
Ranked Bucketization in Action
Allocation
Allocation in Action
Summary
Time and Dates in SSAS Tabular (Part I)
55:25
Introduction
Overview of Time and Dates in SSAS Tabular
The Date Table: Introduction
The Date Table: Design
The Date Table: Creation
Basic DAX Time/Date Functions: Intro and Overview
Basic DAX Time/Date Functions Explained
Basic DAX Time/Date Functions in Action
DAX Time Intelligence Functions: Intro and Overview
Opening/Closing Balances Explained
Opening/Closing Balances in Action
StartOf/EndOf Explained
StartOf/EndOf in Action
First/Last Explained
First/Last in Action
Next/Previous Explained
Next/Previous in Action
Summary
Time and Dates in SSAS Tabular (Part II)
Introduction
Time Intelligence Functions - Review
Total Explained
Total in Action
Dates Explained
Dates in Action
Relatives Explained
Relatives in Action
Common Business Needs - Introduction
To-Date Aggregations Explained
To-Date Aggregations in Action
Prior/'Parallel' Periods - Introduction
Prior/'Parallel' Periods Explained
Prior/'Parallel' Periods in Action
Alternative Calendars - Introduction
Alternative Calendars Explained
Alternative Calendars in Action
Moving/'Rolling' Aggregations Explained
Moving/'Rolling' Aggregations in Action
Summary
Assorted Intermediate SSAS Tabular Topics
Introduction and Overview
Role-Playing Dimensions: Overview
Role-Playing Dimensions: Creation and Operation
Parent-Child Hierarchy: Overview
Parent-Child Hierarchy: Add Full Name Column
Parent-Child Hierarchy: Add Hierarchy Path
Parent-Child Hierarchy: Add Reporting Levels
Parent-Child Hierarchy: Add Employee Hierarchy
Parent-Child Hierarchy: Observe Operation in PivotTable
Many-to-Many Relationships: Overview
Many-to-Many Relationships: Import and Relate Tables, Add Measure
Many-to-Many Relationships: Examine Natural Behavior in PivotTable
Many-to-Many Relationships: Add Measure to Apply Filter Context
Many-to-Many Relationships: Refining Measure to Apply Filter Context
Rudimentary Data Mining: Overview
Rudimentary Data Mining: Market Basket Analysis - Scenario
Rudimentary Data Mining: Market Basket Analysis - Approach
Rudimentary Data Mining: Market Basket Analysis - Meeting the Need
Summary

Download File Size:627.54 MB

---