Wij zijn Business Intelligence- & data enthousiastelingen. Met vele jaren ervaring in elke schakel van de keten van Business Intelligence denken wij in oplossingen voor onze klanten.
In het blog vind je artikelen over Business Intelligence in het algemeen en verscheidene tools in het bijzonder. Voorbeelden van onderwerpen zijn Power BI, DAX, SQL, Data Warehousing, Data Modeling, etc.
Nieuwsgierig naar onze projecten? Enkele voorbeelden betreffen het ontsluiten van data middels een webscraper ontwikkeld in Python, het toepassen van business logica en de opslag van data in Azure SQL DB en rapportages in Power BI.
Would you like to have version control when developing in Snowflake using the browser? You can now create a workspace in Snowflake from a repository. In the example below I am sharing how to do this.
Do you want to implement certain business logic in multiple measures or calculated columns in your semantic model and maintain that logic in one place? With User Defined Functions in Power BI you can do just that. Your own custom functions, reusable across the entire Power BI Semantic Model in measures and calculated columns. It’s…
Ever wanted to know what the data source is for a DirectQuery table in your Power BI composite model? I have not found an easy way to check this. Using Tabular Editor however, it can be done. Follow the steps below. Open tabular editor → connect to the semantic model you want to inspect →…
In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a measure containing the function CALCULATE in Power BI. In the image below we use a measure without the function CALCULATE. Zooming in on the RunningBalanceMeasureNoCalculate value of “1300” in the screenshot below: the first three rows adhere…
In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a calculated column in Power BI. In the image below we use a measure with the function CALCULATE. Zooming in on the RunningBalanceCalculate value of “1300”. The first three rows adhere to the filter condition “<= _Date” and…
Calculating running totals is a must-have for many business reports — but did you know there are several ways to do it? I’ve tested multiple methods, each with its pros and cons, and I’m sharing my learnings with you in this carousel. 👉 Swipe through to see each approach explained simply, and let me know…
How do you know where an AWS Networking Engineer will be at the next networking event? Just check the next record in the Route Table! Now that I have almost killed the mood with that atrocious joke, allow me to deliver the finishing blow with the presentation my latest AWS networking project. This project was…
AWS Project: access an S3 bucket from an EC2 instance in a private subnet using a VPC Gateway Endpoint. The EC2 instance does not use the public internet to access the bucket, but instead uses the AWS backbone network. This means that traffic from the EC2 instance in the private subnet to the S3 bucket…
Another AWS networking project for your amusement. Connecting two EC2 instances that are located in different regions WITHOUT using the public internet. VPC peering is used to connect to EC2-B-private from EC2-A-private. VPC peering uses the AWS backbone network so traffic does not traverse the public internet; both EC2 instances have private IPs. A route…
Are you working with Power BI and Snowflake? Would you like to know what queries Power BI sent to Snowflake? Sometimes you want to know what exactly is happening between Power BI and Snowflake. Perhaps you want to know how costly a certain load from Snowflake to the Power BI Service is. Or maybe you…