MS BI Suite Review
October 24, 2013
MS BI Suite Review

Score 9 out of 10
Vetted Review
Verified User
Software Version
2008-2012
Modules Used
- SSIS
- SSRS
- SSAS
- SharePoint
Overall Satisfaction
Pros
- SQL Server Analysis Services (SSAS) is by far the best OLAP tool on the market today. It helps businesses to aggregate data and analyze historical trends.
Cons
- SQL Server Integration Services (SSIS) has a relatively difficult deployment mechanism. More mature ETL systems like Informatica have a right-click and deploy packages feature. SSIS does not have that out-of-the-box unless you install some 3rd party tools. Also the whole Deployment Manifest thing is a real pain…
- Microsoft BI tools come free with SQL Server license. If you have SQL Server license you get the SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) tools for free.
Comments
Please log in to join the conversation