Ministry of Manpower Unemployment Dashboard in Excel

Posted by on Thursday, September 17, 2009 · Leave a Comment 

MOM’s website (www.mom.gov.sg) contains a wealth of labor data. An example is on unemployment rates in Singapore. I took two sets of data: Unemployment Rate (Seasonally Adjusted) & Resident Long-Term Unemployment Rate (Non-Seasonally Adjusted).

They look like this. As individual charts, they may not present a strong overall picture.

Ministry of Manpower Unemployment charts

I redesigned the presentation into a dashboard using Excel 2003. You can download a copy here: Excel Productivity Cafe Files.

The effect of a well designed dashboard is you are able to survey more data in a glance, and make quicker assessments for faster decisions. I did this dashboard in 20mins, you can do it too.


Learn more about Creating Dashboards in Excel.

Related posts:

  1. Drive your business with a dashboard in Excel What if there is a dashboard that puts you in the driver seat of your business instead of being drowned by numbers? What if you...
  2. How to design a Sales Dashboard in Microsoft Excel Sales activity is the life blood for all businesses.  People who are responsible for sales must have their fingers on this vital pulse at all...
  3. If you can measure it, you can definitely dashboard it! Dashboards can be used to show important KPIs (key performance indicators) for all sorts of industries and work processes. If you can measure it, you...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

android-10b-excel

Google officially announces 10 billion app downloads in Excel

Dec 08, 2011 | Discuss

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. [...]

Continue Reading

3D Setting in Excel Charts

Do it in Excel: Ring charts are better Pie charts

Sep 11, 2011 | Discuss

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801. Pie charts are simple to understand but rather limited because: 1. Can only show a single data series. 2. Can only show [...]

Continue Reading