Introduction to SSAS


What Will You Learn?

  • To develop a data warehouse for your company
  • To develop a repeatable methodology for a successful SSAS project
  • To create and configure a cube and dimensions
  • To write MDX (the querying language for cubes)
  • To define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • To administer and deploy SSAS, defining actions, implementing data mining
  • To build office-based BI applications and dashboards, and administering SSAS



In this course, you’ll learn how to use SSAS in your enterprise. This training takes you from the ground up, teaching you the fundamental skills needed to develop and deploy SSAS solutions and present this new data to your end users.



Director of Training
Devin Knight is our Training Lead, overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books: “Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services”, “Knight’s Microsoft Business Intelligence 24-Hour Trainer” and “SharePoint 2010 Business Intelligence 24-Hour Trainer”. He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server User Group in Jacksonville, Florida (JSSUG).


What to Know Before the Class

This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008/2012/2014 and how to query a SQL Server.

Duration: 7:59:50
Introduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.
Introduction to SSAS Tabular - What you need to get started
Module 00 - Introduction to SSAS Tabular for Developers
Module 01A - Introduction to Tabular (Overview)
Module 01B - Introduction to Tabular (Choosing Tabular vs Multidimensional)
Module 01C - Introduction to Tabular (Upgrading Power Pivot to Tabular)
Module 02 - Importing Data into Tabular
Module 03 - Creating the Data Model
Module 04A - Creating Calculated Columns with DAX (Introduction to DAX)
Module 04B - Creating Calculated Columns with DAX (Your First Calculations)
Module 04C - Creating Calculated Columns with DAX (Navigation Functions)
Module 05A - Creating Calculated Measures with DAX (Basics)
Module 05B - Creating Calculated Measures with DAX (Calculate Function)
Module 06 - Incorporating Time Intelligence
Module 07 - Building Reports in Excel
Module 08A - Managing Tabular Models (Perspectives)
Module 08B - Managing Tabular Models (Partitions)
Module 08C - Managing Tabular Models (Deployment)
Module 09 - Securing Tabular Data Models
Module 10A - Advanced Data Analysis (KPIs)
Module 10B - Advanced Data Analysis (Role Playing Dimensions)
Module 10C - Advanced Data Analysis (Many to Many)
Module 10D - Advanced Data Analysis (Parent-Child)
Module 11 - Performance Tuning
Module 12 - Planning and Implementing a Solution
Class Survey

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, 2008, 2012, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance