Likelihood to Recommend For doing ETL and data transformations where your data is already in a cloud environment Alteryx Designer Cloud is ideal. It allows for the continued democratisation of data and analytics to permeate more extensively throughout a business, particularly those that are already in the cloud or have cloud services in place and are comfortable with procurement and consumption of these systems over and above desktop software. The ETL processing for data validation and wrangling uses machine learning to enable highly efficient data manipulation which saves lots of time and this is a distinct advantage over the desktop software. The expansion and integration of other Alteryx cloud services such as ML, Metrics Store and App builder will only strengthen this position
Read full review SAS Enterprise Guide is good at taking various datasets and giving analyst/user ability to do some transformations without substantial amounts of code. Once the data is inside SAS, the memory of it is very efficient. Using SAS for data analysis can be helpful. It will give good statistics for you, and it has a robust set of functions that aid analysis.
Read full review Pros Combining large data sets - these can be compressed into database files to make for faster runs. Formatting data - this can take 45 min of formatting an excel sheet and run it in 7 seconds. Sending large batch emails - some workflows we have send out 50+ emails to customers in just minutes. Read full review Ability to load an AutoExec when opening a session ensuring everyone has the same global variables. Formatting with Ctrl I. If you're reading someone else's code and it's not formatted correctly you can highlight the area and hit Ctrl I. Read full review Cons New tools to match the ones existing in Designer on-premise. Environments management. Environment variables handling. Read full review Process time of data is a bit long. It depends on the size of your data and complexity of your project tree. There is not enough online free training videos. While working with the project tree sometimes the links between the modules are broken or the order for running the modules get mixed up. You should know your project tree by heart. Read full review Likelihood to Renew On account of current user experience and the organization-wide acceptance.
Read full review Usability I feel like the usability works for every level of computer user. There are very simple tools that can accomplish a huge amount of time savings, and there are very complex tools that can give you even more. We mainly use just the simple tools in our company and have gained an incredible amount of time savings
Read full review It's not all bad, but I don't believe that an enterprise purchase of SAS is worth the expense considering the widely available set of tools in the data analytics space at the moment. In my company, it's a good tool because others use it. Otherwise, I wouldn't purchase a new set of it because it doesn't have some of the better analytical functions in it.
Read full review Support Rating Although I use SAS support for information on functions, these are SAS related and haven't really come across anything that is specifically for SAS EG.
Read full review Implementation Rating I've not worked hands-on with the implementation team, but there were no escalations barring a few hiccups in the deployment due to change in requirement & adoption to our company's remote servers.
Read full review Alternatives Considered Our IT group presented Trifacta to me. They picked it out and among the crowd for me. This was way beyond ETL tools, SQL, or any programming language. It's just much faster and because it's sitting on Hadoop you bypass some of the slowdowns typically faced with RDBMS.
Read full review Why I prefer SAS EG: Data processing speed is much faster than that R Studio. It can load any amount of data and any type of data like structured or unstructured or semi-structured. Its output delivery system by which we have the output in PDF file makes it very comfortable to use and share that file to clients very easily. Inbuilt functions are very powerful and plentiful. Facility of writing macros makes it far away from its competitors.
Read full review Return on Investment It makes it easier to hire staff for data cleaning. Read full review Positive (cost): SAS made a bundle that include unlimited usage of SAS/Enterprise Guide with a server solution. That by itself made the company save a lot of money by not having to pay individual licences anymore. Positive (insight): Data analysts in business units often need to crunch data and they don't have access to ETL tools to do it. Having access to SAS/EG gives them that power. Positive (time to market): Having the users develop components with SAS/EG allows for easier integration in a production environment (SAS batch job) as no code rework is required. Read full review ScreenShots