Why viz…?
At first glance, you’re probably thinking I made a spelling error in the title for this blog. The truth is I am going to attempt to create a viz that displays some insights into the data I organized in MySQL.
Problem 1: Tableau is really fun to use… There were so many different possibilities for displaying the data. At first, I started with a map, and then I started to drill down on the neighborhood with the highest number of incidents over the course of the four-ish years, Westwood.
Problem 2: The dataset I used was linked through MySQL account. I was able to view the data without issue, until I viewed the data for 2018. I had to change the count from “count distinct” to “count” to get the correct number of incidents, which is strange because I modified the EVENT_NUMBER id to ensure each primary key id was different. Well, I drilled down to the hour in search of this miscellaneous tuple that was causing this issue and gave up because there were 200ish tuples. I might find this problematic tupule at a later date.
The fruit of my labor is shown below.
You can view this viz on my tableau public account: https://public.tableau.com/shared/69ZFDJ2HH?:display_count=yes&:origin=viz_share_link. Thank you for reading and please feel free to leave any comments.
Here is a link to the code I used to check my calculations in SQL: https://github.com/sterlingn/Cincifiredeptanalysis/blob/master/CalculationsCheck.sql
~Nate Sterling
Follow me on Twitter: @n8_sterlingdata
DateA Set 