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
82
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 analytics are easy​."
"Alteryx effectively visualizes the flow of data and what happens at each stage. I also like that it's a no-code solution. I also like that you can troubleshoot certain parts of the workflow by putting them in a sandbox."
"The most valuable feature for me is integration."
"The design portion of this tool is easy to use without code, which his something that something we can appreciate."
"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."
"Alteryx is user-friendly and allows easy creation of workflows compared to Informatica PowerCenter."
"Alteryx makes it easy for the end customer to see clean data in a structured form."
"The ease-of-use allows non-technical business users to directly create their own solutions without the use of additional development resources."
"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."
"The solution is scalable."
"I have found the most valuable aspect is the user-friendly environment and current features."
"It helps us fetch specific data sets per users' requirements."
"It is highly efficient and easily scalable, particularly for handling large databases."
"The solution can handle a large volume of data."
"The solution is stable and reliable."
"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."
 

Cons

"Alteryx is just as complicated as coding, in my opinion."
"Alteryx needs to focus on the supply chain aspect since detecting financial figures and data anomalies is currently insufficient."
"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 workflow and pipeline need to improve."
"It would be great if Alteryx could take third party tools and incorporate them."
"Licensing negotiations were problematic, affecting our product usage."
"There's a big jump in terms of pricing between license tiers. I'm not sure I understand why the price jumps are so high."
"It would be great to create the final users' visualization within Alteryx."
"The initial setup could be simplified."
"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."
"It's an expensive product to use."
"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."
"They should improve the solution's performance."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"There is room for improvement in terms of cost-effectiveness."
 

Pricing and Cost Advice

"ROI is huge. There are some secondary benefits, like analysts getting their post 5 PM time back or the ability to shorten all closing processes to a half or less."
"The price could be better."
"It is an expensive solution."
"My organization pays for it, and I do not look into the financial aspect of the licensing, but I know it is pretty expensive."
"While it offers extensive features, including predictive analytics, for those who mainly use it for data preparation and blending, the cost can be prohibitive."
"There are some implementation services and internal effort costs at the beginning but there is nothing else."
"Alteryx is an expensive solution."
"It can be a bit pricey, especially after the first year."
"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 Predictive Analytics solutions are best for your needs.
848,716 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Manufacturing Company
9%
Computer Software Company
9%
Healthcare Company
6%
Financial Services Firm
23%
Computer Software Company
12%
Manufacturing Company
8%
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.
848,716 professionals have used our research since 2012.