Excel Dashboard Templates

Learn how to create Excel dashboards.

Tuesday, June 24, 2008

Excel Template for Dashboards

An easy solution for business intelligence dashboard reporting is sitting right under our noses! Consider implementing dashboard reporting in Excel.

Everyone has Microsoft Excel, so why don't more people use it for creating dashboard reports? Well, the consensus among the dashboard designers I spoke to seems to be that one can't get dashboard designs out of Excel that don't look like, well, dashboards made in Excel.

Yes, we've all seen those dashboards that are simply a collection of Excel graphs. Well, take a look at this nice dashboard layout:



Yes, that slick looking layout is done in 100% Excel. It's a dashboard Excel Template that is all set up and ready to point at your data. Use that link to check out the details.

Even Stephen Few likes the dashboard. See his blog entry in Visual Business Intelligence titled When Expensive Dashboard Software Doesn't Work, Do It with Excel.

Go Excel for dashboards!

Wednesday, June 18, 2008

Business Benefits of Digital Dashboards

If you are trying to justify a business intelligence dashboard project in your enterprise, here are some charts that you may find helpful. Whether you are calculating Return on Investment (ROI) or building a business case more anecdotally, there are both business benefits and technical benefits.

Here are some business benefits of using enterprise dashboards:


  • Improved Decision Making

  • Faster Time-to-Market

  • Improved Competitive Advantage

  • Improved Customer Satisfaction

  • Better Productivity

  • More Profits



And here are some significant technical advantages of business dashboards:


  • Rapid Problem Detection

  • Faster Response to KPI Changes

  • Reduction of Work

  • Improved Organizational Alignment

  • Identification of Problems

  • Management of Exceptions

  • Better Visibility into Remote Operations

  • Increased Operational Efficiencies




Here are the charts. Please click on the graphics to enlarge them:






Tags: Digital Dashboard Business Benefits

Friday, June 13, 2008

Flex Dashboard Example

Here's an example of a RIA dashboard using Flex technologies. It's an interactive flex demo so check it out at the link.

The demo was done as part of the Degrafa project (Declarative Graphics Framework for Flex) and you can read about it on this post about the Degrafa Dashboard Concept Example.



Tags: Degrafa Dashboards, Flex, RIA Dashboard