We performed a comparison between Microsoft Analytics Platform System and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This is a well-integrated solution and that integration empowers results."
"I like that it's integrated with other Azure products."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"It is closely integrated with other products in the MS portfolio."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"Helps our customers to discover trends, which provides useful information based on their business."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"The most valuable features of Snowflake are its performance and power."
"The initial setup is straightforward. You just need to follow the documentation."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"This solution has helped our organization by being easy to maintain and having good technical support."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"Hybrid environments are complex to manage."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Microsoft Analytics Platform System could have better support."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"The pricing model needs to be improved."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"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."
"Some SQL language functions could be included."
"Snowflake can improve its machine learning and AI capabilities."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"The design of the product is easily misunderstood."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"I would like to see a client version of the GUI."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Microsoft Analytics Platform System is rated 6.6, while Snowflake is rated 8.4. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata and IBM Netezza Performance Server, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our Microsoft Analytics Platform System vs. Snowflake report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
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.