Business intelligence in SharePoint Server overview

SharePoint Server 2016
 

Applies to: SharePoint Server 2013, SharePoint Server 2016

Topic Last Modified: 2017-09-07

Learn about the Microsoft business intelligence (BI) tools for SharePoint Server 2016 and SharePoint Server 2013.

Requirements for SharePoint Server 2016 BI is that Microsoft SQL Server 2016 RTM is required. If you want to use Microsoft SQL Server Power Pivot for SharePoint or Microsoft Power View for SharePoint you must install the Power Pivot or Power View add-ins for SQL Server 2016 RTM. This requirement also applies to using Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS) with SharePoint Server 2016. You must install SQL Server 2016 Analysis Services (SSAS) and SQL Server 2016 Reporting Services (SSRS).

Power Pivot for SharePoint Server 2013 is only available with SQL Server 2012 SP1 Analysis Services (SSAS).

Note that to use the business intelligence (BI) tools in SharePoint Server 2013 you must install SQL Server 2012 with Service Pack 1 (SP1) or SQL Server 2014, 64-bit version. For more information, see Hardware and software requirements for SharePoint Server 2016.

The following SharePoint Server 2016 business intelligence planning articles are updated as new information becomes available and as users provide feedback.

 

Content Description

Software requirements for business intelligence in SharePoint Server

Learn about the minimum software requirements to run Business Intelligence features in SharePoint Server 2016.

Overview of Excel Services in SharePoint Server 2013

Learn how to share data-connected workbooks across an organization using Excel Services in SharePoint Server 2013.

Plan Office Online Server

Learn about Office Online Server requirements and prerequisites.

Configure Office Online Server for SharePoint Server 2016

Learn how to configure Office Online Server for SharePoint Server 2016.

PerformancePoint Services in SharePoint Server 2016 overview

Learn about PerformancePoint Services in SharePoint Server 2016.

Plan for Visio Services in SharePoint Server

Learn about planning considerations for Visio Services in SharePoint Server 2016.

Overview of PerformancePoint reports and scorecards

Learn about reports and scorecards within PerformancePoint Dashboard Designer.

Show: