The European Tour Rankings in Power BI Desktop – #PowerBI

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.

 The European Tour Rankings in Power BI Desktop – #PowerBI

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.

 The European Tour Rankings in Power BI Desktop – #PowerBI

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.

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

Erik Svensen