TrustRadius
https://media.trustradius.com/product-logos/g4/Hn/PS1KWPS75CFZ.jpegAlteryx Analytics review from an analyst's perspectiveAlteryx is used in our Analytics team and Data Engineering team. It is being used mainly for data preparation before analytics. Also, it is used for repetitive analytics because it is really easy to run a complex query from Alteryx.,Data preparation. Visualizing complex queries. Processing multiple "joins" in an easy manner.,Alteryx could use data connectors to other software systems. Alteryx may need to add better data visualization capacity.,8,8,6,DomoAlteryx - a solid legacy productAlteryx Analytics was used in my organization for the preparation and processing of datasets prior to handing them off to a BI tool or for additional processing. It ran locally on a Windows server within the firewall so that we could process customer data without violating customer data leaking or being exposed off premises.,Data preparation - many of the most common methods built in Data processing and blending - able to to merge datasets Some modeling using statistical methods,The techniques included for machine learning are far behind the times The interface can be confusing and overwhelming at times The software integrates but not cleanly with many advanced machine learning platforms,4,IBM Watson Studio (formerly IBM Data Science Experience),4,4,Tableau Desktop, IBM Watson Studio (formerly IBM Data Science Experience)Alteryx- the best data toolAlteyx has been used by the Analytics department to extract and manipulate data. We have created workflows that automatically extract information from an API and point to dashboards. We have also carried out some analysis within the workflow to optimise results and have fast answers. Alteryx is very flexible and allows fast data manipulation. Excellent when you use different data sources.,Data extraction Data manipulation Analysis,The graphs are not always clear The possibility to customise the icons,10,Tableau Prep,10,9,Microsoft Power BI, BirstUse Excel?- get upgraded, get Alteryx AnalyticsAlteryx was adopted by one of our analytical department and reffed by them on their achieved success. Now Alteryx is extensively used in 4 different departments with wide range of tasks. Alteryx is best used for handling large size of data which excel is not capable of. It is a brilliant tool with great visualization that deals with SQL codes in the background. It has predictive analysis capabilities and is compatible with "R" making it a even more greater tool.,Predictive analysis - forecasting with different models as ESM / Arima etc. Data clean up, sorting, linking multiple excel files, joining data. Generating reports, scheduling reports, auto emailing of reports.,Expanding more functionality is nice to have. Better input and deletion of links between operations.,10,MicroStrategy Analytics,9,7,MicroStrategy Analytics, MS SharePoint, Cisco WebEx Teams (formerly Cisco Spark)Great for blending large data setsWe use Alteryx to make decisions on the large datasets from a disparate set of sources. Alteryx lets us join data from various sources and perform operations. We primarily use it to gather data from various CRM systems. We use this data to make decisions on the impact of marketing campaigns and also to inform the sales team about client engagement which helps the sales to get leads.,To get data from various disparate sources and to have a holistic view of the marketing activities. To provide sales with leads weekly or monthly based on their marketing engagement. To analyze the CRM systems like Pardot & Salesforce to create a list of customers for targeted email campaigns.,Though it provides good data blending functionality, the visualization aspect is missing. For visualizing data you need Tableau or Power BI. They have some shortcomings like when reading similar files. The tool figures the datatypes randomly and a integer data type might be read as text, and then the tool is unable to read data. There is a way around this but it's cumbersome. The API connections are limited at this point. They do have a macro which you can create to connect to any API, but it's not very straightforward.,8,KNIME Analytics Platform,8,7,Tableau Desktop, Microsoft Power BIAlteryx Analytics - Let's start Alteryx-ing data.Alteryx is used across my organization and in almost all data related projects. I started with Alteryx in the year 2016 to automate my 100's of excel workbooks and the macros used in them, there was bad data coming from different sources and I had to clean it. Alteryx helped me to automate all my work and reuse the workflows whenever required which used to take hours/days. The processes which used to take couple of days to execute, I was able to complete them and get output just in 1 hour.,Clean any data Data wrangling Predictive analytics Spatial Analytics,Creating Macros are not easy for less experienced people, need lot of work. Spatial analytics is very good but again it need more focus to understand. Predictive analytics is not used by everyone, it's potential can be unmasked only with data science use cases. Data Visualization capabilities,9,KNIME Analytics Platform and Trifacta,9,8,Tableau Desktop, Microsoft Power BI, TIBCO Spotfire, Trifacta, Qlik Sense,100,10Choose Alteryx as an analytical solution!!I have been using Alteryx for a year. In our organization, we use Alteryx to build a data model by cleansing data, shaping our data and doing advanced analytics with our data. In the analytical department, we are using Alteryx to analyze our data. We were unable to get insight and manipulate the data so, we adopted this tool to get more insight and do analytics to our data.,Blending multiple data into one data set. Alteryx is great for doing Spatial analysis with data. Alteryx perfectly integrates with other application or data sources.,It doesn't have a perfect predictive model for predictive analysis. Alteryx is moving into a prescriptive and cognitive analysis of data. Since we can do a very limited number of operations in this field.,7,Teradata Analytics Platform and SAS Advanced Analytics,8,8,Tableau Desktop, UiPath Enterprise RPA Platform, GitHubOne of the most Robust Analytics tool you can find in the marketWe use it for data preparation and blending. Its drag and drop makes the process easy, and its robust engine makes the data run quickly. We are using it in almost all the teams, and we see it as one of the most important tools for our analytics process.,Macros are a lifesaver. You can just write a set of logics, create a macro, and use it in any flow and any number of times. Data Connectivity for SQL is super easy, and it's powerful. Scheduling the flows and reporting. I use it to schedule the flows in off business hours so that I can get the data ready for the next day.,The Maps feature in the tool can be improved. Alteryx could come up with the feature of pausing the workflow. As of now, there is only an option to stop.,9,9,9A must tool for data analytics!Alteryx is used by the few specific departments but they impact the whole organization in business making decisions. It is used majorly to manipulate the data available and to create a statistical analysis. Alteryx is also used in data mining and forecasting techniques, with the help of R coding it is a flexible tool that can help better interpret the data. Sales forecasting and data preparation for resource allocation are the most crucial jobs getting done.,Data mining: data can be manipulated easily and completely replace excel formulas. Forecasting: It has inbuilt statistical models that can serve basic forecasting very well, moreover one can also manipulate the R coding that can help with complex data.,Statistical analysis: this tool can easily replace the Minitab software by providing solutions for statistical analysis. Graphs and charts: Although Alteryx is able to generate graphs and charts, they are not visually pretty and has a big room for improvement.,9,MySQL and Microsoft Access,9,9,Microsoft Power BI, SAP HANAAlteryx: a pocket BI solutionAlteryx is the primary ETL/analytics tool being used by our BI users. Alteryx is particularly popular because of its ability to create a tableau data extract and thus provides a meaningful alternative to tableau's missing data blending capabilities. Alteryx offers a range of tools that can be used to clean/prepare your data for analytics along with ETL capabilities. Alteryx has some amazing analytics capabilities including but not limited to spatial, behavioral, predictive etc.,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,9,Trifacta, DataStage and Informatica,8,8,Tableau Desktop, Tableau Server, IBM Cognos, ThoughtSpot, Microsoft Power BI, Teradata Database, BetterWorksThe only data preparation tool you will ever need or want - life changing!Our organization began using Alteryx sometime ago however my team was introduced to it approximately 3 months ago. It is used to support data analytics work in all areas in addition to report preparation. We are attempting to drive the usage of this tool across the organization as it is a cost and time saver in the preparation and analysis of data for every department/business.,Excellent support for the tools through training/white papers and online support. Ease of use - high common sense factor makes the program easy to learn and apply. Compatibility with everything but specifically with commonly used key programs like Tableau.,Cost is a factor - while support and training are "free" the software price is high. It helps to have some good Excel experience to make instant adoption even easier. The trainers tend to go a bit fast so slow learners may need multiple sessions.,10,,10,10,Tableau Server, Microsoft 365 Business, WebEx MeetingsA great tool for predictive analytics and model developmentWithin the Credit Risk Model development space, we use Alteryx to create time series models for PD, LGD and stress testing to compute VaR. It is also used by our predictive analytics department, but some use is spreading out to our data teams given the user-friendly interface and its ability to handle big chunks of GLM simulation for errors in data. It is also suited for a wide range of ETL things, from data cleansing to general data manipulation that helps answer a client's day-to-day questions. All in all, it's a great tool for working with advanced statistics.,Seamless Data Input (Ingestion): Alteryx is capable of connecting with many data sources, we have used Tableau in cloud-hosted solutions with additional support of OleDB & ODBC connections. Advanced analytics: We have used statistical analytics tools which 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. Macros: Just like other tools (e.g. SAS), Alteryx builds a macro. Be it a batch or iterative, it can save loads of efforts for standard and recursive processes. We've built numerous macros and use at least 10+ in every workflow post design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.,Visualization needs severe improvement if it wants to be up to par from its market competitors like Tableau. The workflow scheduler has been reported as frozen in the earlier version which needs betterment. Lack of documentation for the few functionalities and higher cost is a trade-off as well.,8,Tableau Online,9,8,Tableau OnlineAlteryx & Its Robust Server - #NotJustAVizAlteryx Analytics is used by our corporate analytics team. We design dashboards, build predictive models, and deploy them on the server. This helps executives to make data-driven decisions across the board. The dashboards developed by Alteryx are generally associated with financials, employee performance, staff scheduling or any other area where we feel data analysis can improve the results significantly.,Designing dashboards is very easy and intuitive in Alteryx. Although some form of analytical aptitude is needed, most of it is very user friendly. Embedding R or Python Code is fairly straightforward in Alteryx. This makes it very sophisticated for data analysis and predictive data modelling. Effective mathematical calculations-- which are difficult to code in SQL-- are very easy to write in Alteryx.,Improved Maps/ GeoCoding system for geographical analysis should be there. Running data extracts can be made more efficient. Tableau does it much better. Cross-Database joins should be allowed and the data extraction should be much simpler.,8,Tableau Desktop,8,8,Tableau Desktop, RapidMiner Studio, HadoopChanged the roles and depth of our AnalystsHard to pin down as a single use case since this can be so broad. Alteryx is used in almost any analytics capacity to figure out financials and operations problems. More specifically we found Alteryx useful for connecting vendor metrics with underlying date; we're using buyer spend over time as an enhancement for material and payables resource planning, and our logistics team uses it to track the efficiency of carriers and shipping lanes.,Objective analysis Process build Data integration,Faster speed of query More complex join capability. Some more experienced users would like to make more complex joins after the data is in process map rather than a complete preparation before including in process map Connection with Power BI, Tableu, or other graphical data tools would make more seamless intelligence,10,Azure SQL Database,9,9,Tableau DesktopAlteryx, multi-purpose tool for a broad audience range.We continue to grow our organization's use of Alteryx. Alteryx Designer started as a solution being used by one department and has now grown as an Enterprise tool. Many of the common use cases for us include data integration and predictive analytics.,Alteryx does a great job of allowing more beginner Analysts to automate many of their routine process but also allowing advanced Analysts to ability to leverage deep statistical modelling for predictive analytics. Given the visual workflow nature of Alteyrx, the learning curve is not steep. The Alteryx Gallery allows non-technical consumers to execute complex workflows by leveraging an intuitive web interface. Alteryx allows data scientists to bring their own programming language to Altyerx, such as R or Python.,Alteryx has opportunity with version control. Currently today versioning is handled through saving different versions of each workflow.,10,,8,9,IBM Cognos, Microsoft SQL ServerData prep standardCurrently, Alteryx Analytics is being used by a select group of employees in our center of excellence, the total number being around 4 or 5 active users with 10 other licenses allocated based on immediate need.,Data blending Data prep Data exploration,Ease of use in tool functionalities More advanced analytics UI / UX,6,Tableau Desktop,8,4,Tableau Desktop, RStudio, TIBCO SpotfireGreat software worth the priceWe use Alteryx for data prep, cleaning and analytics, to funnel data into Tableau. Used solely in our analytics department.,Makes automating data cleaning a breeze. Data prep becomes a fun activity with Alteryx. Analytics becomes more of a focus, as Alteryx is doing the heavy lifting.,Training seems to be lacking or expensive. Offline guides would be helpful instead of logging into the online training. Multi-use licence would be great to jump from laptop to desktop.,10,Tableau Desktop,10,5,Tableau DesktopAlteryx is a good tool for analytics productivityMy team has been running Tableau reports for clinicians, researchers, and leadership in our organization. As we have developed more reports we had strong needs of managing data pipelines in a systematic way. In many cases, ETL processes were managed individually by data developers and analysts and there were issues of report ownership, data consistency, and management issues. We adopted Alteryx and automated two types of processes: ETL processes and Tableau data extract creation. Alteryx provided values in terms of systemized pipeline management and query performance.,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.,8,,8,6,Tableau Desktop, Tableau Server, IBM Cognos, Cerner HealtheIntentAlteryx: One Tool, Unlimited ApplicationsAlteryx is predominantly used by our predictive analytics department, but some use is spreading out to our data teams given the user-friendly interface and its ability to handle "big data". We also use it for some internal tools that allow other departments, who may not be as familiar with the product, to run reports and gather data specific to our processes that allow them to more easily do their internal reporting. Alteryx is used for a wide range of things, from data cleansing to general data manipulation that helps answers a client's day-to-day questions, all the way to report automation and "wizarding" that provides clients with their solution(s).,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.,10,None,8,8,SQL Server Integration Services, Tableau Desktop, Amazon Web ServicesAlteryx - powerful and easy to useWe used Alteryx for analyzing pre-sales data. We had a proposal management system which generated a lot of numbers. My job as a process analyst was to use Alteryx to get insights into making the process efficient. It helped us in identifying bottle necks and focusing on problem areas. 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 Costly Overkill for simple tasks Not many options for data visualization,8,Talend Data Integration and Tableau Desktop,8,5,Tableau Desktop, Talend Data Integration, Microsoft SQL Server, MySQL, Oracle Business Intelligence Cloud ServiceA fantastic ETL, data munging, data prep, and data processing toolAlteryx use began in the marketing department to help automate data prep pre-Tableau from data sourced from Salesforce. It is now also being used by the IT department to help join multiple data sources to automate data munging for some standard report generation. The primary business problem Alteryx helps our team with is helping analyst move much more quickly by building data workflows visually instead of creating hundreds to thousands of lines of code to move and prep the same data.,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.,10,Jitterbit,10,10,Tableau Online, Tableau Desktop, Google Analytics, Salesforce Analytics Cloud, PostgreSQL, MarketoSimple, efficient yet powerful AlteryxAlteryx is being used into its full potential to collect data, bend and prepare, analyze/summarize as well as create automation workflows, what-if analysis toolkits, and to do statistical modeling of data. It has simplified the way analytics used to be done as well as taken the same to the masses.,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.,10,,10,10,Microsoft SQL Server, Tableau Desktop, TIBCO SpotfireAlteryx for many thingsWe use Alteryx for data cleansing, prep and analytics across sales and marketing functions, i.e. blending CRM, Excel and MailChimp data.,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,9,Strong ROI Increased efficiency of the analytics teams,Datawatch Monarch, Lavastorm Analytics Engine, IBM SPSS, Talend Integration Suite, RapidMiner Studio and Informatica Cloud Data IntegrationOrganization made easy.We specifically use Alteryx for data blending. Due to our multi-sourced approach, we receive multiple data sources in aggregate and find value in combining them into a database. It helps us gain intelligence on specific client-related asks in a simple, easy to use format. It really allows us to stay agile and manipulate data at a fast pace, something that is lacking in Excel alone.,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,9,Tableau Desktop,9,7Tired of processing a bunch of Excel files, let's give a try to Alteryx.Salesify’s products arm data-driven marketers and sales professionals with critical B2B Customer and Business Intelligence. We provide millions of high quality, relevant companies and contacts at the tip of your fingers with the help of our customer data analysis. All the data team is using Alteryx now to process tons of raw data to filter, cleanse and append relevant information based on customer requests. Its super fast processing performance helps us reduce considerable times of running big queries, opening large files and combining different sources.,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,8,9,9
Windows
Alteryx Platform
141 Ratings
Score 8.5 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

Alteryx Platform Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Alteryx Platform
141 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Do you work for this company?

Show Filters 
Hide Filters 
Filter 141 vetted Alteryx Platform reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 43)

Companies can't remove reviews or game the system. Here's why.
Jonghee Jo profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Alteryx is used in our Analytics team and Data Engineering team. It is being used mainly for data preparation before analytics. Also, it is used for repetitive analytics because it is really easy to run a complex query from Alteryx.
  • Data preparation.
  • Visualizing complex queries.
  • Processing multiple "joins" in an easy manner.
Alteryx could be very useful if you need to combine data from multiple data sources. Also, it would help data preparation and cleaning before analyzing data. If the data quality is already excellent, then it would probably be less useful.
Read Jonghee Jo's full review
Christopher Penn profile photo
Score 4 out of 10
Vetted Review
Verified User
Review Source
Alteryx Analytics was used in my organization for the preparation and processing of datasets prior to handing them off to a BI tool or for additional processing. It ran locally on a Windows server within the firewall so that we could process customer data without violating customer data leaking or being exposed off premises.
  • Data preparation - many of the most common methods built in
  • Data processing and blending - able to to merge datasets
  • Some modeling using statistical methods
Alteryx is excellent in a Windows environment where you need to process data, especially on-premises data. It handles structured data well; it struggles with unstructured data. If you have a heterogenous environment with Mac and Linux workers, you will need to either provision dedicated hardware or use virtual machines in order to run Alteryx.
Read Christopher Penn's full review
Maria Piccoli profile photo
September 14, 2019

Alteryx- the best data tool

Score 10 out of 10
Vetted Review
Verified User
Review Source
Alteyx has been used by the Analytics department to extract and manipulate data. We have created workflows that automatically extract information from an API and point to dashboards. We have also carried out some analysis within the workflow to optimise results and have fast answers. Alteryx is very flexible and allows fast data manipulation. Excellent when you use different data sources.
  • Data extraction
  • Data manipulation
  • Analysis
  • Alteryx works very well when there are different files or different data sources that should be combined together. It is also good for data manipulation.
  • Alteryx can be used to build an ETL for a BI tool.
  • The join and union capabilities are a strong point for the tool. It is also very simple to use and intuitive.
  • I would not use Alteryx if you have few and small tables.
Read Maria Piccoli's full review
Rishi Bavishi, CSSGB, CAPM profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Alteryx was adopted by one of our analytical department and reffed by them on their achieved success. Now Alteryx is extensively used in 4 different departments with wide range of tasks. Alteryx is best used for handling large size of data which excel is not capable of. It is a brilliant tool with great visualization that deals with SQL codes in the background. It has predictive analysis capabilities and is compatible with "R" making it a even more greater tool.
  • Predictive analysis - forecasting with different models as ESM / Arima etc.
  • Data clean up, sorting, linking multiple excel files, joining data.
  • Generating reports, scheduling reports, auto emailing of reports.
Alteryx is best used for corporations that rely on large excel files and have too many reporting tasks to perform everyday. It will make repetitive tasks to run through just one click. It is also recommended for initial predictive analysis such as forecasting, demographic analysis and behavior analysis. Since it's compatible with "R", it adds even more functionality.
Read Rishi Bavishi, CSSGB, CAPM's full review
Karan Gupta profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Alteryx to make decisions on the large datasets from a disparate set of sources. Alteryx lets us join data from various sources and perform operations. We primarily use it to gather data from various CRM systems. We use this data to make decisions on the impact of marketing campaigns and also to inform the sales team about client engagement which helps the sales to get leads.
  • To get data from various disparate sources and to have a holistic view of the marketing activities.
  • To provide sales with leads weekly or monthly based on their marketing engagement.
  • To analyze the CRM systems like Pardot & Salesforce to create a list of customers for targeted email campaigns.
Alteryx is well suited for joining data from disparate sources. The data should be in a continuous format. In most situations, there should be a common field between various datasets. It can help to provide an overview of systems and create reports for senior management. It can also connect to back end data repositories and collect information. It can also read large sized spreadsheets in a matter of seconds.
Read Karan Gupta's full review
Aditya Singh profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Alteryx is used across my organization and in almost all data related projects. I started with Alteryx in the year 2016 to automate my 100's of excel workbooks and the macros used in them, there was bad data coming from different sources and I had to clean it. Alteryx helped me to automate all my work and reuse the workflows whenever required which used to take hours/days. The processes which used to take couple of days to execute, I was able to complete them and get output just in 1 hour.
  • Clean any data
  • Data wrangling
  • Predictive analytics
  • Spatial Analytics
It can help anyone to clean and combine any data from any sources, create reusable workflows and can be shared through Alteryx gallery. This is something which everyone should try to make their life easy and be productive.
Read Aditya Singh's full review
KANTHESH M.D profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source
I have been using Alteryx for a year. In our organization, we use Alteryx to build a data model by cleansing data, shaping our data and doing advanced analytics with our data. In the analytical department, we are using Alteryx to analyze our data. We were unable to get insight and manipulate the data so, we adopted this tool to get more insight and do analytics to our data.
  • Blending multiple data into one data set.
  • Alteryx is great for doing Spatial analysis with data.
  • Alteryx perfectly integrates with other application or data sources.
Alteryx is best suited in the places where you need to present your data in the form of raw data. For example, in scenarios where you want to shape and clean your data and fed the data into other application. Alteryx is less appropriate in the places where the end result should be in a well-finished dashboard. For example, in places where the user is expecting to see his data in the form of chats or in picturization form.
Read KANTHESH M.D's full review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it for data preparation and blending. Its drag and drop makes the process easy, and its robust engine makes the data run quickly. We are using it in almost all the teams, and we see it as one of the most important tools for our analytics process.
  • Macros are a lifesaver. You can just write a set of logics, create a macro, and use it in any flow and any number of times.
  • Data Connectivity for SQL is super easy, and it's powerful.
  • Scheduling the flows and reporting. I use it to schedule the flows in off business hours so that I can get the data ready for the next day.
Well Suited:
If you are a non-techie and want to get started with Data Analysis.
If you want to handle large data and process it quickly.

Not Well Suited:
If you are a small startup and looking to not shell out money on analytics tools. The tool is a bit expensive.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Alteryx is used by the few specific departments but they impact the whole organization in business making decisions. It is used majorly to manipulate the data available and to create a statistical analysis. Alteryx is also used in data mining and forecasting techniques, with the help of R coding it is a flexible tool that can help better interpret the data. Sales forecasting and data preparation for resource allocation are the most crucial jobs getting done.
  • Data mining: data can be manipulated easily and completely replace excel formulas.
  • Forecasting: It has inbuilt statistical models that can serve basic forecasting very well, moreover one can also manipulate the R coding that can help with complex data.
It's well suited to data mining; lots can happen with Alteryx, and the time it requires to provide results is greatly low.
It's less appropriate to BI tools are required for even basic graphs and charts.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Alteryx is the primary ETL/analytics tool being used by our BI users. Alteryx is particularly popular because of its ability to create a Tableau data extract and thus provides a meaningful alternative to Tableau's missing data blending capabilities. Alteryx offers a range of tools that can be used to clean/prepare your data for analytics along with ETL capabilities. Alteryx has some amazing analytics capabilities including but not limited to spatial, behavioral, predictive etc.
  • 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 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
Read this authenticated review
Susan Knolla profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Our organization began using Alteryx sometime ago however my team was introduced to it approximately 3 months ago. It is used to support data analytics work in all areas in addition to report preparation. We are attempting to drive the usage of this tool across the organization as it is a cost and time saver in the preparation and analysis of data for every department/business.
  • Excellent support for the tools through training/white papers and online support.
  • Ease of use - high common sense factor makes the program easy to learn and apply.
  • Compatibility with everything but specifically with commonly used key programs like Tableau.
I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.
Read Susan Knolla's full review
Rohit Narang profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Within the Credit Risk Model development space, we use Alteryx to create time series models for PD, LGD and stress testing to compute VaR. It is also used by our predictive analytics department, but some use is spreading out to our data teams given the user-friendly interface and its ability to handle big chunks of GLM simulation for errors in data. It is also suited for a wide range of ETL things, from data cleansing to general data manipulation that helps answer a client's day-to-day questions. All in all, it's a great tool for working with advanced statistics.
  • Seamless Data Input (Ingestion): Alteryx is capable of connecting with many data sources, we have used Tableau in cloud-hosted solutions with additional support of OleDB & ODBC connections.
  • Advanced analytics: We have used statistical analytics tools which 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.
  • Macros: Just like other tools (e.g. SAS), Alteryx builds a macro. Be it a batch or iterative, it can save loads of efforts for standard and recursive processes. We've built numerous macros and use at least 10+ in every workflow post design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
It's a good tool for working with huge sets of data. Very well suited for geographic and data analysis. Fantastic for combining data from multiple sources into one and writing data and reports out in Excel, PowerPoint, Access, text files, and even several GIS platforms. It is easy to write data in multiple files/slides/databases.
Read Rohit Narang's full review
Kunal Sonalkar profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Alteryx Analytics is used by our corporate analytics team. We design dashboards, build predictive models, and deploy them on the server. This helps executives to make data-driven decisions across the board.
The dashboards developed by Alteryx are generally associated with financials, employee performance, staff scheduling or any other area where we feel data analysis can improve the results significantly.
  • Designing dashboards is very easy and intuitive in Alteryx. Although some form of analytical aptitude is needed, most of it is very user friendly.
  • Embedding R or Python Code is fairly straightforward in Alteryx. This makes it very sophisticated for data analysis and predictive data modelling.
  • Effective mathematical calculations-- which are difficult to code in SQL-- are very easy to write in Alteryx.
Alteryx Analytics is very well-suited for areas like data analysis, designing dashboards, embedding basic mathematical models in the system and establishing data driven decision-making across the firm. In areas like healthcare, finance, insurance, banking, sports, etc where we have immense amounts of data, Alteryx can play a major role in helping people opt for a data-driven decision mindset.
It might not be a very good solution for areas like ETL (Extract Transform Load). It would be interesting to see if Alteryx diversified in that area as well.
Read Kunal Sonalkar's full review
Spencer Lewis profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Hard to pin down as a single use case since this can be so broad. Alteryx is used in almost any analytics capacity to figure out financials and operations problems. More specifically we found Alteryx useful for connecting vendor metrics with underlying date; we're using buyer spend over time as an enhancement for material and payables resource planning, and our logistics team uses it to track the efficiency of carriers and shipping lanes.
  • Objective analysis
  • Process build
  • Data integration
Operations, business intelligence, Supplier performance, logistics, production bottlenecks. Essentially any case where information across departments is needed, we really see Alteryx being the go-to for objective dialogues. Previously, these departments were having subjective narratives on how to solve business problems, because the data was too difficult to connect and makes sense of. With Alteryx, the focus is on "What does the data show that are good options to change a business process?"
Read Spencer Lewis's full review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
We continue to grow our organization's use of Alteryx. Alteryx Designer started as a solution being used by one department and has now grown as an Enterprise tool. Many of the common use cases for us include data integration and predictive analytics.
  • Alteryx does a great job of allowing more beginner Analysts to automate many of their routine process but also allowing advanced Analysts to ability to leverage deep statistical modelling for predictive analytics.
  • Given the visual workflow nature of Alteyrx, the learning curve is not steep.
  • The Alteryx Gallery allows non-technical consumers to execute complex workflows by leveraging an intuitive web interface.
  • Alteryx allows data scientists to bring their own programming language to Altyerx, such as R or Python.
Alteryx is well suite for data integration /automation use cases as well as deeper predictive modeling. Alteryx is not a visualization tool. There are many connections and integrations to more robust visualization platforms.
Read this authenticated review
No photo available
November 02, 2018

Data prep standard

Score 6 out of 10
Vetted Review
Verified User
Review Source
Currently, Alteryx Analytics is being used by a select group of employees in our center of excellence, the total number being around 4 or 5 active users with 10 other licenses allocated based on immediate need.
  • Data blending
  • Data prep
  • Data exploration
Alteryx Analytics is suitable for less technical users who do not have coding experience, you can gather information rather painlessly; however, it is still not quite as good as using a language such as Python or R to integrate your advanced analytics work.
Read this authenticated review
Clinton Shields profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Alteryx for data prep, cleaning and analytics, to funnel data into Tableau. Used solely in our analytics department.
  • Makes automating data cleaning a breeze.
  • Data prep becomes a fun activity with Alteryx.
  • Analytics becomes more of a focus, as Alteryx is doing the heavy lifting.
Pulling data from databases and preparing for data visualization is our primary use for Alteryx, however if you have perfect data, Alteryx can get redundant, but honestly who has that.
Read Clinton Shields's full review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
My team has been running Tableau reports for clinicians, researchers, and leadership in our organization. As we have developed more reports we had strong needs of managing data pipelines in a systematic way. In many cases, ETL processes were managed individually by data developers and analysts and there were issues of report ownership, data consistency, and management issues. We adopted Alteryx and automated two types of processes: ETL processes and Tableau data extract creation. Alteryx provided values in terms of systemized pipeline management and query performance.
  • 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.
Well suited: if an organization already has a lot of running ETLs or pipelines but need to systemize them, Alteryx is a good choice. It would be good to figure out how well Alteryx would be harmonized with the existing components, but in a general sense, it may be well harmonized.

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.
Read this authenticated review
Cameron Tubbs profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Alteryx is predominantly used by our predictive analytics department, but some use is spreading out to our data teams given the user-friendly interface and its ability to handle "big data". We also use it for some internal tools that allow other departments, who may not be as familiar with the product, to run reports and gather data specific to our processes that allow them to more easily do their internal reporting. Alteryx is used for a wide range of things, from data cleansing to general data manipulation that helps answers a client's day-to-day questions, all the way to report automation and "wizarding" that provides clients with their solution(s).
  • 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.
More often than not, Alteryx can handle any situation or scenario thrown at it. Some may take a little more "trickery" along the way, but for the most part it is fairly easy to get from point A (data) to point B (results/report). And the nice thing is is that there is more than one way to produce the same result - two people with two different mindsets can ultimately create the same thing, but do so in a way that is better suited for their skill level.
Read Cameron Tubbs's full review
Sanket Bharaswadkar profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
We used Alteryx for analyzing pre-sales data. We had a proposal management system which generated a lot of numbers. My job as a process analyst was to use Alteryx to get insights into making the process efficient. It helped us in identifying bottle necks and focusing on problem areas.

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
It is very well suited for mid-sized data operations. One person working on a project is ideal. I have not used Alteryx in a collaborative project, so can't say for sure. It is quite powerful and compares well with the competitors. If you have data from disparate sources, it helps to have a tool like Alteryx.
Read Sanket Bharaswadkar's full review
Joe Root profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Alteryx use began in the marketing department to help automate data prep pre-Tableau from data sourced from Salesforce. It is now also being used by the IT department to help join multiple data sources to automate data munging for some standard report generation. The primary business problem Alteryx helps our team with is helping analyst move much more quickly by building data workflows visually instead of creating hundreds to thousands of lines of code to move and prep the same data.
  • 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.
Alteryx can do so much more than I use it for, so I believe the only case where Alteryx wouldn't be needed is when a department/team had a full development team to prep data pre-analysis or already has a central data store fully stood up and standardized. Alteryx works extremely well with a multitude of BI and database solutions and would be a great fit for any team trying to speed up the typical daily grind of data prep and ETL so their analytics and data team can be more agile, accurate, and automated.
Read Joe Root's full review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
Alteryx is being used into its full potential to collect data, bend and prepare, analyze/summarize as well as create automation workflows, what-if analysis toolkits, and to do statistical modeling of data. It has simplified the way analytics used to be done as well as taken the same to the masses.
  • Quick data blending.
  • Wide range of analytical coverage - ETL, Descriptive and Predictive analytics.
  • Ease of learning for new users.
Most suited: Teams involved in BI and reporting can do data analysis, blending and analysis really quickly as well as do the statistical analysis and expand the horizon of analytics into the organization with ease.

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.
Read this authenticated review
Rana Banerji profile photo
October 10, 2016

Alteryx for many things

Score 9 out of 10
Vetted Review
Reseller
Review Source
We use Alteryx for data cleansing, prep and analytics across sales and marketing functions, i.e. blending CRM, Excel and MailChimp data.
  • 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 is suited for many, many use cases and scenarios - too many to mention.
Read Rana Banerji's full review
Darrell Haley Jr. profile photo
September 11, 2015

Organization made easy.

Score 9 out of 10
Vetted Review
Verified User
Review Source
We specifically use Alteryx for data blending. Due to our multi-sourced approach, we receive multiple data sources in aggregate and find value in combining them into a database. It helps us gain intelligence on specific client-related asks in a simple, easy to use format. It really allows us to stay agile and manipulate data at a fast pace, something that is lacking in Excel alone.
  • Blend multiple sources of data
  • Append or update existing data
  • Allows for powerful insights for non-technical users
It is great for dealing with mass quantities of data, not so good if you're trying to analyze. If you're dealing with 50k+ records, then it probably is considerably faster to deep-dive into the data with Alteryx. However, for anything under that, Excel is the better program for visually finding patterns and trends in data, at least for someone who has a limited tech background.
Read Darrell Haley Jr.'s full review
Tran Huynh profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Salesify’s products arm data-driven marketers and sales professionals with critical B2B Customer and Business Intelligence. We provide millions of high quality, relevant companies and contacts at the tip of your fingers with the help of our customer data analysis. All the data team is using Alteryx now to process tons of raw data to filter, cleanse and append relevant information based on customer requests. Its super fast processing performance helps us reduce considerable times of running big queries, opening large files and combining different sources.
  • Automation macros
  • Query simultaneously across instances
  • Process big files
  • Output multiple file types
Ask about documentation, maintenance and support.
Read Tran Huynh's full review

Feature Scorecard Summary

Pixel Perfect reports (2)
5.0
Customizable dashboards (21)
5.8
Report Formatting Templates (2)
5.0
Drill-down analysis (27)
7.1
Formatting capabilities (29)
7.5
Integration with R or other statistical packages (27)
8.6
Report sharing and collaboration (27)
7.5
Publish to Web (26)
7.6
Publish to PDF (24)
7.0
Report Versioning (2)
4.0
Report Delivery Scheduling (27)
7.9
Delivery to Remote Servers (1)
9
Pre-built visualization formats (heatmaps, scatter plots etc.) (2)
6.0
Location Analytics / Geographic Visualization (25)
7.5
Predictive Analytics (25)
8.0
Multi-User Support (named login) (2)
8.0
Role-Based Security Model (2)
8.0
Multiple Access Permission Levels (Create, Read, Delete) (2)
8.0
Single Sign-On (SSO) (1)
8
Responsive Design for Web Access (1)
4

About Alteryx Platform

The Alteryx Platform 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 Platform Features

BI Platform Features
Has featureAdministration via Windows App
Does not have featureAdministration via MacOS App
Does not have featureAdministration via Web Interface
Has featureLive Connection to External Data
Does not have featureSnapshot of External Data
Has featureIn-memory data model
Does not have featureOLAP (Pre-processed cube representation)
Does not have featureROLAP (SQL-layer querying)
Has featureMulti-Data Source Reporting (Blending)
Does not have featureData warehouse / dictionary layer
Has featureETL Capability
Has featureETL Scheduler
Supported Data Sources Features
Has featureMS Excel Workbooks
Has featureText Files (CSV, etc)
Has featureOracle
Has featureMS SQL Server
Has featureIBM DB2
Has featurePostgres
Has featureMySQL
Has featureODBC
Has featureCloudera Hadoop
Has featureHortonworks Hadoop
Has featureEMC Greenplum
Has featureIBM Netezza
Has featureHP Vertica
Does not have featureParAccel
Has featureSAP Hana
Has featureTeradata
Does not have featureSage 500
Has featureSalesforce
Has featureSAP
Has featureGoogle Analytics
BI Standard Reporting Features
Does not have featurePixel Perfect reports
Has featureCustomizable dashboards
Does not have featureReport Formatting Templates
Ad-hoc Reporting Features
Has featureDrill-down analysis
Has featureFormatting capabilities
Has featurePredictive modeling
Has featureIntegration with R or other statistical packages
Has featureReport sharing and collaboration
Report Output and Scheduling Features
Has featurePublish to Web
Has featurePublish to PDF
Has featureOutput Raw Supporting Data
Does not have featureReport Versioning
Has featureReport Delivery Scheduling
Does not have featureDelivery to Remote Servers
Data Discovery and Visualization Features
Does not have featurePre-built visualization formats (heatmaps, scatter plots etc.)
Has featureLocation Analytics / Geographic Visualization
Has featurePredictive Analytics
Does not have featureSupport for Machine Learning models
Does not have featurePattern Recognition and Data Mining
Has featureIntegration with R or other statistical packages
Access Control and Security Features
Does not have featureMulti-User Support (named login)
Does not have featureRole-Based Security Model
Does not have featureMultiple Access Permission Levels (Create, Read, Delete)
Does not have featureReport-Level Access Control
Does not have featureTable-Level Access Control (BI-layer)
Does not have featureField-Level Access Control (BI-layer)
Does not have featureSingle Sign-On (SSO)
Mobile Capabilities Features
Does not have featureResponsive Design for Web Access
Does not have featureDedicated iOS Application
Does not have featureDedicated Android Application
Does not have featureDashboard / Report / Visualization Interactivity on Mobile
Application Program Interfaces (APIs) / Embedding Features
Does not have featureREST API
Does not have featureJavascript API
Does not have featureiFrames
Does not have featureJava API
Does not have featureThemeable User Interface (UI)
Does not have featureCustomizable Platform (Open Source)

Alteryx Platform Screenshots

Alteryx Platform Integrations

Alteryx Platform Competitors

Pricing

Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Has featurePremium Consulting/Integration Services Available?Yes
Entry-level set up fee?No
On-premise EditionPricing DetailsTerms
Alteryx Designer3,995per user, per year
Alteryx Designer with Spatial12,995per user, per year
Alteryx Designer with Data29,995per user, per year
Alteryx Server45,000per server, per year
SaaS EditionPricing DetailsTerms
Alteryx Analytics Gallery1,500per 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 Platform Support Options

 Free VersionPaid Version
Phone
Email
Forum/Community
Social Media
Video Tutorials / Webinar
Training

Alteryx Platform Technical Details

Deployment Types:On-premise, SaaS
Operating Systems: Windows
Mobile Application:No
Supported Languages: English, French, German, Brazilian Portuguese