Friday, September 16, 2011

U.S. Unemployment Rate Viz

I decided to try entering the Tableau Viz contest and since we needed to use a public data set, I was curious about looking at unemployment rates in the United States.

I know the economy has been tough for everyone lately and I wanted to see how unemployment rates stack up by state and for the U.S. as a whole. I pulled data for the last ten years from the U.S. Department of Labor. They have lots of fascinating data to analyze. It was hard to pick which data set to use!

I compared the annual average unemployment rate for the entire United States against state unemployment rates. I included the historical high and historical low unemployment rates to compare against July 2011 unemployment rates by state.

Some highlights:
  • Nevada had the highest unemployment rate (as of July 2011) at 12.9%.
  • California had the second highest unemployment rate at 12%. Not promising for my state! 
  • North Dakota had the lowest unemployment rate at 3.3%. Looks like it's time to move to North Dakota!! 
  • The last two years (2009 and 2010) have seen the highest spike in the U.S. annual average unemployment rate (looking at the last ten years). In 2008, the U.S. was at 5.8% and then jumped to 9.3% in 2009 and then 9.8% in 2010. It remains to be seen what the annual average for 2011 will be, but it doesn't look good so far.
  • Highest historical unemployment rate belonged to West Virginia which had an unemployment rate of 18.1% back in March 1983. Wow!
  • Lowest historical unemployment rate (2.1%) belonged to Connecticut and New Hampshire in Oct 2000 and May 1987 respectively.
In conclusion, things may look bad now, but we're not in the worst state we've ever been. Hopefully the unemployment rate will start to drop in all states.

Play around with the data, compare states against each other and compare them against the U.S. annual average unemployment rate.

Try clicking on the states on the map to filter; hold down Ctrl to select multiple states. This will update the Unemployment Rate Trend by State and the data table.

You can also enter states in the dialog box on the right. Use the sliders to filter states based off the July 2011 rate, historical high, and/or historical low unemployment rates. Then click on the bubbles on the state map to update the Unemployment Rate Trend by State and the data table.


For a direct link to this viz, go here.

Special thanks to Alex Kerin from Data Driven Consulting for a better U.S. map that includes Hawaii and Alaska - really helped for this data viz!

Friday, September 2, 2011

Helpful Articles

Here's a list of useful articles I've found perusing various websites, blogs, tweets, facebook statuses, etc. The amount of information available is incredible. So much to learn when it comes to data!  Enjoy!

1)  How To Use Facebook To Market Your Brand - Social media isn't the future. It's the present and those who utilize it well have a huge advantage. Marketers already know this.

2)  Data driven: Improving Business and Society Through Data - How is data changing the world? Special section from Forbes that focuses on the impact of data.

3)  How to Visually Improve Your Meetings - We all have meetings we'd rather not attend ... how can we improve them?

4)  The Interconnected World of Tech Companies - This is such a sweet infographic! Tech is connected in many more ways that you can imagine.

5)  The Org Charts Of All The Major Tech Companies - A funny look at how the top companies are organized ... do you think it's accurate?

The Fab Five Viz

Here's a viz I created using Tableau Public.  An easy tool to use that helps you find insights from your data faster.

Try creating a data viz and enter the Public Data Contest. Would be amazing to win a free trip to Vegas!

Data Cake

This is such a great metaphor for all those who love and interact with data.  What do you think?

Thanks to!
data cake
Image by EpicGraphic