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.

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 5mins
• Intermediate Data Analysis eXpressions (DAX) 52mins
• Intermediate Modeling in SSAS Tabular 53mins
• Time and Dates in SSAS Tabular (Part I) 55mins
• Time and Dates in SSAS Tabular (Part II) 55mins
• Assorted Intermediate SSAS Tabular Topics 59mins