Electronic Dashboards

December 10th, 2010

We are so used to the phrase enterprise dashboard or executive dashboard, that we think it quaint to see the seldom used “electronic dashboard”.

Here is a white paper titled “The Effective Use Of Electronic Dashboards To Promote & Improve Overall Practice Performance: An Exploration Into The Use Of Electronic Dashboard In A Group Practice Setting“.

2 diagrams from that paper caught my eye:

This first one shows the architecture of executive dashboards:

architecture-of-enterprise-dashboards

And this next dashboard screenshot shows a dashboard from iDashboards.

idashboards-electronic-dashboard

tags: idashboard, electronic dashboards

Heat Maps for Data Visualization

July 8th, 2008

Dashboard Spy readers will recall that we have discussed the use of heat map techiques for data visualization. We looked at Google Eye Tracking heatmaps for marketing optimization and the ever popular heat maps for stock market dashboards. We even looked at this ridiculously simple size and color sensitive heatmap dashboard.

Today we look at how heat mapping is used in data visualizations to optimize the customer preference of various gaming machines at Las Vegas casinos. In this environment, the likes and dislikes of customers for different machines or table setups translates to a lot of revenue. Tweaking the slightest variable can mean a huge impact on profitability.

Here’s a close up view of the data visualization heatmap. It shows usage of the machines overlaid across a floor plan.

heatmap data visualization

To see this heatmap in action, take a look at this video:

Read the rest of this entry »

Xcelsius 2008 Dashboard – Gas Price Data

July 1st, 2008

Flash-based dashboards provide great interaction between the user and the data. Technologies such as Xcelsius easily allow us dashboard designers to mix view (read only) modes with what-if analysis modes. In today’s dashboard example by Ryan Goodman of the Interactive Data Visualization Blog, we see this to great effect.

I’ve always liked Xcelsius for dashboarding and the new version, Xcelsius 2008, makes it even more compelling with it’s new Adobe Flex IDE. Take a look at the top 10 new features of Xcelsius 2008.

Ryan’s Xcelsius 2008 Dashboard examines a subject of great concern today: the price of gasoline. As Ryan explains:

With gas prices being a hot topic, I decided to put together a dashboard that illustrates the power of simple data visualization with Xcelsius + runtime calculations to provide additional utility not possible with static reports or dashboard technologies. The data is fed from AAA.com.

http://ryangoodman.net/blog/index.php/2008/06/26/gas-prices-at-the-pump-dashboard

Here is a screenshot of the gas dashboard. Click on the “more” link to view the rest of the post. You’ll find a video summary that you can view if you don’t have time to visit Ryan’s Xcelsius 2008 dashboard right now.

Xcelsius 2008 Dashboard

Read the rest of this entry »

Small Business Dashboards

June 30th, 2008

Several readers of Dashboards By Example have reminded me that the objective of the blog, as the name suggests, is to show actual examples of dashboards. It’s nice to see the cutting edge visualizations and hear about the theories behind software usability, but they want to see more real business dashboards from the trenches. “Let’s have some real dashboards!” is the message.

Thanks for the feedback! Let’s get back to real world executive dashboards and the KPIs used by management to keep tabs on their businesses.

Today we have three examples of dashboards used by small business owners. Designed using InfoCaptor, a dashboarding tool from Nilesh Jethwa, these dashboards surface data from QuickBooks.

This first screenshot is used by the owner of a landscaping company. Click on the image to enlarge it and you’ll see metrics such as Cost of Goods Sold (COGS), Sales by Period, Sales by Product and Top Customers.

QuickBooks Dashboard

Continue reading by clicking on the “See More” link and you’ll find 2 other small business dashboards.

Read the rest of this entry »

The Horizon Graph

June 19th, 2008

Should you have a Horizon Graph for your dashboard? When a new information visualization technique is invented, it’s interesting news. The ones that are worthwhile find themselves in our mental toolboxes and eventually on our dashboards. Sparklines, bullet graphs, treemaps come to mind as recent inventions of note.

When a new infomation visualization technique comes out and is lauded by Stephen Few, however, then it becomes not just interesting, but important! Stephen Few, author of Information Dashboard Design: The Effective Visual Communication of Data, is the developer of the bullet graph and considered one of the leading experts in the use of data visualization for analyzing and presenting quantitative business information.

Let’s have a look at a Horizon Graph. Click to enlarge the screenshot of the chart:

Horizon Graph Example

What???? That’s my initial reaction and I bet it’s yours too.

Let us allow Stephen Few to explain what we are looking at. First some background:

As Steve explains in his latest newsletter titled Time on the Horizon, the Horizon Graph was invented by the business intelligence software vendor Panopticon.

This is not a marketing piece for Panopticon, so I’ll say little about the company except that until recently its products exclusively featured a particular visualization called a treemap. For information about treemaps, I invite you to read an article that their inventor, Ben Shneiderman of the University of Maryland, wrote for my newsletter back in April 2006 titled “Discovering BI Using Treemaps.” The folks at Panopticon applied the potential of treemaps in several innovative and practical ways, and are now complementing their products with the addition of several traditional graphical displays (for example, bar and line graphs), including a few new variations on these themes. One of these variations is called a horizon graph.

Read the rest of this entry »

Who is on your list of Dashboard Experts?

June 17th, 2008

The design, implementation and maintenance of business dashboards spans a range of disciplines. Because dashboard design truely sits at the junction of business and technology, these disciplines are often not the areas of expertise found in the typical dashboard application team. A dashboard project is a learning process for team members encountering new subjects.

Wading into new territory can be uncomfortable, so let’s help each other out. Programmers can tell Graphic Designers where to start. Business Users can ask Information Visualization Specialists how to best describe their KPIs. Knowing what we don’t know is the best first step, so let’s not be afraid to ask for help and look to experts.

By popular demand, I’m releasing my big list of Dashboard Experts. This is my collection of feeds, blogs and resources that I keep a close watch on. The experts on the list span the range of information technology, business management, information design, application development and specialized dashboard software expertise.

Dashboard Spy List of Experts Click to visit the List of Dashboard Experts

I hope you find it useful. I’d love to grow the list with your help. Who do you read that you feel should be on this list?

Tags: Dashboard Experts, Dashboard Resources, Business Intelligence Resource

4 Principles for Dashboard Gauges

June 13th, 2008

In a recent Dashboards by Example post titled Dashboard Eye Candy, we poked fun at the usage of big honking dashboard gauges. Like them or not, however, they do indeed have their place on business intelligence applications.

One of the example gauges used in the article came from the folks at Perpetuum Software, maker of .NET Dashboard Suite, a set of dial/gauge/charting components. In response to the post, they submitted an article to The Dashboard Spy detailing 4 principles to observe when using gauges in digital dashboards and business applications.

The article explores the basic principles of using elements that emulate real analog devices to represent values on digital dashboards. It starts with the acknowledgement that there are both weaknesses and strengths in using such representations.

They even provide cartoons to illustrate the points!

Speed of Perception of Dashboard GaugesAesthetics of Digital Dashboards

There are four basic principles to consider when you are considering a gauge on your dashboard:

  • Is it a good metaphor?
  • Speed of perception
  • Visualization
  • Aesthetics

Here’s the article (click on the “read more” link):

Read the rest of this entry »

Making Dashboards More Productive – Google Analytics Dashboard Case Study

June 2nd, 2008

In making the ROI case for any IT project or application development project, we like to talk about the productivity that the new system will bring. The usual case was to count up how many hours a task or workflow takes if done manually and compare it to the drastically reduced number of hours it will take when the system goes online. Well, most critical business processes have already been automated and how the discussion of productivity is measured in a finer fashion. We now count clicks and measure usability.

Let’s take a look at the issue of productivity when it comes to business dashboard use.

We begin with a look at productivity as defined in 1776 by Adam Smith in the famous book, The Wealth of Nations.

Smith defined productivity by dividing labor into two broad categories – productive labor and unproductive labor. According to Smith, productive labor was work which fixed value into tangible objects. Unproductive labor, on the other hand, was any work where the value was consumed as soon as it was created. The example given by Smith was the role of laborers in a manufacturing plant (who transferred their value through work into their output) versus the tasks of a servant (unproductive work).

Now let’s apply this to software applications in general and business dashboards in particular.

For a case study, let’s use the Google Analytics service, the wildly popular free service offerred by Google to allow tracking of website visitor analytics.

With its vast user base of web masters, the Google Analytics Dashboard is probably the most often-used business dashboard. Certainly, outside of the enterprise, it is often the first real BI dashboard encountered by the general public.

Here’s a screenshot of the first page of the Google Analytics Dashboard:

Avinash Kaushik's Google Analytics Dashboard

Yes, that’s Avinash Kaushik’s Google Analytics Dashboard. Avinash is Google’s web analytics evangelist and a real fan of dashboards. We previously posted a video of Avinash on Dashboards.

Anyway, the dashboard allows drill-down to many different views. Here are a couple of little thumbnails.

Google Analytics Dashboard Funnel Charts Google Analytics Map Chart Google Charts Analytics Dashboad Google Analytics Metrics Dashboard Google Analytics KPI Graph

Getting back to the idea of productivity of dashboards, the Google Analytics Dashboard has evolved quite a bit since the introduction of the service back in 2005. If you dig out some older dashboards, you can see how advances in dashboard design has incrementally increased productivity for users of the dashboard.

But what about larger jumps in productivity?

Well, take a look at this third-party offering by Serence called the Klipfolio for Google Analytics.

Here’s a screen shot of their desktop dashboard:

klipfolio desktop dashboard for google analytics

Uh, well… so what?… you may ask. There’s nothing earth-shaking about this little dashboard. It’s simply a summary dashboard with the typical red/green/yellow status lights.

Actually, the big deal is where this little dashboard goes. It’s a desktop dashboard.

If you are reading this post on the main page of the Dashboards by Example site, click on the “read more” link below to continue reading.

Read the rest of this entry »

Dashboard Eye Candy

May 29th, 2008

Yes, I know that good information visualization practice and dashboard design calls for effective use of screen real estate with clear and simple devices such as sparklines and bullet graphs. Easy to read and interpret, these charts, combined with a monotone color scheme (after all, we have to keep the mind on the data and use color sparingly to call attention to the errant metric and the wayward KPI!), have become a “best practice” design for data-heavy business dashboards.

Take a look at this sparkline dashboard (designed by Stephen Few and featured in his book Information Dashboard Design: The Effective Visual Communication of Data and implemented by Andreas Lipphardt of BonaVista – see “An Excel-based IT Dashboard) and you’ll recognize “the look”.

And see also the sales dashboard (also designed by Few and discussed in his book – this version implemented by Robert Allison using SAS/GRAPH).

Excel Dashboard for CIO

Stephen Few Sales Dashboard by Robert Allison

Yes, these information dashboards are packed with great data visualizations and make effective use of the dashboard layout. Gratituitous graphics are minimized. Utility and user understanding of the meaning of the information is maximized.

But, heck, don’t you ever get tired of the flatness and just sometimes want to ogle a shiny, big-ass 3D gauge like this one?

Dashboard Gauge by XtraGauge

In the mood for some more in this vein? Here are some more digital instrumentation/gauge style dashboard interface elements:

Dashboard Gauge by Dundas

Gauge by Dundas

Assortment of dot net Dashboard Gauges (see more dashboard dials, gauges and charts for .Net from Perpetuumsoft)

The question is when to choose what level of eye candy for dashboards. Is it always “wrong” to go with the shiny gizmo? How about when the project sponsor says “Make the gauges bigger”?

Is the answer to take a blended approach as Dundas does in this HR metrics dashboard? Does this strike the proper balance?

dundas dashboard for HR metrics

Update: The comments posted regarding balancing eye candy with information visualization best practices set me off on a search for a product that I saw a while back. Click on the more link to see what I found:

Read the rest of this entry »

So Where are the Excel 2007 Dashboards?

May 23rd, 2008

Are less dashboards being built using Excel 2007 than I thought? The recent post about customizing the Ribbon navigation panel elements for Excel 2007 dashboards brought out a couple of comments from Dashboard Spy readers that basically said that Office 2007 upgrades were not yet in sight for them. Yes, it’s true that there’s a buzz out there about the dashboard-friendy functionality found in the Excel 2007 version and that we finally have a good Excel dashboarding book (see Excel 2007 Dashboards & Reports For Dummies), but Office 2007 is not yet commonly available in many enterprises.

I thought I’d look at the adoption rate of Excel 2007 in this post.

A great “in-the-trenches” look at whether people are using Excel 2007 yet comes from Charley Kyd of ExcelUser.com in his Excel 2007 Market Share survey. Since the release of Office 2007, he has been running a poll of what version Excel his site visitors have been using.

BTW, if you want an easy, low cost way to produce magazine-quality Excel dashboards, take a look at Charley’s Plug and Play Excel Dashboard Templates. Just point them to your data, and you have some great looking excel dashboard reports.

Here’s a screengrab from his site:

Excel version survey results

Click on the more link for more on this Excel version survey.
Read the rest of this entry »