Skip to Main Content
Excel Dashboards & Reports For Dummies, 4th Edition
book

Excel Dashboards & Reports For Dummies, 4th Edition

by Michael Alexander
April 2022
Beginner to intermediate content levelBeginner to intermediate
384 pages
9h 47m
English
For Dummies
Content preview from 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.

Remember 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Dashboards and Reports for Dummies, 3rd Edition

Excel Dashboards and Reports for Dummies, 3rd Edition

Michael Alexander

Publisher Resources

ISBN: 9781119844396Purchase Link