Microsoft Office Tutorials and References
In Depth Information
FIguRE 4-7 The final worksheet for pivot table analysis of the sales.
Something to note is that, when Bill spoke about relationships, he really meant that in both
tables, there was a column that can be used to perform VLOOKUP. Because the column in the
sales details table contains a product ID, Michelle needed to search in the product table for a
row with the same value for product ID. This is the product to which the sale refers. Michelle
used this pattern whenever Bill told her about a relationship, and she reached her goal.
Discovering the PowerPivot Way
Maybe you suffered from a sense of déjà vu reading this first story about Michelle. But let us
look at what happens if Michelle had PowerPivot available. The story is pretty similar, but the
tools she uses are somewhat more advanced.
Knowing that PowerPivot is able to load tables, she directly goes to the PowerPivot window
and tries loading the ProductModel table. You can see the final result in PowerPivot using
the companion workbook CH04-02-MichellePowerPivot.xlsx.
She opens up a connection with the database and loads it into PowerPivot. She performs some
trial and error because the table is not so easy to load. The first loading ends with this error:
The size specified for a binding was too small, resulting in table 'ProductModel' column
'CatalogDescription' value being truncated.
The operation has been cancelled.
Something is wrong with this column. She is not interested in the catalog description, so she
removes the CatalogDescription column by accessing the table preview in the Table Import
Wizard by pressing the Preview & Filter button shown in Figure 4-8.