"MS BI" = $$$
Updated June 10, 2015

"MS BI" = $$$

Senthil Vallinayagam | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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 (MSBI) Feature Ratings

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