Organizational BI With SSAS 2012 Tabular - Introduction

This course introduces the creation and querying of basic SQL Server Analysis Services 2012 Tabular models.
Course info
Rating
(195)
Level
Intermediate
Updated
Oct 21, 2014
Duration
3h 40m
Table of contents
Introduction and Foreword
Getting Started With SSAS 2012 Tabular
Building the SSAS Tabular 2012 Foundation
Creating and Managing the SSAS 2012 Tabular Model
Introducing Data Analysis eXpressions (DAX)
Querying SSAS 2012 Tabular
Description
Course info
Rating
(195)
Level
Intermediate
Updated
Oct 21, 2014
Duration
3h 40m
Description

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.

About the author
About the author

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.

More from the author
Business Solutions with MDX
Intermediate
5h 21m
Mar 31, 2017
Section Introduction Transcripts
Section Introduction Transcripts

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.