Menu
Menu
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.
https://msdn.microsoft.com/en-us/library/mt710551.aspx
https://www.youtube.com/watch?v=m08kLuofwFA
https://msdn.microsoft.com/en-us/library/mt652547.aspx
https://www.youtube.com/watch?v=3l7THcbUUds
https://www.timmitchell.net/post/2016/12/20/report-portal-in-ssrs/
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/
https://www.timmitchell.net/post/2016/12/21/kpis-in-ssrs-2016/
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/
https://msdn.microsoft.com/en-us/library/mt143173.aspx
https://msdn.microsoft.com/en-us/library/ms141679.aspx
https://www.timmitchell.net/post/2016/12/22/ssis-custom-logging-levels/
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/
https://msdn.microsoft.com/en-us/library/mt591991.aspx
https://powerbi.microsoft.com/blog/power-bi-desktop-october-feature-summary/preview/#rCustomVisuals
https://powerbi.microsoft.com/blog/power-bi-desktop-october-feature-summary/preview/#topN
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#dropdownSlicer
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/
https://www.mssqltips.com/sqlservertip/4393/power-bi-templates-printing-and-favorites/
https://www.mssqltips.com/sqlservertip/4107/advanced-mathematical-formulas-using-the-m-language/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-map/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/
https://msdn.microsoft.com/en-us/library/mt696069.aspx
https://msdn.microsoft.com/en-us/library/ff929136.aspx
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
Gartner places Microsoft as a leader in the business intelligence quadrant
https://www.gartner.com/doc/reprints?id=1-2XXET8P&ct=160204
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!
