The season is rapidly approaching Christmas and if you’re anything like me, the panic has set in that your gut instincts and world-class football knowledge isn’t all that you imagined, and you’re handsomely sat in mid table of your leagues.
Don’t worry though, help is at hand! Using Alteryx, we can utilize the Advanced Analytics capabilities to make the decisions for us. Anybody who came along to Big Data London last month will have seen the first workings of this, but and we’ve now rounded out the Fantasy Premier League Tool category.
We have created The Fantasy Premier League Toolkit, consisting of three workflows and three macros. If you already have Alteryx, then you will simply need to download the workflows, open them in Designer and run. The macros will need to be saved to your macro folder (check out this article if you want to know how to do that).
Before going any further I should point out that this is aimed at improving your football/soccer fantasy team and therefore there may be some references which are a bit different to anyone used to American football! However, the workflows and methodology can be translated across to other sports.
For those not familiar with Fantasy Football; you are given a £100m budget and required to select a squad of 15 players consisting of 2 goalkeepers, 5 defenders, 5 midfielders and 3 strikers. You then get points based on how they perform in their individual games (Gameweeks) throughout the season.
How well has the model performed?
The big question is ultimately going to be how well Alteryx has been able to successfully select the Fantasy Dream Team. Will Alteryx as a football manager be able to class itself as the new ‘Special One’ or will we be falling into Paul Jewell’s elite level group (0% win ratio in 24 Premier League games)?
One thing to take into consideration is that our team, Alter.Formation, was only entered in gameweek (GW) 12, so we may have to wait until 2020 in order to win the overall league. Below is how we have fared vs the global average in the last three gameweeks:
GW 12 – 64 Points vs 48 Points Overall Average
GW 13 – 61 Points vs 49 Points Overall Average
GW 14 – 44 Points vs 51 Points Overall Average
A relatively good performance then! Here is how the Alter.Formation teams line up for Gameweek 15:
What has been created for the Fantasy Football Tool Category?
With the assistance of my colleagues @NickC and @meljaafari there are now three workflows available:
All of these workflows have been built as Analytic Apps; select the wand icon next to the run button, and that will bring up the app interface. It will ask you to fill in the questions before running your workflow. If you Run the workflow normally (with the run button or ctrl+R), it will keep the default values. Each of the workflows also contain a more detailed description.
How does it all work?
As well as the three workflows that have been created, there are also three custom macros that you can use. These are included within the main workflows, of course, but can be used and edited elsewhere!
If you want to know more about any of the workflows, or anything Alteryx related, then feel free to get in contact. Better yet, reply to this blog!
Please feel free to use these workflows to your own benefit and to go and adapt them and make them better! For instance, we have based our coefficient in the Optimization model solely on a players’ Total Score, you could start to incorporate the players’ fixtures, strength of team, etc., all within that coefficient.
Happy fantasy footballing!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.