O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required