Let me just begin by saying that this solution is not something that 99.9% of the Power BI reports out there will have any use for as I honestly think it’s taking more time and calculations than you gain in most situations. In this very particular one it might make sense though, so let’s have […]
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 through the data. Naturally, I could […]
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 the calculated columns and finally the […]
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 Ghost in which sample data can […]
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 want to build on the Power […]
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 be created so swift that it […]