Microsoft Analytics Platform System vs Microsoft Parallel Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Analytics Platform System and Microsoft Parallel Data Warehouse 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.
To learn more, read our detailed Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse Report (Updated: March 2024).
765,386 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
"I like that it's integrated with other Azure products.""It is closely integrated with other products in the MS portfolio.""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.""This solution will connect to any database, you can combine databases, and you can create a cube or tabular model.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""This is a well-integrated solution and that integration empowers results.""Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."

More Microsoft Analytics Platform System Pros →

"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.""The most valuable feature is the business intelligence (BI) part of it.""Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.""The most valuable features are the performance and usability.""One of the most important features is the ease of using MS SQL.""It is a very stable database.""It handles high volumes of data very well.""The solution's integration is good."

More Microsoft Parallel Data Warehouse Pros →

Cons
"The pricing model needs to be improved.""The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps.""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.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""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."

More Microsoft Analytics Platform System Cons →

"More tools to help designers should be included.""I think that the error messages need to be made more specific.""I would like to see better visualization features.""It could offer more development across the solution.""The product must provide more frequent updates.""I would like the tool to support different operating systems.""​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""The reporting for certain types of data needs to be improved."

More Microsoft Parallel Data Warehouse Cons →

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 →

  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    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.
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    Ranking
    17th
    out of 33 in Data Warehouse
    Views
    359
    Comparisons
    266
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    8th
    out of 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    Comparisons
    Also Known As
    Microsoft APS, MS Analytics Platform System
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview
    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.

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    Sample Customers
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Computer Software Company10%
    University10%
    Government9%
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    Company Size
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise6%
    Large Enterprise73%
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    Buyer's Guide
    Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse
    March 2024
    Find out what your peers are saying about Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews. Microsoft Analytics Platform System is rated 6.6, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum. See our Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse report.

    See our list of best 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.