Farewell Tour
DUTCH DATA DUDE FAREWELL TOUR A CHANGE IS GONNA COME Na bijna 10 jaar waag ik de grote stap. Ik verhuis naar Amerika en ga voor Microsoft in Seattle aan de slag. Daarmee komt er een einde…
Power BI Connector for CBS Open Data / Statline updated
I have updated the instructions and the code for the Custom Connector for CBS Open Data / Statline. Please see the original post: Power BI Connector for CBS Open Data / Statline
Machine learning is like washing clothes
Automating a data wrangling pipeline using chained Azure Functions. This post and its code was co-authored with Codeprincess. Machine Learning is all about data… and algorithms. But first and most importantly it’s about data. And it’s not just…
Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)
Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I…
Mapping Dutch geographical data using Power BI
I have written before on the subject of using Power BIs mapping capabilities (see the post on ArcGIS) and using the maps with Dutch geographical data (see using Dutch postal codes in Power Map). However, I have…
Updated: Annual radio countdown Top 2000 in Power BI
Oops, I did it again. It’s that time of the year. A day later than last year (sorry about that ;))…. Back by popular demand: the Top 2000 visualized in Power BI. Read all about it in…
SQL Server 2017: It’s here!
Anxiously you have waited for this day. The day you could finally get your hands on the latest version of the best database platform available. Today is that day. SQL Server 2017 is available and it runs…
Power BI Connector for CBS Open Data / Statline
Updated 7/10/2018: path updated below and new file on GitHub. Since this post primarily concerns a Dutch data source, the rest of this post will be in Dutch. English summary below. De open data die het Centraal…
Microsoft’s Language Understanding Service now speaks Dutch
Over the weekend Microsoft’s Language Understanding Service (LUIS) which is part of the Cognitive Services and the Cortana Intelligence Suite was updated to support the Dutch (Nederlands) language! Great news for anyone who needs to support Dutch…
Implementing incremental data load using Azure Data Factory
Azure Data Factory is a fully managed data processing solution offered in Azure. It connects to many sources, both in the cloud as well as on-premises. One of the basic tasks it can do is copying data…