Microsoft Office Tutorials and References
In Depth Information
Chapter 1. The Advantages of
Dashboard Reporting With Excel
Suppose you’re a manager. You’ve had a long day at work.
Spreadsheet reports litter your desk. When you finally get home for
the evening, you pick up a business magazine to unwind. But
because you’re too tired to read anything, you just look at the
Many of those “pictures” in your business magazine are small
charts and tables…figures that summarize more data than the
typical Excel reports that litter your desk.
What’s going on here? Why is it work to look at data presented by
most Excel reports? Why is it relaxation to look at data presented
by business magazines?
I think there are two reasons, both of which are influenced by the
The Management-Reporting Pyramid
should be designed
like a pyramid.
should receive fewer
pages of standard
reports than their
But those pages
should present a wider scope.
This is common sense. Accounts payable clerks receive extensive
data about each customer’s payment history. But their manager