A History of the North London Derby in the Premier League

I really liked the learnings that I got last Friday from Rhiannon Fox and the cricket viz I ended up creating. It got me to thinking about other data that I could use with a similar visual display to continue practicing what I learned. Arsenal was preparing to play London rival West Ham on Saturday while I was watching my son skateboarding, so I thought I’d create something comparing Arsenal with their biggest rival, Tottenham Hotspur.

I was able to quickly get all of the results from Wikipedia, which I then imported into Google Sheets and then connected to Tableau. I showed a couple of iterations to Gwilym this morning at the Data School to get his feedback and we agreed that displaying goal difference was the most effective display. In addition, I added dots to indicate the winner. The goal difference display helped show the ebbs and flows of the rivalry way better than showing the goals scored by each team in each match as a diverging bar chart.

Click on the image for the interactive version. Does this display work for you? What might you do differently? Leave a comment and let me know or, better yet, download the workbook, iterate on my design and leave a comment with a link to your version. Enjoy!