Menu

Grohrock.consulting

Databases, Business Intelligence and more…

Primary Menu

Skip to content
  • Home
  • About me
  • Impressum
Search

Author: Philippe Grohrock

Load batches using a running sum

Posted on08.12.202208.12.2022

Loading batches of data can be very good, but what happens, if batches become so small that the performance hits the ground? Read More …

CategoriesDatabaseTagsdatabase, etl

Filters are everywhere

Posted on18.10.202220.10.2022

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 …

CategoriesDAXTagsdax, hasonefilter

Power Shell and Power BI on premise

Posted on20.06.202220.06.2022

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 …

CategoriesPower BI Report Server, PowerShell

Calculated Columns in SSAS

Posted on06.05.202215.05.2022

What happens exactly if you use calculated columns in your tabular model? How does it affect refresh performance and why? Read More …

CategoriesSSASTagscalculated column, ssas

Handling tabular models with PowerShell

Posted on02.05.202215.05.2022

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 …

CategoriesPowerShell, SSASTagspowershell, ssas

Aggregating distinct counts

Posted on01.05.202207.02.2023

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 …

CategoriesMicroStrategy

Archives

  • December 2022
  • October 2022
  • June 2022
  • May 2022
Copyright © 2023 Grohrock.consulting. All Rights Reserved. Impressum | Catch Responsive by Catch Themes
Scroll Up
  • Home
  • About me
  • Impressum