Microsoft Parallel Data Warehouse Valuable Features

PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins

The most valuable feature of the solution is SQL Server commands that we use in our company since it allows us to write stored procedures or different stored procedures, which we can call from Visual Studio where it is stored. SQL is faster compared to SSIS, so we can use stored procedures from there.

View full review »
PeterMaier - PeerSpot reviewer
Chief Financial Officer at a retailer with 5,001-10,000 employees

I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets. 

View full review »
SG
Application Designer at LMKR

Everything about the solution is great. The admission tools, their BI tools, and data warehousing tools are all good.

The solution has been reliable. It's stable. 

You can scale the product well. 

The implementation process is great.

Its interface is good. 

The tools are very good, efficient, and easy to work with.

View full review »
Buyer's Guide
Microsoft Parallel Data Warehouse
April 2024
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
Sunil_Shah - PeerSpot reviewer
Senior software developer at a tech services company with 1,001-5,000 employees

The solution's integration is good, and visualization happens in Power BI, making it convenient. Likewise, the solution has free features. It is not that expensive when we try to make it public on our portal.

View full review »
StevenLai - PeerSpot reviewer
Sr. Data Engineer at a real estate/law firm with 1,001-5,000 employees

We have ownership of our data, and it keeps everything on-premises, so we have complete control over our data.

View full review »
EO
Senior Systems Engineer at Dimension Data

Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.

View full review »
AS
IT manager at Farmatrejd

Data collection and reporting are the tool's valuable features. 

View full review »
ONUR ÇALISKAN - PeerSpot reviewer
Managing Partner at INFOLOJIK

It is a very stable database.

View full review »
IS
CTO at Data Semantics Pvt Limited

Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products. The solution makes it easy to build the code and maintain it. At the same time, you get enough resources in the market if you have any queries or need support for the ecosystem.

View full review »
Albert Lacerda - PeerSpot reviewer
Managing partner at Dynamis Informatica

The UI is very simple and functional for my clients, most of the clients that use the solution are not experts. They have fairly limited knowledge of computer usage, and they can create things with this solution. Microsoft Parallel Data Warehouse is very easy to use. 

View full review »
VJ
BI/Data Warehouse Analyst at a healthcare company with 501-1,000 employees

It's very helpful at a database level. It provides a lot of good integration potential.

It performs very well overall.

The interface is fine.

The product does offer different packages. 

The tools on offer for handling the integration are very helpful. 

View full review »
AN
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 »
MM
Team Leader at a tech services company with 201-500 employees

It's a very good solution because we can manage large volumes of data. We can store the data in a data lake for a very low cost. We can move the data in Parallel when we need more performance or decide to leave the data in the data lake. It's a very good product at the moment.

View full review »
MJ
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 »
CC
Product Director at a insurance company with 10,001+ employees

The most valuable feature for me is querying.

View full review »
SM
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 »
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees

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 »
ER
Microsoft Dynamics Specialist at a computer software company with 51-200 employees

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 »
it_user1352403 - PeerSpot reviewer
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 »
it_user347586 - PeerSpot reviewer
Solution Architect at a comms service provider with 11-50 employees

The bulk data-load feature with fast response is one of the most intriguing features. In addition, clustered column store index boosts OLAP query performance significantly.

View full review »
MS
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 »
AJ
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 »
PS
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 »
it_user400518 - PeerSpot reviewer
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 10,001+ employees

Nothing specific, comparable to other solutions.

View full review »
it_user694689 - PeerSpot reviewer
Business Intelligence evangelist at a hospitality company with 10,001+ employees

MPP processing gives us the ability to distribute large data sets across nodes.

View full review »
it_user4014 - PeerSpot reviewer
Developer at a tech consulting company with 51-200 employees
Microsoft SQL Server Parallel Data Warehouse provides significant performance boost from 10-100 X times faster for data loading operation.It minimized the cost of design with lower infrastructure requirements.It is designed to provide optimized performance on latest industry hardware. View full review »
it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees

It handles high volumes of data very well.

View full review »
it_user6414 - PeerSpot reviewer
CEO at a tech company with 51-200 employees
• SQL Data Warehouse provides our organization with a way to access all corporate data in a uniform way. • SQL Data Warehouse allows us to manage our database using network or hierarchical database systems rather than solely relying on relational DBMSs. • It supports the bottom-up process of data warehouse creation where several data marts can be joined to form one big warehouse. I found this very handy especially where a few teams are involved. View full review »
SM
Vice President at a tech consulting company with 201-500 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 »
Buyer's Guide
Microsoft Parallel Data Warehouse
April 2024
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.