I remember reading about lazy evaluation for DAX variables the first time several years back in the book “The Definitive Guide to DAX” from Marco Russo or Albert. I also remember being very confused about the concept back then. It took some time and research in order to understand the concept a little better. If…
Are you trying to reduce the runtime of your Python code? Faster code can reduce cloud costs, especially with serverless solutions like Azure Functions or AWS Lambda. One way to have your script run faster is by using so called “list comprehension” in Python. List comprehensions are a concise and often faster way to create…
Imagine you have to create a whole lot of measures in Power BI that are similar. One free way to do this is, is by using C# scripts in Tabular Editor 2.0. Below is an example of a “static” way to do this. You simply make the necessary adjustments like changing the table name and…
Looking to host a static website cheaply? You can do so in both AWS and Azure using static hosting. Simply create an .html file (using AI) and upload it to the cloud storage of your choice. Enable static hosting and voila, you have yourself a cheap website! Here is some extra info to get you…
I have a data modelling conundrum. It concerns records in a dimension that have start- and enddates. I’ve heard people refer to this type of problem as the “events in progress”-problem. My specific version of this problem goes like this: Imagine you have a sales fact table called FactSales with a date, an employee who…
Speed up your SQL development with this one trick! … No but seriously, this little hack makes SQL coding so much more convenient. Most SQL development environments have the possibility to perform so called “Multi Cursor edits” (also called “Box selection”). Meaning, you can edit several lines in your block of code at once. In…
I am rereading The Data Warehouse Toolkit by Kimball and Ross and would like to share something interesting concerning fact tables. According to the book, there are 3 main types of fact tables: A transaction fact table inserts a new record for every transaction that takes place. An obvious example would be a sales fact…
Verzuim is een belangrijke indicator binnen veel organisaties. Wanneer het verzuim hoog is, wil je dit als organisatie graag verlagen. Om het verzuim te verlagen, kan een interventie ingezet worden. Hierna wil je graag checken of de interventie het gewenste resultaat gehad heeft. Met andere woorden: is het verzuim lager geworden? Het probleem met verzuim…
Did you know you can use SQL queries in your Python worksheets in Snowflake? This works as follows: dataframe = session.sql( ”’ YOUR SQL QUERY GOES HERE ”’ ) And voila! Don’t forget to return it in the function in the worksheet if you wish to inspect the resulting dataframe in the results pane. I…
Are you looking for a way to speed up queries in Snowflake without altering the size of the warehouse? One way you might achieve this is by taking the largest table in your query and applying the necessary filters before you start using it in your query. This means that the aforementioned largest table that…