For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Dashboard

From a simple excel dashboard to a fully integrated enterprise reporting suite, the Business Dashboard is being quickly adopted as the new face of Business Intelligence. It has a rapidly growing role in BI reporting and analysis.

An enterprise dashboard allows at-a-glance visualization of company health and monitoring of key performance indicators. Simple to understand and high in ROI, these executive dashboards are becoming "must-haves" for all enterprises. Easy-to-use by business users and fun-to-implement by the IT department, BI dashboard projects are quickly funded and politically popular.

Dashboards by Example Sponsors

"Dashboards by Example" is a business intelligence blog dedicated to showing you actual examples of do's and don'ts of dashboard design. Study examples of enterprise dashboards, scorecards and other business intelligence interfaces implemented by the world's top organizations.

Looking for a particular dashboard? Try these listings of BI dashboards (call them what you want):

Dashboards Page 1
Dashboards Page 2
Dashboard Page 3
Dashboard Page 4
Dashboard Page 5
Dashboard Page 6
Dashboard Page 7

Search Dashboards

This dashboard screenshot blog is part of the Dashboard Spy network - a unique collection of business intelligence resources. Send us your Dashboards!

Email the Dashboard Spy

RSS Feed

Subscribe to Feed

Navigate

Enterprise Dashboard Advertisements

Building an Executive Dashboard in Excel 2007 with Conditional Formatting

Latest News in Excel Dashboards: New functionality for Excel based Enterprise Dashboards.

One of the truly exciting improvements in Excel 2007 for us avid enterprise dashboard project team members is the extent of the conditional formatting of the cells. Depending on logic related to the value of the contents of the cell, you can assign colors (think heat map visualizations) or icons (think red/green visual KPI indicators).

Here are a couple of excel 2007 demo videos that give a glimpse of the new features that you will definitely be using when building an executive dashboard.

This first video has no sound so think of it as an early silent movie about business intelligence visualization! Watch the cells as the person quickly drops down the conditional formatting options.

http://video.google.com/videoplay?docid=-4115540572629796916

This next one does have sound. You may want to skip straight to the latter part on the formatting options.

http://video.google.com/videoplay?docid=-1192618361577555007

And here is a quick tour of some new Excel 2007 features. This guy blows through 5 new features in 30 seconds!

http://www.youtube.com/watch?v=ubvI4KyZc1I

For reference, here is a link to some more info on Excel 2007.

Tags: Excel Dashboard, Excel Dashboards, Excel Dashboarding, Dashboards with Microsoft Excel

The Dashboard Spy Business Intelligence Dashboards Blog

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.

4 Responses to “Building an Executive Dashboard in Excel 2007 with Conditional Formatting”

Andreas Said on April 22nd, 2007 at 1:29 pm quote
A very useful extension for Excel dashboards is MicroCharts. It provides cell-sized charts
* Line, column, pie and bar charts
* Sparklines with rich formatting
* Bullet graphs for dashboard gauges
Andreas Said on April 29th, 2007 at 10:06 am quote
You can download the MicroCharts Add-In here:
http://www.MicroCharts.net
Jon Peltier Said on May 5th, 2008 at 2:41 pm quote
The video links are broken.
admin Said on May 6th, 2008 at 9:54 am quote
Sorry about that Jon. They are back up now. The Dashboard Spy.

Last Modified: Monday, June 11th, 2007 @ 13:18

This business intelligence dashboard blog entry was posted on Thursday, February 1st, 2007 at 10:40 am and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?

Recently Posted

More Dashboards

Dashboards by Example Volume 1 Goals and Objectives

"Dashboards By Example - BI Dashboard Samples" is the theme and mission statement of this blog. We salute the Dashboard Spy in the field - those business users, project managers, IT executives, application designers, business intelligence experts, analysts, coders and subject matter experts who are on site creating this exciting and new "face of BI". Your business intelligence dashboard can go by many names - performance dashboard, executive dashboard, business dashboard, balanced scorecard, KPI metric summary, enterprise dashboard, bi dashboard, corporate dashboard. Whatever we call it, we believe that the at-a-glance visual approach is the key to user-centric design. Let's learn from each other's dashboard examples and continue to increase the level of usability and usefulness.

We strongly believe that the more dashboards you study, the more adept you will become at choosing correct design solutions for your company. "Learn by Example" is not just a motto - we take it literally, hence the name "Dashboards by Example". So take every chance you get to view examples of BI interfaces. As a matter of fact, take a second now, and study this dashboard example.

What's on your Dashboard?

The Dashboard Spy wants your dashboards!! I've collected over 1000 screenshots of business intelligence dashboards and scorecards for Volume 1 and now need you to send me the next 1000 dashboards for Volume 2. Email me at info at dashboardspy.com and tell me about your dashboard. Send me images, notes, technical details, business rules, metrics, KPIs, anything that you think your fellow Dashboard Spies will have an interest in. Keep this library of dashboarding resources going!

Also, I'd love more links to both the main Dashboard Spy site at http://dashboardspy.com and the Volume 1 blog of 1000 dashboards at http://www.enterprise-dashboard.com. I'd love your help in making these resources better known.

Looking forward to seeing your dashboards, The Dashboard Spy

P.S. Did you check out this free dashboard template for wireframing? Click on the image below for the download link and instructions. Consider it a gift for your unfailing support. Thank you very much. Sincerely, your friend in dashboarding, Dash.