The Big Book of Dashboards

Chapter 6 Ranking by Now, Comparing with Then

Ranking by now, comparing with then dashboard for a single period.

Author: Steve Wexler

Organization: Data Revelations

Note

In this dashboard, we show the percentage of survey respondents who rated a product or service very highly (“Promoters”). For a discussion of how to visualize data that takes into account Promoters, Detractors, and people that don't care one way or another (“Neutrals”), see Chapter 17.

Scenario

Big Picture

Your company takes customer satisfaction very seriously. You monitor it on a monthly basis by major geographic areas (divisions) and subareas (regions) and need to see in which areas it's increasing, decreasing, or staying the same.

You want to be able to react to downturns quickly, but you don't want to panic unnecessarily so you need to see if changes from the previous time period are statistically significant. You also need to be able to look at changes over time to see if big swings are isolated to the particular period or indicative of a larger problem.

Specifics

• You are tasked with showing the percentage of customers who are very satisfied with your products and services (“Promoters”), broken down by division and region.
• You need to sort the data by region so it's easy to see in which divisions customers are most satisfied and in which they are least satisfied.
• You want to make it easy to see ...