Searching a certain value in ANY column in a table has never been easier in Snowflake. Imagine you have an order number, and you would like to search for this order number in a whole bunch of tables that you do not know well. If you knew which column to search, this would be easy:…
Merry Christmas my dear network. Ready for some Python on Christmas day? Here we go. At the risk of kicking in open doors: don’t confuse the semantics of variable declaration in for-loops with functions. Variables that are defined in a function, are local to that function. They exist in the so called “local scope” of…
IMPORT DATA FROM A POWER BI SEMANTIC MODEL INSTEAD OF LIVE CONNECTION? Would you like to import data from a Power BI Semantic model instead of a having a live connection with the model? One way to achieve this is by importing the underlying Analysis Services model. This can be done by following the steps…
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 & Alberto Ferrari. 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.…
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 modeling 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…