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
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 This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in this series have been developed after working on some of the largest models around. The series will cover : Introduction … Continue reading Creative Aggs Part I : Introduction
