Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server Analysis Services 2016 (SSAS) Tutorial


SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack to develop Online Analytical Processing (OLAP) solutions. Over the years SSAS has evolved and has emerged as a leader in the area of analytical solutions. SSAS generally uses a data warehouse as a data source and contains data objects like cubes, dimensions, measures, aggregations hosted in a SSAS database. SSAS also offers options to select a variety of server modes like Multi-dimensional, Tabular and PowerPivot. Multi-dimensional expressions (MDX) and Data Analysis Expressions (DAX) are the two primary query and expression languages which are used to query SSAS database objects.

A typical analytical data model development process using SSAS involves the following steps:

  1. Reading data from data source and configuring a schema for the data model in SQL Server Data Tools (SSDT)
  2. Developing SSAS database objects using the schema
  3. Deploying and processing the database objects hosted in the data model
  4. Exploring, Testing, and Reporting the data hosted in the data model

In this tutorial we will explore this life-cycle for Multi-dimensional as well as Tabular SSAS data models. The tutorial is structured in the following order.

  1. SSAS Installation
    • SSAS Evolution - What's new in SSAS 2016
    • Basic Terms and Concepts
    • Installation - Multi-dimensional and Tabular modes
    • Configuring sample data
  2. Multidimensional Models
    • Fundamentals
    • Developing a multi-dimensional data model
    • Deploying and Processing a multi-dimensional data model
    • Querying the data model using MDX
  3. Tabular Models
    • Fundamentals
    • Developing a tabular data model
    • Deploying and Processing a tabular data model
    • Querying the data model using DAX
  4. Reporting
    • Browsing SSAS data using Microsoft Excel
    • Browsing SSAS data using Powerview

We will be using a sample ready-to-use multi-dimensional as well as tabular model as a base solution to explore different aspects of SSAS data models. Now that we understand the structure of this tutorial, let's get started with the basic terms and concepts of SSAS.

Last Update: 4/18/2017

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools