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

Microsoft Power BI vs Oracle HFM 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.0
Number of Reviews
327
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
Oracle HFM
Average Rating
8.0
Reviews Sentiment
6.3
Number of Reviews
17
Ranking in other categories
Business Performance Management (6th)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. Microsoft Power BI is designed for BI (Business Intelligence) Tools and holds a mindshare of 8.9%, down 21.4% compared to last year.
Oracle HFM, on the other hand, focuses on Business Performance Management, holds 4.1% mindshare, down 9.5% since last year.
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Microsoft Power BI8.9%
Tableau Enterprise6.2%
Amazon QuickSight3.7%
Other81.2%
BI (Business Intelligence) Tools
Business Performance Management Market Share Distribution
ProductMarket Share (%)
Oracle HFM4.1%
Anaplan6.9%
CCH Tagetik5.1%
Other83.9%
Business Performance Management
 

Featured Reviews

LV
HR Manager at PPB
Use advanced data preparation features in analytics projects
Microsoft Power BI can be quite slow when working with data sources that aren't from a data warehouse or a more robust source or data artifact. When working with exports, which we do frequently, the load takes considerable time. This occurs with any BI tool, and it's related to our working methods due to limitations within the area. In HR, we typically use exports because we have numerous data sources. Ideally, Microsoft Power BI would have a no-code or low-code solution for the data sources to be built by the actual developers or development team. This would eliminate the need to work directly with exports. We would have a middle ground to create a warehouse without all the infrastructure, as building a warehouse within an organization can require substantial resources, both in time and personnel.
Segun Oladele - PeerSpot reviewer
Associate Manager, Accounting at BIC
Has supported financial consolidation through accurate reporting and global currency conversion
Oracle HFM is excellent for consolidation and reconciliation. It helps me see the general overview of the business across several locations. The drill-through reporting enhances accuracy in financial analysis. Oracle HFM has a schedule that requires reporting, especially one that ties back to my general ledger. I have to report each line item that comprises that number. It helps me fact-check reported numbers with a schedule. For example, with payables, Oracle HFM allows me to have a list of numbers reported per supplier. This provides comfort that the numbers are not fictitious. Additionally, it has a feature that performs fact-checking from P&L to balance sheet. For instance, if depreciation is reported, it must align with what is in the profit or loss account. These features ensure integrity in the reported numbers and allow for quick error detection while serving as a reconciliation tool. The currency conversion feature provides a global view from entity currency to local currency perspective, enabling value checks in different currencies for the company as a whole. In Nigeria, I report in Naira, and I don't need to report in my parent currency. The entity can report in their currency into Oracle HFM, and the parent company converts to their currency. By inputting budget rates, I can convert to any reporting currency, particularly the parent company currency. This feature saves time, increases speed, and allows the parent company to value its subsidiaries quickly. Regarding data integration capabilities for ensuring data consistency and accuracy, it deserves a high rating. For example, with inventory, if there is an impairment, the reported amount in P&L should match the balance sheet's inventory impairment. This level of checking provides confidence in the accuracy of reported figures.

Quotes from Members

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

Pros

"Easy to use. End-users can make changes to the graphics."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"It allows individuals to do the analysis themselves​."
"Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"Ease of development and maintenance."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"The product is stable."
"It is a very user-friendly software."
"Financial consolidation and reporting tool with good built-in features such as currency exchange and elimination."
"Stability-wise, I rate the solution a ten out of ten."
"It is an expensive product but delivers what it promises, ensuring regulatory compliance, reducing risks associated with spreadsheets, and providing a better return on investment based on usage."
"Oracle HFM's drill-through reporting has enhanced my customers' financial analysis significantly, allowing users to drill down to the base level in each of the dimensions and even further using Smart View for very granular level of general ledger cost centers, making the whole process more effective for their targets and deadlines."
"You can bring in data from any source and from multiple sources, and you can consolidate that data in HFM."
"Oracle HFM is excellent for consolidation and reconciliation; it helps me see the general overview of the business across several locations."
"The most valuable features are around consolidations, eliminations, conversions."
 

Cons

"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 believe the price should be degressive, and we should have a lower, or better unit price if we have more users."
"It has come a long way in terms of how it was working two years ago, but there are some things that you still can't do with it. For example, permission management and user access management are still a bit limited. It is basically based on the idea that everybody from the organization can see everything or limit the type of data they can see. If I want you to see only one report and the other guy to see another report, I can't do it. There should be a better way to manage permissions and users. It should also support external users much better."
"Its price could be better. Its licensing cost is very high."
"I would like to see the product offer more graphics to impact different audiences."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"The initial setup is a little bit technical."
"Automation could be improved and performance enhanced."
"The intercompany reporting function in this tool needs improvement, particularly being able to run reports in batches, rather than one at a time."
"The complexity is okay. I don't see it as super complex. The solution could have more functionality to make it a little bit more flexible."
"In my first experience with Oracle HFM, navigating to input numbers was cumbersome."
"Improvements can be made by possibly different interfaces to modernize it, more automation in scripting, and better integration with third-party solutions and reporting capabilities."
"In my first experience with Oracle HFM, navigating to input numbers was cumbersome."
"It's a difficult process to try to edit, configure, or change the business rules that exist and work within HFM."
"Integration is an area where it lacks and can be improved."
"In terms of improvement, one challenge with Oracle HFM is the need for technical knowledge in writing SQL syntax for custom extensions."
 

Pricing and Cost Advice

"Both cost-wise and implementation-wise, this product is a good choice."
"All of the licenses are on an annual basis, but Microsoft will amortize it to an extent. If it's five years, they'll include the possible interest they might have the following year. Ideally, their licensing scheme is an annual license, but they make it easier for some of our clients to take a five-year license but package everything inside for them to buy the license for five years."
"The solution is less expensive than other PowerBI tools, which is why most people go with it, although it does cost more than MSBI tools."
"The pricing for the solution is relatively higher compared to other alternatives."
"I am satisfied with its price. Its price is very less as compared to Tableau and QlikView."
"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."
"I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage."
"The price of the solution can be expensive if you want to synchronize your data more."
"Oracle Hyperion Financial Management (HFM) uses the named user licensing model. There's different pricing depending on HFM and Essbase planning."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
881,733 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Senior Manager - BI Head with 5,001-10,000 employees
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
Financial Services Firm
12%
Government
9%
Manufacturing Company
9%
Computer Software Company
7%
Manufacturing Company
13%
Financial Services Firm
11%
Retailer
6%
Computer Software Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business135
Midsize Enterprise57
Large Enterprise165
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise2
Large Enterprise11
 

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 HFM?
It depends on the discount offered by Oracle. It is an expensive product but delivers what it promises, ensuring regulatory compliance, reducing risks associated with spreadsheets, and providing a ...
What needs improvement with Oracle HFM?
Oracle HFM could be improved or enhanced in handling metadata or the dimensionality. I currently handle updates in the dimension hierarchies and properties manually. There is a way for it to be cen...
What is your primary use case for Oracle HFM?
The usual use cases for Oracle HFM that I support are for financial institutions, crewing for ships, and an Australian airlines company. They use the application mainly for management reporting pur...
 

Also Known As

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

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
B&B Hotels, Goldwind, Drake & Scull
Find out what your peers are saying about Microsoft, Salesforce, Domo and others in BI (Business Intelligence) Tools. Updated: February 2026.
881,733 professionals have used our research since 2012.