Simple play icon Course
Skills Expanded

Organizational BI with SSAS 2012 Tabular - Intermediate

by Bill Pearson

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

About the author

Bill has been working with computers since before becoming a "big eight" CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership. Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base. Bill's background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information ... more

Ready to upskill? Get started