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
In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show common period comparisons such as: This year versus last year (as difference and/or percent) Delta, or percentage change over the previous … Continue reading Pivoting Data for Speed
For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works well on very large data-sets, especially for visuals that contain multiple measures and multiple periods. The idea is to create a Time Intelligence table which contains blocks … Continue reading Row-based Time Intelligence
Last time I was in Seattle, I was lucky enough to do a short video with the famous GuyInACube showing a useful technique I use when debugging DAX in Power BI. I hope you find it useful.