Install SQL Server Business Intelligence Features

Applies to: SQL Server - Windows only

SQL Server features that are part of the Microsoft Business Intelligence platform include Analysis Services, Integration Services, Master Data Services, Reporting Services, and several client applications used for creating or working with analytical data. This section of the SQL Server Setup documentation explains how to install these features.

Analysis Services and Reporting Services can be installed as standalone servers, in scale-out configurations, or as shared service applications in a SharePoint farm. Installing the services in a farm enables BI features that are only available in SharePoint, including Power Pivot for SharePoint and Power View, the Reporting Services ad hoc interactive report designer that runs on Power Pivot or Analysis Services tabular model databases.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016. Power View support is no longer available after SQL Server 2017.

SQL Server BI Features

All SQL Server features, including the BI components, are installed through SQL Server Setup. The following links provide supplemental information specific to each BI feature.

• Install Analysis Services

• Install Analysis Services in Power Pivot Mode

• Install Data Quality Services

• Install Integration Services

• Install Master Data Services

• Install Reporting Services

• Install Reporting Services SharePoint Mode

Note

SQL Server Data Tools (SSDT) is not included with SQL Server 2016. Download SQL Server Data Tools.

See Also

What's New in Reporting Services (SSRS)
What's New in Analysis Services
What's New in Integration Services
What's New in Master Data Services (MDS)
Install SQL Server
Upgrade to SQL Server