April 22, 2016
Analyzing 63 Months of Crimes in London with Alteryx & Tableau
I’m beginning to think Tom Brown might actually think I know what I’m doing. Last week he threw a challenge at me for fire data. Today, he told me about a data set he had of 63 months of crime data in the UK. His requirement was simple: build a viz. Easy enough, until he showed me the data. It was split up into 2899 CSV files in multiple directories.
This is where our good friend Alteryx comes in. In Alteryx all I had to do was use one input tool and tell is to scan all subdirectories. After that I had a tiny bit of cleanup and I was done. Seriously, about 10 minutes of work.
Awesome! I now had a data set of almost 32 million crimes across the UK. But I needed it to be fast and I needed to be able to publish it to Tableau Public. This meant limiting the data set. So I created a group for the London boroughs and filtered my extract to just those. Cool, now only about 5.5 millions crimes.
From there I simply played with lots of vizzes to see if we could find any stories. The end result is the viz below. It’s amazing what you can accomplish in under 2 hours with Alteryx and Tableau. I love it!