Skip to content
October 4, 2015 / Erik Svensen

The European Tour Rankings in Power BI Desktop – #PowerBI

Today – Thorbjørn Olesen won the Alfred Dunhill Links Championship on the European Tour (Link) – so why not celebrate this by looking at how by building a Power BI Dashboard to analyze the Race to dubai Rankings for 2015.

I know how hard it is to play golf but building the dashboard was quite easy and by using the data from this page – http://www.europeantour.com/europeantour/racetodubai/rankings/index.html – I build a dataset with these few steps.

let

Source = Web.Page(Web.Contents(“http://www.europeantour.com/europeantour/racetodubai/rankings/index.html”)),

Data0 = Source{0}[Data],

#”Changed Type” = Table.TransformColumnTypes(Data0,{{“”, type text}, {“Rank”, Int64.Type}, {“2”, type text}, {“Notes”, type text}, {“3”, type text}, {“Player name”, type text}, {“4”, type text}, {“Nat”, type text}, {“5”, type text}, {“Tournaments Played”, Int64.Type}, {“6”, type text}, {“Race to Dubai Points”, type text}, {“7”, type text}}),

#”Removed Columns” = Table.RemoveColumns(#”Changed Type”,{“”, “2”, “Notes”, “3”, “4”, “5”, “6”, “7”}),

#”Replaced Value” = Table.ReplaceValue(#”Removed Columns”,”,”,””,Replacer.ReplaceText,{“Race to Dubai Points”}),

#”Changed Type1″ = Table.TransformColumnTypes(#”Replaced Value”,{{“Race to Dubai Points”, Int64.Type}})

in

#”Changed Type1″

 

And then a few measures and modelling in Power BI Desktop – I ended up with this dashboard.

 

So a total of 307 players from 31 different have won money on the European tour this year and the average money earned is 281K € – not bad for 2 – 4 days of work in the weekends J

Highlighting Denmark in the Treemap shows us that even though Thorbjørn won today he still isn’t the best dane this year in the earnings.

 

You can download the file from here – Link

Remember you can publish this to your Power BI site and set a refresh every Sunday evening so your dashboard is updated after the weekend tournament.

 

 

 

 

 

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: