Most popular features of all Business Intelligence & Analytics apps
25 reviewers had the following to say about Alteryx's features:
Business problems like considation, analytics, dashboard and reporting can be made very convenient
Pros
Seamless integration with excel, database other sources Good reporting options
Cons
Lack of customer service Not able to read excel files with macro enables format correctly
Rating breakdown
Time used: 1-2 years
Frequency of use: Daily
Likelihood to recommend
Pros
Easy to use UI, just drag and drop tools and start your data modelling.
Cons
Integration with other tools are less compared to its competitor tools such as Informatica .etc.
Rating breakdown
Time used: 2+ years
Frequency of use: Daily
Likelihood to recommend
Massive time saving on Analytical function as well as improvement in accuracy with data from disparate data sources
Pros
Ease of deployment in 'non-analytics' environment was a big enabler.
Cons
The cost initially seems exorbitant - especially as there are alternatives such as KNIME & Rapid Miner. Value delivered however overcame this barrier.
Rating breakdown
Time used: 6-12 months
Frequency of use: Weekly
Likelihood to recommend
Our experience with this product is that it has transformed our ability to analyse, consume, and report on our data in a way that make sense to the business.
Pros
Alteryx is an incredible powerful analytics tool that allows users to input source data, manipulate, clean and transpose that data, then output into a Datawarehouse or other database.
Cons
Still lacks some basic functionality, like an in-built tool for creating SQL views or a tool that can run multiple workflows in sequence (like Crew macro).
Rating breakdown
Time used: 2+ years
Frequency of use: Weekly
Likelihood to recommend
Amazing tool for process automation and integration
Pros
Easy to debug (easy to track and monitor the workflows while it is running) Can Integrate "R" code with Alteryx Alteryx provides variety of features for text data cleaning (including fuzzy matching, regular expressions and table joins) Without much coding alteryx provides machine learning for predictive analytics (drag and drop features)
Cons
At times Alteryx is slow in responding Expensive tool Not good for data visualization Very few training videos
Rating breakdown
Time used: 1-2 years
Frequency of use: Weekly
Likelihood to recommend
It was nice, I have been automating excel user tools with it
Pros
It provides a no. of tools for data blending, data sorting, data extraction , generating reports and emailing them.
Cons
Nothing much I dislike, the only thing I disliked is that we have to use visual tool to view data every time, that slows the running time of the workflow.
Rating breakdown
Time used: Less than 6 months
Frequency of use: Daily
Likelihood to recommend
We used to spend a lot of time in Excel and SQL queries trying to get the data right for reporting, plus if there was anything more complex involved such as forecasting or predictive model building to do, we'd have to find an R expert which really slows the process down.
Pros
Easy to use interface, extremely flexible for data analysis tasks, self-documenting, very fast on large data sets
Cons
Automating workflow is an additional cost
Rating breakdown
Time used: 2+ years
Frequency of use: Weekly
Likelihood to recommend
So much time saved Easy to share documentation without worrying about syntax, coding and verfication Trainable to a layman analyst
Pros
Drag and drop interface, the ability to manipulate my data at any point and expand my analytics through spatial and predictive.
Cons
The Server solution could be better developed to be ready to integrate with other enterprise wide features (for example, managing users, databases, schedules)
Rating breakdown
Time used: 2+ years
Frequency of use: Weekly
Likelihood to recommend
Pros
Ability to import data from and export data into variety of data sources 3.
Cons
Lack of (or limited) visualisation capability. 2.machine dependent licensed(it should had license key Linked to email ID, making it easier to port licensed from one system to another) 3.
Rating breakdown
Time used: 2+ years
Frequency of use: Daily
Likelihood to recommend
This software, especially the predictive analytics piece, gave me new insight into my data.
Pros
An abundance of available nodes make it simple to pull in data from many different sources, merge, union, filter, sort, and even perform statistical or predictive analysis on your data, and then disseminate it to the proper stakeholders.
Cons
Alteryx may be better suited to fields other than education; however, I can still find good use cases for it in my job.
Rating breakdown
Frequency of use: Occasionally
Likelihood to recommend
I have not used the analysis and ML capabilities that it offers, but for my use case, I find it very helpful.
Pros
It's possible to connect to a wide variety of data sources. Also, It offers visual and table data to help you visualize the results and profile the data you're using.
Cons
There's a learning curve to understand all the components that Alteryx offers. However, there's great documentation out there to learn.
Rating breakdown
Time used: 6-12 months
Frequency of use: Weekly
Likelihood to recommend
Pros
This tool's ease of use allows our non-analytical teammates to easily do basic data analysis by themselves, freeing up our analytics team for more technical questions
Cons
For those who are unfamiliar with self-serve/point-and-click analytics tools, the software can be a little overwhelming for the first few hours
Rating breakdown
Time used: 6-12 months
Frequency of use: Weekly
Likelihood to recommend
It helps clean data, and make things easier to read for once you get to the visualization stage of the data analysis process.
Pros
I like being able to quickly manipulate data and create new rows and columns with ease, making the data easier to read as well as adding new factors into data sets.
Cons
I dislike how it can be at time cumbersome when one creates complex workflows that take over an hour to load just once.
Rating breakdown
Time used: 6-12 months
Frequency of use: Daily
Likelihood to recommend
With the power of automation, I have more time for analyzing results instead of spending a great deal of time generating reports.
Pros
It features a vast array of icons called tools, each of which has a specific function such as importing data, filtering based on criteria, summarizing, merging information and so forth.
Cons
I prefer to use Designer to produce my final data result set and export to Excel where I can then take advantage of Microsoft Office formatting and presentation options.
Rating breakdown
Time used: 6-12 months
Frequency of use: Monthly
Likelihood to recommend
Alteryx is a good tool and well fits in our need of clinical data management and analytics pipeline optimization.
Pros
Alteryx is a great tool when need of integrating multiple or complicated analytics pipelines in one place and manage them in a systematics manner.
Cons
The desktop application used to crash (not responding) in case of loading large sized data. It also gets very slow when moving or drag-dropping objects in the authoring environment.
Rating breakdown
Time used: 2+ years
Frequency of use: Weekly
Likelihood to recommend
I'm a Technology Consultant, using ALteryx for ETL projects where analyse the data is a critical job and the size of the data, wouldn't allow me to use tools like excel .
Pros
Built in tool like time Formaters, filters and Joins facilitate the work of doing data cleansing and data prepping for any ETL job.
Cons
The least I like is the price and the latency when loading the data. Because is a strong and powerful Tool, it is a bit pricey in one hand, is not a tool for one day job, is more for enterprise and daily jobs.
Rating breakdown
Time used: 6-12 months
Frequency of use: Daily
Likelihood to recommend
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.
Pros
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.
Cons
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.
Rating breakdown
Time used: 1-2 years
Frequency of use: Daily
Likelihood to recommend
This is a great data handling software.
Pros
There is basically a module for doing everything Connectivity in both inputs and outputs is simply superb
Cons
Output to PDF to export reports might need better capabilities Documentation of less used features might be insufficient compared to most commonly used features
Rating breakdown
Time used: 2+ years
Frequency of use: Daily
Likelihood to recommend
Pros
I can do a simple data pull to a demographic report to doing regression analysis for a complex model.
Cons
The only small complaint I have is that some of the error messages themselves are cryptic and convoluted.
Rating breakdown
Time used: 2+ years
Likelihood to recommend
Recommendations to others considering Alteryx
If you have a need for automation, data compilation and data reporting, this is a very diverse tool that can revolutionize your efficiency and give your analysts more time to think critically rather than be bogged down by menial tasks.
Alteryx is one of the fastest & easiest softwares to use for data processing, data modeling, and data visualization.
Pros
Processes massive amounts of data very quickly, even on a desktop/laptop.
Cons
With the frequent releases, there seems to be more (minor) bugs than in the past when releases weren't so frequent.
Rating breakdown
Time used: 2+ years
Frequency of use: Daily
Likelihood to recommend
It solved our business need plus so much more.
Pros
It is great for working with large data sets that can't be easily managed in excel or access and for allowing multiple data sources to interact with each other.
Cons
Also there are so many tools and more than one way to achieve the same thing.
Rating breakdown
Time used: 1-2 years
Frequency of use: Daily
Likelihood to recommend
It allows me to provide analysis in a simple way, be creative in how I manipulate the data and even create automated running of the workflow.
Pros
Alteryx has a fantastic interface, using function blocks that you can drag and drop to create a workflow.
Cons
The license cost for the tool is very high, which means not everyone can use it.
Rating breakdown
Time used: 2+ years
Frequency of use: Daily
Likelihood to recommend
Pros
I loved how quickly the user is able to learn this software. The tools are in the form of images and are extremely intuitive and helpful.
Cons
It's not possible to run just a small portion of a project without loading all the data back in again.
Rating breakdown
Time used: Less than 6 months
Frequency of use: Weekly
Likelihood to recommend
Pros
. - Ability to enhance the data by applying statistical models, available public data, etc. - UI interface is very intuitive with drag and drop components
Cons
- Hard to scale (Best use case is for individual projects) - Expensive to use, high license cost
Rating breakdown
Time used: 2+ years
Frequency of use: Weekly
Likelihood to recommend
I like Alteryx as a data mulipulation tool but it's also very diffult to learn.
Pros
Because you're creating the workflow, each of the steps are easily auditable and you can swap out the source files when it changes.
Cons
It's hard to get started without some sort of live tutorial from someone that has been using it for a long time.
Rating breakdown
Time used: 1-2 years
Frequency of use: Occasionally
Likelihood to recommend