Archive for January, 2008

Intuitive Dashboard Design - Preattentive Variables

Executive Dashboard project participants are fortunate when they have the opportunity to work with true graphic designers on the visual design portion of the dashboard. There is a real opportunity to see that design is a real discipline and that the value the visual design team is not merely skin deep, but integral to the success of the dashboard interface. Of course, graphic designers vary in skill and understanding, but you know you are in the presense of a real master when they teach you the fundamentals of their trade. When they expose the “why” of their decision making, you learn that making your business intelligence dashboard intuitive relies on understanding factors of human perception.

Let me illustrate the point with a great example from the incredible book, Designing Interfaces by Jenifer Tidwell.

In the chapter on “The Basics of Information Graphics”, the author points out a topic of great interest and value: Pre-Attentive Variables. Basically, the idea is that you have to choose your visual features very carefully because they operate “preattentively” - that is, they convey information before the user pays conscious attention.

The author walks us through a great demonstration that we replicate for you Dashboard Spy readers. Here is a series of graphics to study to understand the principle so that you can apply it to your business dashboard designs:

Look at this first figure and find the blue items. 

Look for the blue items

Assuming you’re not color-blind (and probably even if you are), you can easily pick out the blue items.

Now try it with a larger field of data items:

Even more data to choose from

Still not a problem, as you can see. No matter the number of balls in total, you can easily pick out the blue ones, right? In fact, if you think about it, the time it took for the larger data set was not more than that for the first smaller set. You just look at it and see the blue ones. Instead of being a linear relationship with the number of objects, the time is not dependent on the number. That’s because this example operates on color. That’s the key, because color recognition happens at a primitative cognitive level. Your visual system does the heavy lifting for you and it works in a massively parallel manner. I bet we could show you a page full of balls and it would not take any more time to notice the blue ones.

Now, for the exciting part. Take a look at a text table.

Monotonous text table

Search through the above table for values greater than one. Not so easy, is it? But the real upshot is that if I were to increase the table size, it would take you longer, wouldn’t it? In this case, our parsing of the data values IS linear with the number of values displayed.

Now take a look at this version of the data table:

(more…)

Evolution of the First Balanced Scorecard

The Balanced Scorecard was introduced in 1992 according to the Wikipedia article on Balanced Scorecards.  I’m sorry, but that’s just plain wrong. How do I know? Arthur M. Schneiderman, long time process management guru and honorary Dashboard Spy, was there when the first balanced scorecard was developed at Analog Devices in 1987. It is the world’s first balanced scorecard and it’s still in use today.

Thanks to Mr. Schneiderman, we have a insider historic account of the long and eventful scorecard journey that Analog Devices took starting in 1986. See the incredible resource: The First Balanced Scorecard: Analog Devices: 1986-1992. There are outsider accounts of this first scorecard (i.e. Harvard Business School case) but it takes insider knowledge to really tell the story that would benefit implementation specialists like most of you readers of The Dashboard Spy.

The link above will bring you to a treasure trove of narrative and balanced scorecard project artifacts. Of course, I’m always on the lookout for screenshots. Among the finds I uncovered are a series of screenshots showing the evolution of the scorecard through 5 years of iterations:

Evolution of the first balanced scorecard

In addition to scorecard screenshots like the ones above (fully annoted with project observations, by the way), the site also offers the following:

(more…)

Executive Dashboards in Performance Improvement Frameworks

The Executive Dashboard is the key to driving a corporate culture of performance improvement. The red/green/yellow nature of displaying progress towards performance improvement goals is both intuitive and easily communicated. Everyone understands a KPI. To a top-level manager, each status indicator on the dashboard not only represents the underlying processes, but also is tied to a specific person that he or she manages. The use of the performance dashboard as a communication vehicle between different people involved with performance management and improvement is what makes the tool so useful.

Performance is a measure of results, but one that is abstract in nature. As an abstract concept, it must be represented by concrete events and measurable things. On top of this is the softer ”feeling” that a manager transmits up the chain via his inputs on his dashboard. An executive dashboard must combine hard measurements (surfaced automatically by the dashboarding software) and these softer communications (perhaps the managers “publish” an overall status by manually flipping red, green or yellow indicators as a communication device).

Let’s look at a Performance Dashboard White Paper courtesy of MyDials, a company focusing on executive dashboards via a “Software As A Service” model.

Their very informative paper sketches out the following Performance Improvement Framework:

3 dimensions of Performance Improvement

As you see, the idea is that executive dashboards provide managers with the ability to pay attention to three dimensions:

  • Management Focus
  • Measurement Philosophy
  • Improvement Methodology

 On the Management Focus axis, you want to move towards providing a true value stream that focuses on the client. Measurement Philosophy should move you towards a lean approach and the Improvement Methodology should strive towards a continous mode rather than sporadic.

Let’s look at a screenshot of one of their performance dashboards:

(more…)

Brand Scorecard for Marketers

While the creative aspects of marketing come to mind first when most people think about an enterprise’s marketing function, it is really the analytical aspects that guide the overall implementation of programs and allocation of funds. We all like to admire the slick deliverables having to do with advertising and promotion, but let’s all be sure to pay attention to the tracking tools necessary to make executive decisions.

Marketing programs generate a lot of data. A ton of data. I asked a Dashboard Spy reader who builds marketing KPI dashboards to send me a list of marketing metrics and got this list. He call it his “short” list!

Major Marketing Metrics Short List

Section Metric
Share of Hearts, Minds, and Markets
2.1 Market Share
2.1 Unit Share
2.2 Relative Market Share
2.3 Brand Development Index
2.3 Category Development Index
2.4–2.6 Market Share
2.4 Market Penetration
2.4 Brand Penetration
2.4 Penetration Share
2.5 Share of Requirements
2.6 Heavy Usage Index
2.7 Hierarchy of Effects
2.7 Awareness
2.7 Top of Mind
2.7 Ad Awareness
2.7 Knowledge
2.7 Beliefs
2.7 Intentions
2.7 Purchase Habits
2.7 Loyalty
2.7 Likeability
2.8 Willingness to Recommend
2.8 Customer Satisfaction
2.9 Willingness to Search
Margins and Profits
3.1 Unit Margin
3.1 Margin (%)
3.2 Channel Margins
3.3 Average Price per Unit
3.3 Price Per Statistical Unit
3.4 Variable and Fixed Costs
3.5 Marketing Spending
3.6 Contribution per Unit
3.6 Contribution Margin (%)
3.6 Break-Even Sales
3.7 Target Volume
3.7 Target Revenues
Product and Portfolio Management
4.1 Trial
4.1 Repeat Volume
4.1 Penetration
4.1 Volume Projections
4.2 Growth—Percentage
4.2 Growth––CAGR
4.3 Cannibalization Rate
4.3 Fair Share Draw Rate
4.4 Brand Equity Metrics
4.5 Conjoint Utilities and Consumer Preferences
4.6 Segment Utilities
4.7 Conjoint Utilities and Volume Projections
Customer Profitability
5.1 Customers
5.1 Recency
5.1 Retention Rate
5.2 Customer Profit
5.3 Customer Lifetime Value
5.4 Prospect Lifetime Value
5.5 Average Acquisition Cost
5.5 Average Retention Cost
Sales Force and Channel Management
6.1 Workload
6.1 Sales Potential Forecast
6.2 Sales Total
6.3 Sales Force Effectiveness
6.4 Compensation
6.4 Break-Even Number of Employees
6.5 Sales Funnel, Sales Pipeline
6.6 Numeric Distribution %
6.6 All Commodity Volume (ACV)
6.6 Product Category Volume (PCV)
6.6 Total Distribution %
6.6 Facings
6.7 Out of Stock %
6.7 Inventories
6.8 Markdowns
6.8 Direct Product Profitability (DPP)
6.8 Gross Margin Return on Inventory Investment (GMROII)
Pricing Strategy
7.1 Price Premium
7.2 Reservation Price
7.2 Percent Good Value
7.3 Price Elasticity of Demand
7.4 Optimal Price
7.5 Residual Elasticity
Promotion
8.1 Baseline Sales
8.1 Incremental Sales/Promotion Lift
8.2 Redemption Rates
8.2 Costs for Coupons and Rebates
8.2 Percentage Sales with Coupon
8.2 Percent Sales on Deal
8.2 Percent Time on Deal
8.2 Average Deal Depth
8.3 Pass-Through
8.4 Price Waterfall
Advertising Media and Web Metrics
9.1 Impressions
9.1 Gross Rating Points (GRPs)
9.2 Cost per Thousand Impressions (CPM)
9.3 Net Reach
9.3 Average Frequency
9.4 Frequency Response
9.5 Effective Reach
9.5 Effective Frequency
9.6 Share of Voice
9.7 Pageviews
9.8 Clickthrough Rate
9.9 Cost per Click
9.9 Cost per Order
9.9 Cost per Customer Acquired
9.10 Visits
9.10 Visitors
9.10 Abandonment Rate
Marketing and Finance
10.1 Net Profit
10.1 Return on Sales—ROS
10.2 Return on Investment—ROI
10.3 Economic Profit—EVA
10.4 Payback
10.4 Net Present Value (NPV)
10.4 Internal Rate of Return (IRR)
10.5 Return on Marketing Investment—ROMI; Revenue

For a look at an effective way to design a dashboard to surface metrics such as those listed above, let’s return to the VFX Platform demo provided by the talented team at The Dashboard Company.

Brand metrics Dashboard

As you can see from the screenshot, this is a brand performance scorecard. The text is a little hard to read in my screen grab so let me reproduce the description here:

(more…)