Campus Crime Rates

Sweet mother of Abraham Lincoln, this one was difficult. The FBI crime statistics had to be pulled up one year at a time, and came in the form of massive files with data for approximately 600 colleges each year. I had to merge 2008-2011, create some new fields that generated results so I could get rate per 1,000 students (instead of absolute number of crimes), and generally do a ton of work you won’t see in the final product.

Which is this:

http://public.tableausoftware.com/views/CampusCrimeRates/Dashboard1?:embed=y

 

Enjoy!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s