Load batches using a running sum
Loading batches of data can be very good, but what happens, if batches become so small that the performance hits the ground? Read More …
Filters are everywhere
When creating reports using DAX, filters are everywhere, but until recently I wasn’t really aware of that. In this article I will cover where they are and why it’s relevant. Read More …
Power Shell and Power BI on premise
The combination sounds powerful, but does it really live up to these standards? I’ve tried using it in real-world scenarios and here are the results. Read More …
Calculated Columns in SSAS
What happens exactly if you use calculated columns in your tabular model? How does it affect refresh performance and why? Read More …
Handling tabular models with PowerShell
Is there a way to access tabular models by using regular code, without having to use Visual Studio? The answer is a big yes. Read More …
Aggregating distinct counts
Distinct counts can be awesome, but what often remains is the question of dimensionality, especially when it comes to time aggregation. Thankfully, MicroStrategy can do that for us. Read More …