This post is also available in: Deutsch

A few weeks ago, I visualised the current status of vaccinations in the canton of Basel-Stadt with Power BI in a weekend project. I have received a lot of positive feedback in response to this. Many thanks at this point for that. In addition, there were numerous requests to extend the report to cover the whole of Switzerland.

It took a few days, but the report now contains data for the entire country. The Power BI Report can still be accessed at:

https://impfstand.ch

The selection of the canton can easily be done using the navigation:

Navigation by canton on impfstand.ch
Navigation by canton on impfstand.ch

New features that are now

This post is also available in: Deutsch

This past weekend, I had an aha moment. My girlfriend asked me what the current status of COVID-19 vaccination was here in Switzerland in our area, which means in the canton of Basel-Stadt. After a short internet research, we found either newspaper articles that were already a few weeks old or statistics that presented the current figures only insufficiently or in a complex way.

The canton of Basel-Stadt provides all data as CSV and JSON on its Open Data Basel-Stadt website and allows the use under the Creative Commons license.

Current vaccination status as Power BI Report for Basel-Stadt

As a Power BI enthusiast, I immediately thought of presenting the whole thing in

This post is also available in: Deutsch

Hello everyone,

it is the middle of September and the vacation is slowly coming to an end. I had the time to think and am highly motivated to start something new. My digital notebook is well filled with all kinds of topics that I deal with in my daily work around BI and specifically Power BI. In my experience with clients and colleagues, sometimes we all hang on the same question. I don’t want to keep my knowledge to myself, I want to share my experiences, I will start a blog!

Where will the whole thing lead to? No idea at all! Does it add value for the reader? Also no idea. Will there even be readers? At least one, if you made it to these