The Aggregations in SSAS module provides you with the instructions and devices to develop hands on skills in the following topic:

  • Creating aggregations in SSAS

Exercise 1 - Creating Group of Aggregations

Aggregations in SQL Server Analysis Services (SSAS) improve query performance and calculation time. Aggregations limit the data to be scanned for answering a query.

In this exercise, you will learn to design aggregations in SQL Server 2012. As a prerequisite to this task, you will first perform the tasks to create and deploy a multidimensional cube in SSAS.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.