Microsoft BI

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

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
617 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
569 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

Microsoft BI

Many companies consider SSIS as 'free' since it comes included with the SQL server database. It seems an obvious choice if your data resides in SQL server to go ahead and utilize Microsoft BI tools. Notice, this is not the only option you have but one that many people would consider convenient. However, if most of your data does not reside in SQL server already, consider a wider choice of options for your BI. Another factor is the availability of skilled resources to maintain your BI environment. Due to its popularity on the market you will find most of people in the BI world are able to work with Microsoft BI
Julia Gusman profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

Use it anywhere where scalability and performance are required, especially if newer SAP version has been implemented.The mode users will use it, the better - otherwise, the pricing policy could spoil the ROI. Very good integration possibilities, with other standard enterprise applications. Support of various data resources, incl. XML, OLAP etc. including the ability to connect to JAVA, MS Sharepoint, MS Office and .NET applications.The programmer community around SAP BO is HUGE. It is quite certain, that the problem you have has already been solved by someone else. It requires a little digging in discussions, but the help is mostly available. You definitely cannot start small with SAP BO. It feels too costly,
Viktor Mulac profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
SAP BusinessObjects Business Intelligence (BI) Platform
7.2
Pixel Perfect reports
Microsoft BI
7.9
SAP BusinessObjects Business Intelligence (BI) Platform
7.3
Customizable dashboards
Microsoft BI
7.9
SAP BusinessObjects Business Intelligence (BI) Platform
6.8
Report Formatting Templates
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
7.5

Ad-hoc Reporting

Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
7.0
Drill-down analysis
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
7.9
Formatting capabilities
Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
6.4
Integration with R or other statistical packages
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
6.0
Report sharing and collaboration
Microsoft BI
8.9
SAP BusinessObjects Business Intelligence (BI) Platform
7.9

Report Output and Scheduling

Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
8.2
Publish to Web
Microsoft BI
8.3
SAP BusinessObjects Business Intelligence (BI) Platform
7.5
Publish to PDF
Microsoft BI
8.8
SAP BusinessObjects Business Intelligence (BI) Platform
8.4
Report Versioning
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
8.3
Report Delivery Scheduling
Microsoft BI
7.6
SAP BusinessObjects Business Intelligence (BI) Platform
8.3
Delivery to Remote Servers
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
8.4

Data Discovery and Visualization

Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
6.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
6.9
Location Analytics / Geographic Visualization
Microsoft BI
7.9
SAP BusinessObjects Business Intelligence (BI) Platform
7.1
Predictive Analytics
Microsoft BI
8.0
SAP BusinessObjects Business Intelligence (BI) Platform
6.4

Access Control and Security

Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
7.9
Multi-User Support (named login)
Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
7.5
Role-Based Security Model
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
8.1
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.6
SAP BusinessObjects Business Intelligence (BI) Platform
7.7
Single Sign-On (SSO)
Microsoft BI
8.5
SAP BusinessObjects Business Intelligence (BI) Platform
8.1

Mobile Capabilities

Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
7.2
Responsive Design for Web Access
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
6.5
Dedicated iOS Application
Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
8.5
Dedicated Android Application
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.3
SAP BusinessObjects Business Intelligence (BI) Platform
5.9

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
SAP BusinessObjects Business Intelligence (BI) Platform
6.6
REST API
Microsoft BI
7.9
SAP BusinessObjects Business Intelligence (BI) Platform
6.6
Javascript API
Microsoft BI
8.3
SAP BusinessObjects Business Intelligence (BI) Platform
6.5
iFrames
Microsoft BI
7.7
SAP BusinessObjects Business Intelligence (BI) Platform
6.5
Java API
Microsoft BI
7.5
SAP BusinessObjects Business Intelligence (BI) Platform
5.9
Themeable User Interface (UI)
Microsoft BI
7.8
SAP BusinessObjects Business Intelligence (BI) Platform
7.1
Customizable Platform (Open Source)
Microsoft BI
7.4
SAP BusinessObjects Business Intelligence (BI) Platform
6.8

Pros

  • The interfaces of the products are familiar to most people that currently use Microsoft products so its comfortable in that respect
  • Creating a report is easy to do with drag/drop functionality. You also have alot of dropdowns. You can use formulas the same way you do in Excel. They have "expressions" which are like formulas with a mix of SQL.
  • Publishing a report to the server is simple as well. You go to the server and upload the file from your file directory.
  • Setting up subscriptions is simple as well. Anyone can do it with minimal knowledge. Its sort of like creating a recurring calendar event.
  • The hierarchy within SSRS is intuitive. A Project is the top level item. You can add as many reports as you want to a project. Similar to any other IDE where you keep all your files in one project (HTML, CSS, JavaScript, JSP, Servlet) except in the case of SSRS its all reports.
  • Whether you choose to use 2008 or 2012 the interface is layed pretty much the same. So if you start of in 2008 and then upgrade, you dont have to re-learn anything. Their are slight differences in the two versions but it wont hinder your ability to build a report.
Mashhood Syed profile photo
  • Very good scalability and a real must if you have an SAP as the main ERP system in the production across several factories.
  • Very good vertical integration with other SAP tools and even other main ERP solutions.
  • A good choice for a publicly traded company, where a robust auditable system is a prerequisite for getting transparency into internal.
Viktor Mulac profile photo

Cons

  • 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
  • The Platform Search tool can be troublesome to establish in a clustered deployment.
  • Issues that are repaired in on release, should not resurface in a future release. This is rare but annoying when it occurs.
  • Some of the developer tools require more documentation that what is provided.
No photo available

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.
Steve Wake profile photo
SAP BusinessObjects Business Intelligence (BI) Platform8.4
Based on 22 answers
I think it is a very good product that is very powerful with a wide variety of tools for data analysis.
Albano García Pelaz profile photo

Usability

Microsoft BI7.0
Based on 5 answers
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries. 2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI. It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend
Sean Warren profile photo
SAP BusinessObjects Business Intelligence (BI) Platform9.5
Based on 4 answers
From a server and client side perspective. the Business Intelligence Platform provides a foundation for all aspects of content development, distribution, analysis, collaboration and self service. Ease of use from targeted content delivery through controlled accessibility. Content exporting in the format of the users choice. Scheduling for internal or external delivery. Public and private folders for secure content access when requied. Web based for viewing on the users device of choice without the need to download additional applications.
No photo available

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo
SAP BusinessObjects Business Intelligence (BI) Platform1.0
Based on 3 answers
Its available anytime. Depends on the server configuration.
No photo available

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
SAP BusinessObjects Business Intelligence (BI) Platform7.2
Based on 8 answers
I can see this is the best reporting tool available on market right now.
No photo available

Support

Microsoft BI7.1
Based on 6 answers
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available
SAP BusinessObjects Business Intelligence (BI) Platform7.5
Based on 6 answers
Response is fast and good based on the level of question that we raise.
No photo available

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
SAP BusinessObjects Business Intelligence (BI) Platform9.5
Based on 2 answers
Great training with hand-on labs.
Nathan Patrick Taylor 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
SAP BusinessObjects Business Intelligence (BI) Platform8.0
Based on 1 answer
SAP's training is excellent, though it is expensive.
Nathan Patrick Taylor profile photo

Implementation

Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo
SAP BusinessObjects Business Intelligence (BI) Platform8.4
Based on 7 answers
Hire specialists and experienced staff. Mix some beginners so that everyone is not a leader but a learner too. Plan well; architect well; break down implementation in small steps and move towards larger steps. Create a centralized and authorized SAP Business Objects implementation team.
Priyanka Musale profile photo

Alternatives Considered

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo
MySQL is great but we found that SAP user interface was cleaner and more efficient. Tying the various areas of data together was much more straightforward.
Ben Williams profile photo

Return on Investment

  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo
  • By generating and distributing reports in a timely manner, we were able to save millions of dollars for the company which otherwise would not have been visible.
  • Almost realtime dashboard, saved the company a huge amount by showing the outages and kept the company from buying a tool to do just that.
  • It showed the customers who were not paying the bills and were missing in the system due to some loophole. This was visible by doing reporting on the theft usage of electricity.
No photo available

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

SAP BusinessObjects Business Intelligence (BI) Platform

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
SAP BusinessObjects Business Intelligence (BI) Platform Editions & Modules
SAP BusinessObjects Business Intelligence (BI) Platform
Additional Pricing Details