CHAPTER 8

image

The Elements of Good Excel Dashboards and Decision Support Systems

In this chapter, I’ll discuss what makes for a good dashboard and what I even mean by the term. As you go through the chapter, you should pay particular attention to the many examples presented by Microsoft and others. I will critique this work and explain why you might choose something different. At times, it might feel I’m challenging common wisdom. But I’ll do that for good purpose: many misconceptions of creating applications in Excel have led to poor design.

Types of Dashboards

Before moving forward, let’s talk about the dashboards commonly found in the business ...

Get Dashboards for Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.