Archive for October 2008

Synchronized Presidential Debates Dashboard-Style

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.

Continue reading ‘Synchronized Presidential Debates Dashboard-Style’ »

2008 Political Dashboards for the Election Home Stretch

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!

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)

Continue reading ‘Intranets, Portals and Dashboards, Oh My!’ »

Real Time Excel Dashboard Tracks Gas Prices

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

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:
Continue reading ‘CERN Collider Dashboard’ »

Dashboards As Navigation

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

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

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

Carbon Footprint Dashboard

When Dashboard Spy reader Jonathan Nell said that the dashboard screenshot he just sent over was really “cool”, I didn’t think he meant it literally. Well, he did. The Carbon Footprint Calculator is a data visualization example featured at CoolCalifornia.org, the portal for a consortium of California agencies and organizations.

The California Air Resources Board, California Energy Commission, Next 10, Lawrence Berkeley National Lab, Berkeley Institute of the Environment, and the Renewable and Appropriate Energy Lab have partnered to provide the technology to enable Californian individuals and businesses the ability to evaluate their carbon footprint. The carbon calculator provides emission estimates for personal transportation, housing, food, goods and services.

Users navigate through a series of tabs and ultimately wind up at a summary dashboard. Let’s take a look at the six tabs of the carbon calculator. Click on the images to enlarge them.

CoolCalifornia.org Carbon Footprint Calculator - Tab 1 - Home Economic Information

CoolCalifornia.org Carbon Footprint Calculator - Tab 1 - Home Economic Information

Carbon Calculator - Tab 2 - Transportation Data

Carbon Calculator - Tab 2 - Transportation Data

Carbon Calculator - Tab 3 - Cost of Housing and Utilities

Carbon Calculator - Tab 3 - Cost of Housing and Utilities

Carbon Calculator - Tab 4 - Food Expenditures

Carbon Calculator - Tab 4 - Food Expenditures

Carbon Calculations - Tab 5 - Cost of Goods and Services

Carbon Calculations - Tab 5 - Cost of Goods and Services

Carbon Footprint Calculation - Tab 6 - Summary Dashboard

Carbon Footprint Calculation - Tab 6 - Summary Dashboard

The CoolCalifornia.org carbon calculator was created with Crystal Xcelsius.

Tags: Green dashboard, building dashboards, energy dashboards, carbon calculations.

Glanceable Dashboard Monitors Physician Performance

Dashboard Topic: Patient Feedback Dashboard Allows Doctors to Measure Communication Skills.

Today’s physicians and health care facilities make use of the latest advances in technology to aid in their diagnoses, manage their practices and even assist in surgery. Have you noticed, however, that there has been a decline in the quality of a doctor’s bedside manner? Or at least there seems to be from the way everyone seems to complain about it.

Whatever happened to the kindness and compassion that was the hallmark of a doctor? Whether it’s the fault of the training process or the growing aggravations of managing a medical practice, it seems that with the rise of technology in the medical office, we have seen a fall in patient satisfaction.

I’m happy to report that one particular technology – that which we study everyday here on “Dashboards By Example” – namely, the business intelligence dashboard is now being used by physicians to monitor patient feedback. The Department of Family Medicine in the Medical College of Georgia School of Medicine (MCG) is running a pilot program that lets doctors collect feedback and view the results of patient satisfaction surveys on a performance dashboard.

Finally! Now the patient can do something about the decline in bedside manner. Haven’t you ever wanted to leave feedback about a doctor’s bedside manner but didn’t do it because you couldn’t remain anonymous? Most of us in that situation simply found another doctor. We were unhappy but never provided feedback about our experience. That changes now with the system in place at MCG.

I’ll explain the details, but let’s first examine the dashboard itself. Here is the doctor’s view:

Physician Dashboard Monitors Doctor Performance and Patient Satisfaction

Click to see the rest of this post. We’ll discuss the patient view of the dashboard and how the survey questions are administered.
Continue reading ‘Glanceable Dashboard Monitors Physician Performance’ »