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."Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Easy to build out our snowflake design and load data."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"The most valuable feature of Redshift is its cluster."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The solution is scalable. It handles different loads very well."
"Helps our customers to discover trends, which provides useful information based on their business."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"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."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"The speed of the solution and its portability needs improvement."
"The customer support could be more responsive."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"There are too many limitations with respect to concurrency."
"In our experiments, the handling of unstructured data was not very smooth."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Hybrid environments are complex to manage."
"Functionality needs to be more up-to-date with competing products."
"The pricing model needs to be improved."
"Microsoft Analytics Platform System could have better support."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Microsoft Analytics Platform System is ranked 17th 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 AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. 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.