Tag Archives: business intelligence guru

200+ things you need to know about unemployment in the US, all presented on one insightful dashboard

There are 208 charts on the dashboard below. Each one is loaded with information from the Bureau of Labor statistics. Check it out, you’re bound to learn something you didn’t know before you came here.

The unemployment insight dashboard is now updated with May’s unemployment figures from the BLS. The unemployment rate dropped from 9.9% to 9.7%, in part due to the fact that approximately 200,000 people stopped looking for work and stopped being counted by the BLS as unemployed.

The long-term unemployment population, those out of work for 6 months or more, grew by an additional 47,000 people and account for 46% of all unemployed. That’s the equivalent to all the people (men, women, and children) in the entire state of Washington.

Note: click the picture below to bring up a large version. Then click again to get a crystal clear look at the dashboard.

Dashboard of Joblessness in the U.S.-May 2010

What everybody ought to know about unemployment in the U.S.

The unemployment insight dashboard is now updated with April’s unemployment figures from the BLS. While the unemployment rate is essentially unchanged, the nasty trend in the long-term unemployment continues.

The numbers for April show the long-term unemployed group grew by another 200,000. Now, more than 6.7MM Americans, that’s the equivalent to the entire state of Washington (men, women, and children), have been jobless for more than 6 months. This population now accounts for 46% of all unemployed.

Also, if you’re wondering why the unemployment rate increased despite the fact that the number of people who found new jobs increased, a good explainer can be found here, at the WSJ blog.

In my update last month I said I’d try to get more insights about the long-term unemployed. It turns out there’s a fair amount of information for this group, but the data are updated annually, not monthly. Nonetheless, in the coming weeks I will generate some supplemental posts analyzing the long-term unemployed from the new found data. Until then, here’s a link to a story about the long-term unemployed in the Huffington Post.

I welcome your comments, both positive and negative. I especially want to hear your thoughts on improving this dashboard. In particular, I’m considering getting rid of and/or dramatically altering the bar chart on the left side of the dash showing the number of un/underemployed Americans. I think the scaling of the chart makes differences in the blue bars hard to pick up, I also don’t like the lack of context in the chart. Perhaps indexing it to 1 year ago might be better.

If you’d like to print out or save a copy of a beautiful, high-res, 11 x 17 pdf version of this dashboard, just click here.
Dashboard of Joblessness in the U.S.-April 2010

Unemployment Insight Dashboard for March 2010 shows troubling trend in long-term unemployed

This month’s update shows continued growth in the long-term unemployed population who now number 6.5MM. That’s an all-time high and equivalent to the entire population of Arizona (men, women, and children) being out of work. What will it take to start seeing reductions in this group? Have their jobs disappeared for good? In the coming weeks I will try to answer these important questions by working with the Bureau of Labor Statistics to see if I can get more granular data about this population. Until then, you can find a good story about the long-term jobless here.

In addition, the industry section on the bottom right side of the dashboard shows many industries reversing the trend of increasing weekly work hours. For the last couple of months this section has been filled with blue bars showing growth, but this month, most of the bars are gray, showing contraction in average weekly hours of production. What does this mean?

I welcome your comments, both positive and negative. I especially want to hear your thoughts on improving this dashboard. In particular, I’m considering getting rid of and/or dramatically altering the bar chart on the left side of the dash showing the number of un/underemployed Americans. I think the scaling of the chart makes differences in the blue bars hard to pick up, I also don’t like the lack of context in the chart. Perhaps indexing it to 1 year ago might be better.

If you’d like to print out or save a copy of a beautiful, high-res, 11 x 17 pdf version of this dashboard, just click here.

Dashboard of Joblessness in the U.S.-March 2010

My Unemployment Dashboard ranks #1 in Google search. See why.

It’s taken me about 5 months to get there, but thanks to your help, my award-winning Unemployment Dashboard ranks #1 according to Google. I also rank #1 for the words, ‘Unemployment Insights’. I suspect the postings featuring my dashboard over at chartporn and vizworld have helped quite a bit. Thanks Chartporn & VizWorld! BTW, if you haven’t checked out either site, you should, they are filled with many excellent visualizations.

There’s a lot going on this month in the industry index section on the bottom right hand side of the dashboard. Many industries are seeing strong and continued growth in the amount of hours their employees are working. Expansion in these figures is a leading indicator of hiring down the road. In addition, to provide you with a bit more context, I’ve expanded the time horizon on the industry index section from the last 6 months to the last 12 months.

Something else I noticed this month is the divergence between the unemployment rate and underemployment rate (upper left-hand chart). The unemployment rate held steady, but the underemployment rate rose 1.8%, from 16.5% to 16.8%. That’s an additional half-million underemployed Americans. If you’d like to bone up on the difference between underemployment and unemployment, check out this link.

One other point worth noting is this month’s decrease in the percentage of long term unemployed. For only the second time this year, the percentage of those unemployed for more than 6 months fell. Granted, the decrease was very small, .3% or 50,000 workers.

I welcome your comments, both positive and negative. I especially want to hear your thoughts on improving this dashboard. In particular, I’m considering getting rid of and/or dramatically altering the bar chart on the left side of the dash showing the number of un/underemployed Americans. I think the scaling of the chart makes differences in the blue bars hard to pick up, I also don’t like the lack of context in the chart. Perhaps indexing it to 1 year ago might be better.

If you’d like to print out or save a copy of a beautiful, high-res, 11 x 17 pdf version of this dashboard, just click here.


Dashboard of Joblessness in the U.S.-Feb 2010

Unemployment insight dashboard for Jan 2010 shows 41% of all unemployed, 6.3MM people, out of work more than 6 months.

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.

Dashboard of Joblessness in the U.S.-Jan 2010

Thoughts on “7 Rules for Dashboard Design” post on Dashboard Insight

This post addresses a post on Dashboard Insight’s site titled, “7 Small Business Dashboard Design Dos and Dont’s”

Hi Stacey,

I read your post with great interest, after all, who wouldn’t like to know the 7 rules of dashboard design? As soon as I got to the 19th word of your post, “colorful” I knew that we’d have some interesting differences in our viewpoints.

So let’s start with how you define a dashboard. I agree with most of your definition, especially the part about face-smacking insights. Certainly a useful dashboard should provide the reader with insights. But does a dashboard need to have “gorgeous colorful graphs?” I think not. In fact, if the dashboard designer uses too many colors in their graphs, they can kiss those face-smacking insights goodbye. I think it would be better to say that an insightful dashboard needs color use to be, restrained. The designer needs to be sparing with his/her use of color so that when color is used, the reader’s eyes are immediately drawn to the thing that the designer is emphasizing. Use color everywhere and it becomes meaningless.

I agree with your rule #1 (start with a few key business metrics, don’t waste time collecting everything), and whole-heartedly agree with your rule #2 (use basic tools that you already have). In fact, I’d recommend that most people, beginners and experts alike, use the combination of Excel with XLCubed. XLCubed gives the designer the ability to create very small and crisp sparklines, microbarcharts, bulletcharts, and other useful graphics.

Rule #3 could be summed up as two rules. First, use simple line charts. And second, don’t try to compare things (this month to last month) on your dashboard, it’s never a good idea.

I’m all for simple charts, after all, most complicated charts are a result lazy design (exception is Napeloeon’s march). A good dashboard designer takes the time to ensure that his/her charts are almost instantly insightful. Complex, hard to read charts are almost never instantly insightful.
The second part of your rule #3, that is, don’t make two point comparisons, really surprised me. The most insightful dashboards I’ve seen are ones where the reader can instantly see if a critical measure is above or below last month, or last year, or if a measure is over or under forecast. For that, you absolutely have to compare two points. Further, check out Stephen Few’s bullet charts. They’re all about comparing two things, actual to forecast, test to control, this to that, and that to this. In fact, one rule all dashboard designers might want to follow is to ask themselves this question when including a measure on their dashboard, “Compared to what?” I got that one from Stephen Few.

Rule #4 about Pareto charts, I’m just not a big fan. Yes, the 80/20 rule is an important one to know about, but the actual Pareto chart violates your first rule of rule #3, it ain’t that simple. Dual Axes with a line and a bar on the same graph just isn’t all that intuitive. I agree with your second rule of rule #4, no pie charts, although some info viz bloggers are pushing back against that one, like Jorge Camoes here.

Rule #5, don’t go all Picaso on it. Agree. I agree too when you say ‘limit your creativity to use of colours,’ so long as you mean that colours should be used sparingly and to call out the most important things to monitor on the dashboard.

Rule #6, Monitor your dashboard weekly. Agree 100%. Monitor that dashboard. After all, if you don’t check it out to see how things are doing, what good is it?

Rule #7, Get help from someone who’s ok with Excel and charting, not from someone who’s selling you the software. For most BI vendors out there, I agree with your assessment.

I applaud your efforts to put down rules for small business dashboard designers to follow. And your points about well-designed dashboards helping business owners monitor their businesses is right on point.

Lastly, there’s a small and passionate community of dashboard designers on the web. You can find some great advice from Stephen Few’s website. He’s also published 4 excellent books about information visualization, one focusing exclusively on dashboard design.


John C. Munoz

The Best insights into December’s Unemployment figures updated Now in this award winning information dashboard.

Last month the BLS revised their November 2009 unemployment number from a loss of 11,000 jobs to a gain of 4,000. That’s the first monthly gain in two years.

But December’s data came in showing job losses of 85,000, with the official unemployment rate holding steady at 10%. The underemployment rate moved up slightly, from 17.2% in Nov. to 17.3% in Dec. The most disturbing trend I’m seeing in the numbers is the long-term unemployed, those people out of work for more than 27 weeks. This group of out of work Americans now accounts for 40% of all unemployed people , or 6.1 million people. This group has grown by 135% in the last 12 months. Getting these long-term unemployed back to work is going to take a very long time.

Download a beautiful, high-resolution 11 X 17 pdf version here.

Dec 2009 dash-large

Dashboard of Unemployment in the U.S.

Pie Charts and faulty analytics in the NYTimes? Watch as the Biz Intel Guru fixes a seriously flawed blog post.

“Is Amazon Working Backward?” That’s the title of NYTimes blogger Nick Bilton post on Dec 24, 2009. Mr. Bilton is writing about Amazon’s product, the Kindle. Regarding the Kindle, he writes, “customers aren’t getting any happier about the end product.”

The day Mr. Bilton posted his story, best-selling author Seth Godin poked holes in it. Mr. Godin’s post is titled, “Learning from bad graphs and weak analysis.” Below is a brief listing of the serious flaws in Mr. Bilton’s approach. The listing is a mashup of Mr. Godin’s thoughts and mine.

1. Bilton should know better than to use pie charts because it’s really hard to determine the percentages when we’re looking at parts of a circle. Bar charts would’ve been much better. Stephen Few has stressed this for years. If you’re posting a chart in the NYTimes, you’d better have read your Stephen Few and Edward Tufte.
2. When your charts are the main support for your story, you’d better get them right. Mr. Bilton did get the table of numbers to the left of the pie charts correct. Perhaps he’d be better served by relying on them over the pie charts to make his point.
3. When you’re analyzing something, you shouldn’t compare opposite populations while ignoring their differences.

Mr. Godin cited 4 specific problems with the piece, ranging from the graphs being wrong (later corrected) to Bilton misunderstanding the nature of early adopters. In addition, Mr. Godin writes, “Many of the reviews are from people who don’t own the device.” Obviously, it’s hard to take a review of a Kindle seriously if the reviewer doesn’t own a Kindle. These are the different populations I’m talking about in item #3 above. I’ll address some of Mr. Godin’s concerns with Bilton’s post now and fill in some of the gaps that Godin left to be filled.

Mr. Bilton tried to make the case that each new version of the Kindle is worse than the one before it. His argument is based almost exclusively on the pie charts below, specifically, the gold slices of each pie. The gold slices are the percentage of one star reviews (lowest possible) each Kindle receives.

Here are the original 3 pies that Mr. Bilton showed in his post.

Despite difficulties in estimating the size of each slice in a pie chart, it is apparent that the 7% slice in the first pie chart is much larger than 7%. His corrected version is here.

Another problem Godin has with Bilton’s piece goes to the nature of early adopters. “The people who buy the first generation of a product are more likely to be enthusiasts,” writes Godin. The first ins are more forgiving than the last ins. I can’t really argue with that insight. My brother, an avid tech geek, is an early adopter of lots of tech gadgets. He was the first person I knew to buy an Apple Newton. I don’t recall a single complaint from him about the Newton, despite it not being able to recognize handwriting, which was its main selling point.

Mr. Godin’s claim that many of the reviewers don’t own a Kindle intrigued me the most. If I could quantify the number of one star reviewers who don’t own a Kindle then I could show the difference in one star ratings between the two groups, owners and non-owners.

I recreated the dataset that Mr. Bilton used for his analysis, 18,587 reviews in all. I also read up on how Amazon determines if a reviewer is an “Amazon Verified Purchaser.” Basically, Amazon says that if the reviewer purchased the product from Amazon, they’ll be flagged with the Amazon Verified Purchase stamp. So let’s see, do the one star ratings vary between the Amazon Verified Purchaser reviews compared to the non-Amazon Verified Purchaser reviews? Why yes, they do!

Amazon Kindle one Star reviews

Amazon Kindle 1 Star reviews

It’s clear from these charts that the reviewers who didn’t purchase a Kindle are much more likely to give a one star rating compared to the reviewers who Amazon verified as purchasing the Kindle. With each Kindle release, the non-verified Kindle owners were consistently four times more likely to give a one star review than the Amazon Verified Reviewers—the ones who actually purchased a Kindle. What’s up with that?

Let’s look at the reviews from the verified purchasers. The percentage of one star ratings each new Kindle edition receives doubles from 2% with Kindle 1, to 4% with Kindle 2, and then moves up to 5% with KindleDX. However, this evidence provides very weak support for Bilton’s claim that Kindle owners are getting progressively less happy.

What about the reviewers who are happy to very happy with the Kindle, the four and five star reviewers? Once again, the non-verified Kindle reviewers provide consistently lower ratings than the reviewers who actually own a Kindle. And once again we see the trend of the non-verified reviewers liking each new version of the Kindle less than the previous one. The four and five star ratings for actual owners of the Kindle jibe with Mr. Godin’s claim that the early adopters are more likely to be enthusiasts than those late to the game.

4 & 5 star Amazon Kindle Reviews

Four & five star Amazon Kindle Reviews

So there you have it, Mr. Godin’s hunches are correct!

What’s most interesting to me, though, is the fact that 75% of reviews of the Kindle aren’t made by people who own a Kindle. On my next post on this subject we’ll hear from a good friend of mine, and text mining expert, Marc Harfeld. We’ll mine the text of the 15,000 customer reviews looking for differences in the words used between the verified and non-verified Kindle owners. Perhaps that will shed light on this mystery. We’re also going to weight the reviews by the number of people who told Amazon that they found the review helpful. You’d think that a review that was helpful to 1 out of 3 people is different than a review that was found helpful by 18,203 out of 19,111 people, like this one.

Lastly, we’d love to hear suggestions from you on other next steps we might take with this analysis.

Thanks for reading.

November’s Real unemployment above 17% and 27 million Americans out of work, but there are bright spots. My dashboard shows you where things are starting to improve.

My award winning dashboard is at the bottom of this post

Last month real unemployment stood at 17.2% and 26.9 million Americans were out of work.

Right now I hear my savvy readers saying, “Wait a minute! The unemployment rate is 10%, and only 15 million Americans are out of work.” To you I say, ‘yes’, that’s one way of looking at things. In fact, there are at least five ways to look at the unemployment rate. That’s because the Bureau of Labor Statistics reports unemployment 5 different ways. The official unemployment number is reported in their U-3 statistic, which they adopted as the official rate in 1994. Before that, the official statistic was U-5. Here’s a link to a pdf from the BLS detailing the history of their different ways to measure unemployment.

The U-3 statistic includes unemployed people 25 years old or older expressed as a percentage of the civilian labor force ages 25 and up. It doesn’t include “discouraged workers”. Discouraged workers are people who want to and “be available for work and have searched for work in the prior year, even though they are not currently looking for a job because they feel their search would be in vain.” I wonder if all the out of work autoworkers in Detroit who lost their jobs a year ago are measured in the U-3 statistic.

Moving to U-5. The U-5 measure includes the “marginally attached” workers, those people who have given up looking for work for reasons like child-care or transportation problems. These people could take a job if other things happened, like they got day care, or could catch a bus or a train to work.

Last, but not least, the U-6 indicator. It represents the people in U-3 through U-5 plus all people working part time for economic reasons, aka, underemployed workers. Here’s a quote from the paper from the BLS that I site above, “U-6 provides the largest conceptual break with the official measure of unemployment; it is expected to be useful to those who want a single measure to represent a general view of the degree to which existing and potential labor resources are not being utilized.” I like to start with that figure to help get things into focus and perspective–27MM out of 156MM Americans are out of work or working part-time and are underemployed.

The November update is showing lots of interesting things going on with the long-term unemployed (27 weeks or more). Also, be sure to check out the Industry section on the bottom right side of the dashboard where things are changing fast. Seventy percent of industries covered in the section reported an increase in weekly hours of production for November. Here’s the trend for the percentage of industries (there are forty reported by the BLS) seeing an increase in hourly production over the last 12 months, industry_bar. All of the statistics I report are seasonally adjusted, so this isn’t a pre Christmas bump.

Download beautiful, high-resolution 11 X 17 pdf version here.


October’s Real Unemployment nears 18%, over 25MM Americans jobless. Oddles more insights in this award-winning Dashboard

My dashboard is updated with October’s unemployment data.

I’ve found some interesting commentary about October’s non-seasonally adjusted numbers in the business section of the NYTimes, by Floyd Norris, here.

Click on the image for a larger version.

Unemployment in the US, Oct 2009

Unemployment in the US, Oct 2009

Reblog this post [with Zemanta]