Data Preparation at Its Best
October 06, 2021
Data Preparation at Its Best
Score 10 out of 10
- Alteryx Connect
- Alteryx Analytics Gallery
- Alteryx Scheduler
Overall Satisfaction with Alteryx
We use Alteryx for significant database scrubbing, development of reporting tables, and scheduling of recurring reports for end-users. The program has allowed us to move away from using [Microsoft] Excel to prepare data for use in reports. Additionally, the scheduling capabilities have allowed us to automate a number of reports that used to require the intervention of a DBA or other business user to generate on-demand. Not only has this freed up resources for other purposes, but [also] has allowed the teams requiring these reports to be much more nimble. The fact that Alteryx is so user-friendly for those without a strong background in SQL or other database languages has allowed for certain reporting functions to be handled at a level that otherwise wouldn't be possible. This has [a] broad reach within our organization, from Finance to Operations to Marketing. Ad-hoc analyses that used to require stringing together multiple Excel sheets, spending time vlookuping all day, and slogging through slow response times have become much faster - ultimately allowing answers to be found faster than before.
- Makes database functions accessible to all users
- Automate reporting functions fairly easily
- Performs tedious data scrubbing with ease
- Response time on really large data sets can be long.
- Some tools, like address verification, require additional costs.
- Entrance into Alteryx Server is highly expensive and not viable for smaller companies, thus limiting some functionality.
- Reduced time to respond to operational issues
- Allowed for better dashboard creation, more detailed information
- Provided ability to join very disparate data sources - survey with transactional
Do you think Alteryx delivers good value for the price?
Are you happy with Alteryx's feature set?
Did Alteryx live up to sales and marketing promises?
Did implementation of Alteryx go as expected?
Would you buy Alteryx again?
Generally a very user-friendly interface. Sometimes for complex SQL queries at the data source, it can be a little clunky to develop in the interface. Overall very happy with how things output and the flexibility of options. It would be nice to have a little more flexibility with scheduling options inside the interface.
The support used to be much more hands-on and responsive back in the day before they grew to what they are now. It was very common to work with engineers directly to resolve stubborn problems with the interface. Now, you just get front-line support reps who, while nice, really can't solve a lot of the issues that come up [in my opinion].
Alteryx is a real game-changer for small to mid-sized companies, especially [those] that lack an army of database engineers available to create tables/views at a moment's notice. Alteryx can allow end-users to access data and manipulate it to get answers to questions as a self-service model, which can make the tool very valuable in the right hands. The interface can be a little overwhelming and daunting to use at first, but if you are system-oriented and can handle basic SQL commands, you should find it very easy to pick up. There are some basic visual reporting tools available via Alteryx, but to really create dashboards, you're probably looking at pairing it with a Tableau or Power BI.