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.
Are you a lazy engineer? Then you are good engineer. Being lazy/good at automation of processes helps save work, time and money. In Data Build Tool (dbt) there are several packages that can help automate tedious tasks. The dbt-codegen package provides you with the macro’s generate_base_model and generate_source, among others. Macro’s in dbt are essentially…
Would you like to check if a table contains stale data? Nothing more embarrassing than having a user of a report point out that your data is wrinkled and saggy! As responsible Data Engineers / Analytics Engineers / Insert New Buzzword Job Title Here… we would like to be one step ahead of the users…
Are you collaborating with multiple Analytics Engineers on the same dbt repository? In the following hypothetical setup, dbt is used to load data into Snowflake, and Power BI is used to create reports based on that data. Each engineer has their own schema when developing and deploying locally, following dbt best practices. In Snowflake, this could look…
Meetings are useless. If no one is capturing decisions and to‑dos. It’s just a conversation. Every meeting needs: Otherwise, you’re not collaborating. You’re just blocking calendars.
Combining Data Build Tool (dbt) with CI/CD is a great way to automate tests during deployments from development environments to production. This approach ensures higher data quality and provides early feedback about potential issues 𝐛𝐞𝐟𝐨𝐫𝐞 end users see the data. There’s nothing more embarrassing than having an end user point out a data mistake that could have been caught earlier. By…
Do you ever have unanswered emails? I treat emails (and all digital communication with people I know, actually), like it is a real conversation. In the sense that, whenever I send a message, I expect an answer. And, whenever I receive a message, I try to respond. Sometimes it irks me when people do not…
Have you ever played “The Whispergame”? You have a group of people and the first person whispers a short story in the next person’s ear. This goes on until the last person of the group has heard the story. Inevitably, the story becomes completely distorted. This is what I hear and see happening in a…
You can change a text value containing a date very easily using the [format] argument of date functions like TO_DATE( ) in Snowflake. See below for an example.
The function SPLIT_TO_TABLE is kind of a niche function in Snowflake, but it can work wonders for some specific use cases. Take a look at the screenshot below to see how it works. Have you ever used this function and if so, what problem were you trying to tackle?
Did you know you can save values in variables in a Snowflake SQL worksheet and use them later in queries?