Alteryx vs Microsoft SQL Server

• Alteryx does a great job of allowing more beginner Analysts to automate many of their routine process but also allowing advanced Analysts to ability to leverage deep statistical modelling for predictive analytics.
• Given the visual workflow nature of Alteyrx, the learning curve is not steep.
• The Alteryx Gallery allows non-technical consumers to execute complex workflows by leveraging an intuitive web interface.
• Alteryx allows data scientists to bring their own programming language to Altyerx, such as R or Python.

Read full review

• Good range of data types helps us store lots of diverse data
• Easy administration helps us control who has access and what they can do with the data
• Backup and restore processes are easy to manage and provide good security
• Data can be easily replicated from Server to Server for use in other countries

Read full review

• 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.

Read full review

• Enterprise is unbelievably expensive.
• Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
• Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).

Read full review

• Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
• For visualization purposes I had to move the data to excel for some decent graphs.
• It can become very expensive.

Read full review

• With just one server we can easily host databases for many applications, which makes it easier to maintain.
• The ROI on Microsoft SQL Server is very good as we have been able to set it and forget with out too much time invested in keeping it up and running.
• The Microsoft SQL Server down time has been minimal and 90% of the downtime is due to our user error.

Read full review