Category: Uncategorized

Swedish housing shortage in Power BI

The Swedish National Board of Housing, Building and Planning, also called “Boverket” have published some open data on the housing shortage in Sweden. It’s a 45 MB Excel file and it’s supplemented with a view file where you can find a couple of pre-made tables to simplify the digging...

Trackmania Analyzer – Part 3 – Calculations

In this third and final blog post of the Trackmania series I’m focusing on the Calculations, both for columns as well as measures. Trackmania Analyzer – Part 1 – Using the report Trackmania Analyzer – Part 2 – Data Transformation This blog post covers the calculated table, followed by...

Trackmania Analyzer – Part 2 – Data Transformation

This is the 2nd part of my Trackmania Analyzer series and it covers technical aspects of how the data is loaded and transformed in Power Query. You can read the other posts here: The replay information is stored in .GBX-files. When transformed into JSON there’s a section for the...

Trackmania Analyzer – Part 1 – Using the report

This blog post covers the usage of my Trackmania analyzer that you can find on GitHub, so feel free to make use of this if you want to analyze your own replays! Other parts cover more technical aspects of the report and these posts should be considered if you...

Using PowerPlatform to build Lasergame!

A few month back we had this internal conference. I thought it’d be fun to have a app in PowerApps even though we’re only like 60 people and the conference would last only 2 days. It was kind of like a way for me to prove that PowerApps could...

Creating sample data using Excel

From time to time I need to create a sample dataset. It might be for a demo to a customer, a talk at a conference, to test out a calculation or for a blog post for example. No matter what reason you might have, I want to show you...

Power BI, Excel and Visio walks into a bar…

They all hit their heads on said bar. After that they sat down to talk. Excel bragged about the cool things it could do. “Behold, as I goal seek certain input for a desired output” he said. He headed into the Data tab and selected Goal seek. With the...

“Who did it?”

These type of questions always come. “How many of my users did this?”, “On how many days did we do that” or simply “How many of my users where active?”. Instead of knowing how much each user did of what, we eventually tend to want to know how many...

Taking control and automating your surveys

In many organizations today there is a need to collect survey data. I’ve seen numerous examples of how this can be done and most of the time it involves some kind of automated email sent out with a link in hopes of your subjects decide to deposit a few...

Machine Learning and Power BI

Everyone seems to be talking about ChatGPT and similar AI solutions now in the beginning of 2023, so I figured I’ll share some thoughts on the machine learning features currently built into Power BI! I should however clarify that these are Premium functions in Power BI. To kick it...