My dashboard of unemployment in the U.S. is updated with data from January 2010.
I’ve added sparklines to the Demographic section in the middle of the dashboard. Now, rather than just seeing where unemployment stands this month for a particular demographic segment, you can see where it’s been over the last 12 months. The sparklines on the left side of the demographic section all represent the unemployment rate over the last 12 months. The sparklines on the right show the percentage of total unemployed each segment represents over the last 12 months. For example, a value of 25% in the “% of total unemployed” column for the “White Women” segment means that White Women make up 25% of all unemployed.
It’s interesting to see the huge drop, 9.5%, in underemployment this month. Check out the small chart in the upper right hand side of the dashboard. We went from 9.1MM underemployed in Dec to 8.2MM in Jan 2010. That’s the first big drop in underemployment in at least 12 months.
The long-term unemployed population, however, continues to grow. Another 200,000 Americans added to the pile of 6.1MM Americans who’ve been jobless for more than 6 months. Those long-term unemployed are equal to the entire population of Tennessee. The NYTimes had an indepth story on the long term unemployed, they call them “The New Poor.” You can find that story here.
New data from the Bureau of Labor Statistics will be released this Friday, the 5th, so subscribe to my blog and you’ll get an email notifying you when the revised dashboard is complete.
As always, your feedback is welcome.
Click on the image to enlarge.
If you’d like a beautiful 11 X 17, crystal clear pdf of my dashboard, click here.
BTW, this dashboard was done using Excel 2007.
