1. Home
  2. Data Analytics and BI Services
  3. Alteryx Reviews
  4. User Review of Alteryx
Great for blending large data sets
August 22, 2019

Great for blending large data sets

Karan Gupta | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Alteryx Analytics

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.
  • 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.
Alteryx has a better interface than KNIME, though it's a bit more expensive than KNIME (an open source tool). We cannot use open-source software due to data privacy issues, and this is why we selected Alteryx. Alteryx also had an agreement with Macquarie and provided a discount on the purchase of ~10 licenses.
As I stated previously, Alteryx is good for merging data from disparate sources and can run a large set of datasets in a quick time. Its a great tool for an analyst as it saves a lot of time spent on coding and allows functions like join,union at the click of a button. It also allows you to create additional fields in your dataset and perform computations. The only area where it lacks is the visualization perspective.
It's easy to share workflows in Alteryx, but you might have to use Alterxy server tool which is separate software from the same company. We do not share workflows at this point.
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.

Alteryx Feature Ratings