A personal exprience with Microsoft BI
Updated March 08, 2016

A personal exprience with Microsoft BI

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft BI

Microsoft BI was used to implement a data warehouse and a reporting solution for our department and it provides data downstream to multiple lines of business. We currently use SQL Server, SSRS and SSIS 2012 and are currently deploying SSAS while some of the reports are using IBM Cognos.

Pros

  • Microsoft provided us with an easy and flexible platform to build our data warehouse with very good performance for our medium size databases.
  • We used SSIS to seamlessly orchestrate a daily ETL load of around 5Gb in less than two hour.
  • Visual Studio was used as our main development tool and allowed us to integrate our solution for deployment into TFS as well as track defects and meet milestones within our project.

Cons

  • I would like to have a simpler, better integrated solution for reporting in which we can easily integrate all SSRS, Performance Point, Powerview and Porwerpivot forms into Sharepoint or any other custom reporting portal
  • Also I would like MS BI to have better integration with other products for example SSIS with Cloudera Hadoop or SSRS with Cognos cubes.
In my experience Microsoft BI solutions are very well suited to implement reporting solutions for medium to large size enterprises and departments. It can handle loads very well and has very flexible development tools that are integrated very easily with Sharepoint and MS Office.

Microsoft BI (MSBI) Feature Ratings

BI Platform ()
Not Rated
Supported Data Sources ()
Not Rated
6.3
Pixel Perfect reports
7
Customizable dashboards
7
Report Formatting Templates
5
5.7
Drill-down analysis
8
Formatting capabilities
1
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
8
7.8
Publish to Web
8
Publish to PDF
9
Report Versioning
7
Report Delivery Scheduling
7
5.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
5
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
8.0
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Not Rated
Responsive Design for Web Access
Not Rated
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated
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)