Microsoft Office Tutorials and References
In Depth Information
Now that you have an Excel table, all you need to do is to let PowerPivot know of its existence.
From the PowerPivot tab on the Excel ribbon, choose the Create Linked Table button with the
cursor inside the table (see Figure 2-18). Please note that, if the cursor is not in the table, you
need to manually provide the table boundaries, a tedious task that PowerPivot carries out for
you if the cursor is inside the table.
FIguRE 2-18 The Create Linked Table command imports an Excel table inside PowerPivot.
This operation opens the PowerPivot window in which you can see your Excel table exactly
as if it were a standard imported table. The only difference is in the small chain before its
name, indicating that this is an Excel linked table and not an imported one. The table can be
renamed a more appropriate name if you need to do that—for example, you can rename it
SalesOrderHeader_OnlineOrderFlag. You can see this in Figure 2-19.
FIguRE 2-19 The decoding table imported in PowerPivot.
Maybe the power of what we are doing is not immediately evident, so it is worth spending
some words on it. We are mixing, in the same PowerPivot model, tables coming from a SQL
database with an ad-hoc table created in Excel to suit our needs. In other words, we are
extending the existing model with our personal information. This simple fact helps us build
complex and interesting data models.