"Monarch lets you quickly extract in your preferred format."
"We now mostly use the Enterprise Guide for such scheduling purposes, so error processes will not inhibit the others."
"It is also compatible with other softwares, such as Excel."
"The data cleaning part is valuable. SAS is a very powerful tool to work with and connect with different sources. We have several tables, and we are looking up tables from one place to another place. We are connecting with different data sources. The data is not coming from one source. There are several sources of data, and we have information coming from different sources. There are some flat files, and there is some information from the data warehouse."
"The Query Builder is very valuable."
"In Daman, I had used the data module, where you can join the table and take whatever data we require for our work. You join tables and create columns as you wish, then analyze data in various ways depending on what the problem is. We used it to detect fraud, abnormalities, anomalies, abnormal trends, etc. It's also good for exporting and importing tables."
"Filter and sort query builder is valuable. The ability to do advanced SAS programming is also a useful feature because we can do anything by using Enterprise Guide. It has a lot of functionalities. We can build ETL processes. There are clients who are using SAS Enterprise Guide to build ETL processes. They have a SAS-based program that is scheduled to run at a certain frequency to produce some reports for the business. It is a very useful tool for ETL unit tests and functional tests. You can also do data science projects in SAS Enterprise Guide by using different statistics. During my MBA, we used SAS Enterprise Guide for our statistic course. To query the data, there are many solutions such as SQL, but these tools are only a part of the integration. They are only useful for querying the data and require knowledge of SQL, so they are not suitable for business users. SAS Enterprise Guide can be very easily used by business users to filter and sort the data and build queries. It is not necessary to have coding skills to use SAS Enterprise Guide. For this reason, it is attractive for businesses."
"Similar to Microsoft Access, you can drag and drop. You can simply drag and drop objects onto the page and create various flows to establish your query within the project. You can extract those queries from the preview as needed."
"Takes advantage of our Enterprise SAS Grid."
"I rate Altair Monarch seven out of 10 for affordability. Recently, the pricing model changed from end-user licensing to a concurrent licensing model."
"It is expensive."
"The technical support response time has been consistently slow, and this has been a concern."
"I feel that the performance could be increased by leveraging multi-thread with any SAS BI platform, not just the high performance ones."
"More bi-directional integration with the SAS Studio suite of tools is needed."
"The stability is not very reliable."
"Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user friendly and easier to use. Tableau is very easy to use. It's just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau."
"Our data warehouse is built on the Netezza database. We have SAS BI, and we populate the Netezza database. When we have tables with, for example, a hundred million rows in Netezza, SAS Enterprise Guide doesn't work. It doesn't return any results. It works for around 30 to 40 million rows, but it is not working for anything more than that. This issue is only with the Netezza database. With Oracle, it is quite good. They can improve its performance with the Netezza database. There should be one unique tool that includes SAS Data Integration Studio and SAS Enterprise Guide for more integration capabilities. With SAS Enterprise Guide, it is not possible to create connections and libraries and build transformations that can be used for other projects. This tool should have all capabilities that SAS Enterprise Guide does not have. Such a tool would be perfect because it will be used by developers and business users at the same time. In addition to the integration capabilities, they should also provide more deployment capabilities. There should be an option to easily create SAS packages and export them from one environment to another. There could also be a possibility to connect with R and Python. Open-source tools are hot in the market nowadays, and it would be good to extend its capabilities."
"A log belongs to each program. I have experienced a situation where when I run just the exec files, it replaces the whole log and I wanted to see the earlier log, then this was not possible."
Altair Monarch is ranked 4th in Data Preparation Tools with 1 review while SAS Enterprise Guide is ranked 2nd in Data Preparation Tools with 24 reviews. Altair Monarch is rated 9.0, while SAS Enterprise Guide is rated 8.2. The top reviewer of Altair Monarch writes "In 10 minutes, I can do work that would take me two or three hours in another solution. ". On the other hand, the top reviewer of SAS Enterprise Guide writes "Easy to use, drag and drop interface, with good built-in help facilities". Altair Monarch is most compared with Alteryx and ETL Solutions Transformation Manager, whereas SAS Enterprise Guide is most compared with Alteryx, Toad Data Point and Trifacta Wrangler Enterprise.
See our list of best Data Preparation Tools vendors.
We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.