How to Pick a Chart for Your Dashboard

As Dashboard Spy readers know, dashboard chart selection is fraught with peril and the subject of many books and blogs. I’ve written at length about the relative merits of different chart types and stress how the decision of which chart to use should not be made frivolously nor at random.

To help you (or perhaps to confound you further), I present the “Chart Chooser” or aka “Chart Selections Thought Starter” from www.extremepresentation.com.

Take a look at this screengrab of the graphic and I’ll give you a higher resolution pdf link below the chart.

Chart Suggestion Thought Starter

For a larger pdf, use this link:

Chart Suggestions – A Thought Starter

Here’s an excerpt from the author:

Choosing a good chart: Here’s something we came up with to help you consider which chart to use. It was inspired by the table in Gene Zelazny’s classic work Saying It With Charts (p. 27 in the 4th. ed)

By the way, the chart chooser is step 7 in the 10-step Extreme Presentation method for designing presentations that drive action. More details on the chart chooser methodology here:

http://www.extremepresentation.com/design/charts

Dashboard Explorer Used on Recovery.gov Dashboards

A long time Dashboard Spy reader shared his enthusiasm for the way the federal Recovery.gov site presents its transparency dashboards. They use a nicely laid out navigation page at their Recovery Explorer.

Here’s the note I got from GP:

I have enjoyed reading your BI news site for new information on data, visualizations and dashboards etc.

Wanted to share with you a cloud-based analytics platform that the Recovery.gov site just launched.

http://www.recovery.gov/Transparency/Pages/dataexplorerlanding.aspx

Your readers might find it interesting. I am not aware of any other information discovery resource in the public sector that surfaces up information in such a fairly clean and yet powerful way.

BTW, all of this is hosted in the cloud.

Here is the Recovery Explorer:

Recovery Explorer

And here is an example of the type of transparency dashboard that it navigates to (screenshot shows a fund award dashboard):

Funds Award Dashboard

Definitely check these transparency dashboards out. They are powered by SAP and quite impressive.

Hubert Lee
The Dashboard Spy

Using Sharepoint to Create an Absence Management Dashboard

SharePoint is an easy way to give dashboard type functionality to a portal. In this example, we look at some webparts that can quickly power an absence management dashboard.

Take a look at this little vacation and absence planner:

absence management dashboard

You can set the colors of the chart by this little admin panel:

absence management dashboard admin

If you want to do further research into this little absence management sharepoint application, go here:

SharePoint Dashboard for Absence Management

Free Excel Dashboard Templates from L3 Analytics

Excel dashboard expert and long time Dashboard Spy reader Peter O’Neill is the founder of London based business consultancy L3 Analytics.

Peter is thrilled to share with fellow Dashboard Spy readers his collection of free EXCEL DASHBOARD TEMPLATES.

Take a look at this screenshot and then look for the links below to the excel dashboards.

excel dashboard template

Here’s his note to me:

Hi Hubert,
Thanks again for this, going to be great to get onto a blog such as yours.

The blog post introducing the dashboards can be found at http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/.  It describes why dashboards are important in my field of web analytics, the contents of the dashboards and how they are created/updated.  There are two dashboards available for download, allowing segmentation or without segmentation, both available in Excel 2007 and Excel 97-03.  I have additionally provided a sample dashboard so that users can see what the dashboard looks like once created.

Links

Information

These performance dashboards have been created to fill the gap between Reports and minimalistic Actionable Dashboards.  They provide valuable information to their users but do not overwhelm them with data.  If set up with appropriate KPIs, they provide all the data required by a business owner for them to understand performance without the need to use a web analytics tool themselves.  Any questions can be raised with an analyst to investigate further.

The Performance Dashboards are very customisable, allowing users to define up to 12 metrics and 6 segments along with the relevant time period (day, week or month) and choose between three versions of the dashboard design.  Details are entered into a Setup worksheet and then the dashboard is automatically created via a macro.  Full instructions are included with each dashboard.

Updating these dashboards each period is also automated once data has been entered into a Data Summary worksheet.  Ideally the data extract would be automated as well but this has not been included as the dashboards can work with any web analytics tool or alternative data source.  Customised dashboards including set up and automation of the data extract are available through L3 Analytics.

Bio

L3 Analytics is a London based business consultancy, making use of web analytics data to improve the performance of online organisations. They offer a full range of services from the set-up of web analytics tools through to transforming data into the intelligence required by business decision makers.

I have tried to keep all the information short and to the point here, let me know if you would like me to expand on anything. 

Thanks again

Peter O’Neill

Training Dashboard Users

Is your user documentation up to par? Or, rather, is it what it really should be to give your users the degree of help and support they need? As most of you will probably admit, the amount of attention given to user documentation and help pages is not at all commensurate with the effort placed into the design and implementation phases of the software development life cycle. It is all too easy to concentrate practically 100% of our resources on the “hard stuff” and leave user support and help documentation as an afterthought.

Here’s how one dashboard system approached the user documentation issue. Take a look at this screenshot of the dashboard user training and then visit the link below to experience the help pages for yourself. It’s basically a video demo for the user on how to navigate the dashboard and what settings to use for different purposes.

bank dashboard demo

The dashboard support pages are for the CityNational Bank dashboard and can be viewed here: CityNational Bank Dashboard Demo

Watch the training video and you’ll see that they really take the user by the hand. A typical dashboard training screen has text such as “When you expand a dashboard element, the other configured elements do not appear. They move over to the side navigation bar. From this screen, you can either double-click the heading of the open element to collapse it or you can click on one of the other element icons in the navigation bar to expand it as well!”

One thing that you might notice is that it seems a little silly to describe in words something that is so apparent in an image. However, you really should take that approach as it really helps when a picture is just confusing someone. Belt and suspenders!

Have You Downloaded These Dashboard Templates?

Many Dashboard Spy readers write me asking about an open source business intelligence dashboard template. I always refer them to a series of HTML templates for dashboards that I’ve put together.

Take a look at this page to see if you have these already. If not, sign up using the form on that page and I’ll send what you need to you. Sign up (there is absolutely no cost) and you’ll also get 2 other templates that I’ve put together.

Here’s the link and screenshots:

Dashboard Templates

Dashboard HTML template

Dashboard template for powerpoint

Dashboard Approaches – KPIs versus Operational Lists

This article was contributed by Klipfolio, the business dashboard software company that is focusing on KPI Dashboards and the topic of my previous article about the cool opportunity to be a beta tester for their new dashboard version.

KPIs or lists? Chances are your dashboards need both.

by Allan Wille, President and CEO.

At Klipfolio, experience has taught us that designing dashboards to ensure the effortless visibility of tactical, tangible, real-time operational data across departments and throughout the corporate hierarchy means distinguishing between two typical use cases: monitoring key metrics (KPIs), and providing operational lists. Both are important. Ignoring either can hurt your performance. And, when designing your dashboards, knowing which to use is critical.

KPI visualization

You’re no doubt familiar with the first case. The need to monitor a key metric – usually a numeric value expressed as a ratio or percentage – is well understood in the BI world. I’ve discussed KPIs in detail in past blogs and articles (see What is a KPI, Metric or a Measure? and The Anatomy of a KPI). And a web search for KPI dashboards or operational BI will deliver examples of KPIs that represent business metrics.

These business metrics are invariably displayed as absolute values, ratios, or percentages. If they’ve been designed properly, they’ll likely have associated contextual values, such as goals, averages, or benchmarks, that make it easier to evaluate the KPIs.

An example might be a KPI designed to help a marketing manager keep a close eye on campaign performance – one that tells them something like “Campaign A has delivered 400 leads over the past 30 days compared to our goal of 450 and our historical average of 435.”

The operational list

If you’re like many BI users, you’re not so familiar with the second use case: the operational list.

Lists might seem like old technology, but as data sources become more tactical and right-time in nature, lists make a lot of sense. Examples might include a prioritized list of leads or opportunities for a sales rep, or a list of high-priority incidents that need resolving by a support agent.

Although not KPIs in the strictest sense, these lists embody much of the same spirit – they are time sensitive, tactical in nature, actionable, and highly relevant to individuals in specific roles.

Which to use?
When should your dashboards monitor KPIs and when should they deliver operational lists? It depends on the roles of the people whose performance they are designed to maximize.

For executives, whose role is to manage, plan, and improve efficiencies and performance, KPIs are more useful.

The sales campaign KPI metric already mentioned is a case in point.

On the other hand, front-line workers, such as sales reps and support agents, typically benefit more from operational lists. They need information like that provided by the leads and opportunities lists I’ve described. And they need lists that are easily understood, so they can prioritize and align tasks, and act quickly to fix problems and take advantage of opportunities.

It’s not “either/or”

When it comes to KPIs vs. lists, it’s not always an either/or situation, and chances are good that you’ll not only need both types of operational dashboards, but that some of your dashboards will include both KPIs and lists.

KPIs and lists are, in fact, closely related, and lists will typically impact KPIs. Today’s “open-incident/closed-incident” ratio, for example, which will be derived from a list critical for helping support agents perform effectively, is an important number for managers to track. And those same managers might want to monitor a list that tells them about deals over $100K, or sales to key customers, even though they aren’t likely to take immediate action based on what they learn.

In the same way, sales reps, agents, and other workers whose day-to-day performance means focusing on key lists first and foremost, might well monitor KPIs as a valuable way to understand performance and to perform better themselves.

Use cases and dashboard design

When designing operational dashboards, it’s important to keep the two use cases – KPIs and lists – in mind. It’s essential to recognize that they address two types of needs. And it’s critical to analyze the type of need you are addressing for each person’s role, and to design your KPI or list dashboards accordingly. Dashboards for your executives and managers will likely be KPI-heavy, while those for front-line workers will tend toward the list end of the spectrum.

Nasa Mission Control Dashboard

What would you think an enterprise dashboard would look like if it was built by rocket scientists? Well, here at The Dashboard Spy, we have all sorts of dashboard examples – including this mission control dashboard from NASA. Built for monitoring a satellite, this mission dashboard followed the lifecycle of an entire mission. Take a look at this dashboard screenshot and then look for the link to the actual dashboard below:

nasa mission dashboard

You can view the mission dashboard at this link:

Nanosail-D2 Mission Dashboard

When you visit the dashboard, you’ll see interesting links including a sample of what the audio signal from the satellite sounds like.

This is quite a fascinating project. Here is an excerpt of some information about the solar sail:

“Hold your hands out to the sun. What do you feel? Heat, of course. But there’s pressure as well – though you’ve never noticed it, because it’s so tiny. Over the area of your hands, it only comes to about a millionth of an ounce. But out in space, even a pressure as small as that can be important – for it’s acting all the time, hour after hour, day after day. Unlike rocket fuel, it’s free and unlimited. If we want to, we can use it; we can build sails to catch the radiation blowing from the sun.”

These words were spoken not by a NASA scientist but by a fictional character – John Merton – in Arthur C. Clarke’s short story The Wind from the Sun. If all goes well, Merton’s prophetic words are about to become fact.

NASA researchers, thinking “out of the box” (or maybe “out of the rocket”) have long dreamed of the possibility of sailing among the planets with sails propelled by sunlight instead of by wind. Except in works of fiction, though, no one has yet successfully deployed such a sail anywhere beyond Earth.

“There’s a first time for everything,” says Edward “Sandy” Montgomery of NASA’s Marshall Space Flight Center.

Montgomery’s team and a team from Ames Research Center (led by Elwood Agasid) hope to make history this summer by deploying a solar sail called NanoSail-D. It will travel to space onboard a SpaceX Falcon 1 rocket, scheduled for launch from Omelek Island in the Pacific Ocean during a window extending from July 29th to August 6th (a back-up window extends from August 29th to September 5th).

Here is the official NASA video on the satellite:

Keys to a Successful Balanced Scorecard Project

A reader recently shared with me an incredibly helpful article on ensuring a successful scorecard effort. I found it so solidly written that I thought I’d share it you all you business dashboard project implementers.

It’s from a 2007 university paper. Here’s the abstract:

The Balanced Scorecard concept has been adopted by all types of organizations (manufacturing and service, for-profit and not-for-profit, private and public) in virtually every developed and developing nation in the world and it has evolved from its initial purpose of an improved performance measurement system to become the basis of a new management system, one that aligns and focuses the entire organization on implementing and improving its strategy. Niven’s opinion is that Balanced Scorecard means three things: measurement system, strategic management system, and communication tool. The paper talks about the Balanced Scorecard philosophy and the issues that need to be solved for a successful BSC implementation an provides recommendations for the formulation and implementation of the Balanced Scorecard.

Take a look at the Top 10 Key Elements of a Successful Balanced Scorecard Project:

Tips for a successful balanced scorecard

Some excerpts from the section about the top key to success:

Lack of Executive Sponsorship

With tenacious leadership and support a Scorecard project could ultimately succeed despite a lack of training at the outset. Without executive sponsorship, however, the effort is most likely doomed.
Many Scorecard elements will take place in stages—first strategy is deciphered and translated; objectives, measures, targets, and initiatives are then developed; the Scorecard is cascaded throughout the organization; and, finally, it becomes embedded in the organization’s managerial processes. Executive support and sponsorship is the common thread that connects the entire end-to-end process. Without a strong and vocal leader present at each and every juncture, the effort can quickly stall.