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.
"Because this solution is very easy, and very visual, you can have results in minutes."
"Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"It has provided customer purchase patterns and great visualization."
"We have found the product to be scalable."
"It is low-cost and easy to deploy. It is fully-featured."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"It ingegrates nicely with Office 365."
"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."
"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."
"I think having the conformed structures makes it a lot easier for end users and pulling reports together."
"They were reasonable in terms of price."
"It provides excellent stability."
"It mostly supports enterprise level data. We have millions of records on a daily basis."
"The most valuable feature is the visualization."
"The solution offers a wide range of software tools to meet various needs, such as those concerning reports, developer solutions like APEX and the integration of data."
"I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."
"The accounting data needs improvement."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"I feel the modeling page should be simplified."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
"Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."
"There could be better integration with other solutions, such as Microsoft Office."
"For a beginner, this is a product that is difficult to learn. You cannot learn it quickly."
"If the data is large, the dashboard takes a really long time. So, based on the database, if you have around a million cost contacts, the load time is very low, and the dashboard fails."
"There should be more integration in the solution. For example, there should be one solution with multiple functionalities so that other solutions are not needed. Having one solution with all the needed functionality would be helpful."
"While it is a user-friendly, data-driven tool, the data modeling should be easier to use."
"Its overall organization as an analytical tool, the layout of OBIEE, is not very good."
"The main problem we face is migrating all of the reports into the solution."
"There's a lot of redundancy, especially in relation to creating the code."
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 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 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.