Microsoft's Azure Machine Learning is and end-to-end data science and analytics solution that helps professional data scientists to prepare data, develop experiments, and deploy models in the cloud. It replaces the Azure Machine Learning Workbench.
$0
per month
Azure Synapse Analytics
Score 7.6 out of 10
N/A
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
It's well suited for large, fastly growing, and frequently changing data warehouses (e.g., in startups). It's also suited for companies that want a single, relatively easy-to-use, centralized cloud service for all their data needs. Larger, more structured organizations could still benefit from this service by using Synapse Dedicated SQL Pools, knowing that costs will be much higher than other solutions. I think this product is not suited for smaller, simpler workloads (where an Azure SQL Database and a Data Factory could be enough) or very large scenarios, where it may be better to build custom infrastructure.
User friendliness: This is by far the most user friendly tool I've seen in analytics. You don't need to know how to code at all! Just create a few blocks, connect a few lines and you are capable of running a boosted decision tree with a very high R squared!
Speed: Azure ML is a cloud based tool, so processing is not made with your computer, making the reliability and speed top notch!
Cost: If you don't know how to code, this is by far the cheapest machine learning tool out there. I believe it costs less than $15/month. If you know how to code, then R is free.
Connectivity: It is super easy to embed R or Python codes on Azure ML. So if you want to do more advanced stuff, or use a model that is not yet available on Azure ML, you can simply paste the code on R or Python there!
Microsoft environment: Many many companies rely on the Microsoft suite. And Azure ML connects perfectly with Excel, CSV and Access files.
It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task.
It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on.
It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the SQL Data Warehouse.
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
It is easier to learn, it has a very cost effective license for use, it has native build and created for Azure cloud services, and that makes it perfect when compared against the alternatives. As a Microsoft tool, it has been built to contain many visual features and improved usability even for non-specialist users.
When client is already having or using Azure then it’s wise to go with Synapse rather than using Snowflake. We got a lot of help from Microsoft consultants and Microsoft partners while implementing our EDW via Synapse and support is easily available via Microsoft resources and blogs. I don’t see that with Snowflake
Productivity: Instead of coding and recoding, Azure ML helped my organization to get to meaningful results faster;
Cost: Azure ML can save hundreds (or even thousands) of dollars for an organization, since the license costs around $15/month per seat.
Focus on insights and not on statistics: Since running a model is so easy, analysts can focus more on recommendations and insights, rather than statistical details
