Amazon EMR vs Microsoft Analytics Platform System comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
2,342 views|2,016 comparisons
85% willing to recommend
Microsoft Logo
309 views|228 comparisons
66% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Amazon EMR and Microsoft Analytics Platform System based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Amazon EMR vs. Microsoft Analytics Platform System Report (Updated: March 2024).
770,616 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The project management is very streamlined.""The initial setup is pretty straightforward.""The solution is scalable.""One of the valuable features about this solution is that it's managed services, so it's pretty stable, and scalable as much as you wish. It has all the necessary distributions. With some additional work, it's also possible to change to a Spark version with the latest version of EMR. It also has Hudi, so we are leveraging Apache Hudi on EMR for change data capture, so then it comes out-of-the-box in EMR.""The initial setup is straightforward.""Amazon EMR is a good solution that can be used to manage big data.""The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions.""The solution is pretty simple to set up."

More Amazon EMR Pros →

"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases.""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.""Helps our customers to discover trends, which provides useful information based on their business.""I like that it's integrated with other Azure products.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.""It is closely integrated with other products in the MS portfolio."

More Microsoft Analytics Platform System Pros →

Cons
"The legacy versions of the solution are not supported in the new versions.""There were times where they would release new versions and it seemed to end up breaking old versions, which is very strange.""Modules and strategies should be better handled and notified early in advance.""The product's features for storing data in static clusters could be better.""Amazon EMR is continuously improving, but maybe something like CI/CD out-of-the-box or integration with Prometheus Grafana.""There is room for improvement in pricing.""Amazon EMR can improve by adding some features, such as megastore services and HiveServer2. Additionally, the user interface could be better, similar to what Apache service provides, cross-platform services.""The problem for us is it starts very slow."

More Amazon EMR Cons →

"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""​Hybrid environments are complex to manage.""Functionality needs to be more up-to-date with competing products.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release.""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.""Microsoft Analytics Platform System could have better support.""The pricing model needs to be improved."

More Microsoft Analytics Platform System Cons →

Pricing and Cost Advice
  • "You don't need to pay for licensing on a yearly or monthly basis, you only pay for what you use, in terms of underlying instances."
  • "The cost of Amazon EMR is very high."
  • "The price of the solution is expensive."
  • "Amazon EMR's price is reasonable."
  • "There is a small fee for the EMR system, but major cost components are the underlying infrastructure resources which we actually use."
  • "There is no need to pay extra for third-party software."
  • "Amazon EMR is not very expensive."
  • "The product is not cheap, but it is not expensive."
  • More Amazon EMR Pricing and Cost Advice →

  • "The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
  • "Users have to pay extra for premium-level technical support."
  • "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."
  • "I rate Microsoft Analytics Platform System a seven out of ten for pricing."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    770,616 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Amazon EMR is a good solution that can be used to manage big data.
    Top Answer:As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data.
    Top Answer:We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.
    Top Answer:It's not too confusing. It's based on features, and we don't have to buy additional licenses.
    Top Answer:We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.
    Ranking
    8th
    Views
    2,342
    Comparisons
    2,016
    Reviews
    12
    Average Words per Review
    346
    Rating
    7.8
    17th
    out of 35 in Data Warehouse
    Views
    309
    Comparisons
    228
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    Comparisons
    Also Known As
    Amazon Elastic MapReduce
    Microsoft APS, MS Analytics Platform System
    Learn More
    Overview
    Amazon Elastic MapReduce (Amazon EMR) is a web service that makes it easy to quickly and cost-effectively process vast amounts of data. Amazon EMR simplifies big data processing, providing a managed Hadoop framework that makes it easy, fast, and cost-effective for you to distribute and process vast amounts of your data across dynamically scalable Amazon EC2 instances.
    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.
    Sample Customers
    Yelp
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Top Industries
    REVIEWERS
    Computer Software Company27%
    Media Company18%
    Wholesaler/Distributor18%
    Comms Service Provider9%
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Computer Software Company13%
    Manufacturing Company8%
    Educational Organization6%
    VISITORS READING REVIEWS
    Financial Services Firm13%
    University11%
    Computer Software Company11%
    Energy/Utilities Company9%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise26%
    Large Enterprise47%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise12%
    Large Enterprise72%
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise6%
    Large Enterprise74%
    Buyer's Guide
    Amazon EMR vs. Microsoft Analytics Platform System
    March 2024
    Find out what your peers are saying about Amazon EMR vs. Microsoft Analytics Platform System and other solutions. Updated: March 2024.
    770,616 professionals have used our research since 2012.

    Amazon EMR is ranked 8th in Cloud Data Warehouse with 20 reviews while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. Amazon EMR is rated 7.8, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". 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 EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift and Apache Spark, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our Amazon EMR vs. Microsoft Analytics Platform System report.

    See our list of best Cloud Data Warehouse vendors.

    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.