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

Microsoft BI

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

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

SAP BusinessObjects Business Intelligence (BI) Platform

One of the things I like about BusinessObjects is that, as a BI manager, I can help varying levels of users. For example, if I have a user that has no interest/technical skill, I can build up a universe, create an InfoSpace, and design some view sets. If the user is more advanced, maybe I just need to build the universe and let them play with the view sets. Users can insert themselves in the BI process where they feel comfortable.
I dislike that there has traditionally not been a good method of restoring a single item when a user accidentally over-engineers it or deletes it altogether. And until recently, there hasn't been any kind of versioning. If there is much customization of the environment, it takes a little more effort to upgrade an existing environment or stage a new one.
No photo available

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
SAP BusinessObjects Business Intelligence (BI) Platform
7.1
Pixel Perfect reports
Microsoft BI
7.8
SAP BusinessObjects Business Intelligence (BI) Platform
7.0
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.4

Ad-hoc Reporting

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

Report Output and Scheduling

Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
8.1
Publish to Web
Microsoft BI
8.3
SAP BusinessObjects Business Intelligence (BI) Platform
7.7
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.2
Report Delivery Scheduling
Microsoft BI
7.5
SAP BusinessObjects Business Intelligence (BI) Platform
8.0
Delivery to Remote Servers
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
8.3

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
6.2
Responsive Design for Web Access
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
6.1
Dedicated iOS Application
Microsoft BI
8.4
SAP BusinessObjects Business Intelligence (BI) Platform
6.6
Dedicated Android Application
Microsoft BI
8.1
SAP BusinessObjects Business Intelligence (BI) Platform
6.1
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.2
SAP BusinessObjects Business Intelligence (BI) Platform
5.9

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
SAP BusinessObjects Business Intelligence (BI) Platform
6.3
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.2
iFrames
Microsoft BI
7.7
SAP BusinessObjects Business Intelligence (BI) Platform
6.2
Java API
Microsoft BI
7.6
SAP BusinessObjects Business Intelligence (BI) Platform
6.0
Themeable User Interface (UI)
Microsoft BI
7.8
SAP BusinessObjects Business Intelligence (BI) Platform
6.6
Customizable Platform (Open Source)
Microsoft BI
7.5
SAP BusinessObjects Business Intelligence (BI) Platform
6.2

Pros

Microsoft BI

  • SSIS is by far the easiest and most efficient ETL (Extract, Transform & Load) tool available, after trying many different tools over the years there is no tool that is more flexible and easier to develop solutions with. What takes days/weeks or longer to setup in other tools can be done in at least half the time and perform better.
  • SSRS is one of the best web reporting tools available for companies of any size that doesn't require you to re-architect your entire existing database structure. SSRS can connect to all of the major databases and work with data from multiple of them all in the same report. For web reporting that needs to be up and running fast, but be secure and easy to develop on there is no better tool available today.
  • SSAS is for more in depth analysis of your data and it has the same capabilities as all other Microsoft tools to connect to multiple data sources and present the data to the user in standardized format. Most users will love that they can access so much of the companies data in Excel using the PivotTables that they probably already use today, but now you are controlling the data and know that it is the correct data. With the new Tabular capabilities in SQL Server 2012 and up it allows end users to help build the initial version of these complex data structures which can then be migrated over to IT to add security, automation and quality control to the final solution.
Steve Wake profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

  • Various tools to implement end to end BI, for example: ETL, Reporting, Dashboarding
  • Good connectivity with CRM, ECC and other SAP systems etc
  • Data Security, Visually intuitive, Ease of use
  • Webi, Rich Client, SAP Dashboard, Crystal Reports reporting tool to cover needs of a variety of users
Priyanka Musale profile photo

Cons

Microsoft BI

  • Power Pivot is a very good tool to do self service BI but there is no direct way to implement row based security to the model. There has to be a mechanism where the owner of the book can lock the model within the book to be read only or hide the model so that other users will only see the reports and not the underlying data model
  • Many to many functionality is simple in multi dimensional cubes but there is no direct and efficient way available in SSAS Tabular model and Power Pivot
  • Even though Power Pivot is a easy to use and fast to implement BI solution, without proper training, end users can't utilize all the functionality of Power Pivot and common mistakes and misunderstandings will be expensive in long run
No photo available

SAP BusinessObjects Business Intelligence (BI) Platform

  • SAP should provide free software and licenses for students
  • SAP Extractors are designed by third party, so no support for those
  • Reporting with no semantec layer
Priyanka Musale profile photo

Likelihood to Renew

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
I've been implementing Microsoft, and other, BI tools for many years and will continue to drive adoption of this platform in my client base as it matures. My firm also uses the platform internally for all our operational and analytical systems.
Jacob Saunders profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 8.4
Based on 22 answers
We are currently evaluating other reporting tools to see if they can satisfy our business needs and if it's a better long term solution. Price and long term costs will be a major factor in the decision.
Carla Simoneau profile photo

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 9.5
Based on 4 answers
I have been creating SAP software solutions successfully since past 10 years and SAP BO's popularity and demand is still strong in the market.
Priyanka Musale profile photo

Reliability and Availability

Microsoft BI

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

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 1.0
Based on 3 answers
Its available anytime. Depends on the server configuration.
No photo available

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

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 7.2
Based on 8 answers
When it is deployed properly the system is very stable and consistent in its response times. The way the product is designed the data sources it connects to and the bandwidth of the network its on can be the main performance inhibitors. Addressing these two factors can greatly increase performance overall. Integration with third party tools requires strict adherence to SAP specifications. When they are followed there is no performance degradation.
No photo available

Support

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.
Sean Brady profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 7.5
Based on 6 answers
Very difficult website to use that is not very intuitive. It's hard to reach a good support person that can actually help with the issue. We usually end up solving the issue ourselves.
Carla Simoneau 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

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 9.5
Based on 2 answers
Great training with hand-on labs.
Nathan Patrick Taylor 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

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 8.0
Based on 1 answer
SAP's training is excellent, though it is expensive.
Nathan Patrick Taylor profile photo

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
You need to have (1) a very solid SQL Server DBA and (2) a Windows Server administrator with domain administrator rights to get the BI stack set up correctly. As most Windows systems people will tell you, a lot of good comes out of doing some security planning on the domain side (users, groups, roles, etc.) before you start the implementation. This is a big integrated system, and getting it set up right is half the battle.On the development side, you will want to have a full time data architect making sure that the model you are developing holds together and supports the reporting requirements of the business. You will also want a technical lead who has rich experience with the stack - that person will be able to shepherd the rest of the development team and help them come up to speed with the tools.
Sean Brady profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

SAP BusinessObjects Business Intelligence (BI) Platform 8.4
Based on 7 answers
Choosing the right personnel to deploy and maintain the system is critical to success. Do not underestimate the value of a sandbox and or Development environment. Every aspect of the initial deployment and subsequent upgrade and enhancements should be thoroughly tested by the developers and administrators for expected functionality and compatibility with all interfaces. A Test environment is just as crucial. Initial key user content testing and formal performance testing should take place here prior to the production deployment. This is also where you finalize your operational support plans and system/user security
No photo available

Alternatives Considered

Microsoft BI

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

SAP BusinessObjects Business Intelligence (BI) Platform

Microsoft SQL Server Reporting Services is more dependent on IT for development. We had issues with loger development time with Cognos.Hyperion Essbase Smartview is a good discovery tool but not a good enterprise reporting tool. It is very business centric with the Excel interface, but lack the functionality.
Joel Pick profile photo

Return on Investment

Microsoft BI

  • My organization uses Microsoft BI for nearly all of our development. We would not be able to integrate with our clients to deliver our solutions easily without it.
Megan Juell profile photo

SAP BusinessObjects Business Intelligence (BI) Platform

  • 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

Add comparison