Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-29 The integrated report for predicted sales in 2005.
You can now use this report to produce predictions for category and subcategory. Moreover,
as you might already imagine, if you want to add more attributes for the product, you have
merely to change the source query of the Sales table.
Caution The careful reader will notice that the months are not sorted correctly: April comes
before February and January is at the end. This is an issue with PowerPivot, which sorts attributes
only alphabetically and has no knowledge about a month’s need to be sorted by month numbers.
You will learn how to address this issue later on in the chapter about the date dimension.
The interesting point here is that you have been able to integrate the original OLAP cube with
external information and create new PivotTables on the integrated data model. Although this is
a simple example, it shows the power of data integration that PowerPivot provides.
The unique characteristic of linked tables is that they are refreshed immediately and do not
need you to reload data. If, for example, you need to change some values in the prediction
table, to perform some kind of what-if analysis or compute different scenarios, you need
merely to change the values in the Excel worksheet and refresh the PowerPivot data model
and the PivotTable to get the new values immediately computed. This leads to your being
able to create interactive reports, which use the PowerPivot engine to perform complex