Alteryx vs SAS Enterprise Guide comparison

Cancel
You must select at least 2 products to compare!
Alteryx Logo
2,418 views|1,448 comparisons
SAS Logo
2,919 views|1,159 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Alteryx and SAS Enterprise Guide based on real PeerSpot user reviews.

Find out in this report how the two Data Preparation Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Alteryx vs. SAS Enterprise Guide Report (Updated: March 2024).
767,319 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The scheduling within the solution is excellent.""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 drag-and-drop functionality, the ready-to-use analytics module, and the ability to track my data pipelines visually are the solution's most valuable features.""The most valuable feature of Alteryx is its performance. It is a powerful solution.""It saves time on a lot projects. ​""The product's Macros probably are one of the most useful aspects.""The analytics are easy​.""Alteryx's connectivity is essential. We like the ability to connect the solution to multiple sources. It's easier than other data modeling and extraction solutions. It's built on a self-service concept, so it's easy for anyone to open the tool and directly import or export data from it."

More Alteryx Pros →

"It has improved tremendously moving from providing an easy menu-driven system to also providing an excellent platform for developing and running full production systems, with minimal coding, which enabled increasing popularity among many non-programmers.""The point and click makes it easy to transfer the knowledge to new employees.""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.""Enabled us to remove PC SAS, which reduced risk.""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.""Scheduling downtime of some programs has been eliminated.""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.""We do not bother any longer with some programs did not run, hence having to rerun them again."

More SAS Enterprise Guide Pros →

Cons
"Sometimes, there are performance constraints. Especially when a large file has to be ingested, the system slows down a bit. Its performance is the only thing that can be improved.""The interface could be improved.""A colleague of mind mentioned that the solution should have more options for the visualization of data.""They should work on its pricing.""The screen when you are looking into your workflows and your ETL processes needs to be improved. You cannot manage it very well.""There are a few imputation techniques which they really need to include.""Even when it already includes some AI models, this area could be improved.""Alteryx can improve the model management and deployment processing of large workloads."

More Alteryx Cons →

"I would like to see better Charting in this solution.""A log belongs to each program. I have experienced a situation where when I run just the exec files, it replaces the whole log and I wanted to see the earlier log, then this was not possible.""Recently, we realized that SAS Enterprise Guide is not so stable and gives us some outputs which are not suitable...Sometimes it's quite hard to report its stability issues.""They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything.""It would be very useful if EG could be enhanced to automatically file and clear the project log to ensure non-stop running of the project.""I would like to see integration with schedulers when run from hosting environments such as Citrix.""Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user friendly and easier to use. Tableau is very easy to use. It's just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau.""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."

More SAS Enterprise Guide Cons →

Pricing and Cost Advice
  • "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 seat is too expensive."
  • "It can be a bit pricey, especially after the first year."
  • "The pricing is $5000 per year per production license."
  • "We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees."
  • "There are some implementation services and internal effort costs at the beginning but there is nothing else."
  • "The price for Alteryx Designer is reasonable but the price for Alteryx Server for universal collaborations is too expensive."
  • More Alteryx Pricing and Cost Advice →

  • "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."
  • "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."
  • "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."
  • "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."
  • "The pricing and associated costs are substantial."
  • More SAS Enterprise Guide Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
    767,319 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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.
    Top Answer: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… more »
    Top Answer: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. -… more »
    Top Answer: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… more »
    Top Answer: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 current… more »
    Ranking
    1st
    Views
    2,418
    Comparisons
    1,448
    Reviews
    29
    Average Words per Review
    513
    Rating
    8.3
    2nd
    Views
    2,919
    Comparisons
    1,159
    Reviews
    7
    Average Words per Review
    452
    Rating
    7.4
    Comparisons
    Learn More
    Overview

    Alteryx can be used to speed up or automate your business processes and enables geospatial and predictive solutions. Its platform helps organizations answer business questions quickly and efficiently, and can be used as a major building block in a digital transformation or automation initiative. With Alteryx, you can build processes in a more efficient, repeatable, and less error-prone way. Unlike other tools, Alteryx is easy to use without an IT background. The platform is very robust and can be used in virtually any industry or functional area.

    With Alteryx You Can:

    • Prep, blend, and analyze data
    • Deliver faster, better business outcomes
    • Automate analytics and data science
    • Embed intelligent decisioning
    • Deploy and share analytics in hours

    Alteryx Features Include:

    Some of the most valuable Alteryx features include:

    Scalability, stability, flexibility, fast performance, no-code analytics, data processing, business logic wrapping, scheduling, ease of use, data blending from different platforms, geo-referencing, good customization capabilities, drag and drop functionality, intuitive user interface, connectors, machine learning, macros, simple GUI, integration with Python, good data transformation, good documentation, multiple database merging, and easy deployment.

    Alteryx Can Be Used For:

    • Combining and manipulating data within spreadsheets: Alteryx can be used in situations where complex data manipulation occurs. It can handle large data quickly, and the process is much simpler to see and understand.

    • Database access and supplementing SQL development: Alteryx has several sets of database connectors and functions, including many functions that your average database does not. Alteryx can work with data from multiple databases or areas within a database. It allows users to filter, sort, calculate, etc. as they would commonly do in SQL or an ETL tool.
    • API, cloud, and hybrid access: Alteryx can read and write data in databases, files, REST APIs, and a myriad of other locations (with the correct permissions). When a workflow is published, you can also call a workflow through a REST API to start it.

    • Data science: Alteryx provides pre-built models that are extremely useful for data scientists who may have limited programming skills and also gives you the ability to add R or Python code directly within a workflow.

    • Geospatial analysis: Alteryx gives users drag-and-drop tools to geocode, plot, and map locations, customers, competitors, or anything that has a location (employee, truck, pipeline, etc.).

    • Reports and dashboards: Alteryx provides built-in tools that enable the building of reports and dashboards.

    Alteryx Benefits

    Some of the benefits of using Alteryx include
    :

    • Saves time: Alteryx helps shorten the time required to start analyzing data and looking for insights, minimizing the tasks that do not add value to the business and maximizing the analysis phase.

    • Clear tool configurations: Alteryx provides simple and concise tool configurations that are quick and easy to set.

    • Excellent workflow compatibility.

    • Reduced development time: Alteryx has an extensive gallery of user-developed analytic applications that helps to reduce development time.

    • Fast data loading: Alteryx has tools that make it very effective when working with big data sets.

    • No-code, low-code analytic building blocks: You can prep, blend, and analyze data to enable highly configurable and repeatable workflows.

    • Machine learning: Alteryx allows you to quickly create properly trained algorithms that are ready to deploy.

    Reviews from Real Users

    "Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful." - Theresa M., Senior Capacity Planner at a financial services firm

    "Alteryx has made us more agile and increased the speed and effectiveness of decision making." - Richard F., Director, Digital Experience & Media at Qdoba Restaurant Corporation

    "The scheduling feature for the automation is excellent." - Data Analytics Engineer at a tech services company

    "The product is very stable and super fast, five-star. It's significantly more stable than its nearest competitor." - Director at a non-tech company

    “A complete solution with very good user experience and a nice user interface.” - Solutions Consultant at a tech services company

    "There are a lot of good customization capabilities." - Advance Analytics PO at a pharma/biotech company





    SAS Enterprise Guide is an intuitive statistical analysis solution that enables users of all backgrounds to engage in statistical analysis.

    Users can create and deploy customized tasks and dynamic content that best meet their needs. Interactive content can easily be shared on the cloud and the internet.

    Benefits of SAS Enterprise Guide

    Some of the benefits of using SAS Enterprise Guide include:

    • Provides users with robust, centralized, and role based system security. SAS Enterprise Guide enables users to protect their network from a wide variety of threats. A single system of security provides and authenticates system access credentials. Individuals are empowered to easily adjust their organization’s security credentials to meet their changing security needs.
    • Easily access and manipulate system data. SAS Enterprise Guide employs a user-friendly user interface that enables users to view and and use data without requiring them to have an extensive knowledge of coding. Business analysts can generate and disseminate reports without help. Information technology teams are freed up to handle more pressing issues. Datasets can also be embedded into the system so that users dont have to re-enter them into the system.

    Reviews from Real Users

    SAS Enterprise Guide is a statistical analysis tool that stands out among its competitors for a number of reasons. Two major ones are the solution’s intuitive nature and the suite of functionalities that it offers. SAS Enterprise Guide makes it easy for users who lack a background in statistical analysis to create workflows. The solution enables users to customize and configure queries without requiring them to have a background in coding. SAS Enterprise Guide has a wide variety of functionalities. It is highly flexible and gives users the ability to complete many different tasks.

    The head of analytics at a communications services provider writes, “I think that the ease of use is the most valuable feature. I know SQL. I even taught SQL. But new people who come to the tool without in-depth knowledge of SQL or people who do not have an analytics background can still use the tool. It is very easy for these new users to climb the learning curve using SAS Enterprise Guide because of the way it was created with ease-of-use in mind. It is well-oriented to the business user. In no time new users are able to create workflows. Obviously, it is best if they have some basic knowledge of how things work in doing analysis — like the concept of joins, data profiling, and maybe some other SQL-related concepts. But the key here is they do not need to know how it is coded or the exact commands. All the features are available within Enterprise Guide through a drag-and-drop interface so queries can be built without extensive knowledge of how that works behind the scenes. The ease-of-use makes the tool valuable even for someone who is near the beginner level.”

    Monica B., an SAS Application Architect at a computer software company, writes, “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 statistics course.”

    Sample Customers
    AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
    Canary Islands Statistics Institute
    Top Industries
    REVIEWERS
    Computer Software Company15%
    Manufacturing Company11%
    Financial Services Firm11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Manufacturing Company10%
    Computer Software Company9%
    Retailer6%
    REVIEWERS
    Financial Services Firm53%
    Healthcare Company16%
    Government11%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Financial Services Firm27%
    Government10%
    Healthcare Company9%
    Insurance Company8%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise15%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    REVIEWERS
    Small Business13%
    Midsize Enterprise17%
    Large Enterprise70%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise11%
    Large Enterprise76%
    Buyer's Guide
    Alteryx vs. SAS Enterprise Guide
    March 2024
    Find out what your peers are saying about Alteryx vs. SAS Enterprise Guide and other solutions. Updated: March 2024.
    767,319 professionals have used our research since 2012.

    Alteryx is ranked 1st in Data Preparation Tools with 74 reviews while SAS Enterprise Guide is ranked 2nd in Data Preparation Tools with 24 reviews. Alteryx is rated 8.4, while SAS Enterprise Guide is rated 8.2. The top reviewer of Alteryx writes "Feature-rich ETL that condenses a number of functions into one tool". On the other hand, the top reviewer of SAS Enterprise Guide writes "Easy to use, drag and drop interface, with good built-in help facilities". Alteryx is most compared with KNIME, Databricks, Dataiku Data Science Studio, RapidMiner and IBM SPSS Statistics, whereas SAS Enterprise Guide is most compared with Toad Data Point, Altair Monarch and Trifacta Wrangler Enterprise. 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.