TrustRadius
Microsoft BI Review 7 of 57
Review: "Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you use"
https://www.trustradius.com/business-intelligence-biMicrosoft BIUnspecified7.9617101
Thomas Young profile photo
January 09, 2019

Review: "Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you use"

Score 9 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft BI

Microsoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.
  • As with most every other Microsoft product, Microsoft BI makes setting up and analyzing data about as easy as it gets.
  • Creating graphics is very easy.
  • Connecting to multiple data sources works just fine.
  • Simple reporting and integration with other Microsoft products is great.
  • Microsoft BI is not top of the for advanced analysis and modeling.
  • Reshaping and restructuring data is doable, but not super simple.
  • Customizing visualizations is sometimes difficult to impossible.
Microsoft BI has an advantage over other BI platforms because it integrates nicely with the Microsoft products, such as Excel, Microsoft SQL, Access, and all the other parts of the Microsoft business. A user that has spent time with Microsoft products will find Microsoft BI to be similar in functionality to other Microsoft products. Microsoft puts ease of use as a top priority, and it shows up in Microsoft BI. Microsoft BI is, of course, not the top business intelligence platform. It does not have the nicest graphics, the biggest user base, or the most advanced analytics capabilities. It's sort of a starter BI solution.
I have yet to run across a data source that Microsoft BI can't connect to. Microsoft BI easily connects to JSON, SQL, and pretty much every other data source. The software is not the best at merging data from disparate sources. It takes some time to get things up and running with different data sources. Real-time updating of Microsoft BI visualizations is probably one of the best BI tools out there. Works just fine.
Microsoft BI makes sharing data across the department and organization relatively straight-forward. As long as each user has some understanding of Microsoft BI, sharing data and visualizations couldn't be easier. I'm not really a security guy, but from what I can tell, controlling access works just fine and controlling versioning is also straight-forward. Formatting visualizations is clunky.
Microsoft BI is great if you and your team have used Microsoft products for a long time. Connecting Microsoft BI to your current processes will be a breeze. The software also makes it easy to create executive dashboards and automated data reporting. For simple financial reporting, Microsoft BI is as easy as they come.

Microsoft BI Feature Ratings

Pixel Perfect reports
5
Customizable dashboards
8
Report Formatting Templates
6
Drill-down analysis
7
Formatting capabilities
7
Integration with R or other statistical packages
10
Report sharing and collaboration
9
Publish to Web
7
Publish to PDF
10
Report Versioning
10
Report Delivery Scheduling
10
Delivery to Remote Servers
10
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
8
Predictive Analytics
9
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Single Sign-On (SSO)
10
Responsive Design for Web Access
5
Dedicated iOS Application
5
Dedicated Android Application
5
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
6
Javascript API
6
iFrames
6
Java API
6
Themeable User Interface (UI)
8
Customizable Platform (Open Source)
6