TrustRadius
Microsoft BI Review 25 of 48
Microsoft BI Review: ""MS BI" = $$$"
https://www.trustradius.com/business-intelligence-biMicrosoft BIUnspecified7.8594101
Senthil Vallinayagam profile photo
Updated June 10, 2015

Microsoft BI Review: ""MS BI" = $$$"

Score 8 out of 101
Vetted Review
Verified User
Review Source

Software Version
2008 R2

Overall Satisfaction with Microsoft BI

Microsoft BI is used intensely by Engineering department. The whole product is built around with Microsoft BI stack. The database is built using SQL Server 2008 R2 and cubes built using SSAS. Delivers the SaaS model of the company.
  • Some of the rolling metrics calculations are performed using SSAS cubes. Eg: YoY, YTD, etc
  • Slicing and Dicing of reports becomes increasingly simple with the SSAS cubes.
  • ETL operations are made nimble with SQL server 2008 R2
  • Some of the newer aggregation functions that are used in advanced analytics are missing. Eg: lastNonEmpty ()
  • SSAS (from the BI Stack) adapters to interact with MPP are not entirely nimble
Not reviewed any other product yet.
Renewal is unlikely due to the rise in licensing premium.
  • Overall business went up with the analytics offered by MS BI but the licensing costs are a substantial number.
Small scale cubes (SSAS) where the size is in the order of few 100 Gigs are suitable for MS SSAS. For higher volume, the aggregation and processing is a lot longer.

Microsoft BI Feature Ratings

Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
4
Predictive Analytics
5
Responsive Design for Web Access
8
Dashboard / Report / Visualization Interactivity on Mobile
7