Cricket Data – Alteryx Merge

A few weeks ago I saw the following tweet in my timeline.

I have previously interviewed Brian when he was still working in the world of professional sport for Bolton. Brian now works for the Information Lab who specialize in Alteryx and Tableau. In order for me to improve at Tableau I am always on the look out for free data that I have a real interest in.

CricSheet.org is a great source of freely available Cricket data. They have over 3,000 matches covering all formats of the game. The structure of the individual match files means you need to do a bit of manipulation (to each file) before you can merge and work with a large set of data.

So I asked Brian could he do something to tidy these files and merge the data.

Brian has but together a video of the full process here

And has very kindly made the data available here.

I was very impressed with how it all worked and how repeatable the whole exercise would be as more games get added. As a rule I find analysts spend too much time organising and sorting data rather than analysing it.

One Response

  1. Thomas E Hall August 2, 2017

Add Comment