![]() ![]() Tools used: Text to Columns, Dynamic Rename, Select, Record ID, Transpose, Filter The first part of the workflow involved cleaning up the original data set with all information stored in one field with comma separated data. The key part to this was to get each result on to 2 separate lines, so that you could analyse the performance of each team individually when this would be fed into the model. The data was sourced from a GitHub repository which contained all the results for the current season. As you can see from the screenshot beneath, this was split up into 6 sections/macros, with each macro representing one of the teams pushing for the playoff positions and the trophy at the end. However, the big success for me was how quickly I was able to build a Data Science framework within Alteryx and a platform to help me progress in any future sporting prediction endeavors. That being said, when diving into all the predicted results, the accuracy does start to fall somewhat. Overall, the model was a success, it correctly predicted the teams who would finish 1 st and 2 nd and get promoted automatically, as well as the 4 teams who are now going to compete in the playoffs over the coming weeks. The purpose of this was really to see what was possible to achieve in Alteryx when I had half a day spare, a hypothesis and a real passion that I could quantify in data. At the time of creating the model, Reading sat in 6 th place and then proceeded to fall out. In this league, the top 2 teams will go up automatically to the Premier League, whilst those that finish 3 rd – 6 th go into the playoffs to compete for the 3 rd spot in promotion. For those who are not familiar, Reading currently play in the EFL Championship which is the division beneath the Premier League. I was devastated, the model successfully predicted that they would finish outside the playoffs in 7 th position and end the season early for me and all other Reading fans. ![]() I am a big football/soccer fan and five weeks ago I took on the challenge to see if I could predict whether the team I support, Reading FC, would make it into the playoffs to hopefully ease my nerves for the remaining league games. Hello and welcome to the first blog post to follow on from my new video series, Will's Weekly Wonders, where I look to take data from my own personal life and interests and explore what is possible to do with it in Alteryx.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |