SQL Server 2016 BI Enhancements

Database Engine

Updatable Non-Clustered Column Store Indexes.

R-Integration

R Predictive Analytic functions available via T-SQL.

Polybase Support

Polybase was available only in PDW, now to be available in SQL Server.

Polybase is a technology that allows querying of non-relational data in Hadoop Distributed File System using SQL.

SSIS

SSIS Designer to support previous versions.

Power Query is available as a Data Source, this would allow for Self Service ETL to Enterprise ETL conversion.

New Connectors available for

                Hadoop HDFS.

                JSON

                Azure Storage

                Oracle

                Teradata

ETL Package Templates

SSRS

Ability to create reports for Mobiles.

Support for more browsers.

New Chart types.

Connectors for Oracle, Teradata, SAP BW.

Parameter Enhancements.  

              

Development

BIDS and SSDT Unified in Visual Studio.

SSAS Multi-Dimensional

DBCC commands for detecting data issues.

Distinct count improvements.

Support for Netezza as data source.

SSAS Tabular

Support for Many to Many Relationships.

Bi-Directional filtering.

New DAX Functions – DATEDIFF, GEOMEAN, PERCENTILE, MEDIAN, MEDIANX etc.

Better Time Intelligence Support – Eliminates need for Date Table.

Partitioned table processing – Multiple partitions can be processed in parallel.