Data modelling and DAX
Introduction For this blog, I want to share an interesting approach that can potentially speed up slow reports that include a distinct count calculation. The approach described in this article explains how you can add a DIY version of an approximate distinct count calculation to a DAX based model. The method combines a little pre-processing … Continue reading DAX : Approx Distinct Count
Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations can take advantage of specific optimisations. When RI issues exist in an IMPORT model, complex expressions will not be able to use all … Continue reading Clean data = faster reports
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 (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
