Using Alteryx & Tableau to Visualize London Crimes by the Square Mile

At the Data School, more often than not when Alteryx needs to be taught, I bring in people way better than me. Last week though, I wanted to give teaching spatial analytics a go. I'd been practicing with some exercises, felt like I was improving, and wanted to test my learning by teaching. If you don't know me, then it's important to understand that I am a massive believer that teaching a topic is the best way to learn it.

One of the exercises we went through was taking two data sources, one with shapes and one with points, and creating a grid map. This requires the following as my workflow below demonstrates:

1. Import shape files for each London borough
2. Create 1x1 mile grids within each Borough (which turned out really cool because Alteryx accounts for the edges of each Borough)
3. Import the London crimes data
4. Create spatial points from the latitude and longitude fields
5. Use the spatial match tool to determine the Borough in which each crime occurred
6. Summarize the crimes
7. Export as shape files
8. Import into Tableau