The Ultimate Business Driving Machine
By Zach Gemignani
November 14, 2007
Find more about:
dashboard
reporting
visualization
What do you do when you’d rather be out driving your BMW rather than sitting in your corner office? Make a business dashboard that looks like your car dashboard, of course. You’ll want to have lots of tachometers, temperature gauges, and traffic lights. It’s the ultimate business-driving machine.
It isn’t controversial to complain about the ineffectiveness of “gauges” for data visualization. In fact, even some of the worst offenders admit that gauges aren’t ideal:
Dr. Robert Alison of SAS in showing off a new easy graph procedure for creating gauges says:
“I know, I know … gauges have lots of drawbacks in dashboards. But hey, the other philosophy is 'give the customer what they want' … and try to make it work as well as possible. So, as far as gauges go, these are pretty decent.”
Here’s the example he uses to show off “one of the sharper-looking dashboards I’ve seen”
The folks at Business Object’s Xcelcius admit that gauges shouldn’t always be used in their article entitled “The Use (and Misuse) of Gauges”.
That doesn’t stop them applying a triple-coat of carnauba wax while neglecting their rule to always label the endpoints.
In the end, they primly note: “Despite some recent bad press, a gauge isn’t inherently a poor graphic.” Bad press, is it. If only gauges had better PR.
In my opinion, warning about potential misuse isn’t firm enough. Gauges shouldn’t be used except under the most severe threats from a client offering enough money to buy absolution.
Stephen Few, a man who doesn’t mince words on information visualization, says:
“If you squint really hard, you can barely make out some of the values. But who cares, because if you’re an executive who likes to pretend that you’re driving a car while sitting at your desk rather than actually managing your business, then having a dashboard that is truly informative doesn’t really matter.”
Charley Kyd says:
“Using dashboard gauges for management reporting typically is a mistake. Gauges hide information that managers need and consume significant space in a report.”
Let’s break down the problems with gauges:
Gauges hide trends. For all the focus on how a value is performing, you’d think people would care about the historical trend.
Circles aren’t good for showing differences. Like pie charts, circular gauges aren’t the best way to show size or changes in values—bars are a more straightforward, if less sporty, approach.
Space eaters. Often gauges are used to show a single value. All that decoration for a single value must send Tufte into a tizzy. Attempts to cram two values into a gauge can be confusing. How do you read this one?
Difficult to read. The values can be obscured by all the attractive accoutrement:
Ranges can be tricky. By the analogy to a car dashboard, gauges are expected to have a static minimum and maximum value. What happens when a value goes beyond the pre-set range. Here’s an example of the “right way” from Xcelsius with the label: “This gauge shows a retail store’s progress against a daily revenue target.” We can only presume the maximum value is $45,000. What happens if I go beyond $45,000?
Traffic lights are contradictory. I may be getting nitpicky, but I can’t both have my traffic light look like the real thing (red on top, green on bottom) and abide by basic data visualization assumptions (better is higher).
Lastly, there are so many better options. Here’s a beautiful data display (courtesy of Mr. Few) that could have been done with gauges, but mercifully was not.
Subscribe & Browse
Recent Posts
- 11 Parallels Between Architecture and Interface Design
- Analyticstime!
- Thrown to the Ad-Wolves... or, Learn from My AdWords Mistakes
- Review: 5 Options for Embedding Charts in a Web Page
- Godin Dumps on Bar Charts; Data Visualization Record Falls to 1 and 1
- Why Analytical Applications Fail
- Microsoft's Executive Dashboard... Magnifying Glass Required
- Clever != Smart Naming: Don't make your customers work
- Mashing Google Analytics With External Data
- 10 Minute Reviews: Open Flash Chart
10 comments | Show all comments only the last 5 are shown
Sandy said:
Nice summary Zach.
I've been using the reporting techniques Mr. Kyd discusses on his site and his book with great success at my job for over a year.
Having coincidentally just received Mr. Few's books a couple of weeks ago, I'm in the throws of adopting his recommendations throughout my work.
It's a shame that it takes as much work as it does to create good charts with Excel. It can be done, but why oh why are the default so poor?
Have you found that you need to "de-program" some clients to convince them that shiny widgets just aren't the way to go? Do you find that it's an uphill battle advising against the big BI vendors offerings?
Jon Peltier said:
The Xcelcius dial gauge uses the label ($45,000) to display the value where the needle points, not the maximum of the scale. The obvious question is, why bother with the dial at all?
The dashboard analogy has been applied way too literally. In a car or aircraft, the dashboard provides the driver or pilot with the important information needed to continue to operate safely and towards the destination. Dials and gauges evolved because technically they were easiest to implement, and in general the operator required an instantaneous snapshot of the conditions.
In business, a dashboard should also provide the user with the important information needed to continue to operate safely and towards the destination. Using dials and gauges is an unfortunate byproduct of calling such a display a dashboard. It's important to fit a lot of information into a small space, hence tables, line charts, bar charts, and the like. It's important to show trends, not just current values, hence line charts (again).
Pragmatic Cynic said:
Jon pretty hinted at it in saying gauges were "easy to implement" in true dashboards. But it wasn't just about the ease of implementation. It was because of the technology at the time. If digital readouts were available back in the day, you probably wouldn't have seen the dials. Now try putting those in a car and people will complain because they are so programmed to expect gauges.
The term dashboard is partially at fault--people think they're flying the airplane. But the manager isn't the pilot, he/she is closer to an air traffic controller.
derek said:
<a href="http://www.perceptualedge.com/blog/?p=191">Stephen Few</a> has good word to say about some Business Intelligence software! Me faints with the shock!
All joking aside, those features of <a href="http://www.tableausoftware.com/products/desktop">Tableau Desktop</a> look seriously tasty, and are just the sort of thing I wish I could get out of Excel without hours of major surgery.
Tony said:
At least they used some bullet charts in the SAS dashboard you used as an example. Like you guys have said before, it's a social problem. Too many people like the Tasty look and don't really know any better.
This is what a developer from a Dashboard vendor has to say when I questioned the components they chose for a dashboard, "I fully agree with you that some of the example dashboards use certain visualization types in a manner other than which they were classically intended. However, you have to understand that software vendors (my company included) ultimately cater to what people want to do rather than what they should do. For that reason it is sometimes necessary to show what is possible rather than what is ideal."
Source: http://www.dashboardinsight.com/articles/digital-dashboards/fundamentals/dundas-step-zero.aspx
I would have to somewhat agree with Derek. Tableau has some serious horsepower, but in a different way. Tableau is more of an analysis tool than a dashboard.
Loren said:
I agree that gauges consume valuable real estate space and may not be an ideal option for displaying numerical information. However, gauges can be revealing when they are combined with sliders, dials, and other interactive components; as they help to visualize hidden relationships in the underlying mathematical model.
-- Loren
Chris Gemignani said:
Loren, it is better to use basic bar charts or lines if you want to "visualize hidden relationships in the underlying mathematical model". Bad is bad no matter the source of the number you're displaying.
If you're trying to illustrate the working of a model embodied in a spreadsheet you're better off designing more sophisticated displays that can show how multiple values covary. XY charts and animation leap to mind.
Stephen Few has a nice article here on visualizing change: http://www.perceptualedge.com/articles/09-27-07.pdf
Andy said:
Presumably the point of using gauges is that they are "understandable" and familiar to people not confident with proper charts, so I am often struck how little resemblance there is from BI dashboards to the real thing.
I imagine that some car makers but considerable effort into designing their dashboards to give a small amount of very important information genuinely "at-a-glance". In my (admittedly cheap) car this is done with one large speedometer and a small fuel gauge with the other information in warning lights that only come on if there is a problem, plus an odometer and clock.
But then, when I drive my car I mostly look out of the windscreen towards the road!
I've also seen a few rows of 4 traffic lights at complex multi-lane motorway junctions, and its one of the things that make motorway driving intimidating for some people.
But I have to admit to using Jon Peltier's speedometer chart (in the past).
Ken said:
All the confusion on gauges on dashboards is definitely a result of the automotive context. It made me think about a few years ago when I was looking at buying a Saab. The coolest feature of these cars is the Night Panel display. At night, the only gauge that is illuminated is the speedometer.
<img src="http://z.about.com/d/cars/1/7/F/j/ag_07saab93_nightpnlon.jpg" width="100" alt="Saab gauge">
Then if there is an issue with another system, illumination is added to that system's indicator. This was inspired by the Saab aircraft designs.
Too many aircraft pilots have flown into the ground because they were too enthralled with the overload of "useful" information showing up on the instrument panel. I wonder how much this is happening in businesses today?
Brett said:
Hi Guys,
I wasn't sure where to put this so here is some website feedback:
I really like the site and the content that it contains is amazing, so much in fact that i have spent a long time now reading all of the posts going back through time. But there are a few navigational bugs...
When you access the posts directly through a url such as: http://www.juiceanalytics.com/writing/#Year#/#Month#/#ArticleName#/ the navigation using the categories (or filters) of author and date do not give valid pages. Using the author navigation list leads to a url such as: http://www.juiceanalytics.com/writing/#Year#/#Month#/#ArticleName#/author/#AuthorFirstName# which gives a page not found message.
The behaviour of the categories when not viewing a page directly appends some sort of query to the url eg: from http://www.juiceanalytics.com/writing/topics/analytics/ clicking on Zach as the author appends ?author__first_name=Zack to the url it filters just perfectly.
The screencast links from all apart from 1 of the previous posts (when they are hyperlinks, not embedded) don't seem to work.
The navigation seems to be completely missing from a couple of pages such as:
http://www.juiceanalytics.com/writing/2006/12/square-pie-screencast/
http://www.juiceanalytics.com/writing/2007/07/recreating-ny-times-cancer-graph/
the next and previous links point to both pages from either side but they are then both dead ends!!
Once again an awesome site and thanks for sharing!
said:
Add a comment