Microsoft Parallel Data Warehouse Reviews

• 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.

• Data cleaning involves the use of special software to help the cleaning team uniformly match attributes from the target source data to its destination. • It is expensive. SQL Data Warehouse is not supported by all versions of SQL Server such as the Express version and therefore becomes unavailable to many limiting its acquisition and use. • Uses a different approach to databases than that used in relational DBMS hence posing a challenge to novices.

• It comes as a special tool of cleaning data through the data transformation process where data is extracted from many sources before it is assembled and consolidated to form a single database. This is the main factor that led my company to choose SQL Data Warehouse as the special tool to consolidate relational databases. Close examination was done on SAP Data Warehouse and IBM Data Warehouse but SQL Data Warehouse provided a more extensive way of integrating data. I personally value the role that SQL Data Warehouse has contributed in achieving the goals of business intelligence. Users will to generate timely reports from huge databases as well as database cleaning should embrace this provision.

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

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.

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

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

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

The solution is very scalable.

My understanding is that the team's experience with technical support has been good.

We didn't previously use a different solution. Our customers chose this solution.

The initial setup was straightforward. We had a knowledgeable team working on the implementation. Deployment took about six to eight weeks.

We use the on-premises deployment model.

I'd rate the solution eight out of ten.

I use Microsoft Parallel Data Warehouse to construct and manage a data warehouse. I mainly write SQL queries to manage the data.

The interface is very user-friendly. It's great for managing the data warehouse efficiently when well-managed.

When there are many users or many expensive queries, it can be very slow.

I have been using Microsoft Parallel Data Warehouse for three years.

It is very stable based on my experience.

Scalability could be improved. I would rate it seven out of ten.

I did not use any other similar solution before Microsoft Parallel Data Warehouse.

The installation took less than one hour.

We used a third party for the implementation.

I recommend this solution as it is very stable and, when well managed, can be efficient in organizing data.

I'd rate the solution eight out of ten.

On-premises