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
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
One Response 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 ...
- What Will the Dashboard of the Future Look Like? ...
- Six Degrees of Dashboarding ...
- Excel Dashboard for Monitoring the Competitive Landscape ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- So Where are the Excel 2007 Dashboards? ...
- Ingredients for Building Excel Dashboards ...
- How Microsoft Designed Excel 2007 Graphs and Charts ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Hospital Financial Management Dashboard
- Restaurant Performance Dashboard
- Business Intelligence Architectural Stack
- 3 Steps for Performance Improvement
- More on the Pie Chart
- Dell IdeaStorm Dashboard
- Excel Tool Tips
- Rube Goldberg Dashboard
- Dashboard Spy White Paper Collection Launches
- Excel Visualization of Olympic Medal Count




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