Skip to Main Content
PowerPivot for Business Intelligence Using Excel and SharePoint
book

PowerPivot for Business Intelligence Using Excel and SharePoint

by Barry Ralston
March 2011
Beginner to intermediate content levelBeginner to intermediate
302 pages
6h 57m
English
Apress
Content preview from PowerPivot for Business Intelligence Using Excel and SharePoint

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

Tony Smith

Publisher Resources

ISBN: 9781430233800Purchase book