O'Reilly logo

PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston

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

Assembling the Solution

Our solution will take advantage of PowerPivot for Excel’s ability to load data from a SQL Server database to the SQL Server Analysis Services database installed by the PowerPivot add-in for Excel. After defining a connection to SQL Server, specifically to the AdventureWorksDW2008R2 database, we will construct a table of Internet sales, summarized by product key. Finally, we will apply a sort and a value filter to get the top ten products, ranked by all-time Internet sales.

SQL Server As a PowerPivot Data Source

One of the easier data sources to set up for use by PowerPivot is a SQL Server database. After installing the sample databases, your SQL Server 2008 R2 instance should contain a database named AdventureWorksDW2008R2 ...

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