We performed a comparison between Microsoft BI and SAP BusinessObjects Business Intelligence Platform based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Microsoft BI comes out on top in this comparison. It is reliable and easy to use. In addition, when compared with SAP BusinessObjects, it is easier to set up, less expensive, and has better customer support.
"It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
"My favorite feature is the power query editor, where it can do the data transformations."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"It seems stable. I haven't heard of any difficulties from my clients that utilize Power BI."
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
"Microsoft BI allows us to connect to any database or any dataset."
"The initial setup is straightforward."
"We find that we can scale it as needed."
"The common metadata environment means that the entire organisation has the same definition of core measures rather than these being derived in spreadsheets or specific reports."
"It is solid and stable."
"There are two tools inside BusinessObjects' schematic layout called the Universal Design Tool and Information Design Tool. These are the most powerful tools that set BusinessObjects' reporting from other solutions. If my organization has 300 or 400 tables, I can combine all of them into one universe, and everyone can use that. It is just a schematic layout that does not hold any data but the table relationships."
"It is stable and robust. It has pretty direct integration with SAP ERP. It is easy to use."
"Provides autonomy for all the business users to develop their own reports."
"This reporting and broadcasting solution has a lot of flexibilities and can connect to multiple source systems."
"The solution is stable."
More SAP BusinessObjects Business Intelligence Platform Pros →
"Real-time updating needs improvement."
"They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."
"It would be nice to use other connectors to link with the data."
"The DAX in Microsoft BI is quite difficult."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. This can be a significant drawback for clients who desire more flexibility."
"The default parameters of the prompt could be improved by including a dynamic option."
"The reporting could be a bit better."
"The calculation engine requires some improvement."
"The solution can improve by having more analytical features."
"Tableau was easier for me to use because the interface is more similar to Excel which I was used to using."
"The solution is not good for self-services, they can improve in this area."
"Its price should be better. It is expensive and not cost-effective. It should also be improved in terms of end-user experience. It requires further improvements for usability and ease of use. It should have more dashboarding metrics and much faster integration with ERP so that when you double click, you can instantly see the scenario-based result."
"There is still a lot to be done on the mobile side to make Web Intelligence truly seamless between the desktop and mobile versions and I would like to see SAP pay a lot more attention to this."
"I don't like the fact that I have to use two tools. Web Intelligence is good for reporting and all kinds of stuff, but I would rather have one product. All the reporting features of Web Intelligence should be developed within Lumira. A lot of predictive abilities have been brought into the cloud version of SAP Analytics. It would be nice to see a lot of newer technologies and AI. Predictive capabilities are becoming a little more standard. Instead of having to get another model, we are just looking for one solution to deal with analytics including predictive."
"The solution could be less expensive. It's a bit pricey now."
More SAP BusinessObjects Business Intelligence Platform Cons →
More SAP BusinessObjects Business Intelligence Platform Pricing and Cost Advice →
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while SAP BusinessObjects Business Intelligence Platform is ranked 6th in BI (Business Intelligence) Tools with 102 reviews. Microsoft Power BI is rated 8.0, while SAP BusinessObjects Business Intelligence Platform is rated 7.8. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of SAP BusinessObjects Business Intelligence Platform writes "Web intelligence will work with any amount of data even if you have 10 million rows". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Salesforce Einstein Analytics, whereas SAP BusinessObjects Business Intelligence Platform is most compared with SAP Analytics Cloud, Oracle OBIEE, IBM Cognos, MicroStrategy and Looker. See our Microsoft Power BI vs. SAP BusinessObjects Business Intelligence Platform report.
See our list of best BI (Business Intelligence) Tools vendors.
We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
All the traditional BI platforms including Business Objects and Microsoft Reporting services and Analysis services require IT involvement almost at every step in preparing the data and report.
Self serve BI is the promise to these business analysts without technology background. However following characteristics are a must to meet the self serve BI dream.
- BI tool should be capable of reading data from its source without a dependency on ETL or a warehouse.
- While a dimensional model gives most flexibility for ad hoc data analysis, it brings a overhead of consistent modeling mindset requiring very technical background.
- Ability to convert grid data into visualization and vice versa with few clicks
- Ability to mashup multiple analysis from multiple sources on to a single screen.
- Finally a framework that let's end users seamlessly build their analysis while IT can throttle, govern, audit and scale end user data needs with a great amount of automation behind the scenes as a continuous process as opposed to be a pre process.
Two such platforms I have come across are
1) Tableau
2) CarbonBI
These solutions seem good for Visualizations. I like Pentaho personally. Wondering why the this suggestion hasn't been made??
Sap business objects can provide a sophisticated self service solution that is very easy for the end users to engage with for both ad hoc analysis and report writing and distribution. However as with all Bi solutions the back end data warehouse must be designed intelligently and business objects universes configured correctly. The same thing really applies no matter what toolset you select. If you already have business objects then it makes sense to ask IT to set it up as a self service solution rather than look for another technology. If IT do not have the skills then look for a good consultant to perform a review of your BI solution and make recommendations.
Nick,
Good comments similar to the points I was making. I think that it is still
important to consider how much data you expect to be dealing with, the
tool's analytical architecture (ROLAP or MOLAP), the sophistication of your
analyst end users, and how complex your reports are likely to be. If you
or the analysts expect that solution development is going to be in the
hands of the analyst, then the tool needs to be relatively easy to learn.
On the last point, if you expect a lot of slicing-and-dicing you need an
architecture that will support the high indexing load. Anyway, success and
use acceptance is not just a question of apparent simplicity and seemingly
low cost.
regards,
Keith Breedlove
Polyglot Analytics, LLC
Groveland, FL
I suggest Power Data, the new Microsoft develop.
Try Tableau.
I would suggest looking at Tableau for requirements of self-service nature. The success factor for a self service tool depends on the ease-of-use for the end-user who is less proficient in IT skills and the range of tasks it allows the end user to accomplish. Tableau scores highly on both these parameters. Backed by a well designed data mart, Tableau can be the solution that pretty much allows the end user to replace the need for IT. It has excellent training materials available in one-click and many forums where people are ready share their cool experiences. Developing a report in Tableau for me was more like playing a video game, a throughly enjoyable experience to get to a cool end-product. You want the end-users to cherish the process of creation and Tableau does that with ease.
I would focus on Tableau and MicroStrategy (we went with MSTR several years ago to supplant BO), although QlickView has its proponents for ease of use...