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

Microsoft Power BI vs Oracle OBIEE comparison

Sponsored
 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
No ranking in other categories
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
No ranking in other categories
Oracle OBIEE
Ranking in BI (Business Intelligence) Tools
5th
Ranking in Reporting
3rd
Average Rating
7.8
Reviews Sentiment
7.5
Number of Reviews
157
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.3% compared to the previous year. The mindshare of Microsoft Power BI is 22.4%, up from 22.4% compared to the previous year. The mindshare of Oracle OBIEE is 4.0%, 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

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Amol Rane - PeerSpot reviewer
Supports AI initiatives in terms of predictive analytics
The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.
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

"Mapbox integration for geospatial analytics down to longitude/latitude layers."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."
"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"We use IBM Cognos for enterprise analytics and reporting."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"It is a good platform for data analysis, organization, and all of the other interim performances that are necessary."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI."
"This solution has improved our ability in making decisions and explaining data."
"The ease of integration and connectivity stands out as the most critical aspect, followed closely by the flexibility to customize reports and dashboards."
"The product is easy to use and simple to navigate."
"There is continual improvement year-over-year."
"The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with."
"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."
"It is easy to use...I rate the scalability of the solution a nine out of ten."
"The most valuable feature is the visualization."
"The main features of this solution are that it is easy to use, intuitive, and user-friendly. When I retrieve the data from the database it is in a very raw form, then when I use the Oracle Report Builder it has advanced intelligence features to allow me to view and make changes to the data easily."
"The most valuable feature is the ability to set up the automated delivery of reports."
"It is a very stable solution."
"The most valuable feature is the ability to run it in Exalytics within memory coupled to a Repository on Exadata is where it flies. So it's not meant for mom and pop shops, but if you are a global 500 fortune 1000 company, this is a tool that can get you what you need on time and even in real time."
"The most valuable features of Oracle OBIEE are the ease of logging in, the dashboard, and showing the problems in the data. Additionally, the reports are well integrated and it has good technology."
 

Cons

"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"There are a lot of limitations with the out-of-the-box tool."
"I think the GIS pieces maybe not as good as we would like."
"We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data."
"We identified a couple of issues in the reports. Some reports took too long to load, particularly at the end of our data refresh."
"Areas of Power BI that could be improved are the learning curve for developers who come from non-technical backgrounds."
"It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
"I would like to be able to use more predicting data science features without having to use R."
"The cost of the solution can get high."
"​It needs more graphics and overlays."
"It's quite difficult to learn how to use Power BI."
"Oracle OBIEE could improve by having better integration and compatibility with other vendors."
"Oracle OBIEEE's performance and licensing costs could be improved."
"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."
"Oracle OBIEE is lagging in data visualization."
"The platform's data visualization features need improvement."
"It needs a better security management system."
"The tool's downside is that it is very expensive, making it an area where improvements are needed."
"The solution needs to be easier to scale."
 

Pricing and Cost Advice

"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"It is pretty expensive."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"It's more expensive than similar solutions like Tableau and Power BI."
"The solution is affordable."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"Downloading Power BI Desktop is free."
"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."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"If it has to be applied on the cloud, then it costs around $10 per month per user. For a pro license and for a premium license it's around $20 per month per user. If it has to be applied on-premises then, depending on the course of your server, you have to buy a software assurance version of the database."
"Microsoft BI is very cost-effective and this is why we use it."
"Their price is good."
"The costs are small and the benefits are high."
"If you purchase a license for a server, for users, or the professional version, you might not have to. The free version I think it can satisfy many customers' needs."
"For the license in part of Oracle, my company makes yearly payments."
"It is high."
"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."
"Its licensing is yearly."
"It is reasonable, but it depends on how you're going to use it. There are no costs in addition to the standard licensing fees."
"This is a very costly product."
"It's comparable to the current technology we're using, Qlik Sense."
"Power BI is less expensive than Oracle OBIEE. A benefit to Power BI is having the option to work with concurrent licensing."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
823,795 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
55%
Financial Services Firm
7%
Computer Software Company
4%
Government
4%
Educational Organization
42%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Financial Services Firm
17%
Government
13%
Computer Software Company
10%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
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 wou...
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 info...
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 ...
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 ass...
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 f...
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 ...
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
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

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
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: November 2024.
823,795 professionals have used our research since 2012.