Business Intelligence and Big Data with the Microsoft Stack, For Database Administrators

SQW04 Why OLAP? Building SSAS Cubes and Benefits of OLAP


9:15AM - 10:30AM

Level: Introductory to Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

While OLAP has been around for many years, some developers/organizations shy away from OLAP, despite the benefits it could bring them. In this presentation, I'll present an OLAP example, how to build an SSAS (Analysis Services) database, and the benefits of OLAP. I'll also compare some of the capabilities in the Analysis Services OLAP model with the new Tabular Model in SQL Server 2012. I'm an instructor who has spent years demystifying OLAP in the classroom, and I'll do the same thing in this presentation.

You will learn:

  • How an OLAP database can be created from a data mart or data warehouse, and how Analysis Services handles different types of fact/dimension relationships (both simple and complex)
  • The power of MDX in extending OLAP databases
  • The benefits to end users who consume an OLAP database