Aginity

What do you like best?

People who know SQL can easily work on Aginity as it's front end coding contains SQL as the language to interact with the Hadoop framework. Also, you can run different queries on different tabs which makes parallel processing easy.

Very reusable and scalable in terms of user friendliness. I have used the Analytics Management extensively. Aginity Amp makes sure that analytics use is consistent across your company. It catalogs both the data and the math utilized to create analytics, which makes it simpler to build trustworthy and consistent analytics.

Heard that the governance and data cleansing feauture is also amazing.

What do you dislike?

The dashboard could be more appealing and simple. Sometimes, it gets stuck before of large query handling but that's only sometimes. Initially I had some installation issues too.

Recommendations to others considering the product:

1. Be well verse with SQL before using this. As most of the syntax is really SQL based, it would be better.

2. You can run different queries on different tabs, that's the good part. But try minimising them as well.

What problems are you solving with the product? What benefits have you realized?

Extracting datasets, designing queries to look into big datasets etc. Aginity makes it very simple to do all such stuff. I have used the Azure SQL Data Warehouse to combine query performance with data security. My other team members used to integrate it with other products as well as their roles were of developers. I was a tester and my main job was to find loopholes in the analytics workload demands and expectations.