Installation and Configuration of PowerPivot in SharePoint 2010
PowerPivot is a Business Intelligence reporting feature of SharePoint. PowerPivot helps analyze the data in more efficient way. It is highly interactive and user self-service reporting tool. Using PowerPivot we can analyze data from SQL Server Analysis services or any other OLAP data mart. Now let us see how we can configure the PowerPivot for SharePoint. To install and configure PowerPivot, we will need the following things hands: 1. SharePoint Service account for PowerPivot and Excel Services. If we use the same service account, the whole process will be easy. 2. SQL Server 2008 R2 Enterprise Edition Installer Installation of PowerPivot: To start with the installation, the first thing we have to do is to create a configuration file like this: 1. Create a text file in notepad and paste the following paragraph into there: <?xml version="1.0" encoding="utf-8" ?> <configuration>