Phil Seamark on Aggregation Tables

I was having a candid conversation with Phil Seamark from DAX.tips about Aggregation Tables. During that conversation, I was asking about patterns in using Aggregation tables. Within that 10 minute conversation I was blow away by all the possible patterns. Because of this, we pleaded for Phil to present these patterns to the Milwaukee Brew City User Group.

Patterns in Aggregation Tables

Watch the full webinar below from our user group:

Aggregation Patterns

While these patterns are described in detail here are the various patterns that can be used for Aggregation tables. Also, Phil includes a great introduction, found here. For each of these articles Phil describes proper usage for the pattern.

Horizontal Aggs

The Horizontal Aggs is typically developed using a time dimension. Thus, most aggregation tables would fit this pattern.

Example of a horizontal Aggregation table

Accordion Aggs

The Accordion Aggs are similar to a horizontal Agg. However, the time periods are not equal.

Accordion Aggregation table. Non uniform incremental aggregations.

Filtered Aggs

The Filtered Aggs would contain multiple Aggregation tables of the same data. But, each Agg table could contain different gains of data. For Example, data aggregated by Week, Month or Year.

Filtered Aggregation example.

Incremental Aggs

Finally, the Incremental Aggs. This type of aggregation would be used when aggregating transactions per day by store, and or product.

Incremental Aggregation where you can aggregated transactions over time

Thanks Phil

A special thanks to Phil for presenting. Since, we know you are a busy guy doing tons of great work. Thank you for taking time out of your day to present this wonderful topic. We hope you enjoy this exploration into Agg Tables.

Check out Phil’s other contributions

Phil has been quite active on the PowerBI.tips site. Check out all his other fun contributions.

Like and Follow

If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:
Store Merchandise


Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.