Try our new research platform with insights from 80,000+ expert users

Microsoft Power BI vs Oracle Essbase comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
321
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
Oracle Essbase
Average Rating
8.4
Reviews Sentiment
5.5
Number of Reviews
14
Ranking in other categories
Database Development and Management (12th)
 

Mindshare comparison

Microsoft Power BI and Oracle Essbase aren’t in the same category and serve different purposes. Microsoft Power BI is designed for BI (Business Intelligence) Tools and holds a mindshare of 21.1%, down 22.0% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 1.0% mindshare, up 1.0% since last year.
BI (Business Intelligence) Tools
Database Development and Management
 

Featured Reviews

Shoury Priyanshu - PeerSpot reviewer
Facilitates seamless data aggregation with some outdated visual elements hindering user appeal
Real-time data integration is an area for improvement. Although I've worked on several solutions involving real-time integration, it's not very user-friendly and often lags, especially with over a million data rows. This makes Power BI difficult to manage as loading times can reach one or two minutes, which is problematic today. There are challenges with scalability, requiring multiple pages in dashboards to manage these issues. Visualization could be improved as it appears outdated. Users, especially newcomers, find it unappealing and not user-friendly.
Pratik Phapale - PeerSpot reviewer
Multidimensional cube structure enables complex data storage and Oracle consistently upgrades Essbase
It's definitely growing and has many great features, especially in the cloud. I haven't used the on-premises server as much. Multidimensional data processing: Essbase is a kind of backbone, or back end, for systems like Hyperion Planning and Hyperion Financial Management. It's a multidimensional cube where we can store and process details, generate reports, and do multiple data processing, which isn't possible in Oracle or other alternatives. So, I'm grateful for this experience. Continuous improvement: Recently, I faced a version upgrade from 11.1.2 to 11.4. Now I'm on 11.2.10. Essbase is continuously upgrading its features in different areas, like configuration, properties, and the cloud platform. It's great to have experience with this, as well as working with the fundamental parts of the VM sets.

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 a general-use visualization system. I can express the performance of our network through high-level key performance indicators."
"The solution is easy to use and flexible."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"The stability is good."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"Allows business users with a mission to solve their own problems, without an IT person."
"It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."
"We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way."
"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."
"It is highly efficient and easily scalable, particularly for handling large databases."
"Essbase is extremely stable and low-maintenance."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"Oracle Essbase is a web integration system that integrates with other data systems."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution can handle a large volume of data."
 

Cons

"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"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."
"Whenever you work on the same dashboard or on the same code, Microsoft Power BI doesn't have a good architecture that allows multiple people to work on the same project."
"The solution could be more customizable and you do not have too much freedom on the code."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."
"An area for improvement is data refresh functionality"
"It needs an AI which can choose the appropriate connection strings and provide options for connections."
"The ability to drive external reporting out for development could be improved."
"The reporting tool of Essbase needs improvement."
"It's an expensive product to use."
"The initial setup is pretty complex."
"The main concern is that Oracle is ending on-premises server support, so it would be better if there was a cloud platform available for Oracle Essbase."
"I would like to see an integration with application performance management and a version control management tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"There is room for improvement in terms of cost-effectiveness."
 

Pricing and Cost Advice

"Microsoft Power BI has reasonable pricing."
"Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level. They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free."
"Pricing, that's where Microsoft beats Tableau. It is priced much cheaper."
"In general, Microsoft BI's price is lower compared to Alteryx."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"I have not had a customer suggest the solution is too expensive. There are licenses to use the solution."
"The solution is expensive."
"It is a costly solution."
"Essbase is competitively priced."
"I believe the licensing is on a monthly base."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Educational Organization
30%
Financial Services Firm
9%
Computer Software Company
7%
Government
6%
Financial Services Firm
23%
Computer Software Company
11%
Insurance Company
7%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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 would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
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 information, control users accessing information, the configuration of governance po...
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 fully customizable and very user-friendly. This solution is very stable. Oracle ...
What is your experience regarding pricing and costs for Oracle Essbase?
It's not that expensive, but also not cheap. I'm not sure because it's a private license.
What needs improvement with Oracle Essbase?
If I got the opportunity to work with Hyperion, which is the best product, I would definitely go with that. The main concern is that Oracle is ending on-premises server support, so it would be bett...
What is your primary use case for Oracle Essbase?
We provide complete ownership of this application to Walmart projects. In the UK system, we support and develop for the Asda account, known as Eltham. We provide installation and support to over 50...
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
Essbase
 

Overview

 

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.
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: June 2025.
856,873 professionals have used our research since 2012.