Excel Dashboards & Reports For Dummies, 4th Edition

Chapter 15

Ten Questions to Ask Before Distributing Your Dashboard

You started this book with two chapters that discuss the design and data modeling principles that make up what could be considered dashboarding best practices. Before you send out your finished product, it’s valuable to use the ten questions in this chapter as a checklist to ensure your dashboard follows the best practices covered in this book.

Does My Dashboard Present the Right Information?

Look at the information you’re presenting and determine whether it meets the purpose of the dashboard identified during requirements gathering. Don’t be timid about clarifying the purpose of the dashboard again with your core users. You want to avoid building the dashboard in a vacuum. Allow a few test users to see iterations as you develop it. This way, communication remains open, and you won’t go too far in the wrong direction.

Does Everything on My Dashboard Have a Purpose?

Take an honest look at how much information on your dashboard doesn’t support its main purpose. To keep your dashboard as valuable as possible, you don’t want to dilute it with nice-to-know data that’s interesting but not actionable.

If the data doesn’t support the core purpose of the dashboard, leave it out. Nothing says you have to fill every bit of white space on the page.

Does My Dashboard Prominently Display the Key Message?

Every dashboard ...