Power BI Storage Modes for Aggregations

Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model Continue reading Power BI Storage Modes for Aggregations

Creative Aggs Part I : Introduction

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

Row-based Time Intelligence

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