IT Central Station is now PeerSpot: Here's why

Amazon Redshift vs Microsoft Analytics Platform System comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Use Microsoft Analytics Platform System?
Buyer's Guide
Cloud Data Warehouse
August 2022
Find out what your peers are saying about Snowflake Computing, Microsoft, Micro Focus and others in Cloud Data Warehouse. Updated: August 2022.
620,987 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pricing and Cost Advice
  • "At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
  • "The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
  • "This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."
  • "The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."
  • "Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
  • "It's pay per use. You can have multiple models."
  • "The cost is comparable to Snowflake."
  • More Amazon Redshift Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    620,987 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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… more »
    Top Answer: We have found Machine Learning use cases are very nice.
    Top Answer:The initial setup is very smooth and took us about six months to deploy. The cost is comparable to Snowflake.
    Top Answer:This is a well-integrated solution and that integration empowers results.
    Top Answer:In general, I am not really very satisfied with the tutorials that are out there. When Microsoft releases a new tool, technology — whatever it is — oftentimes it is not really very easy to get your… more »
    Top Answer:I am a freelancer in this area. Microsoft Analytics Platform System is a suite of many different products. I have been busy using Microsoft Analytics Platform for the last 10 years and it is not… more »
    Ranking
    5th
    Views
    12,946
    Comparisons
    10,457
    Reviews
    15
    Average Words per Review
    398
    Rating
    7.7
    10th
    out of 30 in Data Warehouse
    Views
    1,098
    Comparisons
    801
    Reviews
    1
    Average Words per Review
    931
    Rating
    8.0
    Comparisons
    Also Known As
    Microsoft APS, MS Analytics Platform System
    Learn More
    Overview

    Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

    Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

    Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

    As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

    The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.
    Offer
    Learn more about Amazon Redshift
    Learn more about Microsoft Analytics Platform System
    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
    Top Industries
    REVIEWERS
    Comms Service Provider24%
    Computer Software Company24%
    Retailer18%
    Logistics Company12%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider12%
    Financial Services Firm10%
    Media Company8%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider21%
    Energy/Utilities Company7%
    Financial Services Firm7%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise33%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise12%
    Large Enterprise72%
    REVIEWERS
    Small Business33%
    Large Enterprise67%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise68%
    Buyer's Guide
    Cloud Data Warehouse
    August 2022
    Find out what your peers are saying about Snowflake Computing, Microsoft, Micro Focus and others in Cloud Data Warehouse. Updated: August 2022.
    620,987 professionals have used our research since 2012.

    Amazon Redshift is ranked 5th in Cloud Data Warehouse with 15 reviews while Microsoft Analytics Platform System is ranked 10th in Data Warehouse. Amazon Redshift is rated 7.8, while Microsoft Analytics Platform System is rated 0.0. The top reviewer of Amazon Redshift writes "Helps consolidate all of an organization's data into a single unified data platform". On the other hand, Amazon Redshift is most compared with Snowflake, Microsoft Azure Synapse Analytics, Oracle Exadata, Vertica and Teradata, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, Apache Hadoop, Snowflake and IBM Netezza Performance Server.

    We monitor all Cloud 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.