Organizational BI with SSAS 2012 Tabular - Intermediate
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") and Data Analysis eXpressions (DAX)to deliver corporate-level business intelligence solutions.
What you'll learn
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.
Table of contents
- Introduction and Overview 1m
- Quick Review of DAX Basics 2m
- General Considerations and Tools 4m
- Working with DAX Studio 2m
- It All Begins With EVALUATE 2m
- EVALUATE Options 4m
- Controlling Query Row Output: The Basics 4m
- Controlling Query Row Output: More About Filters 4m
- Controlling Column Output and Grouping Basics 4m
- Controlling Output Grouping: More with SUMMARIZE 4m
- Special Output Needs: Cartesian Products 4m
- More Sophisticated Cartesian Products 5m
- Special Output Needs: Scalar Values 5m
- Working with Inline Measures 5m
- Summary 1m
- Introduction 1m
- Overview of Modeling with SSAS Tabular 1m
- Review Basic Tabular Models 7m
- Intermediate Modeling: Calculation Dimension 5m
- More About Calculation Dimension 2m
- Calculation Dimension in Action 3m
- Ratios 3m
- Steps for Creating Ratios 3m
- Ratios in Action 6m
- Ranked Bucketization: Introduction to Ranking 5m
- Basic Ranking in Action 2m
- Introduction to Bucketization 4m
- Ranked Bucketization in Action 4m
- Allocation 5m
- Allocation in Action 2m
- Summary 1m
- Introduction 2m
- Overview of Time and Dates in SSAS Tabular 7m
- The Date Table: Introduction 3m
- The Date Table: Design 4m
- The Date Table: Creation 6m
- Basic DAX Time/Date Functions: Intro and Overview 2m
- Basic DAX Time/Date Functions Explained 5m
- Basic DAX Time/Date Functions in Action 1m
- DAX Time Intelligence Functions: Intro and Overview 2m
- Opening/Closing Balances Explained 3m
- Opening/Closing Balances in Action 5m
- StartOf/EndOf Explained 2m
- StartOf/EndOf in Action 3m
- First/Last Explained 2m
- First/Last in Action 2m
- Next/Previous Explained 2m
- Next/Previous in Action 3m
- Summary 2m
- Introduction 2m
- Time Intelligence Functions - Review 2m
- Total Explained 1m
- Total in Action 3m
- Dates Explained 2m
- Dates in Action 2m
- Relatives Explained 3m
- Relatives in Action 4m
- Common Business Needs - Introduction 2m
- To-Date Aggregations Explained 1m
- To-Date Aggregations in Action 5m
- Prior/'Parallel' Periods - Introduction 2m
- Prior/'Parallel' Periods Explained 7m
- Prior/'Parallel' Periods in Action 3m
- Alternative Calendars - Introduction 3m
- Alternative Calendars Explained 3m
- Alternative Calendars in Action 3m
- Moving/'Rolling' Aggregations Explained 4m
- Moving/'Rolling' Aggregations in Action 3m
- Summary 1m
- Introduction and Overview 3m
- Role-Playing Dimensions: Overview 4m
- Role-Playing Dimensions: Creation and Operation 4m
- Parent-Child Hierarchy: Overview 4m
- Parent-Child Hierarchy: Add Full Name Column 4m
- Parent-Child Hierarchy: Add Hierarchy Path 2m
- Parent-Child Hierarchy: Add Reporting Levels 4m
- Parent-Child Hierarchy: Add Employee Hierarchy 3m
- Parent-Child Hierarchy: Observe Operation in PivotTable 2m
- Many-to-Many Relationships: Overview 3m
- Many-to-Many Relationships: Import and Relate Tables, Add Measure 4m
- Many-to-Many Relationships: Examine Natural Behavior in PivotTable 3m
- Many-to-Many Relationships: Add Measure to Apply Filter Context 4m
- Many-to-Many Relationships: Refining Measure to Apply Filter Context 5m
- Rudimentary Data Mining: Overview 3m
- Rudimentary Data Mining: Market Basket Analysis - Scenario 2m
- Rudimentary Data Mining: Market Basket Analysis - Approach 3m
- Rudimentary Data Mining: Market Basket Analysis - Meeting the Need 3m
- Summary 1m