2019-11-20T05:39:00Z

What needs improvement with Microsoft Parallel Data Warehouse?


Please share with the community what you think needs improvement with Microsoft Parallel Data Warehouse.

What are its weaknesses? What would you like to see changed in a future version?

Guest
99 Answers

author avatar
Top 5Real User

The setup has room for improvement. Some customers want to go to non-Windows Servers. Have the entire SQL Server done there though is an obstacle for us, as the configuration of Microsoft BI with cubes is a bit complicated. I would like the integration to be offered in a simpler way. I would like improvement in the integration between Microsoft SQL cubes and Parallel Data Warehouse with other members of the Microsoft family, such as Microsoft Power BI and SharePoint. This tool needs a lot of memory for processing. As it does a lot of jobs, it may need this memory while other tools don't need that much. It would help if they enhanced the memory and hardware usage of the tool in order to support the performance of doing the queries I would like the tool to support different operating systems. I want a dashboard.

2020-05-04T05:12:00Z
author avatar
Top 5Real User

If the database is large with a lot of columns then it is difficult to clean the data.

2019-12-16T08:14:00Z
author avatar
Top 10Real User

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

2019-12-16T08:13:00Z
author avatar
Top 5Consultant

This solution would be improved with an option for in-memory data analysis. Scalability can be improved because there are other tools that perform better with very large datasets.

2019-12-15T05:58:00Z
author avatar
Top 10Real User

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.

2019-12-12T07:48:00Z
author avatar
Top 10Real User

I would like to see better visualization features. A stateless update functionality for the forms may help. Without this, you have to perform updates manually using the drop-down menu. The user interface should be more user-friendly.

2019-12-09T10:59:00Z
author avatar
Top 5Real User

I think that the error messages need to be made more specific. Recently, I was working with a large amount of data, and I received a runtime error. I had to solve it by running the query several times, removing data each time. If the error messages were less ambiguous then it would have helped.

2019-12-09T10:58:00Z
author avatar
Top 5Real User

More tools to help designers should be included.

2019-12-05T06:53:00Z
author avatar
Top 5LeaderboardReal User

Something that needs to improve, is the integration layer itself connecting to other non-Microsoft layers. But I don't know if that can be improved, due to the complexity of the data that they're connecting to. But I think they can maybe look at a way to do incremental updates, as it is slightly different.

2019-11-20T05:39:00Z
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,764 professionals have used our research since 2012.