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.
Imagine you really do not like someone and you happen to know his IP address. With the power of a Network Policy, you can block him from your Snowflake account! That will that will teach him not steal you desk every single time! You don’t do flexible workspaces! All kidding aside, Network Policies are a…
SnowSQL is the Command Line client for connecting with Snowflake. After connecting, you can use SnowSQL to execute SQL queries and perform DDL and DML operations. However, with SnowSQL being a CLI, it is not as easy to use as SnowSight (the browser-based UI of Snowflake). That being said, a recent course taught me a…
Some time ago I developed a reservation system using AWS CDK. Potential customers can visit a website that contains a calendar, click on a date, click on a time and finally, enter their email address. A confirmation email will be sent to their address right after the reservation. I built this infrastructure using an S3…
Snowflake is primarily known in my circles as a cloud Data Warehouse provider. But did you know that you can also build Dashboards in Snowflake, using SQL queries? Below is an example of a Dashboard built in Snowflake. Right now, the dashboards do not have the same visualization capabilities of e.g. Power BI or Tableau.…
There is an easy way to track the lineage of Snowflake objects now. Whenever checking an object in Snowflake, you can visit the Lineage tab and check out the complete pipeline in Snowflake. Awesome.
Would you like to share your Power BI Report with the world using a public link? Look no further than this method: After a few self-explanatory steps, this will give you a link that you can share with other people, even though they do not have a Power BI account. This can be useful when…
Would you like to insert Dynamic Text Values into your Power BI Text Boxes? As I was updating my CV dashboard (which I created for a contest a few years earlier), I noticed something unforgivable: I HAD HARDCODED A VALUE THAT WAS SUPPOSED TO BE DYNAMIC! This is an outrage! In my case, the hardcoded…
So you’ve created a wonderful instance method for your class. However, you would like to use the instance attributes created in that first instance method, in a second instance method WITHOUT calling the first instance method. In that case you can use the following inside your second instance method: self.first_instance_method()
Why does Power BI hate many-to-many relationships? Despite the title (that did its job in getting your attention) many-to-many relationships *-* are not necessarily evil. However, modeling your data in a manner that avoids many-to-many relationships helps in a lot of scenarios with data consistency, among other things. Let’s dive into this using the ancient…
You published a Power BI Semantic Model to the Power BI Service but it won’t refresh. It gives you the following error: “Information is needed in order to combine data. Please specify a privacy level for each data source.” One way you might solve this is: 1. Open the settings of the Semantic Model. 2.…
