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 excels in handling high volumes of data efficiently, supporting fast daily loads and near real-time analysis.
The integration within Microsoft's ecosystem is seamless, enabling powerful data collection and reporting capabilities.
Customers appreciate its scalability, from a few users to many, while managing large data amounts smoothly.
The ability to control costs by pausing the service when not in use is a significant advantage.
It offers reliable performance and strong data integrity features, crucial for effective database management.

CONS

Microsoft Parallel Data Warehouse lacks compatibility with various Business Intelligence tools and has limited concurrent queries, positioning it more as a data storage option rather than a dynamic data warehouse.
Microsoft Parallel Data Warehouse would benefit from better automation for the data integration process, which would make incremental updating easier for users and developers.
Error messages in the Microsoft Parallel Data Warehouse need greater specificity to improve troubleshooting.
There is a need for improved data visualization and reporting features in Microsoft Parallel Data Warehouse.
The expense of Microsoft Parallel Data Warehouse remains a concern for many customers, particularly given its high cost compared to other solutions.
 

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: January 2026.
881,665 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: January 2026.
881,665 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.