Great One-Stop Shop for Analysis
March 26, 2014
Great One-Stop Shop for Analysis
Score 10 out of 10
Vetted Review
Verified User
Software Version
8.6
Overall Satisfaction
We use Alteryx in a multitude of ways. We use it to generate geo-spatial variables for regression models as well as reporting. We also use Alteryx for internal analysis and data manipulation.
- Alteryx is very easy to learn. It's really good at handling very large datasets and allows users the flexibility to manipulate data in many ways.
- The user support is very helpful for Alteryx. The client services reps are very nice and always helpful when you have questions.
- The analytic tools have made the software more well rounded as an end to end solution.
- The R tools, although a very nice addition, are not easily modifiable so they can be somewhat limited in flexibility.
- The mapping and graph/charting tools continue to be a drawback for Alteryx. We'd love to use Alteryx as the all in one stop shop solution for analysis, mapping, and reporting but it's maps and charts can't hold a candle to Excel Charts or Mapinfo/ESRI maps.
- Processing speed is hit or miss depending on the size of what you're running through it. Generally, Alteryx is great at this but in cases where you're needing to process large data on the fly, things can take hours or days to run. This may not be easily resolvable but in much of our investigations, it seems like how Alteryx maybe could handle processing and optimizing the machine it's run on better. For example, a Quad-Core processor machine with 16GB of Ram may only use a quarter of it's threads to run Alteryx processes so we don't realize noticeable speed gains when run large jobs on our power boxes compared to smaller machines.
- Alteryx has significantly improved employee efficiency. It's helped reduce turnaround time by ~30% already and we expect this to to do more as we leverage more of the tools.
- Alteryx has also been used to automate repetitive processes to free up employees to focus on more of the analytical tasks.
- The only negative to the business impact is how licenses are handed. They often expire without notice and can negatively affect clients.
- sas,Microsoft Access,SQL,Excel
Other tools that have been used include SAS, MS Excel, MS Acess, PLSQL, and MapInfo. Alteryx is the best single source to get many thing completed. I feel that SAS, being primarily an Analytical Suite, is better and more powerful and customizable than alteryx when it comes to modeling but has a bigger learning curve. Excel is faster and provides instant results (cells change as you make changes without having to be "run") but isn't close to as powerful or equipped to handled big datasets. Same thing with SQL, it's less work to do a query in SQL Developer but alteryx is much faster at processing the data. Mapinfo's maps look better but there's a bigger learning curve to use it than Alteryx.
All in all, Alteryx is the overall best solution.
All in all, Alteryx is the overall best solution.