Microsoft Parallel Data Warehouse Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
EtienneReynecke
Real User
Microsoft Dynamics Specialist at Strategix Business Solutions
Nov 20 2019

What is most valuable?

What I like the most about this solution is the fact that you can basically add capacity behind your data modeling, and you speed up the process before it goes into the Cube holding section. That's a great integration layer. You can basically collect all your data, and then that becomes a staging… more»

What needs improvement?

Something that needs to improve, is the integration layer itself connecting to other non-Microsoft layers. But I don't know if that can be improved, due to the complexity of the data that they're connecting to. But I think they can maybe look at a way to do incremental updates, as it is slightly… more»

What's my experience with pricing, setup cost, and licensing?

I think the program is well-priced compared to the other offerings that are out in the market.

What other advice do I have?

On a scale from one to 10, I rate this solution a nine. 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. The biggest part that we battle… more»
Mukul-Jain
Real User
BI Developer at a healthcare company with 51-200 employees
Dec 12 2019

What is most valuable?

One of the most important features is the ease of using MS SQL. It has been easy to do exactly what I wanted. For example, it was very easy to pull the data from, and it is also very easy to import data from CSV or Excel. If I needed a specific set of data from the master then it was easy to get it.

What needs improvement?

I think that the error messages need to be made more specific. Recently, I was working with a large amount of data, and I received a runtime error. I had to solve it by running the query several times, removing data each time. If the error messages were less ambiguous then it would have helped.

What other advice do I have?

My advice for anybody who is implementing this solution is not to overload your server with all of the data that you don't use on a day-to-day basis. It is very easy to pull the data that you need whenever it is required. You will have to decide how to store the data and how easy it is for your client to send new data. Neither of these things should be difficult to do, even for newcomers to SQL… more»
Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Data Warehouse. Updated: December 2019.
389,475 professionals have used our research since 2012.
AnupNair
Consultant
Senior Principal Consultant at a tech services company with 1,001-5,000 employees
Dec 17 2019

What is most valuable?

The most valuable feature is the business intelligence (BI) part of it. BI includes decision trees and similar functionality. This happens post-building of the data warehouse when you start using the analysis features. The user interface is definitely good.

What needs improvement?

This solution would be improved with an option for in-memory data analysis. Scalability can be improved because there are other tools that perform better with very large datasets.

Which solution did I use previously and why did I switch?

We are using Pentaho Data Warehouse in addition to this solution. We select which one is implemented depending on the customer's request and what they want to do.

What other advice do I have?

This is a solution that has good performance and I recommend it. The support from Microsoft is also another thing that makes the Parallel Data Warehouse a good option. The biggest lesson that we have learned from using this solution is that customers are most interested in a quick project turnaround… more»
Real User
Team Lead at a software R&D company with 10,001+ employees
Dec 14 2019

What is most valuable?

The most valuable feature of this solution is performance. It reduces the time it takes to process data.

What needs improvement?

The initial setup of this solution is complex and can be improved. Sometimes you need to re-run the reports because they don't work. The reporting for certain types of data needs to be improved.

What other advice do I have?

My advice for anybody who is implementing Microsoft Parallel Data Warehouse is to be aware of how big the data is. You have to be sure of how to secure and take care of the data. You have to think about scalability. I would rate this solution a seven out of ten.
Elham-Gharegozloo
Real User
Senior System Analyst at Zarrin Roya
Dec 05 2019

What is most valuable?

The most valuable features are the performance and usability. Microsoft Parallel Data Warehouse is simple to use, and the user interface is intuitive.

How has it helped my organization?

This solution helps the higher levels of the organization because they have better visibility of the whole company. This helps with decision making in terms of what should be improved or implemented.

What needs improvement?

More tools to help designers should be included.

Which solution did I use previously and why did I switch?

Prior to Microsoft Parallel Data Warehouse, we used a standard relational SQL database. We switched because of the performance and because the data and KPI changed. It would be difficult to use a relational database. We switched to a data… more»

What other advice do I have?

My advice to anybody who is implementing this solution is to design the databases as well as they can because it is difficult to make changes in the future. It is also important to have a time field in your data in case you want to use it… more»
PALAKSURI
Real User
Software Engineer at Tech Mahindra Limited
Dec 17 2019

What is most valuable?

The most valuable feature is that we can deploy directly to the production environment, rather than having to go through a development environment first.

How has it helped my organization?

We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it. If there are discussions with our clients about changes that need to be made then it is us who implements them.

What needs improvement?

If the database is large with a lot of columns then it is difficult to clean the data.

What other advice do I have?

I am not comfortable with the Microsoft Parallel Data Warehouse at the moment. I would rate this solution a six out of ten.
ClaudeChan
Real User
Product Director at a insurance company with 10,001+ employees
Dec 10 2019

What do you think of Microsoft Parallel Data Warehouse?

What is our primary use case?

The primary use cases for this solution are for recording and transactions.

What is most valuable?

The most valuable feature for me is querying.

What needs improvement?

I would like to see better visualization features. A stateless update functionality for the forms may help. Without this, you have to perform updates manually using the drop-down menu. The user interface should be more user-friendly.

For how long have I used the solution?

I have been using the SQL Data Warehouse for fifteen years.

What do I think about the stability of the solution?

The stability of this solution is based on the set up from the outsourcing team. There are a lot of things to consider, including the connection. It is constantly being used with transactions…
Real User
Vice President at a manufacturing company with 1-10 employees
Dec 16 2019

What do you think of Microsoft Parallel Data Warehouse?

What is our primary use case?

We primarily use the solution to build up our server analytics.

What is most valuable?

The data transmissions between the data models is the most valuable feature. The database is enormous, so much so that we haven't exploited it completely.

What needs improvement?

I don't have any recommendations for new features at this time.

For how long have I used the solution?

I've been using the solution for about one year.

What do I think about the stability of the solution?

The stability of the solution is good. We haven't had any issues with it.

What do I think about the scalability of the solution?

The solution is very scalable.

How are customer service and technical support?

My understanding is that the team's experience with technical…
See 2 More Microsoft Parallel Data Warehouse Reviews

Articles

User Assessments By Topic About Microsoft Parallel Data Warehouse

Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Data Warehouse. Updated: December 2019.
389,475 professionals have used our research since 2012.

Microsoft Parallel Data Warehouse Questions

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.

Also known as
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse
Microsoft Parallel Data Warehouse customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe

Read Archived Reviews