Developing Business Intelligence Apps for SharePoint

Chapter 35. Installing the BI Components for SharePoint

In this chapter, we will cover the installation and configuration of the components that make up SharePoint’s business intelligence suite. We will be walking through the installation of each piece and discussing the variables that should be configured to support the best implementation of these tools.

The areas that we will cover are:

• SQL Server 2012 for PowerPivot

• Excel Services

• PowerPivot Office client

• Power View

• SQL Server Reporting Services Integrated Mode

At the end of this chapter, you will be able to properly install and configure the SharePoint BI suite.

SQL 2012 for PowerPivot on the App Tier

There are two distinct paths for installation of PowerPivot on the App Tier that this section will cover:

1. Upgrading from PowerPivot 2008 R2 (version 1) to 2012 (version 2)

2. Clean install of PowerPivot 2012 (version 2)

Upgrading from PowerPivot 2008 R2 to 2012

One question that is frequently raised around the installation of PowerPivot under SQL 2012 is “What do I do if I have PowerPivot under SQL 2008 R2?” There is an important distinction that needs to be made here regarding versions. PowerPivot is a single-tier upgrade path only. This means that you cannot go from version 1 (SharePoint 2010 and 2008 R2) to version 3 (SharePoint 2013 and SQL 2012 SP1) without upgrading to version 2 (SharePoint 2010 and SQL 2012) first.

To upgrade from PowerPivot version 1 to PowerPivot version 2, the following must be true:

• The version of SQL Server must be ...