This post contains affiliate links you can use to purchase the book. If you buy the book using that link, I will receive a small commission from the sale.
You’ve considered the purpose of your dashboard. You’ve worked with colleagues to ensure the questions being answered are the correct ones. You’ve considered layout and design and made something beautifully functional. In fact, you’ve made a successful dashboard that helps people answer the questions they are asking.
Congratulations! Building an effective dashboard is a difficult thing to do, and you’ve done it.
But if you think your work is done, think again; you’re just getting started.
Dashboard projects do not have endings. Your business evolves over time, and your dashboards should do the same. If not, they run the risk of becoming zombie dashboards, updating daily, shuffling along like the living dead. How many organizations have dashboards that perhaps were useful once upon a time but outlived their usefulness and were never replaced or updated?
How exactly do you ensure you have an evolving, thriving dashboard culture? We recommend taking four steps, discussed next.
1. Review Your KPIs
Every dashboard you build answers questions that are current at the time of the design. Consider the key performance indicator (KPI) dashboard featured in Chapter 8, shown again in Figure 32.2.
Look at the reliability rate. It’s been hitting target for a considerable time. There might come a time when the business should ensure it is still measuring the right thing. If that KPI never fails, why measure it? In this case, there is only one year of data so it is probably too early to be sure this KPI is fixed, but after another year?
2. Track Usage with Data
Do people use the dashboards you’ve designed for them? If a dashboard was intended to be looked at by, say, 20 senior managers once a week, are you achieving that? Maybe the dashboard’s never been used, or maybe its usage is waning.
“Low dashboard usage typically signals a need for change,” says Matt Francis, who is responsible for analytics at the Wellcome Trust Sanger Institute. “Sometimes they are for projects that are wound up. Other times requirements have changed so we work with people to refresh them. This way we ensure dashboards on our systems are giving users answers they need.”
Here are a few specific questions to begin your review:
- Which dashboards are most and least popular?
- Which dashboards were popular but aren’t any-more? These dashboards might cover a problem that the business has now solved.
- Which dashboards are used by only a small section of the intended audience? Low usage might indicate that some users haven’t been trained properly in using the dashboard. It could mean that some users have different questions that the dashboard does not answer.
These questions can be answered by using data. Get the metrics on the number of times a dashboard has been looked at, over time.
3. Speak to Your Users
If you’re designing dashboards for other people in your organization, when was the last time you asked them what they think of the dashboards? In fact, have you ever actually sat down, in a room, in front of the dashboard, and talked through how it is used? My hunch is that many people don’t speak to the intended audience enough.
Why do I have that hunch? I was guilty of this in my early days as an analyst. I would publish what I thought were beautiful, insightful dashboards, then proudly send an email to everyone proclaiming something as grand as “It’s here! The dashboard you’ve all been waiting for. Click this link and insight will follow!” In the following weeks, I would become frustrated as I looked at the data on who was using the dashboards, wondering why my work was being ignored.
What I hadn’t done was enough consultation with the users at the end stages of the project. I hadn’t sat down and watched them use the dashboard I’d created.
Sitting down behind someone and asking them to use your dashboard can be a very humbling experience. (“Oh no, they can’t answer their questions and I thought I’d made it easy.”) It can also be frustrating. (“How can you not see that there’s a filter on the lower right? All you have to do is click it!”) However, it’s the best way to spot the mistakes in your dash- board and x them before sending something to your organization that people won’t be able to use.
4. Build Starter Dashboards
We like to personalize our possessions. We all buy the same smartphone but then accessorize it with a case in order to make it our own. What if you gave all users a basic dashboard and allowed them to personalize it for their own needs? Doing this acknowledges that fact that everybody wants to tailor data in their own way. I work at Tableau. We do have core sales dashboards, but when we hire new salespeople, instead of pointing them to a set of dashboards that they need, we point them to a very basic dashboard, showing very basic sales information: sales over time and by geography.
They tailor the dashboard over time, as they get used to their part of the sales organization, so that it answers the questions they need for their jobs. Not only do they build something relevant to their needs, they also have a better sense of pride and ownership because it’s their own toy.
What does become critical in this situation is that there is consensus around the goal. Not only must everybody be using a well-governed data source, it’s also important that each employee is well aware of the strategic goal.
The real world is not a static place. To avoid dead-end tools, you should regularly review your dashboards using data and conversation. As you remove old ones, publish new ones, and adapt existing ones, you need to work closely with all stakeholders to make sure they are supportive and aware of the changes.
Excerpted from The Big Book of Dashboards: Visualing Your Date Using Real-World Business Scenarios by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave with the permission of Wiley. Copyright © 2017 by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave. All rights reserved.