Microsoft Office Tutorials and References
In Depth Information
Performing Analysis of Old and New Data Together
Another common scenario occurs when you need to add information to an existing table. For
example, when you analyze a budget, you can gather historical information based on previous
sales of existing items. Let us suppose that you have access to an OLAP cube that contains all
the old stuff. That said, to compute correct data, you frequently need to add some anticipatory
information about new items that are going to be introduced to the market. These new
products are not part of the existing database because, by their very definition, they are new.
You cannot perform this type of analysis on standard OLAP cubes because there is no way to
add new items to their existing dimensions or fact tables. Nevertheless, using PowerPivot you
can load the original data, add the new information, and then recompute new PivotTables that
take new data into account.
Let us suppose that, at the end of 2004, you want to forecast sales, using both last year sales,
with a correction factor, and predicted sales about new bikes that you plan to introduce to the
market. To perform this task, you start loading the original data, update it with the correction
factor so that they reflect your predicted sales, and then you are ready to add more
information to the table, to reflect the introduction of new products.
The first set of data is captured from the OLAP cube, using the query shown in Figure 8-25.
You can follow this example in the companion workbook CH08-08-NewProducts.xlsx.
FIguRE 8-25 The 2004 sales taken from the OLAP cube.