Video unavailable

SQLBits 2009

Designing Effective Aggregations in Analysis Services 2008

This session will show you how to build aggregations in Analysis Services 2008 that are useful for the queries you're actually running

Building aggregations is one of the most important ways of improving query performance in Analysis Services, but simply running the Aggregation Design Wizard doesn't always result in useful aggregations being built. This session shows the steps you need to go through in order to build aggregations that are actually going to be used by the queries that you're running.

Speaker

Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft.

Chris Webb's Sessions

Fabric Power Hour

The complete guide to Power BI memory usage and memory errors

What's new in Power Query in Power BI, Fabric and Excel?

Connect Excel to Power BI data with Live Connected Tables

Fabric Power Hour

Fabric Direct Lake Deep Dive

Query folding in Power Query

Power BI User Group: Ask Me Anything! Learn from the Experts and Boost Your Skills

Performance Tuning Power Query And Dataflows In Power BI

The Complete Guide To DirectQuery Mode In Power BI

Creating Tables In Power Query And M Using #table()

An evening with Power BI CAT team

Power BI: Business Intelligence Strategy, Vision, & Roadmap

Performance tuning Power BI dataset refresh

Advanced analytics features in Power BI

Top tips for the accidental Power BI administrator

Introduction To Dataflows In Power BI

Using Analysis Services MD as a Data Source for Power BI

An Introduction to Azure Analysis Services

Introduction to Azure Analysis Services

Using M for data access in Analysis Services Tabular v.next

Advanced MDX Tips And Tricks

Amazing Things You Can Do With Power BI

Building A Reporting Solution Using Power Query

Power Query: Beyond The Basics

DAXMD: SSAS Multidimensional meets DAX and Power View

Advanced Security with Analysis Services Multidimensional

Fun with Scoped Assignments in MDX

Introduction to Performance Tuning Analysis Services 2008

Implementing Common Business Calculations in DAX

Common Analysis Services design mistakes and how to avoid them

Designing Effective Aggregations in Analysis Services 2008

Cache-warming strategies for Analysis Services 2008

Using Analysis Services as a data source for Reporting Services reports

Whats new in AS 2008?

Performance Tuning MDX queries