Try our new research platform with insights from 80,000+ expert users

Microsoft Power BI vs Oracle OBIEE comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
319
Ranking in other categories
No ranking in other categories
Oracle OBIEE
Ranking in BI (Business Intelligence) Tools
4th
Ranking in Reporting
3rd
Average Rating
7.8
Reviews Sentiment
6.5
Number of Reviews
157
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.4%, down from 22.6% compared to the previous year. The mindshare of Oracle OBIEE is 3.9%, down from 4.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Q&A Highlights

NC
Nov 08, 2021
 

Featured Reviews

James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.
VishnuReddy - PeerSpot reviewer
Handles large datasets and easy to interact with and handle but performance could be better
Oracle's technical support usually recommends to upgrade when you contact them for support. They don't focus on fixing the issue at hand or providing guidance on how to do it. If you are in a lower environment, like one version down, they will blindly suggest upgrading. Additional patches are given for other Oracle products like WebLogic, databases, and apps. They fix issues and create patches based on client needs. But from an OBIEE point of view, they mostly provide bundle patches of around 5 to 6 GB that need to be applied and tested end-to-end. It's not an easy way to get small patches, and if issues arise after applying the patches, you have to contact Oracle again.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is shareability, where we can publish work to the cloud and share it with team members."
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
"The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information."
"The scalability is good. We have 20 people in my organization using this solution and plan to increase usage."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"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."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"For me, it makes the difference is in terms of our users being able to take advantage of a product which allows you to get access to data, reports, make decisions quickly, and have better insights regarding operations."
"Dashboards provide us with various views and perspectives on our data, allowing us to analyze metrics such as revenue, occupancy rates, etc."
"The performance can issue queries to work in the Oracle database in Oracle's native language. There are a lot of visualizations which suit our business."
"We do you use Oracle support. We've been paying for an Oracle support subscription for four or five years, and not one ticket has ever been logged. When I came in, I've encouraged the team to ask Oracle questions. They do get back quite quickly. Their support is good. Working with our account managers, if I need to escalate anything, I can speak to them and they escalate the call. I've got that ecosystem working quite well. That does work for us."
"Inter Process Communication."
"The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand."
"The setup isn't too difficult."
"We have scheduled reports delivered automatically to our business users using enterprise features."
 

Cons

"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."
"One area for improvement in Microsoft Power BI is serviceability. Compared to one of its competitors: Tableau, there are a lot of things which you cannot do in this tool, that can be done in Tableau."
"The solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
"The solution's documentation needs improvement."
"It is not leading the charge on scalability, but it meets expectations."
"Its price could be better. Its licensing cost is very high."
"The documentation in Oracle OBIEE can be more user-friendly."
"Even though we have a feature to enable the physical query to be seen in the log, in case of any issues, it is challenging to debug and see or identify where is the issue. For example, we designed the OBIEE repository and deployed it into the server, and we are now accessing and creating a report. For some reason, if the report is not working as expected, it is very difficult to identify the issue. We have a feature to see the physical query that is being generated in the central OBIEE server. I feel that this feature should have been available at the repository level so that while designing the repository, we can select the presentation columns and the query it is going to create. This will avoid the additional task of deploying a feature into the server and then testing the report. It will also make the implementation process friendly if, while designing the repository, we can see: How is a feature working? Are any of the presentation columns selected? How is the query being generated? Which query is being generated? Are any joints used? What kind of joints are used? Having this kind of information will make Oracle OBIEE more powerful and developer-friendly."
"The drawback with the tool is that though it is well-created, its users are under-trained to use it."
"When a large number of queries are running at the same time, the report fails."
"There could be better integration with other solutions, such as Microsoft Office."
"In the on-premises version, the feature for connecting and selecting the data between the databases looks a bit cumbersome, but I am not sure. The person who is using it takes a lot of time to design a data warehouse. When I ask him why is it taking this long, I get a response that this is something that he has to design, and there are different tools that are available. He has to write the ETL and design the warehouse according to the customer's requirement, which takes a lot of time. Its visualization should be enhanced, and there should be a feature where you can easily create your custom data warehouse."
"We needed some technical expertise during setup."
"In terms of tech support, we have our own technicians. But, we did register for their help. When we register a call, it takes time for them to respond to us."
 

Pricing and Cost Advice

"Its pricing is great."
"Power BI is cheaper than Tableau and Cognos."
"The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"The pricing is very reasonable compared to any other tool."
"The price of the solution can be expensive if you want to synchronize your data more."
"Licensing is on a monthly basis, but I am not sure."
"We have enterprise licenses and some of the other tools or features come as a package and others you have to purchase separately."
"Its licensing is yearly."
"For the license in part of Oracle, my company makes yearly payments."
"In our organization, we use a user-based license for Oracle OBIEE, and I've heard that the license cost is based on the number of users."
"This is a very costly product."
"The price of Oracle OBIEE is expensive, it is difficult for a small business to afford."
"A person only needs to pay towards the subscription costs since it is a cloud-based solution. I use the free version of Oracle OBIEE."
"It is an expensive solution."
"If you compare Qlik Sense and Oracle OBIEE licensing, then Oracle products are much better. With Qlik Sense, you have to pay per client and per use. But we get Oracle OBIEE along with the Oracle database, making it much more cost-effective in the long term."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Answers from the Community

NC
Nov 8, 2021
Nov 8, 2021
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle OBIEE offers user security, data security, and many other security options. OBIEE also has a machine learning option, which is very good. OBIEE works best for very large organizations. Microsoft BI is...
See 2 answers
Oct 24, 2021
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle OBIEE offers user security, data security, and many other security options. OBIEE also has a machine learning option, which is very good. OBIEE works best for very large organizations. Microsoft BI is easy to learn, very user-friendly and stable, and integrates well with everything in the Microsoft ecosystem. This solution offers many different licensing options and the technical support is very good. It is a very good solution for teaching and training and works great integrating with Excel. Oracle OBIEE implementation and deployment can be confusing, requiring technical expertise and experience to manage. The pricing model is expensive and it is not a cost-effective solution for smaller enterprises. There also seems to be a lot of redundancy with regard to creating the necessary code to make things run smoothly. This solution should be more intuitive and less complex. Scalability could also be easier. With Microsoft BI, design and visualization seems a bit limited. They should offer better licensing options with more flexibility for various unique client needs, especially with smaller enterprises. Moving to the cloud makes licensing needs even more challenging to figure out and to choose the best option. Support could be better in explaining how issues were resolved and what steps were taken to resolve them. Conclusion Oracle OBIEE is very user-friendly and offers customizable dashboards. The visualization is very good and they offer AI with good forecasting options and machine learning. This is a great solution for large-scale enterprises. Microsoft BI is a good option for smaller-scale enterprises and, of course, works great with everything within the Microsoft ecosystem. It is a great option for the less tech-savvy user.
MR
Nov 8, 2021
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.
 

Top Industries

By visitors reading reviews
Educational Organization
43%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
Financial Services Firm
18%
Government
13%
Computer Software Company
10%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance po...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
Which Oracle product is better - OBIEE or Analytics Cloud?
Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist customers. These are two attributes that make this system quite valuable. OB...
What do you like most about Oracle OBIEE?
The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand.
What is your experience regarding pricing and costs for Oracle OBIEE?
All products from Oracle are very pricey. Microsoft always works out to be a cheaper tool. If you have anything that you do with Microsoft, then price-wise, it is very competitive. Microsoft Power ...
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
 

Overview

 

Sample Customers

Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
Find out what your peers are saying about Microsoft Power BI vs. Oracle OBIEE and other solutions. Updated: February 2025.
837,501 professionals have used our research since 2012.