March 2023

In this article, we will have a look at how ingestion routines that seem simple at first turn out to be complex in big data warehouses. The example is taken from a customer project and is used in the daily load chain to update freight cost into the overall procurement cost structure. Refining Source Data …

Using SQL to create a complex Data Ingestion Routine Read More »

A very useful Add On to Power BI is called “Tabular Editor”. Not only does it allow you to bulk maintain all measures and the data model it also lets you use scripts written in C# to automate manual tasks even further. In this post, I want to share two use cases where scripting has …

Automating Power BI Measures with C# Read More »