Dashboard

    Dashboards By Example Volume 1   From Excel Dashboards to Real-Time Dashboards, these dashboards contain KPIs, metrics, charts, trends and data visualizations. Learn the best practices of enterprise dashboard design by studying the work of your peers on business dashboard implementation teams around the world. Examine their digital dashboards and share your dashboard design tips in return.

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

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers discussing the latest approaches to enterprise dashboards.

Want to connect with the Dashboard Spy? Visit the About The Dashboard Spy page to learn how to connect via LinkedIn.

Archive for October, 2008

This is an archive of the unique and controversial resource on Enterprise Dashboards known as The Dashboard Spy blog on Enterprise Dashboards. This is Volume 1 of the dashboard screenshot collection where you will find 837 dashboard screenshots of various dashboard implementations. Included in this collection are executive dashboards, enterprise dashboards, performance dashboards, corporate dashboards, balanced scorecards, BI dashboards, business intelligence dashboard - the list goes on. What is the difference between all those terms? That's part of the fun! Start studying these screenshots and learn.

Here is an interesting way to find more enterprise dashboards to study: Click this link for a random dashboard. You'll never know what dashboard you'll see next.

Synchronized Presidential Debates Dashboard-Style

Wednesday, October 29th, 2008

Sychronized Presidental Debates on a dashboard. Digital Dashboard watchers must immediately watch this video. If you are like me, you think that every information asset would benefit from being displayed on a dashboard. This video takes the dashboard design pattern to an extreme.

Video clips of the three presidential debates of 2008 are displayed digital dashboard style and then played simultaneously.

Here are some screenshots from the video. Note the dashboard style layout.

You can watch the video on the Dashboards.TV site by clicking on this link:

Synchronized Presidential Debates on Dashboards.TV

Synchronized Presidential Debates

synchronized debate 2008 campaign

If you want to watch the video without leaving the Dashboards by Example site, click on the “Read More” link below to see an embedded version.

» Read more about this business intelligence dashboard example: Synchronized Presidential Debates Dashboard-Style ............

2008 Political Dashboards for the Election Home Stretch

Monday, October 27th, 2008


Election Results Dashboard Update: Here are the latest election returns as viewed from a New York Times home page “pop-up” dashboard:

Click on the link below to launch the Pop-up Dashboard:

POP-UP DASHBOARD

Here is a screen capture of the NY Times 2008 Election Dashboard from after the election:

Political Dashboard

This has been a banner year for political dashboards and visualizations. The “At-a-Glance Political Dashboard” zeitgeist of this election year is evidenced by the appearance of all manners of interactive maps, information visualizations and calculators. Gone are the days of the simple static diagrams of the red and blue states. Turn on any news channel and you’ll see election data maps zooming and drilling and jumping up and down.

For the home stretch of the election, I bring your attention to several dashboards. As I said, this year’s bumper crop of political dashboards gives us plenty to choose from so let me explain why I focus on these particular election dashboards.

The Yahoo! Election Dashboard remains the heavy favorite when it comes to political dashboards. Simply because of its popularity, I have to list it as a must-visit political dashboard. Hailed as a great example of a useful and usable RIA (Rich Internet Application), it allows a close examination of the candidates on a state-by-state basis. The Yahoo Political Dashboard Project is a collaboration between Yahoo, Intrade and RealClearPolitics. Watching the evolution of this dashboard has been insightful. The front page of this election dashboard has morphed appropriately through all the phases of the election process. For a look at what this dashboard looked like back in February, revisit the Dashboards By Example post when we called the Yahoo dashboard the “Best Political Dashboard of 2008“. Compare it to today’s dashboard screenshot:

Yahoo! Political Dashboard
(Click to visit Yahoo Election Dashboard)

iDashboard’s 2008 Presidential Election Dashboard is another dashboard I like to point out because it is a dashboard that comes from a business intelligence dashboard vendor. The company developed a popular Olympic Games Dashboard that we profiled here and has followed up that effort with this election dashboard. The application is built on a Flex-based architecture and uses Flash animation to provide a detailed breakdown of candidate support by race, age, state, gender, marital status and educational background. Additional information includes a map of state electoral votes and financial
details about the political parties. The Presidential Election Dashboard uses color-coded graphs to enable voters to identify and track candidate support. To obtain finer details, users can utilize the hover-and-click capability to drill-down further, examining specific elements; in this case the candidates’ support groups.

Here is the screenshot of the iDashboards political dashboard:

idashboards political dashboard
(Click to visit iDashboards Political Dashboard)

 

Doug Marttila’s Election Center 2008 is interesting project from a savvy Flex/Flash data visualization pro. I select his visualization work to detail whenever possible because he is so willing to share his insights. For this election dashboard project, Doug explains why he chose the tree map for the visualization:

I built the election charts to see the states as a tree map. Tree maps allow viewers to quickly see relative values of items. They’re similar to pie charts in that all items add up to 100%. But, tree maps can be a bit easier to understand when there is a lot of data (a rectangle is easier to judge
than a wedge) and they support hierarchical data better. In this case, they provided an alternative to the geographic map view that shows state by state presidential election polls. Maps are great because people are already familiar with them - it’s easy to find state’s poll numbers because you know
where to look. But, the area in geographic maps is misleading (just take a look at all the different mapping projections out there). Basically, I wanted to quickly see which state had the most electoral votes - not where a state is located geographically.

So, the key to the chart:

  • Number of electoral votes = size of rectangle
  • Color = whether the current polls (I’m averaging the last 3 polls) have the state leaning Obama or McCain. (Dark blue and dark red are 10%+ in either direction. Absolute tie is white. And 0-10% is a gradation of color)

I also grouped the states into strong, leaning, and toss up. 3% points or less is a toss up. 3-10 is leaning. and 30%+ is strong.

You can click on a groups heading to zoom into see just that group.

On the second tab, you can look at the data grid and see exactly which polls are included in the averages. You can also select and deselect polls to include in the average.

Finally, the summary (the first tab), gives a quick overall picture. The columns are sorted so the states that are strongest for each candidate are at the bottom. The height of each rectangle withing a column corresponds to that state’s electoral vote count. The color matches the color in the tree
maps.

You can roll-over most charts to get more info about a specific state.

Forest and Trees Election Center 2008 Data Tree Map
(Click to visit Doug Marttila’s Election Center 2008 Dashboard)

 

I always like to feature the work of Xcelsius pro Kalyan Verma of MyXcelsius.com because he has the heart of a teacher and always takes a transparent, “roll up our sleeves” approach. In his post 2008 Electoral College Calculator using Crystal Xcelsius, he explains how he replicated a Wall Street Journal interactive calculator with Xcelsius 2008.

This is a brief description about how i built it. Many Xcelsius developers should be able to understand. As you can see i used the USA Map component and i carefully placed the icon components over each state (Tedious work Phew…). The reason for the icons was to allow the user to click on a state and insert the relevant value in the cell corresponding to the State. I set Alerts for the states so that they display Red or Blue depending on the value inserted by the icon. The rest of the calculator is simple label components and other basic Xcelsius stuff. Most of the time was spent on the overall look and feel of the calculator.

Here’s a screenshot of the electoral college calculator:

Electoral College Calculator
(Click to visit the MyXcelsius Electoral College Calculator.)

Kalyan does us all a favor by surveying 12 election dashboards in his post, 12 Ways to Pick Your New President.

Here is a screenshot of the election dashboards, he points his readers to. Remember, this is just an image, so visit the MyXcelsius.com post to click on the links.

12 Election Dashboards
(Click to visit MyXcelsius.com’s 12 Election Dashboards.)

Tags: Round Up of Political Dashboards, Election dashboard, flash dashboards, flex, xcelsius

Note: This is a post about business intelligence dashboards from the Dashboard Spy. You may be reading this from a “scraped” source. Be sure to visit the original Dashboard Spy sites for the original context. Dashboards.TV, Dashboards By Example, Business Intelligence White Papers.

Intranets, Portals and Dashboards, Oh My!

Wednesday, October 22nd, 2008

A couple of posts ago, Dashboard Spy readers debated the definition of a dashboard. Some stated that the dashboard metaphor as a layout pattern or navigation device makes for a perfectly fine dashboard - even if it didn’t contain business intelligence artifacts such as metrics or charts. Others insisted that dashboards as we study them here must tell you something about the state of your business. Similarly, we have debated the difference between a dashboard and a scorecard.

Today we look at the fine lines between intranets, portals and dashboards. If you adhere to the “dashboard as a layout pattern” argument, then there doesn’t seem to be muxh of a difference between a portal and a dashboard. Both are often single page / multiple tab constructs that add value to the user by bringing disparate information together onto a single screen. If you belong to the “dashboards show a summary of your business” school, then what do we call those applications that mix business metrics portlets with news feeds? Think of sharepoint dashboards - are they dashboards or portals? Take a look at this demo of a SharePoint marketing dashboard and you’ll see a mixing of portal and dashboard type content.

The best way to get a feel for what is what (and for that matter, whether it’s important at all to differentiate and names these various dashboard-like applications) is to simply visit examples and decide for yourself.

For example, let’s take a look at an intranet/portal/dashboard product. adenin Technologies offers the “IntelliEnterprise Intranet Suite” as an “unbelievably complete intranet suite”. The adenin Live Demo Site allows us to explore an intranet installation that includes enterprise portals, document management sites, dashboards, workflow and more. There’s a lot in this suite which is perfect for this discussion.

The demo starts with a gateway page that allows you to simulate various user roles:

Adenin Intranet Demo User Profiles

You should visit the demo and lead yourself through the various modules, but let’s take a look at a couple of screens that caught my eye.

Click on the images below to enlarge them.

Portal Page on the Corporate Intranet

Portal Page on the Corporate Intranet

The above screenshot is that of the corporate portal. It seems like a typical intranet page, with a web portal-style layout. But look at the right column and you’ll see a portlet titled “New Order Volume”. Ah!! - a business metric makes an appearance. So does this make this a dashboard? Or a portal? Or a corporate intranet with business intelligence sensibilities?

Now take a look at this: (click on the more link for the rest of this post)

» Read more about this business intelligence dashboard example: Intranets, Portals and Dashboards, Oh My! ............

Real Time Excel Dashboard Tracks Gas Prices

Monday, October 20th, 2008


Dashboard Topic: Excel Gas Dashboard

Web queries have been part of the Microsoft Excel object model for quite a while now, but are not often seen on Excel dashboards. Talented Xcelsius and Excel developer Kalyan Verma (author of the fabulous myxcelsius.com blog), has posted an example of using Excel Web Queries to power an Excel dashboard connected to the American Automobile Association’s database of pump prices of 100,000 gas stations.

The post is entitled Real Time Fuel Gauge Dashboard using Excel Web Query and walks the reader through not only a lesson in the use of Excel Web Queries, but also some principles learned from reading Stephen Few’s Information Dashboard Design: The Effective Visual Communication of Data. Can you guess which specific principles?

Take a look at this screenshot. Click on the image to enlarge this excel dashboard. Be sure to visit the post at the link above to read more from Kalyan as well as see more screenshots of the Excel dashboard. Most importantly, you can download the .xls file for the Excel Dashboard and play around with the Excel Web Query dashboard for yourself.

Excel Gas Price Dashboard

Excel Dashboard using Web Queries to Show Gas Prices

Excel Dashboard using Web Queries to Show Gas Prices

If you are new to Excel’s Web Query feature, consult this introduction from Microsoft’s Office Online resource:

Get and Analyze Data From the Web in Excel

Speaking of Microsoft Online, try this query and look who is the first result! Click on the word “Dashboard” below:

Dashboard Search on office.microsoft.com

Update: As noted in the comments below, we have covered similar gas price dashboards previously. Take a look at Ryan Goodman’s Xcelsius Gas Price Data Dashboard. It even has a Dashboard Spy Video!

Tags: Excel Dashboard for Gas Price Monitoring, Web query excel dashboard, myxcelsius.com, excel gas dashboard

CERN Collider Dashboard

Friday, October 17th, 2008

Digital Dashboards have been implemented to measure and track an unimaginably wide range of business activity. A Dashboard Spy reader asked me how I keep up my interest in the subject of business intelligence dashboards. After viewing thousands of dashboards, don’t they all blur into a swirl of graphs and blinking lights? I replied that it was the unbelievable diversity of business application for digital dashboards that keep things fresh for me. We went on to chat about some of the more unusual and exotic business dashboards that I have seen.

When asked to point out an example of a dashboard being used on a cool or unusual project, I sent the Dashboard Spy reader this screenhot of a Project Management Dashboard used to track the completion progress of the Large Hadron Collider built by CERN.

Project Management Dashboard for the CERN Large Hadron Collider Project

This circular graphic represents the progress of the LHC installation. It’s a snapshot from 2007.

Here is a picture of some CERN scientists showing some of their computer screens:

CERN LHC Scientists

Click on the “More” link to read more about this digital dashboard:
» Read more about this business intelligence dashboard example: CERN Collider Dashboard ............

Dashboards As Navigation

Tuesday, October 14th, 2008

When is a dashboard a dashboard? Recently we looked at the Dell IdeaStorm Dashboard and one of the comments was “How is this a dashboard? It might be a portal, but all it does is list links of other things to go look at. It actually contains precious little real information.” If you bring up that dashboard example, you’ll see that the dashboard consists of a panel of portlets with text and links. Here’s a small screenshot. Click the thumbnail of the dashboard to enlarge it to see the detail.

This Dell IdeaStorm Dashboard consists of text descriptions and links.

This Dell IdeaStorm Dashboard consists of text descriptions and links.

That comment got me to thinking. Is there such a thing as a “real” dashboard? What makes something a dashboard?

I personally have always considered navigation as a legitimate goal of a dashboard. By categorizing information into the various “buckets”, a dashboard consisting of text and links does add value. It summarizes information and leads to further analysis. Summary information can definitely be enough to encourage action.

The Dell dashboard shown above has a mix of “real information” along with links. It shows a line of a particular suggestion and other data values. What about a dashboard that has just links? Will it still offer value?

Let’s take a look at AgencyTool’s Web Design Dashboard. It is a dashboard of resource links. There is categorization of topics via the use of portlets. You can hover over the links and get a synopsis of the resource that the link will take you to, but the intent of this dashboard is clearly that of a navigation device.

The screengrab of the dashboard is big, so click on the thumbnail below to enlarge the dashboard.

An Example of a Navigation Dashboard. Do you consider this a "real" dashboard?

Here is a closeup of the hover over / tool tip technique to provide information about the link destination.

Hover over links on the dashboard to see the destination details

So the question is this:

While a dashboard is clearly a design paradigm that can be leveraged for the clarity that it can bring as a visual design pattern, must one have business metrics on it to be considered a business dashboard? Isn’t a dashboard layout simply enough to qualifiy it as a “real” dashboard?

My own thinking is that navigation and categorization can bring plenty of value to business users and that our definition of business dashboards must also include dashboards as a visual design pattern. Many custom applications being built today have a “dashboard” tab on it that acts both as a summary of key information and as a drill-down starting point / navigation panel.

I say that this example is indeed a “dashboard”. What do you think?

Tags: Definition of Dashboard, Dashboards as a Design Pattern

Dow Jones Sparklines

Monday, October 13th, 2008

Every meeting in the office these days seems to start with talk about the economic crisis. Many people are quite worried about the stock market and check quotes all day long. I thought I’d try and keep your mind at least somewhat involved with data visualization while you check the Dow Jones.

Visit the Sparkline Stock Market Data Charts at Bissantz to see the sparkline charts of each of the 30 stocks in the Dow Jones average. While you are there, take a look at the bottom of your browser and check out the sparkline ticker.

Sparkline Charts of the Dow Jones Stocks

Tags: Sparkline charts for stock market data

Note: This is a post by The Dashboard Spy on the Dashboards by Example Volume 1 blog.

Stay tuned - Volume 2 is just getting started at this URL: http://dashboardsbyexample.com Dashboards by Example.

Business Graphics from Apple Computer

Thursday, October 9th, 2008

Business Intelligence - “You’ve come a long way, baby.” Sorry, I couldn’t help but think of that slogan from the old Virginia Slim ads when I saw this short film from Apple Computer. It’s on the advantages of business graphics.

Yes, Apple business graphics can help you do the following:

  • Turn a lot of numbers into a lot of a lot of answers.
  • Use the power of computing to help you understand the numbers.
  • No longer rely on the data processing department who would take weeks to produce a chart.
  • Graph your own data in two minutes.
  • Explain the numbers to management

Good thing, because, as explained in the opening of this 1982 film from Apple, “The information war is on!” and we need the power of business graphics on the Apple II.

In fact, according to this video, Apple business graphics is being used at over 6,000 offices today!

Here’s a screenshot I took of the charts being printed. Look at the old printer!

Apple Computer Business Graphics
 
Take a look at the video:

My favorite part of the video is when the male manager says to his female subordinate, “How about some overheads of these bar charts, OK?”. The “OK?” part just cracked me up. And of course, she’s totally cool with it and cheerfully replies with her own “OK”.

Boss orders business analyst to print bar charts Business Graphics Chart Production

Business intelligence history buffs should enjoy this trip back in time.

Watch more fun videos about Dashboards.

Tags: History of business graphics, Apple Computer Business Graphics

If you are new to enterprise dashboards, you really must start by reading the book by Malik:

Enterprise Dashboards: Designs & Best Practices for IT

To give you a flavor of the wonderful nuggets of enterprise dashboard knowledge, here is a quote from Mr. Malik in which he talks about the SMART elements that enterprise dashboards should have:

So, let us establish the basic characteristics specific to an enterprise dashboard with a useful acronym—SMART. A dashboard must be SMART in that it contains the following underlying elements, which are essential for success: