PowerBI.tips

Tag: Agg Tables

  • Phil Seamark on Aggregation Tables

    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:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat