22-25 April 2026

Further your Power BI development skills

2020

TL; DR

Have you done some Power BI development and are you ready to take the next step to be able to solve more complex problems and follow best practices? Then this course if for you.

Session Details

In this course we will learn tips and tricks to add onto your prior knowledge of Power BI.

The emphasis is on tips and tricks that can help the participants take the next step in their Power BI journey as well as best practices in Power Query, data modelling and reporting.

We will cover more advanced techniques in Power Query, data modelling best practices, report design and storytelling techniques.

Power BI comes in two different versions, free and paid. This course will use the free version so there is no need to have any kind of Power BI license to attend the course.

The participants need to come with their own laptop with Power BI Desktop installed.

The course contains the following:

Ingesting data in Power BI Desktop

  • Importing data from folder
  • Pivot and Unpivot
  • Add columns
  • Functions
  • Append and Merge queries
  • Last updated date
  • SharePoint and OneDrive for Business as source
  • Organizing queries

Modelling in Power BI

  • Star schema
  • Different cardinality
  • Relationships
  • Modelling views
  • Auto Date/Time Hierarchies
  • Row level security

Reporting

  • Power BI Theming
  • Background images
  • Custom visualizations
  • Storytelling with bookmarks, drillthrough, report page tooltip and DAX

Data flows

  • What is Power BI data flows?
  • Reusing your logic
  • Dependencies
  • Scheduling and sharing

What you gain from the course:

  • Advance your Power BI skills
  • Learn best practices
  • Learn tips and tricks when importing data
  • Learn to present more compelling reports

Who should attend this course:

This course is best suited for users with some Power BI knowledge that want to take the next step in their Power BI journey. It is assumed that the participants know the basics of Power BI and how some experienced in using it.

3 things you'll get out of this session

Speakers

Ásgeir Gunnarsson

Ásgeir Gunnarsson's previous sessions

Power BI Governance quick start
For many the mention of governance gives them images of massive effort and inconvenience for themselves and end-users. It´s a hindrance and waste of time. But it doesn´t have to be that way. In this session we will talk about how we can start to tackle Power BI governance. We will look at few things you can get started with very quickly that will get you far in setting up your governance strategy. We will look at things such as documentation, roles and monitoring. The hope is that you go back to your organization with a clear picture of where to start and a better feeling on governance.
 
5 Power Automate flows that could give immediate value in your organization
In this session we will demonstrate how to create value fast with Power Automate. We will do this by showing 5 types of flows that can give value with little development effort
 
Managing Power BI workspaces
This session will help you find the best strategy for managing your Power BI workspaces. Should you go for as much automation as possible or do careful manual process? Should you have few people controlling everything or should everyone do as they want? All this and more you will find in this session.
 
Whats Going On in My Power BI Environment?
As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it.
 
Power BI Governance overview
Governance of your Power BI environment is very important. Setting up structure around it will allow developers (IT or business) to develop Power BI content the right way, first time as well as aid administrators
 
Impact of weather on English Premier League in Power BI
By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.