We performed a comparison between Microsoft BI and Oracle OBIEE 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 is the clear winner in this comparison. It is easy to set up, has good customer support, and is reliable and easy to use. In addition, it has an impressive ROI and is less expensive than Oracle OBIEE.
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"Our setup is very straight forward and can be done in a matter of hours."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"Easy to use and the visualization is valuable."
"My favorite feature is the power query editor, where it can do the data transformations."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"The initial setup is easy."
"Microsoft BI's most valuable feature is flexibility."
"I have found the most valuable features are business intelligence and reporting."
"The security is good. For example, we can implement column-level security."
"I think having the conformed structures makes it a lot easier for end users and pulling reports together."
"I like the scheduling feature. It has an inbuilt scheduler which is very good, and it allows us to create agents, and those agents can be scheduled. It's quite flexible in that respect and goes into our IT infrastructure. The outputs are sent encrypted to various endpoints. Some are internal, and some are our clients, and it's encrypted at a high level. I do find Oracle OBIEE flexible. If there is stuff that's not in your model or schema, it's very flexible to create SQL scripts and create the data you want. It's quite nice to create a dashboard in OBIEE, and that's pretty straightforward in the way you drag and drop everything. You can create sections, and you can add elements to your page. That bit of the interface is relatively straightforward."
"It's the connectors, the adapters. Built in connectors with different ERPs, you can plug in XL, other sources of data. It's very easy to configure. It's very easy to use."
"Oracle OBIEE is a scary and stable product since it is a strong and well-created tool... In short, the solution is stable since it works properly every day."
"I like the cloud deployment feature. There are about 20 new features, and they are available on mobile and more. I haven't used any of them, but these features are highly attractive."
"I think the most valuable features are the ability to drill down, the graphs, and the scheduling for the reports to be received in Excel on a daily basis. Users like Excel, so it's good for them that they receive the reports by email, that they don't have to specify the schedule."
"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
"Integration with products that are not Microsoft could be more improved."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"I believe the price should be degressive, and we should have a lower, or better unit price if we have more users."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"Capacity could be improved."
"The upgrade process could be improved."
"I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."
"The functionality to customize and modify reports has been removed, and it would be beneficial to reinstall it, as it allows greater customization and flexibility in creating reports."
"The documentation in Oracle OBIEE can be more user-friendly."
"Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement."
"It is not a good product for data visualization."
"The pricing model could be improved. Right now, it's quite confusing. Many customers have this feeling that it's a super-expensive option."
"There are a lot of aspects of Oracle OBIEE that are exceptionally complicated, make things unnecessarily difficult for everyone who uses it. In terms of the integrations, Oracle needs to improve a little more, but I believe that they have tried to capture all those issues. The issues we are facing in the Oracle OBIEE 12C versions, in the Oracle Analytical Server Center or Analytical Cloud versions, Oracle has managed to overcome the challenges."
"The development effort takes longer than other BI tools currently on the market."
"Its overall organization as an analytical tool, the layout of OBIEE, is not very good."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while Oracle OBIEE is ranked 3rd in BI (Business Intelligence) Tools with 154 reviews. Microsoft Power BI is rated 8.0, while Oracle OBIEE 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 Oracle OBIEE writes "A solution that is easily accessible, scalable and requires a straightforward initial setup process to get started". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Databricks, whereas Oracle OBIEE is most compared with IBM Cognos, SAP BusinessObjects Business Intelligence Platform, Tableau, Oracle Analytics Cloud and Qlik Sense. See our Microsoft Power BI vs. Oracle OBIEE report.
See our list of best BI (Business Intelligence) Tools vendors and best Reporting 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.
When comparing Power BI with OBIEE, it is evident that OBIEE emerges as the winner in the data management aspect, while Power BI scores drastically above OBIEE in the self-service and data visualization aspects.
Power BI and OBIEE make a strong pair in the Analytics landscape by complementing the weaknesses of one with the strengths of the other!
Therefore, it is good to leverage the best of both OBIEE and Power BI, by connecting them seamlessly and securely through BI Connector.