Over the last few months I have been creating Fantasy Football data flows using Azure which allows me to automate the data flows. This has enabled me to start looking at what data is important. I’ve been concentrating on the Transfers just lately. So here is a Power BI dashboard which shows almost real time data (Data captured every 15 minutes)
In this dashboard I have the ability to look at various pieces of data:
- Transfer data. This allows me to see how big a player is expected to be in the coming game week.
- Goals and assists for those players. I can select the game weeks so I can select what I believe is the right amount of weeks to go back over, 3 to 6 appears to be the ‘good zone’.
- Remaining games details.
The actual Transfer section starts off at the team level then you drill down to players.
I love the capabilities of Power BI to drill down like this, it really gives you some options.
The whole dashboard becomes the selection options. If I actually select Teams or Positions only the data which meets that criteria will be shown, if I select something on the charts the rest stays there but looks opaque. Here I have selected Harry Kane as he wasn’t high up the charts for scoring/Assists.
The final part allows me to see the fixtures. Now this could be an interesting selection to highlight. Over the years I have observed that the first 6 and last 6 games of the season throws up the biggest surprises. Take this season, West Brom have beaten Man united and drew with Liverpool in the last few weeks, and they are in the relegation zone. Spurs have West Brom so I suspect that the players who are bringing in Harry Kane expect a big return, but could there be surprise.
I still have a lot of data to blend to get me to where I want to be, but I’m building up some good history, this at least gives me a good place to start.
Having the historical data allows me to change calculations and then apply the new settings to see what happens.
Roll on next season 🙂