It's Wednesday morning; your manager comes into your office and says that they want to check the red-light violations of the last year in Chicago. They are very busy and ask you to build a dashboard for them. In particular, they want to know where the most violations happen and whether we see trends over the last year. They give you two datasets: one with the camera locations and one with the violations and leaves. They come back and add, I need this within the next hour. What do you do?
First, make a quick plan on how to approach this problem. Take five minutes, think about the steps you would take, and sketch a dashboard design.
Here is an overview on how I would do it:
Tableau Prep > descriptive analysis ...