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.