Business IntelligenceEnterprise TechSQL Server 2016 Business Intelligence Features February 26, 20165070 views0Share By IG ShareThe new features of SQL Server 2016 Business Intelligence Features are more on the Reporting Services side. The integration of Datazen with SSRS 2016 and implementation of HTML 5.0 are some of the major highlights. There is also new Visual Studio business intelligence templates for developers. Read along to know more about the new feature highlights.Note: If you buy something from our links, we might earn a commission. See our disclosure statement.Table of Contents SQL Server 2016 Business Intelligence FeaturesWeb Portal Experience:Tablet ExperienceMobile Experience:Other Features:PowerBI Integration:SQL Server 2016 Business Intelligence FeaturesSQL Server 2012 and 2014 didn’t have many new features and functionalities as you would have liked. With the release of SQL Server 2016, brings you a complete revamp of features and functionalities with a steep learning curve. I have already spoken about High Availability, Enhancements, Performance Improvements & Security Features on separate posts.So, let’s explore the new BI features!SSIS IMPROVEMENTS:SQL Server Always On Availability Groups supportIncremental deployment of packages is supportedImproved project upgrades support from 2012 & 2014 without manual adjustments after an upgrade.Designer UI improvements with multi-version supportOData V4 supportSSAS Tabular Improvements:Parallel partition processingOn-demand loading and pagingTabular and MOLAP modeling enhancementsBetter performance and can scale higher compared to previous releases.Lower TCO – Run your workloads on commodity hardware more efficiently and better with utilization of existing hardware capabilitiesNo need for any application changesScale beyond physical memory size with hot data residing in-memory and cold data on disk or SSDData Modeling features for Tabular:Added Support for BI directional cross filtering (Many: Many)Calculated tables, Date TableTranslationsTabular scripting languageIntroducing new DAX functions (DATEDIFF, GEOMEAN, PERCENTILE, PRODUCT, XIRR, XNPV, and much more)Query engine optimizations for better scalability.New DAX functions for high perf. reportingDirect Query performance optimizationsSSAS MULTIDIMENSIONAL Improvements:New performance improvements with unnatural hierarchies, ROLAP distinct count, and drill-through functions & semi-additive measures.You can now use DBCC commands to detect MOLAP index corruption.The introduction of newer Data Sources such as IBM Netezza etc.Master Data Services improvementsOverall system performance and scale improvementsAn optimistic target of 15x performance improvement for the Excel add-inIncreased performance for bulk entity based staging operationsArchival of Transaction LogsReuse of entities across modelsSupport for compound keysAllow the Name and Code attributes to be renamedNew security roles for more granular permissions around reading, write and delete with multiple system administrators supportability.SSRS Improvements:Mobile Report Publisher is a new tool to create mobile reports. You can use the publisher tool to connect to SQL Server Reporting Services to access data sources and easily create amazing reports and publish them to SSRS Reports Server and can be consumed via a unified web experience or on mobile devices.The New Modern Reports are built on Datazen technology Microsoft acquired earlier.Web Portal Experience:Tablet ExperienceMobile Experience:The new SSRS service allows you to create and consume report from modern browsersOther Features:Improved parametersModern themesNew chart typesPowerBI Integration:You can now connect to an On-Premise Reporting Services Server and consume reports either in the mobile App or in the Power BI portal.Keep yourselves up to date with newer features of Reporting Services from the Official Blog site of the SSRS Team. Affiliate Disclosure: Faceofit.com is a participant in the Amazon Services LLC Associates Program. As an Amazon Associate we earn from qualifying purchases. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0
Enterprise TechList of the Best Threadripper Pro Workstations – W-3100 Xeon W-3200 & W-1200 Alternatives By IGMay 25, 2021
Business IntelligenceDownload Full and Complete List of Power BI Service & Desktop SamplesPower BI is a cloud-based data visualization tool from Microsoft. Power BI is arguably the ...
Business IntelligenceHow to Create Troubleshoot and Resolve PowerBI Gateway IssuesHow to Create Troubleshoot and Resolve PowerBI Gateway Issues The Power BI gateway is a ...
Tech PostsSQL Server Master Data Services Performance Tuning GuidelinesSQL Server Master Data Services Performance Tuning Guidelines Master Data Services is a MDM (Master ...
Business IntelligenceWhat are Data analysis expressions DAX with ExamplesWhat are Data analysis expressions DAX with Examples DAX is an expression language from Microsoft ...