What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
696 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
696 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Likelihood to Recommend

Microsoft BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
7.9
Pixel Perfect reports
Microsoft BI
7.7
Customizable dashboards
Microsoft BI
7.9
Report Formatting Templates
Microsoft BI
8.2

Ad-hoc Reporting

Microsoft BI
8.4
Drill-down analysis
Microsoft BI
8.1
Formatting capabilities
Microsoft BI
8.4
Integration with R or other statistical packages
Microsoft BI
8.2
Report sharing and collaboration
Microsoft BI
8.8

Report Output and Scheduling

Microsoft BI
8.0
Publish to Web
Microsoft BI
8.2
Publish to PDF
Microsoft BI
8.5
Report Versioning
Microsoft BI
7.9
Report Delivery Scheduling
Microsoft BI
7.4
Delivery to Remote Servers
Microsoft BI
8.2

Data Discovery and Visualization

Microsoft BI
8.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.4
Location Analytics / Geographic Visualization
Microsoft BI
7.9
Predictive Analytics
Microsoft BI
7.9

Access Control and Security

Microsoft BI
8.3
Multi-User Support (named login)
Microsoft BI
8.3
Role-Based Security Model
Microsoft BI
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.4
Single Sign-On (SSO)
Microsoft BI
8.3

Mobile Capabilities

Microsoft BI
8.2
Responsive Design for Web Access
Microsoft BI
8.2
Dedicated iOS Application
Microsoft BI
8.4
Dedicated Android Application
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
REST API
Microsoft BI
7.8
Javascript API
Microsoft BI
8.3
iFrames
Microsoft BI
7.6
Java API
Microsoft BI
7.6
Themeable User Interface (UI)
Microsoft BI
7.8
Customizable Platform (Open Source)
Microsoft BI
7.5

Pros

Microsoft BI

  • EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
  • FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
  • FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.
Alexander Lubyansky profile photo

Cons

Microsoft BI

  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
Microsoft BI is a great tool but may require additional, expensive staff to maintain the software and keep it running on a day to day basis from an operational perspective. Other BI products are making the jump to "Self Service" Business Intelligence, empowering the end user to create and modify their data needs. However, if a company resides on a MS SQL server structure, Microsoft's BI tool is easy to integrate and can deploy an enterprise BI solution in a relative short time. Considering the initial software costs, you get a lot for your money
Bryan Simmons profile photo

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

Reliability and Availability

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Microsoft BI

Microsoft BI 7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

Microsoft BI

Microsoft BI 6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

Microsoft BI

Microsoft BI 8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

Alternatives Considered

Microsoft BI

Microsoft BI is definitely catching up, especially with monthly updates.
Ivan Leung profile photo

Return on Investment

Microsoft BI

  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

Pricing Details

Microsoft BI

General

Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No

Microsoft BI Editions & Modules

Edition
Power BI$0
Power BI Pro$102
  1. per user per month
Additional Pricing Details

Add comparison