Microsoft Office Tutorials and References
In Depth Information
Chapter 6. How to Funnel Data into
Dashboard Reports
Dashboard reporting offers an effective way for readers to monitor
business performance, quickly and easily. But how can Excel’s
dashboard workbooks interact with that data easily?
This chapter describes various strategies to funnel source data into
dashboard reports.
How Data Flows into Excel-Based Dashboards
Figure 6-1 illustrates the data-flow
structure of an Excel-based
dashboard report.
At the top of the figure we have a
cloud of business data. It could be
internal and external, past and
projected, all from a wide variety of
sources. And much of it is updated
constantly.
At the bottom, we have a dashboard
report. This report is linked by Excel
formulas to well-defined spreadsheet
cells.
Figure 6-1. For dashboards to
update easily, we must find a
simple way to update their
data ranges in Excel.
The report doesn’t care where in the
cloud its data comes from, nor how
the cells of data were filled. It only
talks with the cells. And though the cells can get their data from
different sources, they have a rigid structure. Deleting, sorting, or
moving one or more cells typically will break the report.
Search JabSto ::




Custom Search