Microsoft Parallel Data Warehouse Reviews

Microsoft Parallel Data Warehouse has delivered a substantial return on investment by efficiently managing large data volumes and integrating with existing tools. One team observed a full return on investment, emphasizing its role in back-end operations. Another group finds it a quick solution for clients. Some sections are satisfied with the ROI but see room for improvement. However, certain areas of the organization do not actively track ROI.

Microsoft Parallel Data Warehouse pricing is generally competitive, often deemed well-priced compared to market offerings, especially for enterprises with large data needs. Costs often vary depending on data size and performance requirements, with some finding it expensive. Licensing agreements are sometimes facilitated through government partnerships. Organizations frequently manage costs through one-time or annual subscriptions, without needing extra support contracts. Integration with Azure is noted as cost-effective, though on-premises solutions may face higher costs.

• "The solution is cost-effective."
• "They offer an annual subscription. The pricing depends on the size of the environments."
• "The tool could be expensive if we need to manage a lot of data."

Organizations primarily use Microsoft Parallel Data Warehouse for storing and analyzing large volumes of data, including historical and real-time data. It supports enterprise data warehouse solutions, helps in building dashboards, integrates and transforms data from multiple sources, and serves as the backend for business intelligence platforms. It is used in sectors like finance, banking, insurance, and retail for tracking sales, shipping, transactions, and other key performance indicators, often utilizing tools like Power BI and Qlik for analytics.

Users report Microsoft Parallel Data Warehouse customer service and technical support as satisfactory. Some have direct Microsoft links, while others rely on online resources like Google and YouTube for assistance. Technical support, rated 7/10, is accessible and knowledgeable, though speed and Azure expertise could improve. A license is needed for support access. User feedback is generally positive, though there's a call for more knowledgeable customer service representatives.

Many users found Microsoft Parallel Data Warehouse's initial setup straightforward and efficient, often completed within days or weeks. However, experiences varied, with some finding it complex, especially when migrating from SQL Server or across multiple regions. Effective collaboration with Microsoft's support team was beneficial. Challenges included data complexity and integration. Knowledge and resources significantly influenced the ease of deployment, ranging from a few days to several months, depending on data size and project requirements.

Microsoft Parallel Data Warehouse is considered scalable by many users, though SQL expertise is often required for optimal use. Some experience no issues, successfully supporting hundreds of users across various environments, including large enterprises. However, others note limitations with large datasets and seek alternatives like Snowflake for better performance. Organizations find it easy to extend the system, yet a few mention room for scalability enhancement, particularly compared to other technologies.

Users find Microsoft Parallel Data Warehouse to be stable and reliable. While earlier versions had issues, it performs well even during outages. Stability is dependent on proper data setup and network conditions. It manages large data volumes effectively, though large data processing may slow down operations. Users report quick issue resolution, lack of crashes, and consistent performance. Some have rated its stability nine or ten out of ten, noting successful integration with various database systems.