- Alteryx provides an integrated workflow management environment for data blending, analytics, and reporting. It is also very extensible to be connected to a variety of data connections including major databases (Oracle, etc.), analytics tools (R), and visualization tools such as Tableau through its plugins. Our department used Oracle and Tableau already and it was well integrated with Alteryx.
- The workflow authoring environment in Desktop is easy to use so that most of the users (if they are a bit skilled data developers or analysts) may not need the training to use its basic functions. Drag and drop interface and icons are intuitive to understand.
- When running Alteryx workflows, it is easy to monitor and track what's the progress by seeing percentages. It is helpful to balance and manage bandwidths of database servers, especially when to populate large data sets.
- Sometimes the desktop version of authoring tool crashes! It's been unstable in the previous versions but gets better. Even if it doesn't crash, it used to be slow or not responding.
- When running several version of database drivers in local machine or server, it is tricky to set up database connections. Often you have to figure out it by googling the problem and solution. There are not many knowledge bases from Alteryx.
- Alteryx project file creates .bak file automatically. It is useful to prevent for the purpose of back up, sometimes it's not necessary. But it is not changeable for some reason. By default, it always creates backups.
Less appropriate: Alteryx is good for "automation", but some data developers and analysts may prefer to remain and keep using SQL tools. One should be careful of not just adding "one more layer or tool" into the existing pipeline and make it more complicated to manage.
- User-friendly interface - the tool structure and general workspace are very easy to pick up on. Short learning curve from "no experience" to "beginner user".
- Standardization - modules/wizards allow a single tool to generate results for multiple clients, all through the use of a few actions/inputs.
- Analytics - wide range of statistical analytics tools makes it easy for a user to look at data and provide simple summary statistics, while also having the ability to build advanced regression models.
- Excel reporting - reports in PDF are fairly straightforward, but trying to output results in Excel can prove to be tricky/ugly.
- Chart creation - current chart tool is very basic; needs to be a way to customize the look/feel of a chart more, as well as an easier way to incorporate "big" data that can be easily reported on/viewed.
The solution engineers were able to better design the proposals which resulted in client satisfaction and savings for the company.
- Cleaning datasets
- Preparing data for analyzing
- Customer data analytics
- Transforming data from one format to other
- Poor documentation
- Overkill for simple tasks
- Not many options for data visualization
- Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.
- Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.
- Macros: have a process that you are consistently running in separate workflows? Build a macro, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
- I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.
- Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.
- The ability to create a TDE(Tableau data extract)
- The ability to use geo spatial data for spatial analysis
- The range of tools that can be used to clean/prepare your data
- Alteryx lacks good visualization capabilities
- Alteryx does not run on Mac(IOS)
- Alteryx is not as stable as some of the enterprise-grade tools like DataStage
- Alteryx analytics is particularly well suited for situations where a BI user needs to quickly prepare the data for analysis
- Alteryx sells tom-tom maps and these maps are extremely useful for spatial analysis and help real estate or SCM teams plot routes and spatial charts
- Alteryx makes predictive modeling easy
- Alteryx lacks the capability to produce good visualization hence one should never try to achieve an end to end BI solution using only Alteryx.
- If you prefer using a MacBook then you need to use a Windows VM to run alt Alteryx
- Quick data blending.
- Wide range of analytical coverage - ETL, Descriptive and Predictive analytics.
- Ease of learning for new users.
- Iterations/ looping/ interactive user interface creation is cumbersome for new users.
- Missing prescriptive analytics modules.
Less appropriate: Organizations that have low analytics adoption and more of visual report consumption culture would find it difficult to resonate with the value proposition of Alteryx.
- It's great at blending data from different sources. I loved how easy it was.
- There is a huge variety of visualizations that are available as well.
- A lot of drag and drop options available for different workflows.
- Open APIs available are a great help.
- I would love better training videos on their website.
- Trying to automate the workflow is at an additional cost.
- If we happen to skip a few versions of Alteryx then it gets difficult to get accustomed to newer versions.
- Alteryx can publish to Tableau server which can be used as an extract and data source for Tableau.
- Scheduling on Alteryx server is a great functionality which helps to schedule the workflows automatically on the server without manual intervention.
- Analyzing the data is great - we can export the data in Excel, CSV; browse the data and so on.
- Breadth of data sources available (Excel to Big Data)
- Easy to learn and use
- Makes applying predictive analytics simpler
- Alteryx community is a great place to learn and share workflows
- Alteryx Gallery is a great platform to share apps
- Alteryx Gallery needs a fresher UI
- Automating workflows that blend Excel would greatly improve productivity
- It can independently generate required analytics instead of having to require specialists.
- The ability to read and write in a multitude of formats: from Excel, Access tables, Tableau and Teradata to MapInfo, ESRI, Google Earth, etc.
- Single drag and drop workflow instead of multiple tools.
- The visualization that Alteryx provides can be improved much more than where it stands tonight.
- It doesn't seem to be able to process Big Data as efficiently as I would have liked.
- There are a lot of things that you need to learn.
- Blend multiple sources of data
- Append or update existing data
- Allows for powerful insights for non-technical users
- Improve work flow in modules, sometimes buggy when dealing with multiple files
- On-screen wizard could help demonstrate common best practices
- Add more tools that could benefit the user without them having to create macros
Alteryx Analytics Review: "Tired of processing a bunch of Excel files, let's give a try to Alteryx."
- Automation macros
- Query simultaneously across instances
- Process big files
- Output multiple file types
- More options for each tool
- Not compatible when running at high DPI
- Should have an account page online to manage license
- Spatial analysis in breakneck speed when compared against GIS. Add to that some pretty comprehensive mapping capabilities. My MapInfo Professional GIS is used less and less.
- The incredible speed at which it reads and processes data (spatial and otherwise).
- The ability to read and write in a multitude of formats: from Excel, Access tables, Tableau and Teradata to MapInfo, ESRI, Google Earth, etc. The flexibility is awesome.
- Fantastic customer service with a live expert that answers everytime.
- Creating maps can be a challenge sometimes as the process can be time consuming, and depending on the complexity of the map, it can take learning some nuances about the program.
- Alteryx democratizes data and quickly allows analysts the ability to turn data into intelligence. Data exploration can take new depths as users are capable of interrogating larger sets of data in reduced timeframes. Processes timeframes are reduced to fractions of their legacy counterparts.
- Innovation has been accelerated by using Alteryx to develop quick prototypes that can rapidly be deployed for production use. Similarly, we have used Alteryx to replatform legacy systems. The transition to Alteryx not only reduces the infrastructure requirements, but also places the application/product into a new paradigm for processing, allowing innovative enhancements that were once limited by the legacy system(s).
- Alteryx is a viral application. We've used Alteryx course training, in-house training, webinars and videos and our user community continues to grow. Alteryx is feature rich and each version of software builds reliably on prior versions. New users quickly come to speed on Alteryx and supoprt requirements for new users is minimal.
- Alteryx seeks feedback from the user community. We regularly provide Alteryx with detailed requirements for supporting our data processing needs and Alteryx consistently delivers required functionality in their software updates.
- Alteryx is rapidly expanding support for advanced analytics and delivery of consumable analytic tools. Alteryx can call other applications if necessary, but can also run R natively. Alteryx has been working both on expanding their delivered modeling toolset as well as enhancing their software to improve the performance of R.
- While parallel processing is performed, there are times that I'd like to see more of it. Alteryx makes it easy to browse data within modules, but the browse output (tabular) is not readily filterable/sortable. Improvements to the user interface would be welcomed.
- Alteryx allows users to schedule individual jobs for execution, but doesn't provide advanced scheduling tools to establish workflows where jobs executions have outside dependencies.
Call Alteryx and see how quickly they respond to your needs. Client Services is available most hours either by phone, email or chat. You can post to their community boards. They are very responsive and seek high customer satisfaction. They are very accessible and if you want to talk to their Chief Customer Officer, she'll get on the phone with you.
- Alteryx is a very versatile program to use. Whether you are formatting data or running complex models it can be efficient and helpful.
- Alteryx interface is very easy to follow. There is code behind all of the tools but the visual appearance of the tools and process flow allow the user to visually see exactly what is going on behind the scenes.
- Alteryx can be used by a variety of skill levels. Beginners can benefit greatly from already built modules. Experts can be innovative and provide company wide solutions that will streamline processes and make results more consistent.
- Some error messages seem too ambiguous. Granted user error is a major cause of problems, it could still be beneficial to have the error point more closely to the area that is malfunctioning.
- Reporting tools are difficult at times to get formats exactly fine tuned to the desired output.
- Alteryx handles metadata really well. The tools are intuitive in their use.
- For analytics Alteryx it is a great platform.
- There are barely any software bugs in the product.
- The error messages are actually helpful to debug modules.
- If a load-balancing application is internally developed on top of Alteryx processing nationwide universes can be really fast.
- Speed is somewhat lacking.
- It isn't optimally geared for ETL.
- Intellisense would be a nice feature
- There is no version control.
- The tools could use some more features.
- More pre-built macros would be nice
- Alteryx is very easy to learn. It's really good at handling very large datasets and allows users the flexibility to manipulate data in many ways.
- The user support is very helpful for Alteryx. The client services reps are very nice and always helpful when you have questions.
- The analytic tools have made the software more well rounded as an end to end solution.
- The R tools, although a very nice addition, are not easily modifiable so they can be somewhat limited in flexibility.
- The mapping and graph/charting tools continue to be a drawback for Alteryx. We'd love to use Alteryx as the all in one stop shop solution for analysis, mapping, and reporting but it's maps and charts can't hold a candle to Excel Charts or Mapinfo/ESRI maps.
- Processing speed is hit or miss depending on the size of what you're running through it. Generally, Alteryx is great at this but in cases where you're needing to process large data on the fly, things can take hours or days to run. This may not be easily resolvable but in much of our investigations, it seems like how Alteryx maybe could handle processing and optimizing the machine it's run on better. For example, a Quad-Core processor machine with 16GB of Ram may only use a quarter of it's threads to run Alteryx processes so we don't realize noticeable speed gains when run large jobs on our power boxes compared to smaller machines.
- Reads in large amounts of data pretty efficiently; provided it has enough power. Pretty much takes in any format of data and gives the output in the format needed.
- Easy to learn.Tools are named logically and hence easier to understand.
- Integrates with SQL pretty well.
- Helpful Online sites.
- Good Onsite support.
- Supports processing of large amounts of data pretty efficiently; again provided machine has enough power.
- Variety of Maps provided are not always what the customer wants; so customizable maps would be nice.
- The drag and drop interface is very intuitive allowing users to hit the ground running on this product.
- Alteryx allows input and output of various data types (.csv, .tab, .shp, .png, .xlsx, .yxdb, etc.)
- The user is able to "browse' the data along the way unlike some data processing programs.
- The map visualization is terrible. If you're planning on outputting presentation worthy maps, Alteryx is not the software for it!
- The program has glitches - sometimes everything will be created perfectly (data joining as it should, appropriate fields selected, etc), but the program will fail to read in or "update" the workstream and cause errors
- Though Alteryx is touted as "Big Data" friendly, we have seen those limits reached (billions of records) and been disappointed with run times.
- Data blending: It makes SQL, Excel and Access look ancient.
- User-Friendly: The workflow logos are aesthetically pleasing and easy to understand.
- Efficiency: The apps take a of the leg work out of the process.
- There is a steep learning curve, but nothing they can do about that.
- It needs to be available on the OS platform!
- It can become very expensive.
- Alteryx handles data imports very well and give great feedback on the import process.
- Alteryx is incredibly feature rich. I never found myself unable to manipulate data in the way I had hoped.
- Alteryx provides great formats for export as well.
- You cannot as a novice just play around and get started. The learning curve is very steep, rewarding, but steep. I can't help but wonder if the product would not benefit from a "light" version for less data-mining accustomed business managers.
In other words, Alteryx is a fantastic data scientist tool to make data-based business decisions. But to be most effective, first you need to know what data you have, what data you want to find/incorporate and what the goal of the exercise is.
- Processing speed; capable of analyzing millions of records in a short time.
- Data connectivity; capable of connecting various databases/formats.
- Many pre-built sample modules available for your use that require little of additional time to customize them to your needs.
- The reporting capabilities do not have many options for customization. It would be great to have some additional functions for graphing, charting similar to Power Point or Excel.
- Alteryx geospatial capabilities are great, but are in some way limited. The quality of geospatial reports could have been improved; specifically the mapping part. Having more options to customize the maps and /or add some more of GIS capabilities would be very beneficial.
- Currently the user has to start Allocate (the demographic part of Alteryx) separately from the Designer part in order to create custom variables. Having an option to build custom variables within the configuration/properties window in the Allocate Append tool (Demographics) would be very helpful.
- The geospatial utilities are exceptional for mapping and plotting coordinates for data selection and market campaign planning.
- It makes data manipulation easy. The easy-to-use interface makes ETL simple, while maintaining the power of the most recognized tools.
- It's dozens of tools in one package. You'll no longer need to jump from tool to tool, changing layouts and spending time setting up the next process. Instead, you can set it up all at once, in one powerful tool.
- Managing input of fixed-width files is a difficulty. The ability to type out the layout, instead of having to manually select column specifications, would be much easier.
Alteryx Analytics Scorecard Summary
Feature Scorecard Summary
About Alteryx Analytics
Alteryx Analytics is a business intelligence and predictive analytics solution. The vendor's value proposition is that their solution provides analysts with the unique ability to easily prep, blend, and analyze all of their data using a repeatable workflow, then deploy and share analytics at scale for deeper insights in hours, not weeks. According to the vendor, analysts love the Alteryx Analytics platform because they can connect to and cleanse data from data warehouses, cloud applications, spreadsheets, and other sources; easily join this data together, then perform analytics – predictive, statistical, and spatial – using the same intuitive user interface, without writing any code. Additionally, the vendor says thousands of companies and data analysts worldwide rely on Alteryx daily.
Alteryx Analytics Screenshots
Alteryx Analytics Integrations
Alteryx Analytics Competitors
|On-premise Edition||Pricing Details||Terms|
|Alteryx Designer||3,995||per user, per year|
|Alteryx Designer with Spatial||12,995||per user, per year|
|Alteryx Designer with Data||29,995||per user, per year|
|Alteryx Server||45,000||per server, per year|
|SaaS Edition||Pricing Details||Terms|
|Alteryx Analytics Gallery||1,500||per user, per year|
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.
Alteryx Analytics Support Options
|Free Version||Paid Version|
|Video Tutorials / Webinar|
Alteryx Analytics Technical Details
|Deployment Types:||On-premise, SaaS|
|Supported Languages: ||English, French, German, Brazilian Portuguese|