target="_blank" rel="nofollow" href="#i000030260000.jpg"/> If you don’t get anything else out of a particular chapter or section, remember the material marked by this icon. This text usually contains an essential process or a bit of information you ought to remember.
Beyond the Book
A lot of extra content that you won’t find in this book is available at www.dummies.com. Go online to find the following:
✔ Excel files used in the examples in this book can be found at
www.dummies.com/extras/exceldashboardsreports
This book contains a lot of exercises in which you create and modify tables and Excel workbook files. If you want to follow the exercise but don’t have time to, say, create your own data table, just download the data from the Dummies.com website at www.dummies.com/extras/exceldashboardsreports. The files are organized by chapter.
✔ Online articles covering additional topics at
www.dummies.com/extras/exceldashboardsreports
At this page, you’ll find out how to use conditional formatting to build annotations into your charts, add an extra dynamic layer of analysis to your charts, and create dynamic labels, among other details to aid you in your Excel dashboards journey.
✔ The Cheat Sheet for this book is at
www.dummies.com/cheatsheet/exceldashboardsreports
Here, you’ll find an extra look at how you can use fancy fonts like Wingdings and Webdings to add visualizations to your dashboards and reports. You’ll also find a list of websites you can visit to get ideas and fresh new perspectives on building dashboards.
✔ Updates to this book, if we have any, are also available at
www.dummies.com/extras/exceldashboardsreports
Where to Go from Here
It’s time to start your Excel dashboarding adventure! If you’re a complete dashboard novice, start with Chapter 1 and progress through the book at a pace that allows you to absorb as much of the material as possible. If you’re an Excel whiz, skip to Part III, which covers advanced topics.
Part I
Getting Started with Excel Dashboards & Reports
✔ Discover how to think about your data in terms of creating effective dashboards and reports.
✔ Get a solid understanding of the fundamentals and basic ground rules for creating effective dashboards and reports.
✔ Uncover the best practices for setting up the source data for your dashboards and reports.
✔ Explore the key Excel functions that help you build effective dashboard models.
Chapter 1
Getting In the Dashboard State of Mind
In This Chapter
▶ Comparing dashboards to reports
▶ Getting started on the right foot
▶ Dashboarding best practices
In his song “New York State of Mind,” Billy Joel laments the differences between California and New York. In this homage to the Big Apple, he implies a mood and a feeling that come with thinking about New York. I admit it’s a stretch, but I’ll extend this analogy to Excel – don’t laugh.
In Excel, the differences between building a dashboard and creating standard table-driven analyses are as great as the differences between California and New York. To approach a dashboarding project, you truly have to get into the dashboard state of mind. As you’ll come to realize in the next few chapters, dashboarding requires far more preparation than standard Excel analyses. It calls for closer communication with business leaders, stricter data modeling techniques, and the following of certain best practices. It’s beneficial to have a base familiarity with fundamental dashboarding concepts before venturing off into the mechanics of building a dashboard.
In this chapter, you get a solid understanding of these basic dashboard concepts and design principles as well as what it takes to prepare for a dashboarding project.
Defining Dashboards and Reports
It isn’t difficult to use report and dashboard interchangeably. In fact, the line between reports and dashboards frequently gets muddied. I’ve seen countless reports referred to as dashboards just because they included a few charts. Likewise, I’ve seen many examples of what could be considered dashboards but have been called reports.
Now, this may all seem like semantics to you, but it’s helpful to clear the air and understand the core attributes of what are considered to be reports and dashboards.
The report is probably the most common application of business intelligence. A report can be described as a document that contains data used for reading or viewing. It can be as simple as a data table or as complex as a subtotaled view with interactive drill-downs, similar to Excel’s Subtotal or Pivot Table functionality.
The key attribute of a report is that it doesn’t lead a reader to a predefined conclusion. Although reports can include analysis, aggregations, and even charts, reports often allow for the end users to apply their own judgment and analysis to the data.
To clarify this concept, Figure 1-1 shows an example of a report. This report shows the National Park overnight visitor statistics by period. Although this data can be useful, it’s clear this report isn’t steering the reader toward any predefined judgment or analysis; it’s simply presenting the aggregated data.
Figure 1-1: Reports present data for viewing but don’t lead readers to conclusions.
A dashboard is a visual interface that provides at-a-glance views into key measures relevant to a particular objective or business process. Dashboards have three main attributes:
✔ Dashboards are typically graphical in nature, providing visualizations that help focus attention on key trends, comparisons, and exceptions.
✔ Dashboards often display only data
