Dutch Data Dude

Data Nerdiness

Search
  • Blog
  • Shop
  • About
  • Disclaimer
  • Blog
  • Shop
  • About
  • Disclaimer
  • UPDATED: ANNUAL RADIO COUNTDOWN TOP 2000 IN POWER BI

    January 4, 2022

    Here we are again – trying to continue the tradition of updating my Power BI analysis of the Dutch Radio 2’s Top 2000. Later than ever this year, I was on vacation since early December. Read all about it in the original post from 2016. Happy new year and see you next year!

    Continue Reading
    Jeroen ter Heerdt 0 Comments
  • The capitalization (uppercase / lowercase) of my text data changed in Power BI! Why?

    / November 29, 2021

    Some of you might have seen this before – you load some data into Power BI and suddenly the capitalization (uppercase / lowercase) of your text changes on you. Let me explain what is happening here. Why…

    read more
  • Visualizing Home Assistant data in Power BI

    / September 15, 2021

    Ahhh, Power BI and Home Assistant. Two of my favorite tools. So, why not try to bring them together? I like the Home Assistant data visualizations, but they are limited - that's where Power BI can really…

    read more
  • Making your own ‘smart’ garage door controller

    / February 9, 2021

    I have two garage doors, both of which can have motors and can be opened automatically from my car, using a remote or a press off a button. Very convienient. However, sometimes I want to check if…

    read more
  • 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
  • Never forget to water the plants again: building a DIY automatic plant watering / irrigation system for <$5

    / November 12, 2020

    One thing we never seem to get right is when to water plants. We either overfeed them or forget them. In either case, they die quickly. As part of my many home automation endeavors I wanted to…

    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
  • Fixing ‘subscription is not registered with NRP’ error in Azure

    / April 24, 2020

    Today I hit the following error while trying to write a PowerShell script to automate some Azure Networking related tasks (more on that soon!): 'Subscription [subscriptionID] is not registered with NRP'. In this short post I will…

    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
 Older Posts

Shop (more available)

  • AI: Artisan Intelligence (dark colors) $21.99
  • Data Miner (dark colors) $21.99
  • The truth about statistics sticker $7.99
  • Data. (light colors) $21.99
  • AI: Artisan Intelligence sticker $7.99
  • The Truth About Statistics (dark colors) $21.99
  • Data Scientist (dark colors) $21.99
  • Evil pie chart (light colors) $21.99
  • Data Wrangler (dark colors) $21.99
  • Data. sticker $7.99
2022 Dutch Data Dude | Bard Theme by WP Royal.
Back to top