Organizational BI with SSAS 2012 Tabular - Intermediate
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction and Foreword- 5m 7s
—Introduction and Intended Audience 1m 10s
—Course Objectives and Assumptions 3m 9s
—Getting Help with Preparation 0m 48sIntermediate Data Analysis eXpressions (DAX)- 52m 1s
—Introduction and Overview 1m 27s
—Quick Review of DAX Basics 2m 8s
—General Considerations and Tools 3m 46s
—Working with DAX Studio 2m 28s
—It All Begins With EVALUATE 2m 29s
—EVALUATE Options 3m 34s
—Controlling Query Row Output: The Basics 3m 49s
—Controlling Query Row Output: More About Filters 4m 17s
—Controlling Column Output and Grouping Basics 3m 56s
—Controlling Output Grouping: More with SUMMARIZE 3m 44s
—Special Output Needs: Cartesian Products 3m 38s
—More Sophisticated Cartesian Products 5m 23s
—Special Output Needs: Scalar Values 5m 9s
—Working with Inline Measures 4m 57s
—Summary 1m 10sIntermediate Modeling in SSAS Tabular- 53m 10sTime and Dates in SSAS Tabular (Part I)- 55m 25sTime and Dates in SSAS Tabular (Part II)- 55m 55sAssorted Intermediate SSAS Tabular Topics- 59m 53s