Skip to main content

Crime in Detroit Analysed using Tableau

The Tableau dashboard published is used to analyze Crimes in Detroit.
Raw data taken from Public domain data published to City of Detroit website: https://data.detroitmi.gov/Public-Safety/DPD-All-Crime-Incidents-2009-Present-Provisional-/b4hw-v6w2

The Report has two Dashboards
A. Crime Listed by Year, Council and Neighborhood/Address
B. Count of Crime over Time colored by Crime category (with Analytics)

Dashboard A: Crime Listed by Year, Council and Neighborhood/Address has the following components/Viz:
A1. Count of Crime over Month-Year
A2. Crime by Neighborhood and shaped by Council for the selected Month-Year
A3. Detailed Crime Count by Crime-Spots in selected Neighborhood above

Dashboard B: Count of Crime Analysis by Category
B1. Box and Whisker plot of the Census, colored by Category over Council on X Axis
B2. Filled Area chart for different Neighborhood over distinct Crime Spot Count (X Axis) colored by Category
B3: Count of Crime over Time colored by Category

Interactive report published to tableau public and embedded below

Comments

Popular posts from this blog

Retail: Shipping Time Analysis using Tableau

This report is based on the calculated field called Shipping Time, where 'Time to Ship' formula is as below: The two charts 'Ship Time by Year' and 'Ship Time by Month' are a Filled Area map of the - Number of Orders (Y Axis) - Days to Ship (X Axis) Colored By - Year - Months The 'Timely Shipment' chart is colored by whether 'Ship Mode' is 'Early', 'On-Time' or 'Late' Based on a business Logic per formula below: The report below is interactive using Dashboard Action filters.  Uses OOTB retail data that comes with Tableau installer.

Tableau Fiscal Calendar Dynamic Choice

Created an example, where User can choose the starting Month and the report dynamically updates to show corresponding Fiscal Months, QTR and YR

Canada FSA Code Filled Map inTableau