"The support is very good."
"The connectors are a very good feature."
"There are a lot of good customization capabilities."
"Technical support is very helpful."
"The solution has excellent drag and drop functionality. There's no need for coding."
"All of the data science features in terms of unioning and joining data together are valuable."
"The design portion of this tool is easy to use without code, which his something that something we can appreciate."
"Alteryx has made us more agile and increased the speed and effectiveness of decision making."
"The solution is user-friendly, the resource for the query builder is very useful, and the ability to explore the data is a benefit."
"The Query Builder is very valuable."
"The product has a drag-and-drop feature that is excellent for business users and that makes it easy-to-use."
"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."
"We are able to work on the server, and I can copy a data set and share it with someone in my team. Similarly, if I want some data from them, I can get it. Being able to work on the server and being able to switch from one user to another is a good thing. It is reliable and powerful, and its community is very wide."
"Areas where SAS EG does a better job than regular SAS are in the realm of importing and exporting data. For instance, exporting a SAS data set in Unix to an Excel spreadsheet on a PC is a simple task compared to doing the same task with Base SAS."
"Alteryx is just as complicated as coding, in my opinion."
"There could be a bit of improvement related to performance. Sometimes it demands a lot of resources for running it, like memory and search."
"A colleague of mind mentioned that the solution should have more options for the visualization of data."
"We are hoping that the NLP features will also support Chinese characters."
"The interface could be improved."
"The principal problem is the pricing. They're expensive products."
"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."
"Lacks an open source edition which would be helpful."
"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."
"Machine learning is not utilized and that could enhance the product."
"For some of the advanced functions, you need to learn some SAS code to get what you want."
"Our data warehouse is built on the Netezza database. We have SAS BI, and we populate the Netezza database. When we have tables with, for example, a hundred million rows in Netezza, SAS Enterprise Guide doesn't work. It doesn't return any results. It works for around 30 to 40 million rows, but it is not working for anything more than that. This issue is only with the Netezza database. With Oracle, it is quite good. They can improve its performance with the Netezza database. There should be one unique tool that includes SAS Data Integration Studio and SAS Enterprise Guide for more integration capabilities. With SAS Enterprise Guide, it is not possible to create connections and libraries and build transformations that can be used for other projects. This tool should have all capabilities that SAS Enterprise Guide does not have. Such a tool would be perfect because it will be used by developers and business users at the same time. In addition to the integration capabilities, they should also provide more deployment capabilities. There should be an option to easily create SAS packages and export them from one environment to another. There could also be a possibility to connect with R and Python. Open-source tools are hot in the market nowadays, and it would be good to extend its capabilities."
"The product is missing a visualization component so we have to use a separate tool for visualization."
"There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL."
"They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything."
Alteryx is a self-service data analytics solution, that provides a platform that can prep, blend, and analyze all of your data, then deploy and share analytics in hours. It can automate time-consuming and manual data tasks while performing predictive, statistical, and spatial analytics in the same workflow. It uses a drag and drop tool with an intuitive user interface with no coding and programming required. Alteryx licenses are subscription-based and include all product updates and support to their customers.
SAS Enterprise Guide is a point-and-click, menu- and wizard-driven tool that empowers users to analyze data and publish results. It provides fast-track learning for quick data analysis, generates code for productivity and speeds your ability to deploy analyses and forecasts in real time.
Alteryx is ranked 1st in Data Preparation Tools with 28 reviews while SAS Enterprise Guide is ranked 2nd in Data Preparation Tools with 6 reviews. Alteryx is rated 8.2, while SAS Enterprise Guide is rated 7.6. The top reviewer of Alteryx writes "Efficient, with great automation capabilities but technical support is not as good as it once was". On the other hand, the top reviewer of SAS Enterprise Guide writes "Easy-to-use with a drag-and-drop querying feature, this fine tool still lags in visualization and machine learning". Alteryx is most compared with KNIME, Dataiku Data Science Studio, Databricks, RapidMiner and Microsoft BI, whereas SAS Enterprise Guide is most compared with Trifacta Wrangler Enterprise, Toad Data Point, SAS Data Loader For Hadoop and Paxata. See our Alteryx vs. SAS Enterprise Guide report.
See our list of best Data Preparation Tools vendors.
We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.