Geo-spatial analytics with Chicago traffic violations

It's Wednesday morning; your manager comes into your office wanting to check the red-light violations of the last year in Chicago. They ask if you can build a dashboard for that purpose. In particular, you're asked to highlight where the most violations happen and whether there is an overall trend in Chicago traffic light violations over the last few years. You are given two datasets, one with the camera locations and one with the violations, and told that the dashboard is needed within the next hour. What do you do?

Before you continue reading, think about how you would approach this problem. Take five minutes, think about the steps you would take, and sketch a dashboard design.

The following is an overview of how I would do it:

1. Open the datasets in Tableau Prep Builder
2. Join the two datasets
3. Clean the data if needed
4. Open the output in Tableau
5. Use a map to visualize the locations...