Try our new research platform with insights from 80,000+ expert users
Microsoft Parallel Data Warehouse Logo

Microsoft Parallel Data Warehouse pros and cons

Vendor: Microsoft
3.9 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft Parallel Data Warehouse handles high volumes of data efficiently and supports fast data loads and real-time analysis.
Customer service and technical support are highly satisfactory.
The performance and usability of Microsoft Parallel Data Warehouse are highly valued, making it reliable and scalable.
Data collection and integration with business intelligence tools like BI and SAS are powerful features.
It integrates well with other Microsoft products and offers good firewall processing and data integrity features.

CONS

Microsoft Parallel Data Warehouse has limited compatibility with common BI tools and solutions.
Concurrent queries are restricted to 32, which limits its functionality as an active data warehouse.
More frequent feature updates are needed, as updates on the on-premise version are slow.
The tool is expensive, with high costs posing issues for users and businesses seeking cost-effective solutions.
Large datasets cause performance lags, leading to inefficiency during large query operations.
 

Microsoft Parallel Data Warehouse Pros review quotes

it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees
Feb 27, 2018
It handles high volumes of data very well.
reviewer1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
Nov 20, 2019
I am very satisfied with the customer service/technical support.
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees
Dec 5, 2019
The most valuable features are the performance and usability.
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,310 professionals have used our research since 2012.
MJ
BI Developer at a healthcare company with 51-200 employees
Dec 9, 2019
One of the most important features is the ease of using MS SQL.
CC
Product Director at a insurance company with 10,001+ employees
Dec 9, 2019
The most valuable feature for me is querying.
reviewer1038354 - PeerSpot reviewer
Team Lead at a computer software company with 10,001+ employees
Dec 12, 2019
The most valuable feature of this solution is performance.
AN
Senior Principal Consultant at a tech services company with 1,001-5,000 employees
Dec 15, 2019
The most valuable feature is the business intelligence (BI) part of it.
PS
Software Engineer at Tech Mahindra Limited
Dec 16, 2019
We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.
MS
EDRMS Practice Lead at a tech services company with 51-200 employees
May 4, 2020
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 or ease of use when getting a resource and knowing everything about it.
it_user1352403 - PeerSpot reviewer
System Administrator at a university with 501-1,000 employees
Aug 27, 2020
It is not a pricey product compared to other data warehouse solutions.
 

Microsoft Parallel Data Warehouse Cons review quotes

it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees
Feb 27, 2018
It needs more compatibility with common BI tools.
reviewer1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
Nov 20, 2019
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.
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees
Dec 5, 2019
More tools to help designers should be included.
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,310 professionals have used our research since 2012.
MJ
BI Developer at a healthcare company with 51-200 employees
Dec 9, 2019
I think that the error messages need to be made more specific.
CC
Product Director at a insurance company with 10,001+ employees
Dec 9, 2019
I would like to see better visualization features.
reviewer1038354 - PeerSpot reviewer
Team Lead at a computer software company with 10,001+ employees
Dec 12, 2019
The reporting for certain types of data needs to be improved.
AN
Senior Principal Consultant at a tech services company with 1,001-5,000 employees
Dec 15, 2019
This solution would be improved with an option for in-memory data analysis.
PS
Software Engineer at Tech Mahindra Limited
Dec 16, 2019
If the database is large with a lot of columns then it is difficult to clean the data.
MS
EDRMS Practice Lead at a tech services company with 51-200 employees
May 4, 2020
I would like the tool to support different operating systems.
it_user1352403 - PeerSpot reviewer
System Administrator at a university with 501-1,000 employees
Aug 27, 2020
It could be made more user-friendly for business users which would increase the user base.