Alteryx is a good tool for analytics productivity
April 30, 2018

Alteryx is a good tool for analytics productivity

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

Overall Satisfaction with Alteryx Analytics

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.
  • 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.
We did not do any comparison of Alteryx with other tools, but before Alteryx we used Sandbox tables in our databases. It caused a lot of issues in terms of data consistency, workflow automation, and patient data privacy and security. Using Alteryx resolved a lot of the issues.
Alteryx provides good data connections to most of existing commercial or open source based data sources. Most of the cases it works well based on our experience. It may be needed to provide an enriched knowledge base or online communities to cover troubleshooting and technical solutions from Alteryx. Comparatively, Tableau has very, very strong online resources and active discussions in communities.
Although Alteryx Analytics gallery is provided, our department didn't have a chance to use it, as we're a healthcare organization and may be very sensitive due to patient privacy laws. But we integrated the tool into both desktop and server-side with our LDAP system so that we can track authorship and ownership of Alteryx workflows. The integration went very well.
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.

Alteryx Feature Ratings