Dutch Data Dude

Data Nerdiness

Search
  • Blog
  • Shop
  • About
  • Disclaimer
  • Blog
  • Shop
  • About
  • Disclaimer
  • Updated: Annual Radio Countdown Top 2000 in Power BI

    / December 23, 2020

    Here we are again – trying to continue the tradition of updating my Power BI analysis of the Dutch Radio 2’s Top 2000. This year however, the report was fully redesigned by my friend Marc Lelijveld after…

    read more
  • Power BI Pro Tip: show 0 instead of (Blank)

    / May 12, 2020

    Default behavior of Power BI is to show (Blank) even when summing a numerical column that happens to be all empty. Want to show 0 instead? COALESCE helps.

    read more
  • Azure SQL firewall settings for Power BI refresh

    / April 28, 2020

    I do not claim that what is included in this post is the perfect way of doing things. However, some things related to Azure SQL firewall settings for Power BI data refresh caught me by surprise recently…

    read more
  • Working with aggregations in Power BI Desktop

    / April 23, 2020

    Aggregations bring me back to the good old SSAS days.You can imagine that I was curious but skeptical when I tried aggregations in Power BI Desktop.

    read more
  • Updated: Annual radio countdown Top 2000 in Power BI

    / December 30, 2019

    A bit later this year, but even after my move to the US I decided to keep up the tradition of updating my Power BI analysis of the Top 2000 analysis for this year. Read all about…

    read more
  • Passing command line settings to SQL Server Integration Services (SSIS) packages using dtexec on Linux

    / March 1, 2019

    This is my first blog post since I moved to Redmond. A lot of time has passed, sorry for that! I kept busy filling out forms, forms and some more forms. After that came more forms. I…

    read more
  • Updated: Annual radio countdown Top 2000 in Power BI

    / January 3, 2019

    This is starting to become a tradition, sort of. My Power BI analysis of the Top 2000 has been updated to include 2018’s edition! Read all about it in the original post from 2016. Full screen Enjoy…

    read more
  • Farewell Tour

    / September 18, 2018

    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…

    read more
  • Power BI Connector for CBS Open Data / Statline updated

    / July 10, 2018

    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  

    read more
  • Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)

    / April 6, 2018

    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…

    read more
 Older Posts

Shop (more available)

  • Shallow vs Deep Learning sticker $7.99
  • Data Miner (dark colors) $21.99
  • Data Wrangler (dark colors) $21.99
  • Evil pie chart (dark colors) $21.99
  • Data. sticker $7.99
  • The truth about statistics sticker $7.99
  • Power BIer (Yellow Logo) $17.95
  • SQL Super(wo)man $21.99
  • Data Scientist sticker $7.99
  • Rage against the machine learning (dark colors) $21.99
2021 Dutch Data Dude | Bard Theme by WP Royal.
Back to top