Fun with Old Newspapers, Part 2
Tableau Exercise With Crime Data
Topics:
—Crime and Dual axis charts
—Filtering
Chart 1:
–Jurisdiction
–Population
–Total violent crime
Look at the scales. which one will overwhelm? How to visualize? Stacked chart
Dual Axis
Average Line from Analytics
Rotate chart x,y axis
—beware, Don’t use violent crime rates. use the actual data for these exercises
Chart 2: Murder Filter
Jurisdiction
Total violent crime
Murder
–Drag murder to Filter, Sum
–Show filter
Questions:
Filter for area with at least 1 murder, List in Ascending Order. How many?
Filter for areas with no murders. How many?
Filter for areas with at least 10 murders. How many?
Average Murder Rate all areas. What is it?
Bonus:
Biggest area with no murders. Where is it?
Chart 3: Murder and Rape Filters
Which cities have a Rape rate of at least 50 per 100,000 and a Murder rate of at least 20 per 100,000?
Chart 4: Jurisdiction With Crime
Jurisdiction
All violent crime rates
—Murder, agg assault, robbery and rape
left click on measure values, show filter
—Murder, agg assault, robbery and rape
left click on measure values, show filter