We performed a comparison between Amazon Redshift and Microsoft Analytics Platform System based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's scalable because it's on the cloud."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"This service can merge and integrate well with all databases."
"The stability of Amazon Redshift is good."
"The most valuable feature of Redshift is its cluster."
"It allows for the storage of huge amounts of data."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"It is closely integrated with other products in the MS portfolio."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"Helps our customers to discover trends, which provides useful information based on their business."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"Amazon Redshift is a little more expensive than other products."
"This solution lacks integration with non-AWS sources."
"The solution is unable to work fast."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"The product must become a bit more serverless."
"The product must provide new indexes that support special data structures or data types like TEXT."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"It takes a lot of time to ingest and update the data."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Functionality needs to be more up-to-date with competing products."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"The pricing model needs to be improved."
"Microsoft Analytics Platform System could have better support."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Microsoft Analytics Platform System is ranked 18th in Data Warehouse with 9 reviews. Amazon Redshift is rated 7.8, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics and IBM Netezza Performance Server. See our Amazon Redshift vs. Microsoft Analytics Platform System report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse 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.