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

Alteryx vs SAS Enterprise Guide comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 10, 2024
 

Categories and Ranking

Alteryx
Ranking in Data Preparation Tools
1st
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
79
Ranking in other categories
Predictive Analytics (1st), Data Science Platforms (5th)
SAS Enterprise Guide
Ranking in Data Preparation Tools
2nd
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
24
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Data Preparation Tools category, the mindshare of Alteryx is 29.7%, down from 35.2% compared to the previous year. The mindshare of SAS Enterprise Guide is 23.4%, down from 26.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Preparation Tools
 

Featured Reviews

Vivek Vaibhav - PeerSpot reviewer
Has a good UI and drag-and-drop features which makes it easy to understand
There have been some issues with licensing, particularly with the increased prices. This has led some companies, including ours, to consider reducing the number of licenses or potentially discontinuing their use of Alteryx. Since most of our team members work with Alteryx, deploying workflows to clients who may not have licenses became a hurdle. Every user needed a license to run the workflows, which could pose difficulties, especially for clients who only needed occasional access for small data analyses. Unlike other software like Microsoft Power BI, which offers free trials or user licenses for basic functionality, Alteryx doesn't provide such options, potentially limiting its accessibility for occasional users. It should improve scalability.
Marcelo Amado - PeerSpot reviewer
Has a valuable query builder feature and helps to create views and filters
Our primary use case for the solution is creating views and filters, and we deploy the solution on-premises The query builder feature is the most valuable. The stability of the solution can be improved.  We have been using the solution for approximately three years and currently use version…

Quotes from Members

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

Pros

"Alteryx is a low-code platform, and that's the biggest reason why we chose it."
"The product's initial setup phase is simple and straightforward."
"Alteryx is so advanced. It's just drag and drop."
"The most valuable feature of Alteryx is user-friendliness."
"Good data transformation."
"Technical support is very helpful."
"The data transformation feature is the most valuable. The ability to ingest data, visualize data, and transform that data is useful."
"It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
"Scheduling downtime of some programs has been eliminated."
"Similar to Microsoft Access, you can drag and drop. You can simply drag and drop objects onto the page and create various flows to establish your query within the project. You can extract those queries from the preview as needed."
"The data cleaning part is valuable. SAS is a very powerful tool to work with and connect with different sources. We have several tables, and we are looking up tables from one place to another place. We are connecting with different data sources. The data is not coming from one source. There are several sources of data, and we have information coming from different sources. There are some flat files, and there is some information from the data warehouse."
"An excellent tool for data manipulation and analysis."
"In Daman, I had used the data module, where you can join the table and take whatever data we require for our work. You join tables and create columns as you wish, then analyze data in various ways depending on what the problem is. We used it to detect fraud, abnormalities, anomalies, abnormal trends, etc. It's also good for exporting and importing tables."
"One of the features of the SAS Enterprise Guide is that it has a server, and we can access the server."
"Brought better performance by having people work on a powerful server instead of a workstation."
"Filter and sort query builder is valuable. The ability to do advanced SAS programming is also a useful feature because we can do anything by using Enterprise Guide. It has a lot of functionalities. We can build ETL processes. There are clients who are using SAS Enterprise Guide to build ETL processes. They have a SAS-based program that is scheduled to run at a certain frequency to produce some reports for the business. It is a very useful tool for ETL unit tests and functional tests. You can also do data science projects in SAS Enterprise Guide by using different statistics. During my MBA, we used SAS Enterprise Guide for our statistic course. To query the data, there are many solutions such as SQL, but these tools are only a part of the integration. They are only useful for querying the data and require knowledge of SQL, so they are not suitable for business users. SAS Enterprise Guide can be very easily used by business users to filter and sort the data and build queries. It is not necessary to have coding skills to use SAS Enterprise Guide. For this reason, it is attractive for businesses."
 

Cons

"It should have Linux support. It currently supports only Windows. It does not support any other platform. Its price should also be lower. Their US partner management program is actually unresponsive. One of the reasons why we don't have a formalized partnership plan with them is because their partner management team is atrociously unresponsive. This is something that they need to change."
"When configuring target tables, it is difficult to see the full text when deciding on load operations."
"The next feature release should include easier reporting."
"I'd like it to be easier to work with PDF."
"There are a few imputation techniques which they really need to include."
"More statistics tools: We can use to compare SPSS statistics with some automated advisory."
"The formula we currently use in Alteryx can be automated."
"They should work on its pricing."
"I see no reason for limiting the process to sequential all the time."
"I feel that the performance could be increased by leveraging multi-thread with any SAS BI platform, not just the high performance ones."
"It is expensive."
"I would like it to give more information rather than just a forever loop that forces you to shut down the system. Give you more error messages without stopping the entire project, or even the entire application. That it displays more error messages rather than terminating the application."
"More bi-directional integration with the SAS Studio suite of tools is needed."
"Machine learning is not utilized and that could enhance the product."
"The stability is not very reliable."
"I had difficulty with the diagrammatic flow chart style representation of projects. When projects got too large and complex (which was basically every project, except the most trivial). There just wasn't enough real estate to display the flow chart and dependencies without a lot of scrolling, even when a flow was down to minimum tasks. My recourse was making the flow less "atomic". E.g., rather than use the various subset, etc., tasks as program nodes to display the details, I would write chunks of code that did a few things and use them as SAS program nodes."
 

Pricing and Cost Advice

"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."
"Opt for the three year subscription. It is 20% less than the yearly one."
"A designer and scheduler for $13K/year in total is pretty much earning you the money back in time and in other resources."
"​Very transparent.​"
"The cost of Alteryx is approximately $2,900 annually."
"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."
"In order to have designers, and, if you want to collaborate, you have to buy a server. If the designer is $5,000, and if you want a server, you have to pay $80,000."
"Management liked it a lot because the license per seat was cheaper than a traditional SAS environment."
"It is very expensive. We have a basic license, and there are many features that are not available with the basic version."
"The pricing and associated costs are substantial."
"In general, SAS has high prices, which is a reason why some clients don't use SAS solutions. The licensing is on a yearly basis."
"I did look at the prices a few years ago, and I believe it was approximately $1,000 for a yearly subscription at that time."
"It is expensive. We get a different price based on our corporate rate. So, I'm not sure what the general cost is because we got a special rate for it."
report
Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
824,145 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
24%
Healthcare Company
11%
Government
9%
Computer Software Company
9%
 

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 do you like most about SAS Enterprise Guide?
It streamlines our workflow involving multiple steps, from data extraction to modeling, and it is aimed at improving various aspects of banking operations, including customer retention and risk man...
What needs improvement with SAS Enterprise Guide?
I find it challenging when I need to use certain functions and predictive modeling techniques in SAS. The procedures and data steps for database analysis take longer, and I've noticed that the curr...
 

Comparisons

 

Learn More

Video not available
 

Overview

 

Sample Customers

AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
Canary Islands Statistics Institute
Find out what your peers are saying about Alteryx vs. SAS Enterprise Guide and other solutions. Updated: December 2024.
824,145 professionals have used our research since 2012.