Home Team dashboard

I’ve spent more time playing on dashboards, it appears the more time I spend the more options I want to include :). I decided to go with a Home Team dashboard.

You pick a League and a season and it gives you the home info.

If you select a Team you get the details

If we look at the games in details we can see that home draws are going to cost Liverpool.

You can look at the data across multiple season as well, here I selected 3 seasons and it gave me this data.

I’ve built quite a few dashboards now, I need to build the away dashboard next then I’m onto the predictive analysis stuff. I will then start to use R/Python to really push the data. The current Predictions stuff is not accurate enough yet so I’m busy building in some other variables.

Its amazing what you can add in and luckily with some of the variables I can retest all the previous results to see what effect it has. Some of the variables I cant use as I only have certain data points but going forward that will grow.

During my time on this side project it has made me realise the importance of collecting data, but not just collecting it but actually using it.

 

 

Working on the Prediction dashbord

A new dashboard has been added, this time it based on real football and it includes Predictions 🙂

This one allows you to select a home team and an away team and you can see stats based on that fixture. In the example I selected ‘Manchester City’ and ‘Newcastle’. Looking at the stats its going to be a home win.

 

It has also been predicted as a home win 67.74%. The predictions are still being tested as I have changed the algorithm a lot this season.

The stats in the tiles are based on historical fixtures between the 2 teams. Currently I’m using all data but I will modify this once I see how relevant all the data is.

If we change the teams to Arsenal/Palace we can see at one point this would have been a guaranteed Home win. But recent form shows a different story. The Prediction is 60.78% for a home win but I think it might be a draw.

if we use the players dashboard we can see it might be closer.

After this weeks games I will be doing some more analysis before I update all the data.

Watch out for another post coming out very soon.

Power BI and Fantasy footy data

The joys of data and hopefully some useful insights 🙂 Here is my latest dashboard on the Fantasy Footy Data.

3 week diff

This charts shows the data when you look at it over a three week period. The purpose of this data is see in form players, but by looking at three weeks it shows more analysis than looking at a single week. It shows the data in the following way:

  • Data by teams
  • Data by players
  • Data by position

It can be filtered by team or cost band.

 

Goals & Assists

These charts are showing goals and assists by players. It is the same format as the last chart. Interesting you can see that only two teams have not ahd a defender score and Chelsea have 11 goals from defenders.

Quadrant

This chart is showing goals and assists per minute played. The size of the bubble is total points. Bottom left quadrant is the one to be in.

This can be filtered by position.

If we zoom in we can see the stats for Mo Salah.

Drilldown

The drill down capabilities shows us the records which makes up the charts, if we right click on Chelsea and DEF we can see who has scored.

 

Drill down records

The records are showing us that Alonso has scored 6.

 

The purpose of these charts is to help me select which players do I bring into my team.

I will be posting once a week from now as we in a position when the data is flowing and we are seeing some good insights.