Coming October 25: PeerSpot Awards will be announced! Learn more

Microsoft BI vs Oracle OBIEE comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
46,105 views|36,772 comparisons
Oracle Logo
17,029 views|11,619 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on April 6, 2022

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.

  • Ease of Deployment: Most Microsoft BI users say the initial setup is straightforward. Some Oracle OBIEE users say the initial setup is straightforward, while others say it is complex.
  • Features: Reviewers of both products are happy with their reporting tools. Microsoft BI users say it is stable and scalable, user-friendly, and has good integration options, but that its performance slows down when handling large amounts of data. Oracle OBIEE users say it is flexible, secure, and has good forecasting capabilities. Several OBIEE users note, however, that its performance and scalability could improve.
  • Pricing: Some Microsoft BI reviewers feel that the price is fair while others feel it is too high. Most Oracle OBIEE reviewers say it is an expensive product.
  • ROI: Reviewers of both products report seeing an ROI.
  • Service and Support: Microsoft BI reviewers are very satisfied with the level of support they receive. Most Oracle OBIEE reviewers say the support is good but that sometimes there is a slow response time.

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.

To learn more, read our detailed Microsoft BI vs. Oracle OBIEE report (Updated: September 2022).
633,952 professionals have used our research since 2012.
Q&A Highlights
Question: How does Oracle OBIEE compare with Microsoft BI?
Answer: 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.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology.""Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.""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.""It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable.""The amount of customization that you can do is good, and it's relatively straightforward to do.""The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question.""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 most valuable feature is integration with Python."

More Microsoft BI Pros →

"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 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 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 solution is easy to use and very flexible.""I like the scheduling feature. It has an inbuilt scheduler which is very good, and it allows us to create agents, and those agents can be scheduled. It's quite flexible in that respect and goes into our IT infrastructure. The outputs are sent encrypted to various endpoints. Some are internal, and some are our clients, and it's encrypted at a high level. I do find Oracle OBIEE flexible. If there is stuff that's not in your model or schema, it's very flexible to create SQL scripts and create the data you want. It's quite nice to create a dashboard in OBIEE, and that's pretty straightforward in the way you drag and drop everything. You can create sections, and you can add elements to your page. That bit of the interface is relatively straightforward.""In terms of features, everything is good. It is also stable and scalable.""The most valuable feature of Oracle OBIEE is the security of the solution.""The security is good. For example, we can implement column-level security."

More Oracle OBIEE Pros →

Cons
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users.""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.""There are some connector-related issues in their MSBA solution.""I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it.""They can improve it in terms of rule-based security. Currently, it has very limited rules.""Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution.""The upgrade process could be improved.""The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."

More Microsoft BI Cons →

"There are a lot of aspects of Oracle OBIEE that are exceptionally complicated, make things unnecessarily difficult for everyone who uses it. In terms of the integrations, Oracle needs to improve a little more, but I believe that they have tried to capture all those issues. The issues we are facing in the Oracle OBIEE 12C versions, in the Oracle Analytical Server Center or Analytical Cloud versions, Oracle has managed to overcome the challenges.""Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement.""The performance could be better.""I would like to see Machine Learning included in this solution.""It was a little bit tedious to install a new release.""There's a lot of redundancy, especially in relation to creating the code.""It would be better if it had a wide range of visualization options. For example, Microsoft Power BI has an extensive range of visualization options, but it's not available in OBIEE. There are also some conflicts because it's complicated, but the cloud application is easier. They added some features for ETL with the on-premises application, but we need a different or a separate application for ETL in the cloud. In the next release, I would like to have more AI features.""Managing the OB applications requires a high level of experience, and makes the solution quite heavy."

More Oracle OBIEE Cons →

Pricing and Cost Advice
  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • "Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."
  • More Microsoft BI Pricing and Cost Advice →

  • "This was not an expensive product for us, although the price varies depending on conditions for each company."
  • "The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
  • "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."
  • "It's comparable to the current technology we're using, Qlik Sense."
  • "Simplifying the data integration process would save our clients considerable costs."
  • "Pricing is an area that could be improved."
  • "This is a very costly product."
  • "Its licensing is yearly."
  • More Oracle OBIEE Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    633,952 professionals have used our research since 2012.
    Answers from the Community
    Netanya Carmi
    Mridul Rao - PeerSpot reviewerMridul Rao
    Real User

    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.

    Questions from the Community
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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. OBIEE… more »
    Top Answer:The most valuable feature of Oracle OBIEE is the security of the solution.
    Top Answer:The licensing cost is based on the number of users using it.
    Ranking
    Views
    46,105
    Comparisons
    36,772
    Reviews
    182
    Average Words per Review
    538
    Rating
    8.1
    Views
    17,029
    Comparisons
    11,619
    Reviews
    33
    Average Words per Review
    469
    Rating
    7.8
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
    Learn More
    Overview

    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

    Oracle OBIEE (Oracle Business Information Enterprise Edition) is a business intelligence (BI) tool developed by Oracle. OBIEE will gather, store and analyze an organization's network data and compile the information to create reports, dashboard graphs, and performance analysis. OBIEE’s unique platform allows clients to discover new awareness and improve the speed of completing important business decisions by providing robust visual tools and intuitive realization coupled with the latest unmatched enterprise analytics available. OBIEE helps IT enterprise organizations to experience an intelligent view of all enterprise data from across all sources and empowers trusted users with increased levels of reliable, dependable access, interaction, and the ability to utilize the data to increase the overall effectiveness and productivity of the organization.

    OBIEE provides unique immediate mobile access, intuitive dashboards, robust reporting, real-time alerts, metadata search, procedure management, direct access to Big Data resources, enlightened in-memory computing, and seamless systems management processes. These features seamlessly combine to make Oracle OBIEE a complete, top-of-the-line broad solution that is cost-effective, minimizes TCO, and provides a competitive, quick ROI for the entire organization.

    Oracle OBIEE Top Features 

    • Complete comprehension: Oracle OBIEE offers a full range of BI strategies, including intuitive smart dashboards, dynamic alerts and detection, efficient workflows, enterprise reporting, MS Office integration, real-time predictive analysis, and more. OBIEE also includes many next-generation options, including mission critical scalability and performance, diverse data access and integration, and a modern, robust, service-oriented architecture.
    • Hot-pluggable: OBIEE will take advantage of existing IT relationships, both Oracle and non-Oracle databases, solutions, and applications. Organizations that partner with OBIEE have access to an entire library of analytic tools that are immediately deployable and provide an improved TCO and a super-fast ROI. Additionally, in an outstanding collaboration with Hyperion, OBIEE incorporates BI tools that integrate well with the current suite to supply the grandest selection of BI tools available on the market today.
    • Extensive: OBIEE is very user-friendly and extremely intuitive, and the 100% Web UI brings robust and dynamic BI from diverse sources to any audience, distributing awareness when and where users require it to manage activities, decisions, and processes. 

    Reviews from Real Users

    Sandeep V., Process System Engineer at a comms service provider, tells us, “This solution is very easy for people who are building ad-hoc things. It's an enterprise solution so it can be deployed for a lot of users. There are some great new features that come with the 12c like data visualization, desktop BI Publisher, automation, and interactive dashboards. The product has good features. “ 

    A user who is a CEO at a consultancy relates, “The most valuable feature is the visualization. The data warehousing, data storage, and data wrangling are all features that are in there, and it's one of the better products out there. A good thing is that for large datasets, it's very stable, especially when you have an Oracle database.”

    A user who is a Principal Business Intelligence Architect at a computer software company suggests, "It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market."



    Offer
    Learn more about Microsoft BI
    Learn more about Oracle OBIEE
    Sample Customers
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
    Top Industries
    REVIEWERS
    Financial Services Firm14%
    Manufacturing Company14%
    Computer Software Company11%
    Government10%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Comms Service Provider13%
    Financial Services Firm10%
    Government7%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company11%
    Comms Service Provider9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Computer Software Company23%
    Financial Services Firm13%
    Comms Service Provider10%
    Government10%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business21%
    Midsize Enterprise20%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise73%
    Buyer's Guide
    Microsoft BI vs. Oracle OBIEE
    September 2022
    Find out what your peers are saying about Microsoft BI vs. Oracle OBIEE and other solutions. Updated: September 2022.
    633,952 professionals have used our research since 2012.

    Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 187 reviews while Oracle OBIEE is ranked 6th in BI (Business Intelligence) Tools with 33 reviews. Microsoft BI is rated 8.0, while Oracle OBIEE is rated 7.8. The top reviewer of Microsoft 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 "Extremely flexible, easy to set up and great for reporting". Microsoft BI is most compared with Amazon QuickSight, Tableau, MicroStrategy, SAP BusinessObjects Business Intelligence Platform and IBM Cognos, whereas Oracle OBIEE is most compared with Oracle Analytics Cloud, SAP BusinessObjects Business Intelligence Platform, Tableau, IBM Cognos and Qlik Sense. See our Microsoft BI vs. Oracle OBIEE report.

    See our list of best BI (Business Intelligence) Tools vendors and best Reporting Tools 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.