BI, Big Data, and Data Visualization

SQT07 Add It Up: Analysis Services Aggregations


11:00am - 12:15pm

Level: Intermediate to Advanced

Craig Utley

Craig Utley



Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You'll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You'll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You'll dive into queries to see if aggregations are being used and learn when aggregations aren't useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.

You will learn:

  • How aggregations work
  • How to create aggregations
  • To create a plan for creating the right aggregations for your SSAS solution