Data modelling and DAX
I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so far Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs … Continue reading Creative Aggs Part V : Incremental Aggs
The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs … Continue reading Creative Aggs Part IV : Filtered Aggs
Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs (this article) Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart … Continue reading Creative Aggs Part III : Accordion Aggs
Introduction to Aggs Horizontal Aggs (this article) Mixing Agg and base table to produce a single value Accordion Aggs Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart … Continue reading Creative Aggs Part II : Horizontal Aggs
