Microsoft Power BI vs Oracle Essbase comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

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

Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools.
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: March 2024).
763,955 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Power BI is more powerful than other tools because it is new for us. Each new version has more capabilities, and we're expecting AI and ML features in the next version.""The fact that you can visualize items is great.""MS SQL & SQL Server Analysis Services.""The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see.""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.""In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected.""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.""SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."

More Microsoft Power BI Pros →

"The solution is stable and reliable.""It helps us fetch specific data sets per users' requirements.""The solution is scalable.""The solution can handle a large volume of data.""Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data.""I have found the most valuable aspect is the user-friendly environment and current features.""It is highly efficient and easily scalable, particularly for handling large databases.""Essbase is extremely stable and low-maintenance."

More Oracle Essbase Pros →

Cons
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features.""Microsoft BI’s integration and visualization could be improved.""There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented.""In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility.""It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved.""A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution.""I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. This can be a significant drawback for clients who desire more flexibility.""Power BI shows reports on actual data, not metadata."

More Microsoft Power BI Cons →

"I would like to see an integration with application performance management and a version control management tool.""The ability to drive external reporting out for development could be improved.""The initial setup is pretty complex.""It's an expensive product to use.""Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good.""They should improve the solution's performance.""There is room for improvement in terms of cost-effectiveness.""The initial setup could be simplified."

More Oracle Essbase Cons →

Pricing and Cost Advice
  • "There is room for at least 45% discount as compared to the initial price."
  • "MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
  • "All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
  • "I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
  • "Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
  • "Make it low in cost. It is a no-brainer!"
  • "Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
  • "Paid for itself in the first month."
  • More Microsoft Power BI Pricing and Cost Advice →

  • "Essbase is competitively priced."
  • "I believe the licensing is on a monthly base."
  • "It is a costly solution."
  • "The solution is expensive."
  • More Oracle Essbase Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    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:It is a costly solution. This is because we require high-performance servers with substantial CPU and RAM capacities to handle our extensive datasets effectively.
    Top Answer:There is room for improvement in terms of cost-effectiveness.
    Top Answer:We are a telecommunications company operating in Iran, and we manage a vast amount of data related to our network infrastructure. We have hundreds of data points specifically pertaining to our network… more »
    Ranking
    Views
    35,424
    Comparisons
    29,814
    Reviews
    19
    Average Words per Review
    555
    Rating
    8.1
    Views
    192
    Comparisons
    132
    Reviews
    8
    Average Words per Review
    381
    Rating
    8.4
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Essbase
    Learn More
    Overview

    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 Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.

    Sample Customers
    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
    CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Financial Services Firm50%
    Retailer25%
    Comms Service Provider13%
    Computer Software Company13%
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Computer Software Company9%
    Manufacturing Company9%
    Retailer7%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise41%
    Large Enterprise45%
    REVIEWERS
    Small Business27%
    Large Enterprise73%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    Buyer's Guide
    BI (Business Intelligence) Tools
    March 2024
    Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 22 reviews while Oracle Essbase is ranked 10th in Database Development and Management with 8 reviews. Microsoft Power BI is rated 8.0, while Oracle Essbase is rated 8.4. The top reviewer of Microsoft Power BI writes "User friendly, easy to set up and great for analyzing data". On the other hand, the top reviewer of Oracle Essbase writes "Everybody uses it for financial purposes, but it can also be used for other analytic purposes, such as mathematical models, statistical models, and so on". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME and Domo, whereas Oracle Essbase is most compared with SAP BusinessObjects Business Intelligence Platform, SAP Analytics Cloud, Oracle Analytics Cloud, Oracle OBIEE and IBM Planning Analytics.

    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.