League positions over time
Using comparison measures on the cube above we can compute the differences to the league position achieved a few years ago. The measure below shows the positional improvements cyprus mobile number compared to five years ago and has been sorted by best total improvement. We find that Plymouth, Bournemouth, Preston North End, and Burton Albion are the most improved teams.
The Apteco Datathon: 5. What is significant about East Anglian football?
If we looked at the other end, we’d find that supporters of Leyton Orient, Yeovil, and Tranmere Rovers certainly haven’t been in it for the glory recently!
Many football fans would be able to tell you about the teams that have remained in the top division of English football for the longest consecutive amount of time (Arsenal and Everton are the top two). It’s to be expected that the top division will have teams that have remained there for a long time since very strong teams just have to avoid being relegated. Teams that stay in one of the lower divisions for a long period of time are less likely, since they only have to have a good or bad season to be promoted or relegated. So, which team has remained in the second, third or fourth tier of English football for the longest? (Hint – it’s 16 years and the answer is coming up!)
We can answer this question using the Segmentation tool. This is a similar approach to the one we used in the World Cup blog post. In this case, we can use our domain knowledge of the football league fixture schedule to set the segment definitions to follow this pattern.