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

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 23.1%, down 26.2% 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.
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 most valuable feature of Alteryx is its stand-alone version that we do not have to download dependencies for loads. Additionally, the scan is useful for beginners."
"You get more support with Alteryx, and it's good for non-sophisticated users who can benefit from the support included in the price."
"It offered quick development, with the ability to process large datasets."
"Alteryx makes it easy for the end customer to see clean data in a structured form."
"Alteryx is a simple and easy-to-use solution."
"It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"It allows for manipulation and automation, which has greatly reduced the amount of time required per project."
"The solution has been stable."
"The solution is stable and reliable."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"It helps us fetch specific data sets per users' requirements."
"Essbase is extremely stable and low-maintenance."
"Oracle Essbase is a web integration system that integrates with other data systems."
"It is very fast compared to other normal databases, like SQL and MySQL."
"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."
 

Cons

"The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections."
"Mastering Alteryx, a comprehensive solution, takes time. However, once you have gained proficiency with its layout and how to drag, drop, and connect components, it becomes remarkably easy, yet still thorough."
"The GUI interface functions but it could stand to be updated to a more modern look and feel."
"There could be a bit of improvement related to performance. Sometimes it demands a lot of resources for running it, like memory and search."
"All of the reports are migrated or exported in an Excel file, and most of the time, a business intelligence tool is required. They could have better reporting. The aesthetic could be improved."
"Alteryx can improve in data science. They have to have more features and components in the data science aspect because they claim to be a data science tool. However, in order to be more competitive, they have to improve on their data science propositions. Thre are other solutions on the market, such as other players in the market, Data2Go or DataIQ, and Alteryx needs to catch up."
"The principal problem is the pricing. They're expensive products."
"Alteryx's predictive data models are pretty average and can be improved."
"The initial setup is pretty complex."
"The ability to drive external reporting out for development could be improved."
"I would like to see an integration with application performance management and a version control management tool."
"There is room for improvement in terms of cost-effectiveness."
"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."
"The initial setup could be simplified."
"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."
 

Pricing and Cost Advice

"I don't know much about the licensing, but there are some additional costs for certain features."
"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."
"The solution has a more costly license than other tools in the market."
"The price for Alteryx Designer is reasonable but the price for Alteryx Server for universal collaborations is too expensive."
"Alteryx is generally more suited for medium—to large companies due to its potentially high licensing costs."
"I rate the tool's pricing a two out of ten."
"We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees."
"The designer license costs 5000 euros. The server edition is 1000 euros."
"It is a costly solution."
"The solution is expensive."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
report
Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
838,737 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
11%
Manufacturing Company
9%
Insurance Company
6%
 

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, RapidMiner and others in Predictive Analytics. Updated: February 2025.
838,737 professionals have used our research since 2012.