Microsoft Office Tutorials and References
In Depth Information
FIguRE 1-7 Choosing the tables to import.
We want to load three tables:
■ Product Contains all the details about products sold by AdventureWorks.
■ Sales Order Header Contains header information about the orders.
■ Sales Order Detail Contains the detailed information about all the rows inside the
orders and acts as a bridge between the sales order header and the products.
After you select these three tables, you can perform basic analysis about which products
have been sold. The orders header provides information about the date of the order, the
customer, the order total, and other information. Clicking Finish after having selected those
tables launches the process of loading data from the database, which completes in a few
After the tables load, the PowerPivot window changes, showing all the data that has been
loaded, as you can see in Figure 1-8.