Microsoft Office Tutorials and References
In Depth Information
We want now to create an Excel workbook that performs some analysis on the AdventureWorks
database using PowerPivot. The first step is to import data from the external database. You can
choose from several options for doing that, but this first example simply covers importing data
from the SQL Server database containing AdventureWorks. Later, in Chapter 5, “Loading
Data and Models,” we discuss other options in greater detail.
From the Launch group on the Excel ribbon, click the PowerPivot Window button, shown
in Figure 1-4, and launch the PowerPivot window, which is the most important tool we will
use to get and arrange all the data we need to analyze. That window is separated from the
Excel window, but it is strictly integrated, nevertheless, because you are still operating on
the same Excel document.
FIguRE 1-4 The PowerPivot Window button on the Excel ribbon.
When you open the PowerPivot window, you are ready to load some data. The first step
is to establish a connection between the Excel sheet and the database. To do that, on the
From Database drop-down menu, choose From SQL Server, as shown in Figure 1-5.
FIguRE 1-5 The menu option to import data from a SQL Server database.
Selecting this menu option opens a dialog box, which allows you to specify the connection
option. In the example shown in Figure 1-6, we are loading data from the local instance of
SQL Server. Your specific configuration might be different from this, requiring a different
name for the SQL Server instance.