Fantasy Football League 10-20-2016 23:11 PM

[theBIbutler]

Hi,
 
First go at this, some colleagues and I are in a couple of Fantasy Premier League Football leagues, I put together this report to keep track of the competition and to promote some 'bants' in the office 

 
We did the same last year, but the dashboard was in Tableau (sorry bad word!) Happy with the way it's turned out in Power BI!!
 
Cheers
 
Mark
 
P.S. I won last year as is fitting for the Analytics bloke in the office!!

eyJrIjoiNTBhNGMwOGUtNzMyNy00NzVmLTk5N2QtMTdiMTRkZGUwODI3IiwidCI6IjlkMzQ4NzUyLWI5YWMtNGI1OS1iY2YzLTgwMTQxMjZlMDExNyIsImMiOjh9

[berntmagne]

when connecting to api and the classic league data, how did you manage to authenicate your self/sign in? 

I can't figure out how I can authenticate so that I get some of the api data the requries you to sign in

[watsonneil]

I don't supose you'd share the template with the links to the API? I need to do this exact thing myself and can't work out how to parse the JSON etc?

Cheers

Neil

[theBIbutler]

Hi Neil,

Wow, this is going back a bit!

I've attched the original .pbix file, might help you out?

Cheers

Mark

[watsonneil]

Thanks Mark!

[osoosh]

Nice one! the butler did it needs to improve next fixture!I'll have Ozil in, he might assist you some points.

[theBIbutler]

Cheers Mate.

Ozil is tempting after that hattrick....will keep an eye on him 

I had a slow start last year too, just need an Aguerro 5 goal haul to pull it back!!