What users are saying about

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
615 Ratings

Microsoft BI

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

Add comparison

Likelihood to Recommend

Microsoft BI

I found that Tableau is more efficient in providing options to calculate measures, percentages as compared to MS BI Power Pivot. Also, Tableau is more web-friendly. However, analytic capability is well suited in Microsoft BI. Microsoft BI is well suited in larger organization setup which requires various integration with external line of business applications. Sometimes, the cost impact can be bigger for smaller organizations as they look for savings while shopping for minimum viable product.
Ved Mishra profile photo

Feature Rating Comparison

BI Standard Reporting

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

Ad-hoc Reporting

Microsoft BI
8.6
Drill-down analysis
Microsoft BI
8.4
Formatting capabilities
Microsoft BI
8.3
Integration with R or other statistical packages
Microsoft BI
8.6
Report sharing and collaboration
Microsoft BI
8.9

Report Output and Scheduling

Microsoft BI
8.5
Publish to Web
Microsoft BI
8.5
Publish to PDF
Microsoft BI
8.7
Report Versioning
Microsoft BI
8.6
Report Delivery Scheduling
Microsoft BI
8.1
Delivery to Remote Servers
Microsoft BI
8.6

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.9
REST API
Microsoft BI
8.1
Javascript API
Microsoft BI
8.3
iFrames
Microsoft BI
8.1
Java API
Microsoft BI
7.2
Themeable User Interface (UI)
Microsoft BI
8.2
Customizable Platform (Open Source)
Microsoft BI
7.7

Pros

  • Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
  • Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
  • Collaboration (via SharePoint only, before the release of Power BI Designer)
  • Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
  • Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
Lee Cullom profile photo

Cons

  • SQL Server Data Integration (also knows as SSIS) seems to provide most functionality you would expect from an ETL tool. However, when you start using it you quickly find out that most transformations perform slower than equivalent functionality when coded directly in SQL. So you go ahead with creating joins, using case statements and data type conversions directly in SQL input statements and potentially end up with a huge piece of code that performs nicely but is hardly maintainable in the future.
  • The development environment takes quite a while to get used to. Once you are all set up and doing your development work it is all fine but if you accidentally close some window or 'pane' just figuring out how to get it back can take quite some time.
Julia Gusman profile photo

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
Microsoft is widely adopted and it does get the job done. For legal reasons, support perspective and resourcing it is often the tool of choice and, of course, the technology is there to support the day-to-day business.
Julia Gusman profile photo

Usability

Microsoft BI7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky profile photo

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Microsoft BI7.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 BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

Microsoft BI6.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 BI8.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 BI9.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

Breadth of Deployment

It was the main reporting tool used by all the different departments. It was used by the Executive level, operations, marketing, sales. Number of users were probably around 50. Types of users: VP's, Directors, Managers, Analysts.
Mashhood Syed profile photo

Alternatives Considered

Microsoft BI offers many more benefits and allows you to use several products integrated with it.
Jean Franco profile photo

Collaboration and Sharing

Microsoft BI8.4
Based on 34 answers
Microsoft BI's templates are superb and result in a graphical summary of information that is easy to display/present to the wider team
Brian Caulfield profile photo

Data Integration

Microsoft BI8.5
Based on 33 answers
Microsoft BI supports a variety of different data sources such as SQL Server, Oracle DB, DB2, Sybase, Excel, Access, Text files, MySQL, Teradata, Amazon Redshift, Azure SQL Database, Azure SQL Data Warehouse, Impala, SAP Business Warehouse, SAP Hana.
Gonzalo Angeleri profile photo

Return on Investment

  • At the moment, the lack of use of Power BI has indered our market progression IMO
  • A large majority of customers keeps the solution once implemented, very few have switched platform
  • Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
Charles Saulnier 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
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details