kohera-logo-regular.svg

This was Microsoft BI in 2016

Vector_BG.png

This was Microsoft BI in 2016

Vector_BG.png

With the latest version of Microsoft SQL Server, we – BI folks – have a lot of new features to play with. Reporting Services (SSRS) has brought the biggest changes in years. Also, Analysis Services and Integration Services deliver some major updates. It’s not just SQL Server that gave us a lot of new BI features. Power BI, the all-in-one clean-up and reporting tool/portal from Microsoft, has also made enormous progress in 2016. Let’s look at some of the new, enhanced and/or interesting features of 2016.

 

SSRS 2016

Custom Branding

https://msdn.microsoft.com/en-us/library/mt710551.aspx
https://www.youtube.com/watch?v=m08kLuofwFA

Mobile Reports

https://msdn.microsoft.com/en-us/library/mt652547.aspx
https://www.youtube.com/watch?v=3l7THcbUUds

A New reporting Services Web Portal

https://www.timmitchell.net/post/2016/12/20/report-portal-in-ssrs/

Subscriptions using an SMTP server outside your network

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/07/15/deliver-reports-via-email-using-an-email-server-outside-your-network/

Migrating your DataZen to SSRS

Power BI and SSRS integration

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/10/25/announcing-a-technical-preview-of-power-bi-reports-in-sql-server-reporting-services/
http://biinsight.com/ssrs-2016-power-bi/

Improved embedding paginated reports into ASP.NET

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/09/23/embed-paginated-reports-into-asp-net-web-apps-using-the-report-viewer-2016-control/

KPI Report Type

https://www.timmitchell.net/post/2016/12/21/kpis-in-ssrs-2016/

Simplified installation modes and SharePoint integration options

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/11/17/simplifying-our-sharepoint-integration-story/
https://whitepages.unlimitedviz.com/2016/03/ssrs-2016-integrated-native-mode/

 

SSIS 2016

Incremental package deployment

https://msdn.microsoft.com/en-us/library/mt143173.aspx

Improved Debugging (like column names in the error output and custom logging level)

https://msdn.microsoft.com/en-us/library/ms141679.aspx
https://www.timmitchell.net/post/2016/12/22/ssis-custom-logging-levels/

Target Server Version (backwards compatibility)

https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/
https://blogs.msdn.microsoft.com/sqlgardner/2016/08/17/ssdt-vs2015-gotcha-target-server-version-new-feature/

 

SSAS

Calculated tables

https://www.mssqltips.com/sqlservertip/4343/how-to-create-calculated-tables-in-a-tabular-sql-server-analysis-services-ssas-model/

Display Folders and Translations

http://www.kapacity.dk/migrating-ssas-tabular-models-to-sql-server-2016-translations-and-display-folders/?lang=en

Bi-directional cross filtering (also in Power BI)

https://msdn.microsoft.com/en-us/library/mt591991.aspx

Tabular Model Scripting Language (TMSL)

 

Power BI

R-powered custom visuals

https://powerbi.microsoft.com/blog/power-bi-desktop-october-feature-summary/preview/#rCustomVisuals

TOP-N Filter

https://powerbi.microsoft.com/blog/power-bi-desktop-october-feature-summary/preview/#topN

Drop-down slicer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#dropdownSlicer

Grouping and binning

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/

Power BI Templates

https://www.mssqltips.com/sqlservertip/4393/power-bi-templates-printing-and-favorites/

Advanced Mathematical Formulas using the M Language

https://www.mssqltips.com/sqlservertip/4107/advanced-mathematical-formulas-using-the-m-language/

Shape Maps (also custom shape maps)

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-map/

R script transformations (Query Editor)

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/

Power BI Embedded

 

SQL Server

Even more power with column store indexes

R Server is now part of SQL Server

https://msdn.microsoft.com/en-us/library/mt696069.aspx

What’s New in Master Data Services (MDS)

https://msdn.microsoft.com/en-us/library/ff929136.aspx

Data Science

R is being integrated more and more in Microsoft’s BI stack and this Free eBook – Data Science with R – is confirming this trend
http://blog.revolutionanalytics.com/2013/02/free-e-book-on-data-science-with-r.html

 

Business 2016

Gartner places Microsoft as a leader in the business intelligence quadrant
https://www.gartner.com/doc/reprints?id=1-2XXET8P&ct=160204

 

2017

It has been going fast in 2016 for Microsoft BI. If we continue to move on like this, we’re in for a treat in 2017. And the first signs are already promising. In the latest SQL Server vNext we see a major update for getting data in Analysis Services. Also, on-premise Power BI reports via SSRS will soon be publicly available. With the monthly updates of Power BI, chances are big that we‘ll see a lot more things happening over there. So keep checking our blogs and last but not least: Happy New Year!

2319-blog-database-specific-security-featured-image
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
kohera-2312-blog-sql-server-level-security-featured-image
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
blog-security_1
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
DSC_1388
Aggregaties
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
blog-2303
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...