Ásgeir Gunnarsson

Ásgeir is a Data Platform MVP and a Business Intelligence Developer at Össur in Iceland. He works on Business Intelligence solutions using the whole of the MS BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.? 
Ásgeir speaks regularly at events both domestic and internationally and is the group leader of the Icelandic PASS Group.? 
Ásgeir is passionate about data and loves solving problem with BI. 


PRECON: Ask the Expert (Monday)

During the lunch break, there will be a panel of experts available in our 'Ask the Expert' booth. Between 12:45 and 13:15 you can ask our experts (listed below) for their practical advice and/or tips & tricks.

Feeding them will influence the quality of feedback you'll receive..


Koen Verbeeck

  • BI
  • SSIS
  • SSAS (Mainly Tabular)
  • SSRS
  • Power BI
  • (Dimensional) Data Modelling


Pinal Dave

  • SQL Server Performance Tuning Expert


Wesley Backelant

  • (Azure) Data Platform


Ásgeir Gunnarson

  • BI
  • SSIS
  • SSAS
  • SSRS
  • Power BI


Koen Verbeeck Pinal Dave Wesley Backelant  Precon  200 

Impact of weather on English Premier League matches – Power BI Desktop analysis



Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data. How you can then manipulate and extend it and finally report on it.

We will look into how you can use open weather data and combine it with data from web pages to create the dataset you need. When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.

In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report so they will see both the limitation of Power BI Desktop and open data as well as its strength.

In the end the Power BI Desktop file will be available to download for the audience.