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.
"The interface is very easy to use."
"Microsoft BI allows us to connect to any database or any dataset."
"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."
"Technical support is quite responsive."
"The stability is great and continues to get better and better."
"I have found the most valuable feature of this solution is the Natural Language tool."
"It's pretty easy to set up the product."
"The most valuable feature of this solution is real-time report tracking."
"I like the architecture of this solution. RPV is a powerful feature in Oracle OBIEE. It lets us design as per the needs of the organization. I can have multiple presentation folders and presentation layers. I can have customization in a single node in VMware, which is a very good feature of Oracle OBIEE. It helps customers in designing as per their requirements."
"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."
"Inter Process Communication."
"They were reasonable in terms of price."
"The “Business Model & Mapping” layer in the Administration Tool, because the maintenance and evolution processes are greatly facilitated."
"Easy to create ad hoc reporting for different solutions."
"The dashboard and analysis are the most valuable features of this solution."
"It is a stable and scalable solution."
"These licenses are in US dollars. With a long-term license, the client is unaffected when the exchange rate goes up. However, if the exchange rate goes down, you don't get refunded from the excess money you've paid. I guess that is a risk you take in business."
"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions."
"I would like to see integration with Excel."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"From an improvement perspective, I think if the Power BI developers of that platform would really focus on being more detailed and specific on the error messages, it would help a lot of developers troubleshoot and maintain the report ECT or the dashboard ECT."
"Its functionality is lacking."
"BI Server"
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"The development effort takes longer than other BI tools currently on the market."
"Warehouse and business intelligence are two different things, but OBIEE also has some warehouse features in it. I would like to see some of those capabilities improved."
"This solution is weak in the data science perspective. I have past data science experience. And, I find that there is a lot of room for improvement in terms of incorporating more advanced statistical modeling into the product."
"One significant improvement is the need for simplification. The set up could be more intuitive. An enterprise setup with HA and DR are pretty complex and to get a robust solution one has to play around with Real Application Cluster data sources and FAN notifications as well as WebLogic clustering and external load balancers. SSO also is not that simple to set up especially if you want all your Oracle systems to use the same SSO solution, i.e., no cheating with direct LDAP connectivity."
"There's a lot of redundancy, especially in relation to creating the code."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while Oracle OBIEE is ranked 3rd in Reporting 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 MicroStrategy, whereas Oracle OBIEE is most compared with SAP BusinessObjects Business Intelligence Platform, IBM Cognos, Tableau, Oracle Analytics Cloud and Microsoft SQL Server Reporting Services. See our Microsoft Power BI vs. Oracle OBIEE report.
See our list of best Reporting vendors and best BI (Business Intelligence) Tools vendors.
We monitor all Reporting 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.