SharePoint® 2010 Business Intelligence 24-Hour Trainer

8

Creating and Configuring PowerPivot for SharePoint Services Applications

PowerPivot is a tool new in Office 2010 that provides a type of in memory OLAP tool, which is available in the familiar interface of Excel. It gives end users the ability to analyze data in a similar fashion that an Analysis Services cube would provide. For the purposes of this lesson though we will focus on the configuration of PowerPivot with SharePoint, but for a more in depth discussion on PowerPivot and when it is appropriate to use, read Lesson 13.

PowerPivot is one of the most difficult and time consuming of the Business Intelligence tools to configure for SharePoint. It requires a separate install of an Analysis Services instance and special considerations depending on whether SharePoint is installed on a standalone machine or on an existing farm. In this lesson's Try It section you walk through the steps for properly configuring a standalone instance, which is the best way to get you up-and-running the fastest.

SQL SERVER AND SHAREPOINT INSTALLATIONS

Before you can begin installing SQL Server or SharePoint you will need to ensure your machine is properly prepared. You will also need to have the proper editions of products to install. Use this checklist before beginning the installation:

• The operating system is Windows Server 2008 R2 or Windows Server 2008 Service Pack 2 or higher and must be 64-bit.
• SharePoint 2010 Enterprise.
• SQL Server R2 Enterprise Edition.
• Domain account available that can ...