In this section, you will explore Adventure Works using PowerPivot. You will learn how to import data into PowerPivot and how to enrich your PowerPivot data with additional columns and calculations. After finalizing your data set, you will post your PowerPivot data into Excel.
To set the stage for using PowerPivot, you must first open Excel. When Excel is loaded, select the PowerPivot tab, and click PowerPivot Window. From the empty PowerPivot designer, click From Database, and select From SQL Server. In the Table Import wizard, enter a connection name, server name, and select AdventureWorksDW2008R2 as your SQL Server database. The completed dialog is shown in Figure 12–10