Microsoft BI Review

SQL Server 2016 delivers built-in mobile BI capabilities.

Valuable Features:

Microsoft SQL Server Report Publisher

Microsoft SQL Server Report Builder

Microsoft SQL Server Reporting Services (Web Portal)

SQL Server 2016 delivers built-in mobile BI capabilities.  The above tools give professionals the ability to deliver business insights quickly and easily as well as enabling a quick way of presenting the data/charts/reports over a web portal.  The portal is compatible for cross platform, from desktops to major mobile devices.

Overall a great way of delivering your insights to your data.

Improvements to My Organization:

Works with data, systems and tools we already have. They are "additional" tools rather than complete replacement software.  Easy to upgrade / install.  The new SSRS tools in particular give us an easier way to share insights and reports to our clients and within our own teams.  Security is easily managed within SharePoint.

Room for Improvement:

License fee structure.  Mobile reporting Services is only available for the "Enterprise" addition of SQL Server 2016.  This comes with a hefty price tag.  Would be better if you could pick and choose the features you require and then the price tag is set accordingly.  Rather than paying for the full Enterprise addition and getting a lot of features we do not need/use.  

Use of Solution:

We have been using Microsoft's extensive software library for years.  But at the time of writing this review, SQL Server 2016 Enterprise is pretty brand new.  We knew of the latest reporting services offering and were eager to trial it.

Deployment Issues:

Deployment isn't rocket science, but it isn't child's play either.  There were a fair few standard issues getting everything to talk to each other.  Nothing to worry about though.  Microsoft has worked well to make sure the latest SSRS is an "add-on" feature that integrates seamlessly. 

Initial Setup:

Straightforward easy setup.  Typical Microsoft software (familiar).

Which version of this solution are you currently using?

SQL Server 2016 Enterprise
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Microsoft BI reviews from users
...who work at a Energy/Utilities Company
...who compared it with Tableau
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2021.
533,638 professionals have used our research since 2012.
Add a Comment
ITCS user