What is our primary use case?
I am using the Microsoft Parallel Data Warehouse for working with information services and datasets, creating reports. It is used primarily for our historical data, but we do some in real-time also. We can receive data weekly, nightly, or even hourly.
What is most valuable?
The most valuable feature of this solution is performance. It reduces the time it takes to process data.
What needs improvement?
The initial setup of this solution is complex and can be improved.
Sometimes you need to re-run the reports because they don't work.
The reporting for certain types of data needs to be improved.
For how long have I used the solution?
I have been working with these kinds of services for the past five to ten years.
What do I think about the stability of the solution?
The stability depends on your data and whether it is null. If the data is set up properly then it will be more stable.
What do I think about the scalability of the solution?
It is definitely scalable. We have more than 220 users in multiple cities. Most of the people, perhaps 70%, are information technology users. The remaining 30% are business analysts who are concerned only with reports.
We do plan on increasing our usage. We recently converted all of our Tableau data, and now we are working on permissions and security.
How are customer service and technical support?
The technical support from Microsoft is good.
How was the initial setup?
The initial setup is definitely complex.
We are not always aware of where the data comes from because it is distributed. Sometimes the data is fine and sometimes it needs to be set up. Once it is configured then it runs fine in parallel.
The length of time for deployment depends on the size of the data and whether we were also implementing a data warehouse or a data mart. When I was implementing this solution and copying data, it took between six and eight months. That is end-to-end with everything finished.
If it is a small data mart then it may only take a month.
What about the implementation team?
Our in-house team, including our DBA, handled the deployment.
What other advice do I have?
My advice for anybody who is implementing Microsoft Parallel Data Warehouse is to be aware of how big the data is. You have to be sure of how to secure and take care of the data. You have to think about scalability.
I would rate this solution a seven out of ten.