Blog Post

Open Source Power BI Desktop Workshop

,

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you do because it’s great fun and you actually learn something too. My course however isn’t nearly as sophisticated; I simply don’t have the resources to create an online class like that. Instead, I took a more basic approach: I created a couple of files and documents that will help you deliver a Power BI workshop. This workshop can be as long or short as you want, depending on which features you want to focus, but typically I use it for a one day workshop.

The audience mainly focuses on power users: people that know Excel and can behave themselves with a little bit of code. If your students are less tech-savvy, you can skip the modelling part and just create some cool reports. The workshop consists of free and open data. It starts from the IMDB Top 250 Movie list and enriches this list with extra data from the omdb (Open Movie Database) API. You only need an Internet Connection. Some screenshots:

power bi workshop overview report

power bi workshop model

power bi workshop sample report

The .pbix file contains a set of reports, where each reports shows different features of the tool. Some focus on new additions from the last couple of months. There’s also a little DAX involved, but mainly to show how calculated columns and measures work, and how filter context behaves.

The data is fetched with Power Query and a query has been turned into an M function (this is one part where a little code can be involved). Because the data contains a lot of comma separated lists (multiple directors, multiple genres, multiple countries …), they are all split out into many-2-many relationships (a good learning opportunity for bi-directional cross-filtering). Because of the way caching behaves (or doesn’t) refreshing the model can take quite some time (although there isn’t much data involved). I haven’t been able to solve this yet. To circumvent this, there are .pbix files provided that match with the start or end of certain exercises. For example, in the exercises you’ll create only one many-2-many relationship. The next exercise starts with all the other relationships already created. Otherwise the exercises would be a bit too repetitive and boring.

The workshop is quite basic now, but I’ll expand it in the future with more guidelines, hopefully more features and maybe corrections as well. Maybe I’ll create a recording where I explain all the material, but that’s for later. Now, where can you find all the goodies?

  • you can find the source files on Github. There’s a .pbix file (a Power BI Desktop file) that contains the model and sample reports. On Github, you can also find the exercises.
  • the accompanying slide deck can be found on Docs.com. If you download the PowerPoint file, you’ll see I added a lot of notes explaining each slide.

All the material is licensed under the MIT license, which means you can use it for all purposes (give trainings at your colleagues, at your clients or use it to learn more about Power BI yourself) as long as you keep the copyright notice.

That’s it for now. If I make updates to the workshop, I’ll update this blog post as well.

If you happen to use the materials and give a presentation/workshop, let me know in the comments how it turned out. If you have any feedback or suggestions, please post them in the comments as well.

UPDATE 2017-02-16: I made some significant changes to the data sources. More info: Updates to the Power BI course.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating