Microsoft Parallel Data Warehouse Reviews

Name: Microsoft Parallel Data Warehouse
Brand: Microsoft
Rating: 3.9 (34 reviews)

3.9 out of 5

34 reviews
85% willing to recommend

1,469 followers

What is Microsoft Parallel Data Warehouse?

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.

Get the Microsoft Parallel Data Warehouse Buyer's Guide and find out what your peers are saying about Microsoft Parallel Data Warehouse, Snowflake, Teradata and more!

Microsoft Parallel Data Warehouse is the #10 ranked solution in top Data Warehouse solutions. PeerSpot users give Microsoft Parallel Data Warehouse an average rating of 7.8 out of 10. Based on the analysis of the 34 most recent Microsoft Parallel Data Warehouse reviews, the overall sentiment is positive, with a sentiment score of 7.4. (Among the highest in the category). Microsoft Parallel Data Warehouse is most commonly compared to Snowflake: Microsoft Parallel Data Warehouse vs Snowflake. Microsoft Parallel Data Warehouse is popular among the large enterprise segment, accounting for 60% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 28% of all views.

Buyer's Guide

Microsoft Parallel Data Warehouse

November 2024

Get the report

Helped 823,875 peers since 2012

Featured reviews

StevenLai

Sr. Data Engineer at Amrock

We use it to build our data warehouse and databases, and everything in the back end It helps streamline our metadata warehousing process. As it is our only type of data warehouse and database, it serves as our source, destination, and staging area. This product has many features which are useful…

Read full review

PALAK SURI

Senior Software Engineer at Eurofins

The initial setup was fine and straightforward. The migration process related to Microsoft Parallel Data Warehouse has been going on for a month in my company. We have multiple labs, of which it was possible to load the data in 47 labs. With one lab, it took almost a week to load the data since the data count was in millions, due to which it initially failed multiple times, creating a huge issue for us. It's all done right now, but we have faced issues in the past. In our company, we created new databases in the new SQL Server. We replicated the databases, and then we got the data from there.

Read full review

PeterMaier

Chief Financial Officer at a retailer with 5,001-10,000 employees

We primarily use Data Warehouse for our business intelligence platform Qlik, which sits on top of it. Data Warehouse is a middleware product. Our users work with Qlik, and our data architects are using SQL Server. It mostly feeds the data to the Qlik cloud product. Very few people are directly…

Read full review

Microsoft Parallel Data Warehouse mindshare

As of December 2024, the mindshare of Microsoft Parallel Data Warehouse in the Data Warehouse category stands at 1.0%, down from 1.3% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Warehouse

PeerAnalyst reports

Type	Title	Date
Category	Data Warehouse	Dec 18, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 18, 2024	Download
Comparison	Microsoft Parallel Data Warehouse vs Snowflake	Dec 18, 2024	Download
Comparison	Microsoft Parallel Data Warehouse vs Oracle Exadata	Dec 18, 2024	Download
Comparison	Microsoft Parallel Data Warehouse vs Teradata	Dec 18, 2024	Download

Title	Rating	Mindshare	Recommending
Snowflake	4.2	17.1%	97%	98 interviews Add to research
Teradata	4.1	17.1%	87%	76 interviews Add to research

Valuable Features

"It is very strong, scalable, and has tons of features."
"The initial setup was straightforward."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."

Room for Improvement

"A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us."
"The product scalability needs improvement."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."

ROI

Several users express satisfaction with the ROI from Microsoft Parallel Data Warehouse, noting significant returns in some cases. It is praised for efficiently managing substantial data volumes and seamlessly integrating with existing tools. Though not all users track ROI directly, some mention a complete return attributed to its importance in back-end operations. Despite these benefits, potential for improvement is acknowledged by some users.

Pricing

Microsoft Parallel Data Warehouse pricing is competitive and well-priced compared to alternatives, with government agreements easing costs for some users. Pricing often depends on data size and solution requirements, making it cost-effective for large organizations but potentially expensive for those with extensive data needs. The licensing structure includes an annual fee and can vary depending on environment sizes. Technical support incurs an additional fee, and seamless Azure integration offers cost benefits, although on-premises users may face challenges.

"The solution is cost-effective."
"They offer an annual subscription. The pricing depends on the size of the environments."
"The tool could be expensive if we need to manage a lot of data."

Popular Use Cases

Service and Support

Customer service for Microsoft Parallel Data Warehouse is satisfactory but not exceptional. Users note good technical support with knowledgeable, responsive staff and effective online resources. Many find solutions independently using Google or YouTube. Some face challenges contacting Microsoft directly; however, those with access report positive experiences. Utilizing Microsoft's ecosystem generally offers adequate assistance, although improvements in team knowledge and response speed are suggested. A license is necessary for accessing technical support services.

Deployment

Scalability

Stability

Microsoft Parallel Data Warehouse is recognized for its stability, even during power outages, and offers a reliable experience for many users. Setup impacts stability, especially with data nulls or structural changes. Some users mention quick resolutions for issues, and it performs well under heavy data loads. Occasional slow processing with large datasets is noted, but it remains a robust choice, achieving high marks for stability and performance.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Microsoft Parallel Data Warehouse Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Computer Software Company

28%

Financial Services Firm

20%

Insurance Company

Government

Educational Organization

Retailer

University

Manufacturing Company

Healthcare Company

Wellness & Fitness Company

Real Estate/Law Firm

Construction Company

Energy/Utilities Company

Logistics Company

Pharma/Biotech Company

Recreational Facilities/Services Company

Wholesaler/Distributor

Sports Company

Transportation Company

Non Profit

Media Company

Outsourcing Company

Compare Microsoft Parallel Data Warehouse with alternative products

Learn more about Microsoft Parallel Data Warehouse

Microsoft Parallel Data Warehouse was previously known as Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse.