Compare Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse and other solutions. Updated: January 2021.
464,655 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:

Pros
"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.""I like that it's integrated with other Azure products.""This is a well-integrated solution and that integration empowers results."

More Microsoft Analytics Platform System Pros »

"I am very satisfied with the customer service/technical support.""The most valuable features are the performance and usability.""The most valuable feature for me is querying.""One of the most important features is the ease of using MS SQL.""The most valuable feature of this solution is performance.""The data transmissions between the data models is the most valuable feature.""The most valuable feature is the business intelligence (BI) part of it.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."

More Microsoft Parallel Data Warehouse Pros »

Cons
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps.""Functionality needs to be more up-to-date with competing products.""The pricing model needs to be improved.""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.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."

More Microsoft Analytics Platform System Cons »

"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""More tools to help designers should be included.""I would like to see better visualization features.""I think that the error messages need to be made more specific.""The reporting for certain types of data needs to be improved.""This solution would be improved with an option for in-memory data analysis.""If the database is large with a lot of columns then it is difficult to clean the data.""I would like the tool to support different operating systems."

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."

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."

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.
464,655 professionals have used our research since 2012.
Questions from the Community
Top Answer: I like that it's integrated with other Azure products.
Top Answer: I think the biggest problem with the product is that it does a data ingest model, which is very expensive.
Top Answer: Our primary use case is for monitoring our servers. We have a virtual fleet within Azure and we monitor that.
Top Answer: Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity… more »
Top Answer: 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… more »
Top Answer: The setup has room for improvement. Some customers want to go to non-Windows Servers. Have the entire SQL Server done there though is an obstacle for us, as the configuration of Microsoft BI with… more »
Ranking
15th
out of 30 in Data Warehouse
Views
896
Comparisons
498
Reviews
4
Average Words per Review
839
Rating
6.3
7th
out of 30 in Data Warehouse
Views
2,674
Comparisons
1,945
Reviews
11
Average Words per Review
486
Rating
7.6
Popular Comparisons
Also Known As
Microsoft APS
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server 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.

Offer
Learn more about Microsoft Analytics Platform System
Learn more about Microsoft Parallel Data Warehouse
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
Computer Software Company28%
Comms Service Provider17%
Media Company13%
Financial Services Firm8%
REVIEWERS
Computer Software Company27%
Pharma/Biotech Company18%
Comms Service Provider9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company29%
Comms Service Provider12%
Financial Services Firm11%
Insurance Company7%
Company Size
REVIEWERS
Small Business38%
Large Enterprise63%
REVIEWERS
Small Business32%
Midsize Enterprise18%
Large Enterprise50%
Find out what your peers are saying about Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse and other solutions. Updated: January 2021.
464,655 professionals have used our research since 2012.

Microsoft Analytics Platform System is ranked 15th in Data Warehouse with 4 reviews while Microsoft Parallel Data Warehouse is ranked 7th in Data Warehouse with 11 reviews. Microsoft Analytics Platform System is rated 6.2, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Microsoft Analytics Platform System writes "Has unique functionality for advanced analytics but could use enhancement in machine learning and AI features". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Apache Hadoop, Oracle Exadata, Oracle Big Data Appliance and Amazon Redshift, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and Vertica. See our Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse 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.