No more typing reviews! Try our Samantha, our new voice AI agent.

Amazon Redshift vs Microsoft Analytics Platform System comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Redshift
Ranking in Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
73
Ranking in other categories
Cloud Data Warehouse (6th), Database Management Systems (DBMS) (8th)
Microsoft Analytics Platfor...
Ranking in Data Warehouse
19th
Average Rating
6.6
Reviews Sentiment
6.8
Number of Reviews
9
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2026, in the Data Warehouse category, the mindshare of Amazon Redshift is 4.7%, down from 7.8% compared to the previous year. The mindshare of Microsoft Analytics Platform System is 2.3%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Mindshare Distribution
ProductMindshare (%)
Amazon Redshift4.7%
Microsoft Analytics Platform System2.3%
Other93.0%
Data Warehouse
 

Featured Reviews

Hemanthreddy Vakiti - PeerSpot reviewer
Data engineer at a tech vendor with 10,001+ employees
Optimized restaurant analytics has driven faster insights and streamlined daily reporting
Amazon Redshift offers massive parallel processing capability, allowing it to handle millions of records, along with integration with other AWS features such as S3 and QuickSight. The column-level storage supports high performance and easy data retrieval compared to other tools. The integration with S3 has helped my team immensely since S3 is our starting source, and the direct integration with Amazon Redshift simplifies the transformation and loading process. Columnar storage has benefited our performance significantly, allowing us to extract specific rows from tables with years of data much faster than other tools with row-level storage. Amazon Redshift has positively impacted our organization by significantly improving query performance and speed. Features such as easy integration with S3 allow us to process millions of records efficiently, ultimately saving us nearly one hour per day for our project.
MahmoudMohamed1 - PeerSpot reviewer
Senior Data Engineer at Tatweer Educational Technologies Company - TETCO
Offers smooth data integration between systems, but requires better real-time analytics capabilities
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services. This lets us continue using private databases without paying additional licensing fees. Additionally, the license includes Analytics services and Power BI, which work on-premises, unlike most other technologies that require cloud solutions.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"We have found Machine Learning use cases are very nice."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"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 most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The ability to reload data multiple times at different times."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The result is a highly flexible, affordable, and scalable platform that makes large-scale Hub and Spoke EDW architectures a practical reality."
"Helps our customers to discover trends, which provides useful information based on their business."
"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."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"I think Microsoft Stack offers the end-to-end solution I need."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
 

Cons

"Running parallel queries results in poor performance and this needs to be improved."
"Planting is the primary key enforcement that should be improved."
"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."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"I rate the solution as an eight out of ten because it is not 100 percent, as there is much service-related maintenance required."
"The customer support could be more responsive."
"Should be made available across zones, like other Multi-AZ solutions."
"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."
"In general, I am not really very satisfied with the tutorials that are out there."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"​Hybrid environments are complex to manage."
"However, centralized EDW tends to be extremely expensive and very inflexible."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"The trouble is Microsoft has changed their licensing. It's an extremely expensive product now."
"Hybrid environments are complex to manage."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
 

Pricing and Cost Advice

"The cost must be improved."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"The solution is available at a mid-range price compared to other vendors."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"The product is quite expensive."
"It is an expensive product."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"I rate Microsoft Analytics Platform System a seven out of ten for pricing."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"Users have to pay extra for premium-level technical support."
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
890,124 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
8%
Computer Software Company
7%
Construction Company
6%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise21
Large Enterprise29
By reviewers
Company SizeCount
Small Business4
Large Enterprise7
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
What is your experience regarding pricing and costs for Amazon Redshift?
My experience with pricing and setup cost is satisfactory, as we have been loyal clients of Amazon since the beginning of our organization. However, I am not aware of the exact costs associated wit...
Ask a question
Earn 20 points
 

Also Known As

No data available
Microsoft APS, MS Analytics Platform System
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Find out what your peers are saying about Amazon Redshift vs. Microsoft Analytics Platform System and other solutions. Updated: April 2026.
890,124 professionals have used our research since 2012.