Microsoft Office Tutorials and References
In Depth Information
Chapter 7. How to Use Spreadsheet
Databases for Dashboard Reporting
As the previous chapter discussed, poorly designed spreadsheet
databases can have significant problems. Even so, certain
techniques can reduce these problems significantly.
Therefore, for companies
with only one operating unit,
a properly managed Excel
database can serve as a
reasonable substitute for an
OLAP database, and
therefore provide an
allExcel solution.
Figure 7-1 shows the
general approach.
You enter business data into
an Excel database, which is
carefully reconciled and
checked for errors. And you
password-protect this
database to protect it from
unauthorized changes.
Many different Excel
dashboards and other
reports can report against
this data. Typically, they do
so using Excel’s INDEX
function.
Figure 7-1. If an Excel workbook database
is properly managed, it can provide small
companies and divisions many of the
benefits of an Excel-friendly OLAP.
Search JabSto ::




Custom Search