Tuesday, September 29, 2009 - We are pleased to announce the winners of the 2009 Excel Dashboard competition.

Thanks to everyone who entered, and congratulations to our winners, below. Please click on the respective link for more detail on each of the winners:

1. Ajay V Singh - Operations Dashboard for a Debt Collections Company.

The target audience are the CXO level execs of the business, aiming to provide a view of all the nerve points of the organization in a single unified interface that is portable and yet comprehensive.

2. John Munoz - Insights into Unemployment in the United States.

Using data from the bureau of Labor statistics, the dashboard gives a deep glimpse into the unemployment situation in the US. A large volume of disparate and tabular information is brought together in a single concise view, which aids understanding and adds real insight. The trends and demographic splits come through very well, and make for easy comparison.

3. Lisa Cunningham - Anti-Social Behaviour Dashboard.

The dashboard is produced by the Research and Information Team at Leicestershire County Council as part of a suite of dashboards produced for the Crime and Disorder Reduction Partnerships. It is available to the public through the local web portal, which makes readability, and also the contact information provided vital. The dashboard aims to provide an at a glance view of the level and trend of ASB, and does an excellent job.

** Note that all data has been obfuscated, and none of the screenshots contain actual data.

The Competition

Like last year, the competition is for real world solutions, we are not providing a sample data set, and we’re looking forward to seeing some great examples of reports, charts and dashboards.

The dashboards are judged on the clarity and effectiveness of their design, particularly:

 

  • Clean and clear organization
  • Effective table and chart design
  • A single-screen display, properly designed for the web, screen or print outs

 

We’ll also consider technical aspects of the dashboard, did it use effective techniques fo:

The Dashboard layout

Data management, data logic and calculation : YTD figures, variances, etc….

Dashboard delivery: Sharing the dashboard via PDF, the web or as an Excel Workbook