Perfect tool for a data analyst
July 30, 2021

Perfect tool for a data analyst

Prashast Vaish | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

I am working with an insurance client where a lot of claims and policy data comes in every day, we use amazon redshift to perform ETL and analyze the data to gain business insights.
Amazon redshift is an integral part of our data analysis.
  • Amazon redshift is super quick due to its Massive parallel processing
  • Amazon Redshift is compatible with many visualization tools which helps visualize the insights
  • Amazon redshift has almost 0 downtime and allows for a massive store of data
  • Since Redshift is a part of a larger AWS ecosystem, connecting with other resources is never a problem
  • Amazon redshift could have more detailed documentation including practical examples
  • Amazon redshift still lacks some of the advanced concepts which are possible with MS-SQL and others
  • It should have a feature where users can visualize the data stored for a better understanding
  • Able to accommodate large data
  • massively parallel processing
  • SQL based
  • Redshift is comparatively cheap and only charges for the time you actually use it
  • The insights gained from Redshift helps improve the business for the company
  • The stakeholders love it for being quick with all the processing
Redshift is better cost wise and also since the whole ecosystem is set in AWS, it is wise to use redshift

Do you think Amazon Redshift delivers good value for the price?

Yes

Are you happy with Amazon Redshift's feature set?

Yes

Did Amazon Redshift live up to sales and marketing promises?

Yes

Did implementation of Amazon Redshift go as expected?

Yes

Would you buy Amazon Redshift again?

Yes

Amazon redshift is best suited for data analysis and is not suited for transactions.
for eg. you can use amazon redshift to gain insights from a large data set but cannot use it to do a transaction level update and insert