Install Business Intelligence Features – SQL Server

12/13/2019 2 minutes to read Table of Contents In this articleSQL Server BI FeaturesSee Also In this article APPLIES TO: SQL Server (Windows only) Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse SQL Server features that […]


APPLIES TO: SQL Server (Windows only) NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

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.

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.

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 2016
Upgrade to SQL Server 2016



Source Article

Next Post

Entrepreneurs on Fire with John Lee Dumas

Mon Apr 20 , 2020
Gary Vaynerchuk “I featured JLD in my book ’Crushing it!’ because he’s the real deal and he puts in the work!” Amy Porterfield “I’ve always admired John’s honesty, transparency, & genuine enthusiasm for inspiring Entrepreneurs to achieve their dreams!” Lewis Howes “JLD has been inspiring Enterpreneurs for over 5 years […]