Data modelling and DAX
This post is the last in this series (for now) and describes a technique used to enhance performance in Power BI models that use Aggregate Awareness. I hope you’ve enjoyed the series as much as I have writing and sharing. I will no doubt add more articles in the future but need to pause this … Continue reading Creative Aggs Part VI : Shadow Models
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
