Analytics Dashboard Design Case Study

Case studies of dashboard designs are incredibly valuable and very hard to come by. When you find such treasures, read them and revisit them again and again. As your own dashboard design skills get honed over time, you’ll see the information with new appreciation.

Here’s a really good article on “Building your App Dashboard”. It walks you through the design and construction of a web analytics dashboard:

Evolution of a Dashboard Design

Just take a look at these great graphics from the article:

Evolution of a Dashboard Design

Application Dashboard Design

This excerpt from the article:

BUILDING YOUR APP DASHBOARD

It’s difficult to build a dashboard, without needing one first. This is why I think it’s a waste of time to build one before you have any customers. Inevitably you end up over-designing something that is impractical and showing you the wrong data. Once customers start using your application, you’ll have a much better idea what’s relevant and how often you need to see it. Even when the customers roll in, I’d still advise against building anything too fancy too soon. Here’s roughly how I see your needs and thus your dashboard evolve…

Dashboard Graphics in Microsoft Access

In recent Dashboard Spy posts, we’ve looked at the power of Microsoft Excel for business dashboards. We’ve shown you how simple it can be to embed icons and graphics into Excel dashboards. We’ve seen some pretty slick business intelligence dashboards with gauges, dials, bar charts and pie graphs. My favorite excel dashboards seem to be the ones that use spark lines.

Now it’s time to look at using KPI visualization such as meters and dials in Microsoft Access dashboards. Yes, you can actually use Access to create some visually interesting executive dashboards.

Take a look at this screenshot from an Access dashboard:

Microsoft Access Dashboard

or how about this one?

Access Dashboard

Nice, right? Want to know how to create your own Access dashboard with these nifty business dashboard graphics?

Go to this post:

Using Dashboard Graphics in Access

This from the article:

Let’s face it, Access isn’t typically a tool you would think of when considering a dashboarding platform. The reporting tools in Access, as slick as they are, don’t lend themselves to visualizations.

That is, Access doesn’t offer a whole lot in the way of dashboarding graphics. Sure, it has charts and conditional formatting, but nothing like Excel.

In this post, I’ll show you a hack to spruce up your Access reporting by using your own dashboarding graphics.

Excel Dashboard Celebrates Indian Cricket Worldcup Win

Want to see how you can use a tool you already own to create a compelling business dashboard? Download this file of an Excel Dashboard to see how Microsoft Excel can provide interactivity and out-of-the-box design capabilities for a complete modern business intelligence dashboard. First, have a look a the screenshot:

Excel Dashboard for Indian Cricket Worldcup Victory

Now download the excel worksheet here:

Excel Dashboard

Note that it’s an XLSM file. You’ll need to view it with Excel 2007 or Excel 2010. Be sure to allow the macros to turn on the full interactivity.

This is a great study and we have Chandoo to thank for it. Be sure to click on the “Learn how this dashboard is made” button to get a lesson on it’s construction.

Or follow this link:

Dashboard Tutorial

More on the Cricket dashboard from Chandoo:

How is this Dashboard constructed?

This dashboard was one of the most difficult ones I built, because I did not know what to put in the dashboard. I know that the dashboard should reflect our team’s hardwork, journey, outstanding performances but I had no clue which format & layout exposed these qualities. So I took a lot of time drawing up sketches of possible dashboards before hitting on the present layout. Once I came-up with the layout, the actual dashboard took me about 4 hours to make (and may be another 4 for polish).

Here are some of the techniques used in the dashboard:

The dashboard is divided in to 3 areas – Highlights, our journey to the victory and best performances.

Highlights: This section shows overall summary of all the 9 matches India have played. It shows some interesting statistics, how much our top players contributed to our victory etc.

Techniques used: All parts of this are made with text boxes and simple text formulas.

Our Journey to victory: This was the most time consuming & intense part of the dashboard as I made this portion interactive. The left side shows all the matches we have played by date and the results. When you select a particular match, the right side portion shows a match summary. This includes match venue, result, toss details, India’s top 3 batsmen, top 3 bowlers, photos of India’s best batting & bowling performers, oppositions score, best batsman, bowler, their stats. It also shows the country flags etc.

Techniques used: The click to select as described in on-demand charts article, conditional formatting, picture links, more picture links, LARGE formula.

The most difficult part of this was to get a moving arrow that would change its position based on which match is selected. I did this with picture links, offset formula and a dynamic named range. (Examine the named range movingArrow).

Best performances (top 10): In this area, I showed the best batting, bowling, catching, partnership performances for all the matches in World-cup (not just India’s matches).

Techniques used: All the charts are made in Excel 2010 using solid bar conditional formatting & picture link based techniques. Later, I just copied them and pasted as images so that they look same in Excel 2007 also.

Colors & Fonts:

I choose the blue color as it is team India’s jersey color. I used orange to contrast the best performances.
The fonts are Bookman Old Style & Meriyo UI.

Is Managing by Historical Data a Myth?

Today’s guest post on The Dashboard Spy is by Allan Wille, President and CEO of Klipfolio.

Myth: Managing by historical data is like driving while looking in the rear view mirror.

Catch Quote: “Managing through the rear view mirror. A dangerous practice for any business! You’d never drive only looking backwards.”

You’ve heard lines like this one before…it has all the right ingredients to be remembered and retold. It’s catchy, it paints a clear picture, adds a dash of FUD (fear, uncertainty, and doubt), and may even be confused with true wisdom!

Let’s debunk this.

Let’s frame the story by discussing measured data, environmental factors, and how decisions get made.

Measured data (we discussed measures, metrics and KPIs in this blog post http://www.klipfolio.com/blog/entry/305), or measurements are values associated with an agreed upon standard (such as km/h). For example, I’m driving at a speed of 50km/h. This is a “real-time” measurement, but it could have been; Yesterday, my top speed was 120km/h, or my average trip speed is 35km/h for the past 30 minutes. Measured data is historical no matter how you spin it. However, knowing when the data was measured is a critical factor that often gets left out of the “rear-view mirror” picture.

Let’s say you’re driving in an unfamiliar neighborhood. You know from experience (historical data) that on a street of this size, with children playing outside, you should probably not exceed 40km/h. Ahead, a road-sign warns of a school zone: 25km/h max. This is new data, and it will cause you to adjust your speed.

In that example, the sign is an environmental factor. When you’re making business decisions, environmental factors might include competitive threats, economic opportunities, or regulatory changes. A simple way to differentiate might be to think of these as the external factors – the O and T of your SWOT analysis. Don’t confuse environmental with a sudden snow storm…although that too, should cause you to drive differently.

Provided you’re not flipping a coin, decision making is, of course, much more involved. Past experiences (measured historical data) are combined with cognitive and personal biases (know any folks at your office?), environmental factors, and time constraints to influence the choices people make. Read up at Wikipedia: http://en.wikipedia.org/wiki/Decision_making. Interesting stuff.

I suspect that much of where the rear-view mirror warning comes from has to do with using an appropriate timeframe. My speedometer tells me how fast I’m going now, not yesterday – yes, that would indeed be dangerous. Is that the issue?

Ideally, and this is possible using today’s dashboards and BI software, you would have the following decision support at your disposal:

1. Current performance (real-time or near-real-time)
2. Timeframe-appropriate historical performance data
3. Predictive or conditional alerts (based on goals, history, or environmental factors)

Let’s add a pre-emptive note about predictive analytics – a wonderfully powerful tool to assist with future decision making. Keep in mind though, that predictive models exploit patterns found in historical and transactional data to identify risks and opportunities for future decision guidance.

Nobody has a crystal ball. However, a keen understanding of your history, an understanding of trends and cycles, awareness of your environmental factors, and smart, analytical thinking will help you predict what’s around the next corner.

About the author:

Allan Wille is President and CEO at Klipfolio Inc. An expert in operational data visibility and performance dashboards, Allan helps global enterprises to simplify and grow KPI usage across the workforce to drive higher performance and profitability.

Allan is responsible for the strategic vision, direction and operations of Klipfolio. He is an evangelist of the company’s vision to make operational metrics easier to use.

Apple Uses Dashboard Layout for Discussion Forums Redesign

Dashboard Spy topic: Dashboard Layout Design, a new example from Apple – the Apple Support Communities Dashboard. When Apple rolls out a redesign, it behooves us to sit up and pay attention. Especially if the new design includes a dashboard layout.

The recent revamp by Apple for its discussion forums in the Apple Support Communities includes a user configurable dashboard. A new tab on the support communities main page called “Your View” is a customizable dashboard view. In order to see it, you’ll need to log into your Apple Support Communities account. See this screenshot:

Apple Support Communities Dashboard

From a design perspective, it’s really interesting how the dashboard designer calls attention to the fact that the “Your View” tab is customizable. Note that the big blue “bubble” really draws the eye to the fact that personalization of the dashboard is possible. What a strong selling point to the dashboard users.

What Kind of a Business Dashboard Do You Have?

Is your dashboard an Operational, Tactical, or Strategic Dashboard?

This excellent article by Allan Wille of Klipfolio KPI Dashboards reminds us of how Wayne Eckerson’s Book “Performance Dashboards: Measuring, Monitoring, and Managing Your Business
” (now in it’s second edition), categorizes performance dashboards into the 3 types of Operational, Tactical and Strategic dashboards.

This from Allan’s article:

In a nutshell, Wayne defines Operational Dashboards as being focused on exception alerting, based on real-time or transactional data. It’s up to the user or a script to then act upon this opportunity or issue. OK, I’m with him so far.

Tactical Dashboards display data that is not quite as real-time as operational dashboards, and are generally not evaluated against absolute conditions. Contextual information, and the ability to explore the data, tends to guide users to the decision process.

Strategic Dashboards, according to Wayne, track performance against high-level objectives. As a result, these dashboards tend to summarize performance over the past month, quarter, or year. Strategic objectives are usually also the result of many underlying metrics, and require social analysis to digest properly.

Wayne goes on to describe which dashboards tend to be the most popular, and which ones amass the most users. Five years ago, strategic dashboards captured the popularity vote (in the number of firms having deployed this type). However, with the growth of operational BI outpacing traditional BI, I wonder if it’s still in top spot. Certainly there is no question about which dashboards capture the greatest audience … you just need to follow the pyramid of employment to know that tactical and operational dashboards out-number strategic ones. Some of our customer deployments range in the tens of thousands.

No matter what you call them, performance dashboards are seeing incredible growth. And, as the accessibility, ease of use, self-service, and costs become more competitive, this trend is not likely to slow down.

Read more at this link:

Operational, tactical, strategic … what kind of dashboard do you have?

Stephen Few Judges Infographics Contest

Business intelligence visualization expert Stephen Few was one of the judges of an international competition for journalistic infographics. He and 9 other brilliant judges spent over 3 days poring over the merits of 1300 examples. They awarded 7 gold medals, 25 silver medals and 70 bronze medals for infographic excellence. Alas, they did not produce any infographic detailing the results nor showcasing the winners. (Now, THAT’S a great idea for an infographic!

Take a look at the brainpower of this panel of judges:

Stephen Few judging infographics

Stephen’s blog post, Malofiej 19 in Review, details his experience in depth, so be sure to visit.

He reveals that the top prizes include a Best of Show for the Print category done by National Geographic for “Gulf of Mexico: A Geography of Offshore Oil”.

Here’s a peek at the winner:

Gulf of Mexico Geography of Offshore Oil

And here’s my favorite, the Best of Show for the Online category: New York Times for “How Mariano Rivera Dominates Hitters“. Click that link to watch the amazing video.

mariano rivera pitching infographic

Be sure to visit Stephen’s blog for the other winners.

Hubert Lee
The Dashboard Spy

About the Enterprise Dashboard Digest

Several of you Dashboard Spy readers have asked me how to refer readers to my new business intelligence dashboard newsletter.

The newsletter is called The Enterprise Dashboard Digest and is a weekly compilation of dashboard examples, business intelligence posts and interesting videos about related topics.

You can sign up here if you are not currently on the distribution list:

Sign-up To The Enterprise Dashboard Digest!
Enterprise Dashboard Digest

The digest is a compilation from the following Dashboard Spy resources:

The Dashboard Spy Blog
The Dashboards by Example Blog
The Dashboards.TV Video Collection
The Dashboards.ORG Community

Here’s what the Enterprise Dashboard Digest looks like:

Enterprise dashboard digest

Business Intelligence Best Practices Benchmark Report

Dashboard Spy resource: Business Intelligence Best Practices Benchmark Report

A new business intelligence white paper has come out that’s worth getting. It features detailed examples of ROI from business intelligence projects, a summary of the drivers and obstacles of BI projects and metrics for tracking and measuring the success of BI implementations.

What’s different about this one is the emphasis on quick ROI – they stress the importance of immediate results over long drawn out perfect system architecture-type projects.

Get the white paper here:

Business Intelligence Best Practices Benchmark Report

Metrics for Measuring Afghanistan War

From the Dashboard Spy: Metrics and KPI analysis was and still is a big part of the U.S. involvement in Afghanistan. Statistics and intelligence is often subject to bias depending on one’s view in any situation but is especially common in politically charged scenarios. It’s my observation that

Here is President Obama talking about 50 metrics for measuring success in Afghanistan:

And here is a pdf on Afghan Campaign Metrics titled The Aghan War: Metrics, Narratives and Winning the War.

It’s full of business intelligence (military intelligence?) charts and graphs showing various metrics. Here’s an example of a map driven analysis:

Afghan war metrics

A good analysis is here:

http://csis.org/publication/afghan-war-metrics

An excerpt:

Analyzing, Fighting, and Reporting on the Afghan-Pakistan War

No one approach to providing the proper mix of metrics and narratives in analyzing, fighting, and reporting on the Afghan conflict is “right,” and no unclassified, outside analysis cannot assess the fully range of what the US, ISAF, and allied countries are already doing. Moreover, the tasks involved include trying to deal with multiple “centers of gravity” in which US civil-military splits, other divisions within a 46-country alliance, problems in GIRoA, the fact this is both an Afghan and Pakistan conflict, and a foreign aid effort which is often decoupled from the reality that Afghanistan is at war all combine to vastly complicate the problems in providing an adequate mix of narratives and metrics.

Accordingly, the Burke Chair has developed a report that focuses on the full range of problems in the reporting and metrics the author saw in a recent trip to Afghanistan, and has seen in US, ISAF, UN, and other reporting over the last eight years. This report is entitled The Afghan War: Metrics, Narratives, and Winning the War and is available on the CSIS web site at

http://csis.org/files/publication/100607_AfghanCampaignSummary_0.pdf

To the extent that the complex mix of issues contained in this report can be summarized for discussion purposes, they are condensed into the following six points:

* The narrative will always be the key message, not the metrics. Metrics should support the narrative.

* There needs to be far more focus on metrics and narratives that show progress in key operations and in meeting key challenges – rather than trying to map every aspect of the war, and create some kind of integrated model.

* It is far better to provide the best and most relevant metrics and narrative for a given operation/challenge at a given time, than to seek nation-wide coverage and consistency over time.