Microsoft Parallel Data Warehouse Valuable Features

Mohammed Sleem
EDRMS Practice Lead at a tech services company with 51-200 employees
* Availability of resources everywhere * The cost of resources * The information knowledge is there. * It is easy to use. You can do what you want with the tool. * It integrates well with SQL Server. 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. You can collect data from Oracle Databases, SQL databases, or file systems where it is then saved in one location, building cubes in an easy for SSIS packages. View full review »
reviewer1352403
System Administrator at a university with 501-1,000 employees
In our economic situation, the price is really the most important consideration. It is not a pricey product compared to other data warehouse solutions like Oracle and similar products. It is less expensive, but it still achieves our goals and fulfills all our needs. So I think it is a comfortable solution for us and we can afford the price. View full review »
EtienneReynecke
Microsoft Dynamics Specialist at Strategix Business Solutions
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 database for other models, where you can then either report directly with Power BI, or Excel, or other applications, and in more specifically, data Cubes with Microsoft Analysis Services. View full review »
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
437,827 professionals have used our research since 2012.
Mukul-Jain
BI Developer at a healthcare company with 51-200 employees
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. View full review »
AnupNair
Senior Principal Consultant at a tech services company with 1,001-5,000 employees
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. View full review »
reviewer1038354
Team Lead at a computer software company with 10,001+ employees
The most valuable feature of this solution is performance. It reduces the time it takes to process data. View full review »
Elham-Gharegozloo
Senior System Analyst at Zarrin Roya
The most valuable features are the performance and usability. Microsoft Parallel Data Warehouse is simple to use, and the user interface is intuitive. View full review »
Sekhar Minna
Senior Software Engineer at a tech services company with 1,001-5,000 employees
Most features on the SQL Server are quite useful to us. Its temporary functionality and the partitioning, searching, etc., are great. Tools like the BI and SAS are excellent. View full review »
PALAKSURI
Software Engineer at Tech Mahindra Limited
The most valuable feature is that we can deploy directly to the production environment, rather than having to go through a development environment first. View full review »
ClaudeChan
Product Director at a insurance company with 10,001+ employees
The most valuable feature for me is querying. View full review »
reviewer1086345
Vice President at a manufacturing company with 1-10 employees
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. View full review »
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
437,827 professionals have used our research since 2012.