Skip to main content
TrustRadius
Alteryx

Alteryx

Overview

What is Alteryx?

Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs. Alteryx Designer…

Read more
Recent Reviews

ETLing Alteryx.

10 out of 10
April 14, 2023
Incentivized
Our organization has data in several different systems. Alteryx does an excellent job of connecting our various systems, blending the …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Alteryx?

Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering…

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.alteryx.com/products/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

35 people also want pricing

Alternatives Pricing

What is Tableau Prep?

Tableau Prep enables users to get to the analysis phase faster by helping them quickly combine, shape, and clean their data. According to the vendor, a direct and visual experience helps provide users with a deeper understanding of their data, smart features make data preparation simple, and…

What is Alteryx Designer Cloud?

Trifacta is a "data wrangling" (or data preparation) platform particularly of use with Hadoop, developed by the company Trifacta headquartered in San Francisco, California. Alteryx announced their acquisition of Trifacta in January of 2022.

Return to navigation

Product Demos

Alteryx Analytics Automation Platform

www.alteryx.com
Return to navigation

Product Details

What is Alteryx?

Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs.

Alteryx Designer can be used to automate every analytics step — from data prep to data science. Access any data source or type, then blend via drag-and-drop interface.

Text mining is accelerated with optical character recognition and natural language processing. Visualize better with instantly generated data profiles. Enrich insights with third-party packages for data mapping, and geocoding. Connect Alteryx automated workflows with process intelligence systems or RPA bots. Publish insights to interactive dashboards, or send them directly to more than 70 enterprise applications.

Low-code and no-code process available.

Alteryx Screenshots

Screenshot of Alteryx APA - Automating asset inputsScreenshot of Alteryx APA - Automating outcomesScreenshot of Alteryx APA - Data enrichment and insightsScreenshot of Alteryx APA - Data quality and preparationScreenshot of Alteryx APA - Data science and decisions

Alteryx Video

The Alteryx Analytics Cloud Platform automates analytics at scale to enable intelligent decisions across the enterprise. The self-service, unified, enterprise-grade solution provides automated data preparation & analytics, approachable machine learning, and automated insights with data stories.

Alteryx Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows
Mobile ApplicationNo
Supported LanguagesEnglish, French, German, Brazilian Portuguese, Japanese

Frequently Asked Questions

RapidMiner and IBM SPSS Statistics are common alternatives for Alteryx.

Reviewers rate Support Rating highest, with a score of 9.5.

The most common users of Alteryx are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(329)

Attribute Ratings

Reviews

(1-25 of 115)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use it to aggregate large amounts of Excel file (templates) into a single lead sheet that can be analyzed and used in Tax Return software.
  • Brings semi-structured template data together
  • Allows for crawling up a hierarchy
  • East for an end user to get up to speed on.
  • Price per seat
  • Some tools are not very user friendly in my opinion.
Alteryx is fantastic for bringing together disparate bits of data from various sources files and formats. It doesn't do visualization very well even though there is some functionality built in.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Alteryx for tax automation. We streamline processes that have multiple inputs, consolidate data and automate the calculation of complex tax adjustments. Alteryx has taken processes that used to take days to months of time down to minutes. We can now save time and reduce hours of manual labor while decreasing the rate of manual errors that come with a manual process. Team members spend less time on manual tasks and can now focus on value-add activities related to the tax provision and compliance processes.
  • Alteryx reduces the rate of manual error by automating previously manual processes
  • Alteryx reduces the time it takes to complete a task by automating it on designer
  • A firm can benefit by using the server instead of purchasing tons of individual licenses so many can benefit from workflows created
  • The reporting tools are not as dynamic as an interface such a Power BI
  • Alteryx works well for applying logic across columns of data rather than one "cell" for example
Alteryx is a great tool for data manipulation and transformation. It consolidates multiple inputs well whether thats in one workflow or a more complex workflow that can consolidate hundreds of files. The time savings using Alteryx is irreplaceable and has given team members tens to hundreds of hours back to focus on more value-added work. Taking manual processes and automating them has benefitted both the firm and end user.
Score 9 out of 10
Vetted Review
Verified User
We use Alteryx to enable decision-makers to access information that transforms our internal operations. This primarily functions as a tool for accessing our data lake and manipulating the data in a low-code format that can then either be directly output into reports for users to access, or to be used with Tableau where we build out dashboards for users to pick and choose views they want to see.
  • Little-to-no experience in coding required to use the platform
  • Structures workflow in an "easy to digest" manner
  • Access to plenty of tools and macros to get any job done quickly
  • Incredibly active community to help when problems come up
  • Control containers
Empowering business-savvy employees to begin exploring their own data needs without a DS background is where Alteryx shines. I think for users who have more of a DS background, Alteryx may be a little big slower for them to accomplish the same work they could do with Python or R. It does make scheduling data runs/workflow sharing much easier though.
Score 10 out of 10
Vetted Review
Verified User
Our team uses Alteryx to pull in data from multiple sources (mostly excel and S3 buckets), then blend, prep, and apply formulas in a forecasting model. This model is used to give labor forecasts and recommendations. As an individual contributor I have grown to love Alteryx as it takes the place of using Python and Excel individually for prepping reports and blending data.
  • Data blending
  • Data prep
  • Report Building
  • Python integration
  • Data visuals
Anyone that is mostly reliant on SQL and Excel (and some of those that rely on Python/Pandas) for day to day tasks could benefit from using Alteryx. I used to be very reliant on pulling in data from SQL and other sources, then building out reports in excel - I now have it automated in Alteryx to where I just have to hit run.
Dylan Dowrick | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We use Alteryx for A LOT of solutions!
In total, Alteryx is the jack-of-all toolboxes for your jack-of-all workers that don't have the time to learn to code or learn fifteen different platforms. With their no-code/low-code options anyone can start automating.

I have implemented it to create (and automate) our month end reports for ALCO at the beginning of each month and reflecting back on the previous month-end/quarter-end. It can be used to create applications to provide a more seamless analysis search for a less-skilled user. I have used it to geocode and then reverse-geocode within the same workflow in order to get an accurate depiction of data within our branch regions. My favorite use case at the moment is not what it is really advertised for. My team and I are building an application to be accessed by the Accounting team to create entries/review entries/attach support for entries that will create the necessary file outputs to be batch uploaded the following day.
  • ETL: extracting from random platforms and cleaning data
  • Analysis: breaking down large data into smaller bite-size chunks in routine ways
  • Creating an interface for applications that lesser skilled users can still use
  • Customer Service is PHENOMENAL
  • Data visualization is not its best skill
  • Excited to see what the Cloud version brings to the table
  • Chaining apps within Gallery is a touch confusing
The best scenario for Alteryx to make the biggest impact is within small-to medium-sized institutions where there isn't a fully established coding/data team in place. While it will ultimately be helpful wherever it is implemented, Alteryx can help these institutions from day 1 and continue lifting that load as you won't have to go back to the same project or workflow every day/week/month.
Score 10 out of 10
Vetted Review
Verified User
Alteryx has solved nearly everything. Data automation, data solutions, really anything you put your mind to - Alteryx can solve it. We have tens of thousands of users and Alteryx has increased productivity to a level that isn't even measurable. So many processes have been automated across numerous lines of businesses
  • Data analysis
  • Data manipulation
  • ETL
  • ML
  • AI
  • More features can be added
  • Fix the few and rare bugs
  • continue to make it the best it is
Alteryx is well suited for really any business that has large amounts of data or just processes they want to automate. The list goes on. The solutions are endless. I cannot tell you how much I love Alteryx and use it to speed up things. The continue releases make it a world class leader
Prateek Naharia | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Alteryx is a crucial part of our organization, addressing key business problems through its data integration, preparation, advanced analytics, and workflow automation capabilities. We leverage Alteryx to efficiently handle diverse data sources, perform complex analyses, and automate processes, improving decision-making and operational efficiency. Its deployment spans across departments, empowering us to drive data-driven insights and gain a competitive edge.
  • Data Integration and cleansing
  • Spatial Analytics
  • Machine Learning Integration
  • Automation Workfow
  • Steeper Learning Curve: Alteryx can have a steep learning curve for users who are new to the platform or have limited experience with data analytics. Enhancements to the user interface and user onboarding resources could help make the learning process more intuitive and accessible to a wider range of users.
  • Enhanced Data Visualization Capabilities: Alteryx offers basic data visualization capabilities, but there is room for improvement in terms of advanced visualizations and interactive dashboarding features. Adding more sophisticated chart types, interactive widgets, and customization options would enhance the data visualization capabilities within the platform.
  • Improved Error Handling and Debugging: Alteryx provides error handling mechanisms, but enhancing the error reporting and debugging capabilities would be beneficial. Improved error messages, better visibility into data flow, and debugging tools could help users troubleshoot and resolve issues more efficiently.
Well Suited Scenarios
  • Data Preparation and Integration: Alteryx excels in data preparation tasks, such as data cleansing, transformation, and integration.
  • Predictive Analytics and Modeling : It enables users to perform complex statistical analysis and models and algorithms, making it more valuable for cases like customer segmentation, demand forecasting, fraud detection.
  • Automation WorkFlows: Amazing for repetitive data processing task, or automated rescheduling.
Less Appropriate Scenarios:
  • Real Time data processing, large scale big data processing, Heavy statistical computations.
Score 10 out of 10
Vetted Review
Reseller
Alteryx is used across all aspects of the business, from HR to finance, legal to supply chain. We solve everyday data cleanliness and connectivity problems and generate insights using automated machine learning. We connect systems together, clean & combine datasets, generate additional features, and (depending on the use case) perform a variety of analytics: spatial, prescriptive, and predictive. All are automated dynamically by Alteryx.
  • Data cleansing (ETL/ELT)
  • Feature engineering
  • Spatial analysis
  • Joining data sets
  • Automated machine learning
  • Amazing community of like-minded and helpful users
  • Visualisation
  • Reporting
I would not hesitate to recommend Alteryx to a colleague. Alteryx can be put to almost any data use case and because it's low-code/no-code/code-friendly it can be used by any member of the organization. Alteryx is well-suited to anything that is currently done in Microsoft Excel and for any users who have to perform repetitive tasks.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We handle a lot of data. We need to do so accurately, consistently, and efficiently. Since we have been using Alteryx, we have been able to re-platform and (massively) improve existing processes as well as introduce new ones, many of which are available to colleagues on a self-serve basis. Processes that used to take a day, now take minutes, while we have been able to handle data in a level of detail that we were unable to do previously. Scheduling a simple App to check data has already saved us thousands. Moreover, I love developing on Alteryx; it is intuitive, flexible, and enjoyable to use.
  • Connect to various databases - cloud-based and on-premise.
  • Handling large data sets
  • Offering a self-serve platform
  • Improved interfaces would be good
Our Alteryx proof of concept was to create a reconciliation process handling large data sets (~1 million to ~1 billion). This used to take many hours and in some cases, days. These can now be completed within minutes with much greater accuracy.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Alteryx is being used across the whole organization from the tax department to the assurance department. Alteryx is a fantastic software that allows for data manipulation and complex workflows that would normally take a program like excel double, maybe even twice the manual work. With Alteryx expect juiced up version of excel with a workflow layout allowing you to build custom flows to manipulate and understand complex data.
  • Data Wrangling
  • Ability to Handle Big Data files
  • Easy functionalities, avoiding common excel formula pitfalls
  • User must have significant knowledge of functionalities
  • "Code Based" Software which provides a big learning gap
  • Many intricacies that can ruin a whole workflow
Alteryx is well suited when dealing with LARGE data files that need to be converted to different document types, Manipulation of data, and creating standardized workflows to be used a multitude of times.

Less appropriate, simple/ small data files not needing much manipulation. Logical excel formulas could be used to solve the issue.. etc.
April 14, 2023

ETLing Alteryx.

Score 10 out of 10
Vetted Review
Verified User
Incentivized
Our organization has data in several different systems. Alteryx does an excellent job of connecting our various systems, blending the data, and formatting the data in a way our users need it. I use Alteryx to send daily dashboard reports, exception reports, parse website data, and anything else we have data related. Alteryx does an exceptional job formatting the data exactly how we need it.
  • Connecting to practically any data source.
  • Easy to user interface.
  • Excellent community and support.
  • Regular updates.
  • It would be helpful to have a favorites workflow section or be able to pin often used workflows in Designer.
  • It would be nice to have one button to cache all incoming connections in designer.
  • The desktop automation application needs an update.
If you spend time formatting, blending, or extracting data, it's worthwhile to see if Alteryx would be a good fit for your organization. In my opinion, Alteryx is a good fit if you have 20 or 20000 employees in your company. The time Alteryx saves us more and pays for itself the more we use it.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Alteryx to merge and reformat large data sets. We have workflows built out to automate tasks that are done at weekly, bi-weekly, monthly and quarterly intervals.
  • Ability to work with large data files
  • Combining data sets that are in different formats, file types, etc.
  • Automating workflows
  • Offering a version for Mac
  • More guidance when there is an error in your workflow
Alteryx has been a game changer for our organization. It allows us to work with multiple large files at once that are in various formats, with the ability to merge files, run calculations, add additional variables, etc. It's great for automating tasks such as running reports where you're taking data from multiple files that are in different formats and combining them into one file with everything in the same format. Once you have your workflow built out, it's simply a matter of swapping out the input and output files and clicking "Run." It's also great for working with files that are extremely large that otherwise might slow your computer down or cause it to crash.
April 07, 2023

Alteryx is Amazing

Score 10 out of 10
Vetted Review
Verified User
Incentivized
Mainly data transformation and accessibility. Alteryx is helping every area of our business become more data literate.
  • Input data from multiple different data sources
  • Output data to multiple different data sources
  • Easy annotation and commenting
  • Need better error messaging for problem targeting
  • Would like smoother line connectivity
  • Left joins
Alteryx is very powerful, and the preferred data processing engine for refreshing.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Alteryx to clean and transform datasets used for out financial audits. We also use it to provide additional statistical insights to our audits. For example, we made sure that the calculations for working hours and pay
  • Data transformations
  • Data quality checks
  • Automated processes
  • No looping mechanisms
  • No way to store variables
  • Replicating VLOOKUPS is tedious
Alteryx is best suited for data quality inspection, data cleaning/engineering processes, and statistical calculations
Lauren Susoeff | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I use Alteryx to identify areas of concern or analyze trends in data. The reporting tool is helpful to no only create reports but send emails to stakeholders to let them know urgent information. I have been able to solve escalated issues quickly with the simple drag-and-drop interface. I have also used it to provide data for standard industry audits.
  • Drag-and-drop interface allows for ease of entry
  • ability to use existing tools to create macros opens the door to more versatility
  • Python plug-in allows me to do anything a Turing complete language can!
  • Gallery search functions a pretty poor
  • There is no way to search schedules on the gallery
I can interface with SharePoint using APIs in Alteryx. It is also great for automation.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
As a data consulting firm, Alteryx is at the heart of the business. It's one of the softwares that we specialise in. The product addresses a multitude of business problems. The flexibility, creativity, and low barrier to entry really help the technical staff have conversations with non-technical staff without "losing" them in the details. The workflows you can produce are visual, logical to follow, and allow you to step through the entire process. The visual workflows are an amazing feature in terms of debugging, helpfulness when sharing the workflow, and the readability of your work.The best part of Alteryx for me is the automation. Like many ETL tools: connecting to any data source, combining disparate files however you like, transforming the data, and then having the ability to output the information in a variety of data formats is one thing. But then being able to automate this is a complete step up. i.e., automatically selecting the most recent files in folder dumps (based on metadata), bringing those into the workflow, and running those new files on the original workflow you built (without having the repoint data sources). Game changer. And the list goes on in terms of its uses.
  • Low barrier to entry
  • Connecting to ANY data source
  • Fantastic Learning platform and community
  • Free, recognised certifications
  • automation
  • To expand and shrink windows inside of Designer can be quite painful if you're not steady with your mouse!
  • Cost if you wanted it for personal use
Alteryx is perfect if you find yourself repeatedly doing tasks. Alteryx can be used to automate these, and you don't need to understand a coding language like Python, the low barrier to entry really helps with this.

If you ever find that the tools in Alteryx do ALMOST what you need but you need them to be more dynamic for automation, you've got a whole toolset in Alteryx to help with this. Macros in Alteryx, and the interface tools, allow users to drill deeper into Alteryx to add the extra customisability when needed.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
A good analytical tool that is easy to use, allows easy import of data sources, seamless manipulation and cleansing, and easy exports into databases. The user-friendly interface, ease of learning, and minimal coding requirements make it a must-have. Nice tool for data science, machine learning, and predictive modeling enthusiasts, who can also visualize their data to check its integrity and quality.
  • Compatible with R and Python
  • Good visualization of data to check its quality and integrity
  • Easy to import, cleanse, manipulate and export data
  • Pricing is steep
  • APIs can be improved as connectivity to some data sources can be a challenge
  • Visualization tools are good but nowhere as good as Tableau and PowerBI
Well suited for predictive analytics, machine learning, and data analytics-based assignments where we leverage their intelligence suites. Also, its analytics cloud offering allows easy processing of workflows in the cloud, along with scheduling and management options. Less appropriate as a standalone visualization tool as it is quite inferior in that respect to a Power BI or a Tableau.
January 19, 2023

Powerful Yet Simple

Score 9 out of 10
Vetted Review
Verified User
Incentivized
I've been using Alteryx for a few years and it has enabled me to quickly produce automations that save thousands of hours of resources. Alteryx is powerful and easy to use. Its drag-and-drop interface allows anyone to pick it up. No coding is required. It has got its limitations, e.g. when trying to write nicely formatted tables to Excel files. Most teething issues/limitations have workarounds which are easy to find on the Alteryx community, though. It’s widely used across the globe by firms and the Alteryx community forums are very active. Overall, a solid product. Would highly recommend giving it a go if you haven't already.
  • Easy to use
  • Powerful data manipulation capabilities
  • Quick workflow/app deployment on Alteryx Server
  • Widely used
  • Alteryx community forums are very active
  • Expensive - there are free/cheaper alternatives such as Knime
  • End user experience is not very customisable
  • Alteryx are slow to respond to user feedback
Useful when attempting to automate a process that is done manually, as long as the process/steps can be defined logically. It’s saved me huge amounts of time when collating information from numerous files into a single report, which is very easy to set up and runs extremely quickly. It’s also helpful when several different reports need to be created in one go, e.g. an Excel file for each country - it just takes the click of a single button to generate all those files, it’s like magic. Less useful when users need to interact with the data to review/interpret it - a dashboarding tool such as BI/Tableau may be required for that, but Alteryx can still be useful for preparing the data that feeds into it.
January 07, 2023

Alteryx is great

Jean-Baptiste PINET 🎲 | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Data cleaning, processing, making the data easier to use and reliable.
  • Cleaning
  • Processing
  • Spatial Analysis
  • Combining sources
  • UI
  • Reporting Tools
Doing some spatial analysis like trading areas. Cleaning data to make it more reliable and usable for visualization purposes.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
At my company, we ingest various disparate data sources and need to be able to see our clinical trials at a portfolio level for multiple metrics at a single glance. Alteryx came in to play two years ago to begin helping us find ways to prep and blend the disparate sources and even automate those refreshes so we could build BI dashboards on top of the blended single source. We eventually expanded our use of Alteryx once we realized it was may more powerful than just a data prep and blend tool. We eventually expanded to use it for user interface apps and automated reporting outputs. Within two years, Alteryx has become an integral part of our reporting and analytics. All of our analysts from various backgrounds and experience levels are able to pick it up quickly and expand their knowledge with Alteryx's community forums.
  • Data Prep/Blend
  • User Interface Applications
  • Community Participation
  • Credentialing
  • Alteryx Server Functionality
  • Alteryx Server error message descriptions
Alteryx is a great tool for transforming any data source at any skill level of the user. Little to no programming experience is required in order to build and automate some amazing processes that have no business remaining manual. If you happen to work for a company that has precise ETL and never need to transform your data beyond how it already is in database tables or data marts then you may get by without needing Alteryx for data cleansing and prep but there is still so much other functionality Alteryx has to offer even if you have the cleanest databases to work with. Alteryx can't quite replace BI tools such as Tableau or Power BI in terms of having a dashboard that folks can navigate to and interact with but it is a great tool for preparing your data for BI tools or even replacing SSRS.
November 18, 2022

game changer

Darren Fernandez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
This software has transformed the way I deal with large data quickly. I have built many applications on this platform which automate tasks for me. It makes it easier to share the workload when everything has the same template as an analytic app. I couldn't imagine going back to using Excel as my primary data tool. It also help encourage me to learn other software such as python as it can all be used together to achieve a lot more
  • data prep
  • highlighting errors
  • automation
  • dark mode
  • simpler way to install (maybe auto update)
It can be used to solve any data problem no matter how small, if you would like to keep repeating the task then this would be the best way to use it. Invest the time to build once and then reap the benefits forevermore.
Chris Broussard | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I use Alteryx daily for data prep, formatting, reporting for end users, outlier identification, trend analysis, and as a data feed for our Spotfire and Tableau dashboards. Our Alteryx workflows scheduled on the Server connect to Snowflake and generate recurring output without any manual intervention.
  • Data wrangling
  • Automated output to Excel, Spotfire, Tableau, or many other formats
  • Machine Learning
  • Artificial Intelligence (AI)
  • Easy output to Excel, with different formats for each Sheet
  • Macro Management
  • Easy migration to server / production
Data wrangling / Data prep: The Alteryx low-code/no-code workflow development environment immediately improved my coding efficiency by 60% or 70%. The ability to view my data at each individual transformation step is unparalleled.

Quick results: initial Alteryx workflow development has a very low learning curve. I was able to quickly get up-to-speed using the free online training resources.

Macros and server use can be challenging. But those are advanced topics.
Kamesh Pandrangi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We were able to address the material weakness of the organization which was challenged by the external auditor on our legacy applications,Alteryx provided a quick let solution with its analytics and data management capabilities in lesser time
  • Working with heterogeneous data
  • Processing speed on huge volume of data
  • Reconciliation and automation made easy
  • Save & export feature — lot of times our team just save the workflow while it has to be exported to save those changes.
  • Non-support of workflows that are created in older version
In a technical eco system where you have a blend of both legacy and digital technologies Alteryx helps you to deal with data easily and analyze it…may not be good option to use it as an ETL tool
October 05, 2022

Best for big data prep

Gottfried Mathurin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Alteryx is to my knowledge the most efficient tool for agile data preparation. I use it massively as a low-code yet elaborate-feature-rich piece of software to acquire, transform, cleanse and analyse data, generally big data, from various and heterogeneous sources as required for the corporate internal audit assignments which cover the full scope of business units and activities in the company I work with.
  • data prep
  • acquiring data from various sources in various formats
  • combining (joins), (even fuzzy) matching, parsing
  • dealing swiftly with big data
  • providing a graphical (audit) process trail
  • (basic) machine learning functionalities
  • practical visualization outputs
  • (even) more straightforward integration of Python and R code
  • SQL push down (translation of workflows into SQL code)
  • (full blown) cloud version of Designer
To any "Excel power-user kind of" profile, to any any data owner willing to reap information from huge volumes of data and facing data prep difficulties, I would definitely recommend Alteryx. Yet, Alteryx is not the best suited for machine learning, even in a low-code approach and should for such needs be regarded as a very useful preparation tool before actual machine learning processes. Alteryx deploys well bottom up, pushed by thrilled users and doers. It is not to be launched as an ERP-like project from top down, with armies of consultants and project managers.
Jifeng Qiu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I am working with an EPC company, which performs engineering, procurement and construction of chemical plant. My role is the administrator of 3D model of the chemical plant, with Smart 3D software of Hexagon. We are using Alteryx to retrieve data from 3D model database and perform blending and reporting work. The repeatable, easy-to-trace and eay-to-configure feature of alteryx has beem making my work so much easier. Recently we are doing some new challenges, to implement our engineering design rules into Alteryx flows to perform some design QC check and modeling work, then feedback to 3D model via API. We can already see some promising results.
  • Retrieving data from on-premise and cloud SQL Server
  • Repeatable schaduable workflow with Alteryx server
  • Greate capability for data cleansing, blending
  • Free feature to work with windows scheduler.
Alteryx is best suited for organizations to handle data distributely, meaning even a "normal" member can perform the data processing at his needs with knowing complex or difficult coding skills. In some cases, such as the data is not well structured, Alteryx might encounter challeges.
Return to navigation