"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.

Pros

  • 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

Cons

  • 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

BI Platform ()
Not Rated
Supported Data Sources ()
Not Rated
BI Standard Reporting ()
Not Rated
Ad-hoc Reporting ()
Not Rated
Report Output and Scheduling ()
Not Rated
5.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
4
Predictive Analytics
5
Access Control and Security ()
Not Rated
7.5
Responsive Design for Web Access
8
Dashboard / Report / Visualization Interactivity on Mobile
7
Application Program Interfaces (APIs) / Embedding ()
Not Rated

Comments

More Reviews of Microsoft BI (MSBI)

  1. Home
  2. Business Intelligence (BI) Tools
  3. Microsoft BI (MSBI) Reviews
  4. User Review of Microsoft BI (MSBI)