Microsoft Power BI vs Oracle Fusion Middleware comparison

The compared Microsoft and Oracle solutions aren't in the same category. Microsoft is ranked #1 in BIT , with an average rating of 7.9, and holds a 23.0% mindshare in the category. Oracle is ranked #6 in AppS , with an average rating of 7.9, and holds a 5.2% mindshare. Additionally, 93% of Microsoft users are willing to recommend the solution, compared to 86% of Oracle users who would recommend it.

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Microsoft Power BI and Oracle Fusion Middleware based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools.

To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: November 2024).

Buyer's Guide

BI (Business Intelligence) Tools

November 2024

Download the complete report

Helped 816,192 peers since 2012

Categories and Ranking

IBM Cognos

Mindshare comparison

BI (Business Intelligence) Tools

Application Server

Q&A Highlights

Ross Verschelden

ICT Business Engagement at Ipswich City Council

Apr 23, 2023

Is it easy to extract data from Oracle Fusion into Power BI?

I had the experience of supporting a client. Could not connect Oracle to Power BI gave an error I learned the following: The problem is that Microsoft documentation is a simple process and not detailed. 1 - Install and configure the Oracle client (depends on the version) 2 - Must be compatible with the BI desktop version. 3 - Configure the gateway in the BI service. I suggest you look for someone expert in Oracle to install and configure it for you.

See all answers

Featured Reviews

Carlos Larrad Salgado

Deputy Director Operations Management Control at Mapfre

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.

Read full review

Amol Rane

Solutions Architect M365 at Sogeti UK

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.

Read full review

Husni Milhem

Projects & SCM Track Leader at El-Seif Engineering Contracting Company

Maintains top database performance and includes a very good ATB feature

Technical support is helpful. They have a good support bot for handling items so most case response times are fast. Support is aware and responsive but it takes time for them to resolve issues. Our whole enterprise is in the cloud and uses this application. It is a high priority to close any issues. We need an immediate response with resolution within two to three days. Support sends a lot of templates to fill in based on the priority or escalation. Completing templates takes time, particularly with the bot. The support process definitely needs improvement so technical support is rated a seven out of ten.

Read full review

Quotes from Members

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

Pros

"When it comes to decision-making, the product is very useful and used in many departments since a lot of people prefer the reports to be generated by IBM Cognos."

"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."

"This solution allows you to input a wide range of file formats."

"In terms of stability, I think that Cognos is more stable than Tableau and Power Bi because of its framework manager concept that allows us to import metadata and store it in the framework manager."

"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."

"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."

"We use the account statement report. When you use an account in HSBC, you receive various types of accounts, such as the stock market, fixed accounts, credit cards, and business accounts. We can create one consolidated report called CCS support, which includes all these accounts. In that statement, we are consolidating all those accounts."

"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."

More IBM Cognos pros

"The product is easy to use and simple to navigate."

"The tool is very flexible so it allows creativity."

"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."

"Technical support has been great."

"The fact that you can visualize items is great."

"It is really flexible. The charts and reports are really nice. You have the flexibility of self-service."

"With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."

"The user interface is easy to work with."

More Microsoft Power BI pros

"The solution is quite good for applying patches or performing upgrades."

"Fusion Middleware's main feature for me is that it is quite flexible, and, as middleware, it provides us with all sorts of technology and application adapters, which makes it very handy to use."

"Oracle Service Bus is the most valuable feature of the solution."

"The most valuable feature is the structure of the product. We use Oracle Fusion Middleware to manage the Oracle database. Registered users can go to each product if sign-on credentials match each user's identical framework."

"The scalability is good."

"The solution is very easy to install."

"Data integrity."

"The most valuable features are the pre-built connectors between Oracle applications, which allow quick integration. I also appreciate the fast deployment of components. Oracle Fusion Middleware's key benefit is enabling real-time data transfer between applications."

More Oracle Fusion Middleware pros

Cons

"I would like to see is more easy building, movement in the reports, and dashboard functionality within reporting. Overall more simple elements within reports. If the elements are simple then you don't have to render a full page, but you can move separate parts in the page."

"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."

"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."

"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."

"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."

"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."

"It could have more options for themes."

"There are a lot of limitations with the out-of-the-box tool."

More IBM Cognos cons

"Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."

"We would like it if they added more Python libraries in the Power BI service. For Power BI service right now, you can use Python, but it is limited to a few libraries or a few packages from Python."

"The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job."

"The dashboards lack a user-friendly appearance."

"Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today."

"Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region. Its usability could also be better, and it could also have more connections with different data sources."

"It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."

"Integration with products that are not Microsoft could be more improved."

More Microsoft Power BI cons

"I would rate the stability a nine out of ten because we did have multiple breakdowns and crashes."

"Oracle Fusion Middleware is based on the regulations in Saudi Arabia and the legislation changes. There is a need to be improvements all the time. It needs to adapt quickly in this market. Additionally, there could be some improvements in the construction sector."

"The main improvement must be made on the user interface. You need to use another Oracle cross in this product. It must be improved and some features of the connectors must be changed."

"All areas of HCM modules could use some improvement."

"For improvements, I think Oracle Fusion Middleware could be better at connecting to third-party applications. While it works well with Oracle products, it's more limited to non-Oracle systems than other middleware solutions like MuleSoft."

"Its price can be improved. We are currently looking for more cost-efficiency. It should also have a little bit more flexibility for customizations. The customizations should be quicker."

"The product should improve BPEL features."

"The documentation might not be good enough for new users."

More Oracle Fusion Middleware cons

Pricing and Cost Advice

"My company uses IBM Cognos with another IBM product, so I think only one license is used."

"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."

"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."

"The solution is affordable."

"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."

"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."

"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."

"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."

More IBM Cognos pricing and cost advice

"The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user."

"It would be better if the price was cheaper."

"Pricing is a big advantage that Power BI has over Tableau. Power BI is three or four times cheaper than Tableau. For my personal use, I will definitely prefer a $20 monthly fee of Power BI rather than a $70 monthly fee of Tableau. If you pay altogether for Power BI, they give you a discount, whereas, with Tableau, there is no discount. There are three versions of Power BI: Free, Pro, and Premium. The Premium version comes with a lot of things. There is no extra or hidden fee. You pay every month, and the software is with you. If you upgrade, there will be some extra charges."

"We have a professional license for Microsoft BI and the price is fair."

"We have enterprise licenses and some of the other tools or features come as a package and others you have to purchase separately."

"As far as I am aware you do not need a license for the solution."

"The solution is priced well for what they offer. However, the premium version is very expensive."

"Licensing fees are paid on a yearly basis."

More Microsoft Power BI pricing and cost advice

"We pay annually for the solution."

"My advice is to buy the basic modules first, gain the most benefit from them, then buy the advanced modules."

"The solution is quite expensive so is only used by larger organizations."

"The licensing costs are reasonable."

"The tool is best suited for large companies due to high licensing costs."

"It is expensive. We are looking for a cheaper solution."

"The solution is expensive so pricing is rated a six out of ten."

"The pricing is moderate. It's fine."

See which vendors are best for you

Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.

See recommendations

816,192 professionals have used our research since 2012.

Comparison Review

it_user79932

Senior Manager - BI Head at NVidia

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…

Read full review

Answers from the Community

Ross Verschelden

ICT Business Engagement at Ipswich City Council

Apr 23, 2023

Is it easy to extract data from Oracle Fusion into Power BI?

Hi Ross,Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below:https://www.biconnector.com/po...The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also ret...

2 out of 3 answers

PATRICKMURPHY

Financial Systems Advisor - US Controller Group at McDonald's

Apr 19, 2023

Hi Ross, Easy is a tricky description...We are going through this effort too. We are 'grappling' with the governance of this type of access as well as the technical journey. So you are not alone. Fusion Middleware applications include a number of connectivity options including native client or Oracle Data Access Components (ODAC), with OLEDB, JDBC, etc., on top. Each has its own quirks. This is the 'plumbing' between the analytic tool and source. Adding to that is the cloud and database level security of the data source. A good way to start is to use Oracle's SQL Developer to connect to your data source. It gives developers a great query tool for Oracle and other databases. (https://www.oracle.com/databas...) Once you understand what you can access, you can easily migrate that connectivity to Power BI. Moreover, you will have validated queries that you can test directly or simply bring in the tables using the PBI Navigator.

Read full answer

Dinesh Murugappan

Technical Marketing Specialist at Guidanz Inc

Apr 20, 2023

Read full answer

See all 3 answers

Top Industries

By visitors reading reviews

Educational Organization

56%

Financial Services Firm

Computer Software Company

Government

Educational Organization

41%

Financial Services Firm

Computer Software Company

Manufacturing Company

Educational Organization

55%

Financial Services Firm

Computer Software Company

Government

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 ...

See all answers

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.

See all answers

What needs improvement with IBM Cognos?

I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...

See all answers

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...

See all answers

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...

See all answers

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 ...

See all answers

What do you like most about Oracle Fusion Middleware?

The most valuable features are Oracle Unified Directory and unified identity access management.

See all answers

What is your experience regarding pricing and costs for Oracle Fusion Middleware?

The tool is best suited for large companies due to high licensing costs.

See all answers

What needs improvement with Oracle Fusion Middleware?

For improvements, I think Oracle Fusion Middleware could be better at connecting to third-party applications. While i...

See all answers

Comparisons

Tableau vs IBM Cognos

Compared 10% of the time

Oracle Hyperion vs IBM Cognos

Compared 10% of the time

Amazon QuickSight vs IBM Cognos

Compared 8% of the time

SAP BusinessObjects Business Intelligence Platform vs IBM Cognos

Compared 7% of the time

SAP Analytics Cloud vs IBM Cognos

Compared 5% of the time

More IBM Cognos Competitors

Tableau vs Microsoft Power BI

Compared 17% of the time

Domo vs Microsoft Power BI

Compared 10% of the time

Amazon QuickSight vs Microsoft Power BI

Compared 8% of the time

KNIME vs Microsoft Power BI

Compared 6% of the time

MicroStrategy vs Microsoft Power BI

Compared 2% of the time

More Microsoft Power BI Competitors

Oracle WebLogic Server vs Oracle Fusion Middleware

Compared 79% of the time

JBoss vs Oracle Fusion Middleware

Compared 6% of the time

IBM WebSphere Application Server vs Oracle Fusion Middleware

Compared 6% of the time

Tomcat vs Oracle Fusion Middleware

Compared 5% of the time

IIS vs Oracle Fusion Middleware

Compared 5% of the time

More Oracle Fusion Middleware Competitors

Product Reports

Buyer's Guide

IBM Cognos

November 2024

Download IBM Cognos product report

Buyer's Guide

Microsoft Power BI

November 2024

Download Microsoft Power BI product report

Buyer's Guide

Oracle Fusion Middleware

November 2024

Download Oracle Fusion Middleware product report

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

No data available

Learn More

IBM

Microsoft

Oracle

Overview

IBM Cognos Business Intelligence provides a wide range of tools to help you analyze your organization's data. IBM Cognos BI allows businesses to monitor events and metrics, create and view business reports, and analyze data to help them make effective business decisions.

IBM Cognos applies techniques to describe, summarize, and compare data, and draw conclusions. This allows users to see trends and discover anomalies or variances that may not be evident by simply reading data. Data sources that contain information from different areas of a business can be stored in separate packages. Users can see only information that they have been granted access to, based on their group or role.

IBM Cognos BI consolidates the following business intelligence functions into a single web-based solution:

IBM Cognos Insight: Create personal and managed workspaces for data analysis. Using these interactive workspaces, you can share insight results with managers. Cognos Insight supports write-back, and you can also use these workspaces to capture and integrate management goals, commitments, and forecasts.
IBM Cognos Workspace: With IBM Cognos Workspace, you can create rich, interactive workspaces using IBM Cognos content as well as data from external sources. You can view and open your favorite workspaces and reports, edit content in your workspaces, and share your workspaces via email.
IBM Cognos Analytics: IBM Cognos Analytics utilizes built-in AI and intuitive searches which helps users to quickly create the visualizations and a wide range of reports. Cognos Analytics provides cognitive and managed self-service, enabling you to gain insights from controlled and trusted data.
IBM Cognos Report Studio and IBM Cognos Query Studio: Easily create structured and query reports. IBM Cognos allows users to create application and report templates. In addition, report authors can reuse report objects to apply filters, fields, and styles to reports. Users can set the language of the user interface and report content according to the user's native language.
IBM Cognos Event Studio: Receive notifications of events that occur within your organization in real time. Event Studio enables the creation of agents that detect the occurrence of business events, failures, or anomalies, based on the change of specific events or data conditions. Notification can be sent via email, publication in the portal, or by triggering reports.
IBM Cognos Connection: This is the Web portal for IBM Cognos BI and is the central area for accessing all the IBM Cognos functions. In the web portal, users can schedule and distribute reports, create tasks, administer the server and the access permissions, and more.

Reviews from Real Users

IBM Cognos stands out among its competitors for a number of reasons. Two major ones are its powerful analysis tool and its reporting capabilities.

Prasad B., a senior software engineer at a financial services firm, notes, “The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report. We can receive automated reports as well. They are easy to schedule on a weekly or monthly basis. It is very fast. I mean in means of report output, it's very fast compared to the actual clients involved.”

Microsoft Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

Oracle Fusion Middleware is the digital business platform for the enterprise and the cloud. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures.

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

Police Department of Izmir City

Buyer's Guide

BI (Business Intelligence) Tools

November 2024

Download Free Report

Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: November 2024.

DOWNLOAD NOW

816,192 professionals have used our research since 2012.

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.