Content Roadmap: Set up and configure SharePoint Server 2013 and SQL Server BI

SharePoint 2013

We are in the process of combining the SharePoint Server 2013 and SharePoint Server 2016 content into a single content set. We appreciate your patience while we reorganize things. See the Applies To tag at the top of each article to find out which version of SharePoint an article applies to.


Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2016-12-16

Summary: Design your BI environment by creating a BI Center and setting up the BI tools you need, such as Excel, SQL Server, SharePoint Server, PowerPivot, Reporting Services, and Analysis Services.

Content roadmap for IT professionals (banner image)

This article steps you through the process of creating a SharePoint Server 2013 Business Intelligence Center and integrating it with the various SQL Server Business Intelligence tools and SharePoint BI services.

Set up and configure SharePoint Server 2013 Business Intelligence Center with SQL Server 2012 SP1 BI tools

Getting started

Prerequisites: What do I need to know first?

There are several different tools and applications in Microsoft BI. You don’t need to activate or use them all. Read these articles to become familiar with the many BI features that Microsoft offers and decide which ones you want to set up and configure at first. Remember that you can always add more functionality later. It is important to note that the SharePoint BI features discussed here require that you have a SharePoint Server 2013 Enterprise license.

Deploy icon

Install the core software

This section contains the steps to install SharePoint Server and SQL 2012, including Reporting Services and Analysis Services.

123 steps

Create a BI Center and configure BI services and features

Now that you have installed SharePoint Server and SQL Server, you are ready to create a SharePoint BI Center. Follow these articles to learn how to start, configure, and integrate the various SharePoint Server and SQL Server services with you BI Center.

Troubleshoot icon

Add more features and customize your environment

Behind the scenes icon

Reference information