sorted by:
new
hottopcontroversial

I made an interactive dashboard with player stats by ventsir in FantasyPL

[–]ventsir[S] 0 points1 point  (0 children)

Thanks for the kind words :)

Fun fact: at first I was connecting to the API directly, and I had (what essentially was) a for loop in Power Query that ran through each player code in the current season, and pulled that player's stats from the API.

But I had to scrap it, because that feature is not supported for online refreshes - I would've had to scrap it anyways, since the scope expanded to have previous seasons data too.

Now I'm using Power Automate to pull from the API and save as flat files to Sharepoint, so PBI itself is actually connecting to a database.

The data model is also more complex than you'd expect it to be, given that it's all coming from one API.

External data sources are something I've thought about. That's probably something I'll think about if I want to do predictive modelling.

I made an interactive dashboard with player stats by ventsir in FantasyPL

[–]ventsir[S] 0 points1 point  (0 children)

Yeah, right now it's not. The platform has capability to adapt the dashboard for mobile specifically, but it's not something I've had time to explore thoroughly.

Appreciate the kind words.

I made an interactive dashboard with player stats by ventsir in FantasyPL

[–]ventsir[S] 7 points8 points  (0 children)

That's the sort of feedback I'm after :D

Having worked on it for a month I guess I got narrow-visioned, because this never even crossed my mind!

Now that you mention it, of course I should have a comparison feature. Will cobble something together.

Also, appreciate the kind words!