US Open leaderboard 2015 in Microsoft Power BI Preview #Powerbi

Here a few hours before the second round of the US Open begins – I decided to try to make a live dashboard in Power BI – and even though the “live” might be a questionable – it was quite easy – but will get back to the “live” later on

Here is the result – Notice that after round 1 no players from England is under par.

 

I was actually quite easy – Start the Power BI designer – (download here)

The leaderboard – http://www.usopen.com/en_US/scoring/index.html is used as a data from the Web.

 

Then a number of transformations, replaces and extra columns – I ended up with a clean table like this

Then I created some visualizations in the Report area

 

Saved the file locally and uploaded it to my Power BI account – via Get Data

Then we can create a new dashboard and start to add elements from the report to the dashboard.

 

The live issue

 

You can set a web datasource in Power BI to do a scheduled refresh

but the schedule can only be daily and you have to specify the credential type – in this case Anonymous

 

So unfortunately it won’t refresh every 5 min as the web leaderboard does L – If you use the Power BI API you can properly get around this but using these tools you have to do it manually via the refresh button for the Dataset

 

And now

 

You can QA the data as well if you activate the feature on the dashboard

 

And voila

 

 

Or

 

Pretty fun to analyze the data now.

You can download a copy of the Power BI Designer here

 

 

 

 

Analyzing POS data using the new Q&A function in Power BI

The Q&A feature in Power BI has so far been limited to the samples files provided by Microsoft – but now you can use your own models.

I have played around with the feature and here is the result. Click the picture to see a video of a demo.

I think it’s pretty awesome and will open up new possibilities for the BI users – It will be very exciting to try to see how the users will feel about this new tool.