Best Analytics Cloud Data Warehouse Database
November 21, 2017

Best Analytics Cloud Data Warehouse Database

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

We used the Amazon Redshift for Analytics Data Warehousing. It helped to process our various departments in organization like renewals, sales, marketing & finance department to analyze the data very quickly and performance effective with tableau reporting tool.
  • It's a columnar data storage architecture and which allows it to particularly run structured data query for reporting very fast.
  • We used amazon redshift cloud datawarehouse with Tableau, looker reporting tool and it has perfectly helped our reporting needs for business users.
  • Very easy to copy data from Amazon Web Services S3 storage container to Redshift Database with simple copy statements.
  • It provides built-in commands to table structure effectively with less use of memory.
  • AWS can provide some cheaper options with pre core cpu purchase rather than hourly charges on amazon redshift.
  • There are no options for on-premise set-up of the amazon redshift database.
  • Limited documentation on best practices for dist key, sort key and various amazon redshift specific commands.
  • It provides great returns due to its fast processing data analytics purpose.
  • It sometimes toss for cost of AWS Service with Amazon Redshift.
It's fast processing compared to other products and it's best for structured data analytics & data warehousing purpose.
The unique columnar data storage architecture compared to other products makes it the great choice for analytics projects.
It's the best option when we need to have a high volume of structured data analytics datawarehouse design & development. It perfectly reports fast with tableau reporting tool, even data around 300 million records. It's best suited where the organization is planning to build a custom datawarehouse rather than using any pre-packaged BI Apps data model.