Data profiling, data quality reporting
The easiest route - we'll conduct a 15 minute phone interview and write up the review for you.
Use our online form to submit your review. It's quick and you can post anonymously.
Data profiling, data quality reporting
Sometimes a project knows little about its data. IA is good at data profiling / data discovery. It can give insight into data about data type, format, uniqueness, completeness, frequency distribution, etc. The other powerful feature of IA is its ability to check data against business rules. It can give statistics on how many records violate a rule.
Data rules, column analysis, virtual tables
The interface is not the most friendly. Performance.
There are also these following features - documented in the user guide - but do not work:
1. Global Logical Variables (GLVs)
2. Migrating projects. Neither the internal method (Export/Import) nor the command line interface (CLI) method work 100%. They sometimes error out.
3. When you open a data rule and do no modifications, when you close it, IA asks if you want to save the changes, even if you did not make any. A bit disturbing when you know you did not change anything yet you start to doubt what you think you know.
My wish list for new features:
1. Ability to use functions on data sources. I do not understand how IBM could miss this. Data sources are not visible when coding custom expressions. For example if you have a field called CUSTOMER.ACCOUNT_NUM, you cannot code TRIM(ACCOUNT_NUM). My workaround is to create a variable in the rule definition then bind it in the data rule. Functions can only be applied to variables, not directly to fields. I have a rule where I do things to about 12 fields - concatenate, substring, length, coalesce, etc - and I had to make up 12 lines in the definition that do nothing but refer to these variables. I had to invent a rule so I coded seemingly useless rule conditions like address1 = address1 just so I have a variable for the field I want to code functions for. Huge oversight on the part of IBM.
2. Copy a data rule and modify the copy. Right now only rule definitions can be copied, not data rules. Sometimes I need to create two or more versions of the same rule. IA forces me to generate each of them from scratch. This is annoying when version 2 is only slightly different from version 1. If it took me an hour to code the original, it would take me close to that amount of time to code the new version. If I could copy and modify, the effort would only take maybe 5 minutes.
3. The date of last modification. IA only shows the date of creation which is generally useless. The last modification date is far more important and needs to be available and visible.
4. A file manager, a la Windows Explorer. I may want to see the list of rules and sort them by date of modification.
5. Enhanced dedup on output. Currently, IA can only exclude duplicates based on the entire record. It should allow deduping on a select set of columns.
6. Feature to select one record from multiple matches in a join. For instance, in Oracle SQL, one can FETCH FIRST ROW ONLY or use ROWNUM or TOP 1.
7. Ability to sort the output.
8. New virtual tables take a while to appear. You create one and the list doesn't list the new table. Wait 15 minutes or so and maybe it will be listed. Or log out and log back in.
Since 2008.
The tool sometimes crashes or freezes. But the latest version, 11.7, is more than stable than previous ones.
Customer Service:
Scale of 1 to 10: 8. While IBM is excellent at responding to inquiries, it is slow to implement much-needed software fixes. While that is common in the industry, I would still like to see IBM fix software bugs sooner.
Technical Support:
Same as customer service.
Positive
No never had the chance.
I have not been involved in setup but I understand it is very complex, not for the faint of heart.
Excellent!
I was not involved in the selection.
Get the latest version. Compare with competing products. Know that there are not many experts in the product and that they may pay a premium to hire them.
SAS Viya Platform is being used by Gilead to perform data analysis for clinical trials and drug development. For clinical data analysis, study analysis, and related activities, we use SAS Viya Platform for that analysis.
We have been using SAS Viya Platform for clinical trials and data analysis for years. We have SAS developers who are working on this and are familiar with SAS, using it very tactfully. That is how it is impacting our work.
From my perspective as an administrator, the best features that SAS Viya Platform offers include scalability. If you are using millions of rows and very large datasets, SAS Viya Platform can easily handle that because it has a compute analytics server built in. It can handle very large data pretty easily, and analyzing that large data using CAS analytics will take minutes.
CAS basically helps with scalability by keeping the data in memory. There is no data on the disk, and it directly keeps data in memory. When you are doing the analysis, it is very fast in reading the in-memory data, and that is how it reacts very fast and returns results quickly compared to other platforms. That is the architecture.
Earlier we had SAS 9.4, and SAS Viya Platform is the higher cloud modernization version. Now it is on cloud, so scalability is a plus point which is helping the organization definitely.
SAS Viya Platform can be improved in certain ways, not much but certain ways. Their support system is a very lengthy process. We need to send out an email to them, and then they will respond and ask for logs and all those things, which is a very lengthy process. That can be corrected and optimized.
There is always a scope of improvement that keeps it from being a perfect ten.
I have been working in my current field on SAS Viya Platform for about five to six years. In total, I have been working with SAS for about twelve years.
Earlier we had SAS 9.4, and SAS Viya Platform is the higher cloud modernization version.
We are managing this application end-to-end, building it from scratch and then providing production support, troubleshooting user issues, and doing SAS Viya Platform version upgrades, hotfixes, SAS license management, and SSL certificate management. All of those things that an administrator takes care of, we are doing.
The output from SAS Viya Platform is very reliable. If you submit code, then the output is very reliable.
SAS Viya Platform is integrating AI, co-pilots, and all those things, which are really secure and governed correctly. That is acceptable.
Using SAS Viya Platform, you need to be well-versed. If you are going into SAS Viya Platform administration, you need to be familiar with administrator roles and responsibilities. You also need to be familiar with AWS cloud functionalities and Kubernetes and kubectl commands, and all those things. That is the basic requirement.
I would rate this product a nine out of ten.
