Our office is trying to decide whether to keep investing in Alteryx. We currently have tried Alteryx, IDEA, PowerBI and in my previous job, I tried Arbutus, which is similar to ACL.
Our needs are basic data analysis and visualization such as top spender, duplicate transactions, transactions of certain characteristics, key-word search. (i.e. no machine learning, no predictive analysis).
Our experiments of tools find that Alteryx seems to require a lot of steps and logics to achieve basic analysis goals and do not seem to be as user-friendly compared to IDEA or Arbutus/ACL. It does not have strong visualization capability compared to PowerBI. Yet it is way more expensive than other tools. The only benefit of Alteryx is that it is more visually appealing in terms of documenting workflow but I wonder if it's worth paying $4500 more and spending longer human time on basic analysis goals just for this benefit.
Maybe I am missing something? Maybe I don't truly understand the advantage and beauty of Alteryx? Can anyone share their thoughts on this? Why do you choose Alteryx over other tools? Or do you think Alteryx is not worth it unless predictive analysis and machine learning are desired?
(Optional Details)
This is the details of what we found.
Visualization and data exploration: PowerBI and even Excel are better than Alteryx. In both PowerBI and Excel, it's easier to make a quick filter on data to check something and it's easier to make a bar chart compared to Alteryx where you have to run the workflow every time you want to check anything.
Duplicates: IDEA is better than Alteryx. IDEA has dedicated function that allows you to identify duplicates based on keys and even allows you to identify duplicates that share certain characteristics but also are different in one key field (e.g. transactions of same amount, date, but of different vendors). In Alteryx, in order to find duplicates, I need several steps to summarize and join back original data. In order to find duplicates that are of same amount/date but different vendor, Alteryx requires 3-4 more steps and involves writing formulas and arranging data in certain ways, very complicated.
Others pointed out in the past too that in IDEA and ACL you can do all kinds of fuzzy match and there are dedicated functions for that. In Alteryx, I have never tried but I bet it involves a complicated formula.
Transactions of certain characteristics: Fair game of any tool. Every tool can achieve this easily.
Key-word search: Didn't find any dedicated tool of Alteryx that enables key word search of multiple key words. Alteryx probably requires a long formula or a join of keyword table with additional formula to achieve this. Arbutus has a dedicated function for it that can be done in one step.
Other areas such as supported data source, data type, output file type, are fair game of any tool. Nothing special of Alteryx.
Data download from database: Alteryx is quicker than PowerBI, but similar speed as dedicated database SQL editor.
Interface and documentation of workflow: Alteryx is better than other tools in terms of showing the workflow visually. I don't think PowerBI documents workflow very well. Arbutus documents workflow in codes, which is not user-friendly. I don't know how IDEA/ACL documents workflows.
Price: Alteryx is 10X more expensive than any of the tools mentioned.
