The Future of Excel Dashboards
->
In past Dashboard Spy posts, we’ve discussed the growing importance of Microsoft Excel as a serious business intelligence dashboard tool. Because of its ubiquity and role as lingua franca between business units in the enterprise, the recent expansion of Excel’s dashboard capabilities has an importance to us BI dashboarders for years to come. Of particular interest are things like the enhanced conditional formatting and dashboard status icons / indicators.
Add to the mix some cutting edge data visualization tools such as the sparkline charting products (Microcharts 3) from BonaVista Systems and incredibly detailed instructional books such as Excel 2007 Dashboards and Reports for Dummies, and you have the makings of a business power user revolution in visual business intelligence (e.g. dashboards).
The recent announcement by BonaVista Systems of an Excel Dashboard contest brought several thoughts to mind. First, of course, was the anticipation that this event will allow us to see what fellow dashboarders are currently doing with Excel in terms of dashboarding. Second was an interesting thought spurred by the first prize in the contest - an Apple iPhone. They show a small thumbnail of an iPhone mocked up with a Microcharts powered sparkline dashboard. That was neat (and it gave me inspiration to create a larger version of the iphone business dashboard shown below), but what really made me think was the caption “more information per pixel”. I thought that the phrase sums up neatly the sparkline approach to data visualization.
Let’s take a look at the iPhone dashboard I mocked up and then I’ll share some details of the Excel dashboarding competition. It’s still open, so I encourage all Dashboard Spy readers to enter.
Is this the future of Excel dashboards?

Before we look at the details of the Excel Dashboard contest, have a look at some of the Microchart graphics that you can use in your dashboard:

Click on the more link to learn about the excel dashboard competition:
Here is a snapshot from the dashboard contest details page.
Tags: Excel dashboards, dashboard contest, microcharts sparklines, excel 2007 dashboards

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
2 Responses to “The Future of Excel Dashboards”
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- A Look at Building Dashboards in Excel ...
- Excel Infographics ...
- Go Back to School for Excel ...
- What Will the Dashboard of the Future Look Like? ...
- Excel Dashboard for Monitoring the Competitive Landscape ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- Six Degrees of Dashboarding ...
- So Where are the Excel 2007 Dashboards? ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Excel Infographics
- iDashboards Winter Olympics Dashboard
- Go Back to School for Excel
- 7 Ways to Remain Relevant for Business Intelligence in 2010
- Dashboard Data Table Navigation
- Dashboard Metrics Status Indicators
- Communicating Through Business Dashboards
- Building a Flex Dashboard
- Retail Store Scorecard
- Google Analytics Marketing Dashboard





I just wanted to commend you for pushing the envelope on the use of Excel. As a consultant, encouraging people to use the tools they already have always makes the most sense to me. As MS makes it easier for people to use Excel, I think we’ll see the dashboard vendors scramble to lower their prices. MS ought to buy a few of them!
Patrick
http://workflowiq.wordpress.com
[...] http://www.enterprise-dashboard.com/2008/05/05/the-future-of-excel-dashboards/ [...]