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.
The Horizontal Aggs is typically developed using a time dimension. Thus, most aggregation tables would fit this pattern.
The Accordion Aggs are similar to a horizontal Agg. However, the time periods are not equal.
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.
Finally, the Incremental Aggs. This type of aggregation would be used when aggregating transactions per day by store, and or product.
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.