This course introduces SQL Server Analysis Services 2012 Tabular to deliver corporate-level business intelligence solutions. The course helps those new to SSAS Tabular assemble and relate data from diverse sources, and to then build and query basic Tabular models.
Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, etc.) in regular conversions of these once-dominant applications to the Microsoft BI stack.
Building the SSAS Tabular 2012 Foundation Organizational Business Intelligence with SQL Server Analysis Services 2012 Tabular, the basics. I'm Bill Pearson and this is Building the SSAS Tabular 2012 Foundation. In this and subsequent modules we'll discuss the details of the development environment and all the different steps and objects involved in creating a Tabular project as well as different options as far as the approach to design and development of a Tabular project. Our objectives within this module will include the establishment of a development environment from which to create, maintain, and deploy our SSAS 2012 Tabular Models, to create a new Tabular project, to perform an object inventory of the pieces that make up a Tabular model, to take a detailed look at the things, many of which are automatically created, and whether we have to manipulate them within the Tabular Model, and to look ahead to a third type of creation of Tabular Model, we're going to cover the first and second here, but this is PowerPivot to SSAS Tabular and we'll get into a lot of detail about when to make the switch and things of that nature.
Introducing Data Analysis eXpressions (DAX) Organizational Business Intelligence with SQL Server Analysis Services 2012 Tabular, The Basics. I'm Bill Pearson and this is introducing Data Analysis eXpressions or the DAX language. In this module we're going to get into using DAX to create calculations to enhance our model. Objectives, we're going to introduce the Data Analysis Expressions language, we're going to discuss the language and its components, we're going to expose function type groupings and we're going to introduce the concept of evaluation context, this is something in the DAX language that presents a learning curve often to practitioners well down the road as their models become more complex. We're going to expose DAX functions within Calculations. We're going to review calculated columns and calculated measures, which we looked at in the last module, in preparation for the use in working with DAX functions and examples. We're going to demonstrate uses of DAX functions in those examples and we're going to discuss results returned by representative functions.