Archive for the 'Dashboards' Category

Enterprise Dashboard Mashups

The recent post on Dashboards By Example on creating WebSphere Portal Dashboard Mashups using Google Gadgets triggered a few discussions on whether or not the public APIs (Google Maps, etc) consumed by mashup dashboards and applicaitons will really be embraced by Enterprise IT. The hesitation expressed concerned the lack of ownership and control of the data.

For those of you that didn’t see the post, I basically ran through some of the impact that Web 2.0 has had on enterprise dashboards. In particular, I discussed how the availability of APIs from Amazon, Google, Yahoo, etc has allowed a surge of Dashboard Mashups - or dashboards that consume both data and behavior from many difference sources. Think of it as web services and SOA come true in its most user-centric way.

There was no doubt among the Dashboard Spy readership that the user experience will benefit, but some dashboarders with a traditional IT mindset seemed a little “scared” of the fact that their applications would be exposing both data and behavior that they did not own.

I point out the very informative InfoWorld article from July 28, 2006 called Enterprise Mashups: Web 2.0 Style Integration at the Browser Isn’t Just for Consumer Apps Anymore and Businesses Are Starting to Take Notice.

Enterprise mashups cover page Info World magazine

I took the liberty of “borrowing” a couple of key graphics from the article (Once a Dashboard Spy, always a Dashboard Spy, I suppose!).

First, let’s have a look at what they call “The beautiful simplicity of mashups”.

Diagram of How Enterprise Mashups Work

Here is a listing of what they identified as enterprise mashup best practices:

(more…)

Evolution of Dashboard Design Aesthetics

Using the word “Aesthetics” in conjunction with discussing business dashboards or software in general can be tricky. As most commonly used, aesthetics refers to the way something looks and whether or not it can be considered art. Let’s not go into the discussion of whether various dashboard software elements look good or not. I truly believe that most of that is basically opinion (although of course there are generally accepted prinicipals). No, what I am trying to get to is more of a common category of a visual look. An aesthetic, for example, would be the current Web 2.0 look. You know, that shiny, big-button look that you see everywhere these days. Even on business dashboards.

How does something become an aesthetic? Without delving deeply into the “what is art” discussion, I would say that an aethestic develops out of seeing common design solutions arise out of a particular time and place (virtual places are allowed - doesn’t have to be a physical location). This confluence of similar design takes hold and eventually becomes something that is purposefully strived for as a “look”. That’s when it becomes an aesthetic.

Starting a few years ago, we saw a real growth in the use of CSS for design and styling purposes. By adopting CSS-driven approaches to design elements, we started to see common looks arise. For example, the gradient background, the rounded corners, etc. This css-based look appeared on the “new” sites that were powered by the technologies that we associate with Web 2.0 - CSS/DOM/AJAX, etc. Once the Web 2.0 “look” started being shared through templates (especially on blogging platforms), this look really took off - in fact, it became rapidly emulated. Now, we have the Web 2.0 aesthetic - one that new sites want to adopt so as to be seen as Web 2.0 i.e. new and improved!

Here is a good slide presentation of what makes something look like Web 2.0:

What does Web 2.0 Look Like?

Bringing the discussion back to business intelligence dashboard design and the Web 2.0 design aesthetic, let’s take a look at a dashboard screenshot sent to me by a Dashboard Spy reader who is indeed striving for that 2.0 look.

I have it over at the Dashboards by Example site, but here is a quick screengrab of the upcoming new Dashboard/Scorecard product that’s been under wraps. Have a look and I’ll explain more in the post titled Balanced Scorecard Meets Web 2.0. Please click on the image to bring up a larger dashboard screenshot:

KPI2.0 Dashboard

Tags: Dashboard Design, Web 2.0 Aesthetic, Business Intelligence Dashboard Design

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…)