Home

Thanks for visiting my blog! On this website I write interesting blogposts about data related topics. All topics I write about are based on real challenges that are experienced during data transformation activities. Topics are either based on challenges I have experienced myself, or problems shared by users on the PowerBI forums. The blogposts are focused on PowerBI, Power Query, SQL and Excel.

Please see below for an overview of my latest posts:

• SQL – subqueries versus Common Table Expressions (CTE)
• Using custom functions in Power Query (to boost performance)
• Dynamically renaming columns in Power Query
• Importing files from a folder using Power Query
• Reproducing the SQL LAG function in Power Query in order to determine an internal promotion