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
319
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 (10th)
 

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.4%, down 22.6% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 1.2% mindshare, up 0.7% since last year.
BI (Business Intelligence) Tools
Database Development and Management
 

Featured Reviews

James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.
RANOJOY PAUL - PeerSpot reviewer
Stores multidimensional data, good customer support and interface is very easy
It is very fast compared to other normal databases, like SQL and MySQL. It doesn't store data in tables in the back end. To load data into Essbase, we need to prepare it in a table format. When we find the data in the table, we need to verify it. This way, you can rate the data. But Essbase stores multidimensional data. We have dimensions, which means the data belongs to some company or some time period. For example, if you work for three years, your salary should be something. In this way, we prepare top-level members called dimensions. The dimension defines your position, the year, and the section you were working in the company. We get an intersection of all these dimensions for certain data, and fetching that data is very fast in Essbase compared to normal SQL. If you store this data in a normal SQL table, you need to prepare a row with your company name, employee name, employee ID, joining date, and everything, and then you need to push it into a SQL table. You can search it using your query, but here, that thing is different. Here, you can collect data using forms, reports, and we use a Microsoft tool, which is an add-in called Smart View. Using that, you would just take that data. Here, you need to just create an integration of all these dimensions, and then only you can find the data.

Quotes from Members

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

Pros

"The product is user-friendly."
"Microsoft BI's most valuable feature is flexibility."
"There is also a chart store where we can download charts, which is extremely useful."
"The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."
"The stability is great and continues to get better and better."
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources."
"The most valuable feature of Microsoft BI is its visualization and its ease of use."
"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."
"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."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"The solution is scalable."
"The solution can handle a large volume of data."
"Oracle Essbase is a web integration system that integrates with other data systems."
 

Cons

"I would like to see the product offer more graphics to impact different audiences."
"If you need data in real-time, it's not an ideal solution."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"The dynamic browsing tables could be better in Microsoft Power BI."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"We did have some issues building the Microsoft blog."
"The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
"They should improve the solution's performance."
"The reporting tool of Essbase needs improvement."
"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."
"There is room for improvement in terms of cost-effectiveness."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"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."
 

Pricing and Cost Advice

"The solution’s pricing is reasonable."
"No comment on pricing."
"We are end-users, and we don't take care of the prices and accounting. We get a product and pay the fee to our internal service provider, but its price should be reasonable. Otherwise, they wouldn't have bought it."
"Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
"The solution's pricing is medium."
"This product offers good value for the money."
"The pricing is reasonable."
"MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
"I believe the licensing is on a monthly base."
"The solution is expensive."
"Essbase is competitively priced."
"It is a costly solution."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
838,713 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
43%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
Financial Services Firm
23%
Computer Software Company
11%
Manufacturing Company
9%
Insurance Company
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: January 2025.
838,713 professionals have used our research since 2012.