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

Alteryx 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

Alteryx
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
81
Ranking in other categories
Predictive Analytics (1st), Data Science Platforms (5th), Data Preparation Tools (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

Alteryx and Oracle Essbase aren’t in the same category and serve different purposes. Alteryx is designed for Predictive Analytics and holds a mindshare of 21.4%, down 26.0% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 1.0% mindshare, up 0.8% since last year.
Predictive Analytics
Database Development and Management
 

Featured Reviews

Theresa McLaughlin - PeerSpot reviewer
Quick development enables seamless data processing despite occasional support issues
There were times when the product would fail during development without an apparent reason. The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system. Licensing negotiations were problematic, affecting our product usage. For instance, our licenses were temporarily lost during negotiations when an agreement couldn't be reached.
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 solution offers excellent predicting power. The accuracy and confidence have been great."
"The drag-and-drop features are useful for data scientists who do not like to code because it is already in the system."
"I believe that the ability to leverage the gallery for scalability, as well as the general data blending functionality, is most beneficial to our core-based users."
"Alteryx has a good UI. We use it frequently in our projects. The tool comes with drag-and-drop features and is easy to understand for business needs. One situation where Alteryx's advanced analytics capabilities were particularly beneficial for us was during a forecasting project. Unlike Python, which requires coding, Alteryx simplifies the process significantly. With Alteryx, users can adjust parameters within the user interface without writing any code."
"The filtering is fast, and it provides a search tool that is great."
"Good data transformation."
"I like the solution's velocity, the speed with which it processes data, and its ease of use."
"It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"The solution is scalable."
"Essbase is extremely stable and low-maintenance."
"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."
"It is very fast compared to other normal databases, like SQL and MySQL."
"It helps us fetch specific data sets per users' requirements."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is stable and reliable."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
 

Cons

"It would be beneficial if Alteryx could lower its price or introduce a loyalty program for individual consultants and freelancers like me."
"Licensing negotiations were problematic, affecting our product usage."
"The data integration component could most likely be improved to increase enterprise scalability."
"It would be nice if they can provide Alteryx with more options for In-DB connectivity. That functionality is there, but it doesn't include all software we are connecting."
"More statistics tools: We can use to compare SPSS statistics with some automated advisory."
"The solution is improving continuously. They have, for example, just added automatic insights. If they continue to improve on their overall service offering, that would be ideal."
"There are a few hiccups with specific data sets and languages or formats that the data comes in. That may be a minor problem, but we can work through it. We had some issues looking at XML format in added data, but it wasn't significant."
"There is currently no cloud solution and this would be valuable for many clients."
"It's an expensive product to use."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"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."
"The initial setup is pretty complex."
"There is room for improvement in terms of cost-effectiveness."
"The initial setup could be simplified."
"The ability to drive external reporting out for development could be improved."
 

Pricing and Cost Advice

"If one is a high price, and ten is a low price, I rate the tool's price as a one. The tool is expensive."
"It can be a bit pricey, especially after the first year."
"I rate the tool's pricing a two out of ten."
"I don't know much about the licensing, but there are some additional costs for certain features."
"Alteryx is generally more suited for medium—to large companies due to its potentially high licensing costs."
"A designer and scheduler for $13K/year in total is pretty much earning you the money back in time and in other resources."
"Alteryx isn't extortionately expensive, but it's not cheap either."
"It's very expensive. I'd rate it a four out of ten in terms of the price. It's great for big companies but not for small companies."
"It is a costly solution."
"Essbase is competitively priced."
"The solution is expensive."
"I believe the licensing is on a monthly base."
report
Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
845,564 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Manufacturing Company
10%
Computer Software Company
9%
Healthcare Company
6%
Financial Services Firm
23%
Computer Software Company
12%
Manufacturing Company
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
One of the differences is that with Alteryx you can use it as an ETL and analytics tool. Please connect with me directly if you want to know more.
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
Alteryx is an extremely easy and flexible data tool, flexible in terms of drag and drop toolset and also has python, R integrations if your team requires this. It can handle over 2 billion rows of...
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
I am not familiar with IBM SPSS Modeler, therefore, I cannot compare these two products. Regarding Alteryx I can say the following: - An excellent desktop tool for Data Prep and analytics. - Featu...
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...
 

Comparisons

 

Also Known As

No data available
Essbase
 

Overview

 

Sample Customers

AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
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 Alteryx, SAP, Altair and others in Predictive Analytics. Updated: March 2025.
845,564 professionals have used our research since 2012.