“A computer lets you make more mistakes faster than any invention in human history, with the possible exceptions of handguns and tequila.”

Mitch Ratcliffe

March 7 Class

Join Tables In Tableau

We are going to join the 2014 and 2010 crime tables to track data trends over time and visualize them in Tableau. You will then compare this to the national trends. You will then write a story pitch based on this data.

Skills you will learn including joining tables and creating calculated fields within Tableau. The calculated fields trick is significant since you are using Tableau for your calculations instead of relying on Excel.

Joins:

Inner Join
Outer Join

ARK 2010-2014 Crime Data-Tableau-Feb22

1) Know how many rows you have in the tables you will join
Look at the 2014 only data in Tableau Data Source
Look at the 2010 only data in Tableau Data Source

2) Inner Join
What is the common field for the join of these two spreadsheets?
Agency

3) Which cities saw increases in violent crime between 2010-2014?
Agency to row
2010 violent crime to columns
2014 violent crime to columns
Dual axis chart
Side by side bars

4) Create a calculated field and visualize it.
How calculate the difference between the 2014 and 2010 violent crime totals

2014-2010

Step A: Start with the 2014 Violent Crime total

Step B:

Build the calculation Subtract the 2014 Violent pill from the 2010 violent pill

Assignment – 100 points

Using the method described above of creating calculated cells
Calculate the difference in overall murder in Arkansas localities between 2010 and 2014.
Visualize this in Tableau

Calculate the difference in murder RATES in Arkansas localities between 2010 and 2014
Visualize this in Tableau

Do the same with Total Property Crime, and Robbery

You will produce four charts:
Difference in overall murder in Arkansas localities between 2010 and 2014.
Difference in murder RATES in Arkansas localities between 2010 and 2014
Difference in robbery in Arkansas localities between 2010 and 2014
Difference in property crime in Arkansas localities between 2010 and 2014

Based on these charts, write a story pitch — 250 words.

Create a blog post, embedding these four charts to illustrate your story pitch, and post on WordPress by 11:59 pm Sunday March 12.