We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"I am very satisfied with the customer service/technical support."
"The most valuable features are the performance and usability."
"The most valuable feature for me is querying."
"One of the most important features is the ease of using MS SQL."
"The most valuable feature of this solution is performance."
"The data transmissions between the data models is the most valuable feature."
"The most valuable feature is the business intelligence (BI) part of it."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Functionality needs to be more up-to-date with competing products."
"The pricing model needs to be improved."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."
"More tools to help designers should be included."
"I would like to see better visualization features."
"I think that the error messages need to be made more specific."
"The reporting for certain types of data needs to be improved."
"This solution would be improved with an option for in-memory data analysis."
"If the database is large with a lot of columns then it is difficult to clean the data."
"I would like the tool to support different operating systems."
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
"Users have to pay extra for premium-level technical support."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"I think the program is well-priced compared to the other offerings that are out in the market."
"Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
"All the features that we use do not require any additional subscription or yearly fees."
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Microsoft Analytics Platform System is ranked 15th in Data Warehouse with 4 reviews while Microsoft Parallel Data Warehouse is ranked 7th in Data Warehouse with 11 reviews. Microsoft Analytics Platform System is rated 6.2, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Microsoft Analytics Platform System writes "Has unique functionality for advanced analytics but could use enhancement in machine learning and AI features". On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Apache Hadoop, Oracle Exadata, Oracle Big Data Appliance and Amazon Redshift, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and Vertica. See our Microsoft Analytics Platform System vs. Microsoft Parallel Data Warehouse report.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.