Month: September 2021

Calculating handling time during office hours

From time to time, I stumble upon data that have a starting and an ending time. It could be opportunities in a CRM system, time between an email arrived in you mailbox until it was responded to or a very common one; A service desk case. Calculating the amount...

Temperature Data in Power BI

I recently came into possession of a dataset of weather data from a friend of mine. Just as I am one of those normal friends who get’s thrilled when presented with 1,2 million rows of raw temperature data, so is he a very normal friend who gets thrilled by...