Microsoft Parallel Data Warehouse Valuable Features
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.
I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.
View full review »SG
Syed SaqibGhawas
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.
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 »We have ownership of our data, and it keeps everything on-premises, so we have complete control over our data.
View full review »EO
Edgar Orare
Senior Systems Engineer at Dimension Data
Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
View full review »AS
Andrej Shendov
IT manager at Farmatrejd
Data collection and reporting are the tool's valuable features.
View full review »It is a very stable database.
View full review »IS
Imaduddin Shah
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 »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
reviewer963051
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
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 »MM
reviewer2255670
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
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.
CC
ClaudeChan
Product Director at a insurance company with 10,001+ employees
The most valuable feature for me is querying.
View full review »SM
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 »EG
Elham-Gharegozloo
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
reviewer1212726
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 »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 »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
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 »AJ
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 »PS
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 »Nothing specific, comparable to other solutions.
View full review »MPP processing gives us the ability to distribute large data sets across nodes.
View full review »
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 handles high volumes of data very well.
View full review »
• 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
Subrata Maity
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.