The Dashboard Spy

May 30, 2006

Office 2007 Dashboard – Review of Excel 12 as a tool for dashboards

Filed under: Dashboard Screenshots — dashboardspy @ 9:02 am

Much thanks goes to our Dashboard Spy in the field, Alex Kerin, for giving us this detailed rundown of the upcoming Excel 12 (part of the new Office 2007) as a dashboarding product. Alex decided to give the Office 12 beta a shakedown by creating a sales dashboard. As he tells it,

"This is a partial recreation of a mock sales dashboard as shown in Stephen Few's book, Information Dashboard Design. It was created in Office 12 Beta – I thought I'd share some experiences. While Excel is not at all the best choice for deploying a dashboard, the realism is that some people are happiest here, and that MSFT will push this as an interface, even if it's through Office Web Components.

Anyway, firstly the sparklines – these are all small graphs – Office 12 does a pretty good job with these as the series line is now anti-aliased leading to a much more professional look. In general charting is nicer – the defaults at least are clearer and nicer than older versions of Office. Second, there are new conditional formatting options that allow you to add bars or threshold indicators directly to cells. These are pretty good, but definitely conceived with more thought to looks than usability. For example, in Few's book he points out that you should only highlight problem areas – i.e. a green symbol is unnecessary to show things are okay – just a red blip should show. To get just a red symbol to show I had to jump through a few hoops, including writing formulas.

There's another example of the conditional formatting in the bar chart at the bottom – it's okay, but you're forced to use a gradient as the fill – this gradient always fades to white which makes comparing similar values difficult – this hopefully will change after beta. This could function as a dashboard by using OLAP links to a datamart etc. expect to see more of these as MSFT increases its BI charge."

Thanks, Alex, for the insight into this new version. Not everyone is willing to go through the hassle of trying this beta – you've done a great service to the executive dashboard community by detailing your observations. As I've mentioned before when discussing the future of enterprise dashboards, I believe that the launch of Excel 12 will start a new "look" in digital dashboards. It is simple – the sheer size of the installed user base will mean that you will start seeing everywhere things like the gradient bars.

Excel Dashboard Screenshot

Homework: It's still early but if you want a head start, keep an eye on these upcoming books on Office 2007.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy's favorite books.

4 Comments »

  1. […] Excel Dashboards The Dashboard Spy has been reporting on how people are using Excel to provide nice looking dashboards that help them keep their businesses smoothly. He/She has also posted about the upcoming Excel 2007 which adds more features for presenting Business Intelligence data. […]

    Pingback by Magnum B.I. : Excel Dashboards — June 7, 2006 @ 8:48 am

  2. This is excel-lent (get it? ha ha). Seriously, thanks for your excel dashboard posts. I’m excited about the new excel’s dashboard capabilities.

    Comment by Excel User — June 16, 2006 @ 7:50 am

  3. Check out Microcharts:
    * Line, column, pie and bar charts
    * Sparklines with normal band and rich color formatting
    * Bullet graphs – an effective replacement for dashboard gauges
    http://www.bonavistasystems.com

    Comment by Andreas Flockermann — November 1, 2006 @ 11:01 am

  4. Hello Dashboard Spy. I enjoy your blog about marketing dashboards. It is good to see such information. I have been studying this topic for many months now and am glad to see so many examples. I will visit your site often.

    I was very interested in seeing your post about “KPI Requirements for Dashboard Projects – Using the KPI excel dashboards. Thank you for the information about this dashboard topic. There is a dashboard project at work about this subject.

    The excel dashboards graphic is very nice. I like the colors and the questions are very interesting – What Question? Who’s Asking, Why is it Important, etc. I think it is very good. I also like the layout of the screen. I have a question about the boxes on the right side. Is the user supposed to type the answers to the questions into the boxes?

    Comment by saibaba — November 22, 2007 @ 12:25 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: