Using PowerPivot with Adventure Works
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.
Importing Adventure Works Data
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
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
