Microsoft Azure Synapse Analytics Primary Use Case

Jael Sande
Information Architect at Systems Analysis & Design Engineering
I am a consultant, and when I go on-site, it's to determine how they can move to the cloud. Often, clients want to migrate because everyone else is. Others want to because they assume that they are going to save money. They will require less support staff in-house and they won't have to purchase servers. Customers have a need to cut back on expenses, and equipment. Their servers are becoming obsolete and are required to update their licensing. Rather than doing that and creating a larger overhead, they look into Microsoft Azure. It might be a better way to go and it's less money upfront. Some clients have already implemented VMs. A lot of their data is stored that way. There is a difference when you move that to the cloud. If you share it back and forth, you have your hybrid where you have it in the cloud and on-premises. It depends on the company and what their plans are. There is an automated tool that you can analyze your data sources and identify whether or not you can upgrade them and you can also use it for SharePoint. I've used Azure for that purpose. In regards to data warehouses, I'm doing the upgrades from on-prem to in the cloud, or a combination of both. View full review »
reviewer1394304
Sr. Teradata Consultant at a tech services company with 201-500 employees
We primarily use the solution for analytic purposes. It allows us to store data for years and then go back and look up information to learn things like how users function, react, follow trends, etc. It allows us to follow past and recent demands for products as well so that we might be able to find the reasoning behind the action or trend. View full review »
Mukul Biswas
Enterprise Solutions at Celebal Technologies
We are service providers for our clients. My clients primarily come from the enterprise segments, such as manufacturing, retail, pharmaceutical, and industrial. Most are supported by a large ERP solution like SAP. Some of our clients are mid-size and others are large enterprise companies, some of the largest in India. View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,986 professionals have used our research since 2012.
reviewer1003956
Managing Partner at a tech services company with 11-50 employees
This is a data warehousing solution. View full review »
EmeaIT677
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
We use this solution for data warehousing. Specifically, we have an ERP that does not have a direct connection to our Power BI solution. This connection will exist in the future, but in the meantime, we use an ETL process to transport data out of the ERP into Azure SQL, and then from Azure SQL into Power BI. At that point, we can use the dashboard to display our information. Our environment is a private cloud. View full review »
reviewer1052472
Data Architect at a tech services company with 10,001+ employees
Our general use of this solution has to do with the needs of one of our clients. They had an SQL server and they were migrating from an on-premises SQL Server to Azure SQL server on the cloud. We use this solution because it fits their budget and they have some clients in other countries they want to give access to the product through Power BI. View full review »
AveekDas
Analytics Engineer at a tech services company with 51-200 employees
We are developing our SQL Data Warehouse locally, using SQL Server 2016 on our private cloud, and we will be migrating it to Azure once it is ready. The company for which I am working deals with products in the leisure industry, such as museums and swimming pools. They use the data warehouse solution for big data reporting. Currently, we are developing a multi-platform data warehouse that can support the reporting requirements for all of the customers. Whatever analytics they want to perform will be done with the data warehouse, and not the SQL database application. My role is to design the data warehouse, and once that is complete, we need to build the data pipelines so that the data can be moved from the application databases into the warehouse. Then we will design the OLAP servers and OLAP cubes, vertically, to give us a presentation layer on top of the data warehouse. This layer is what the customers will be using. View full review »
reviewer1423767
Software Engineer at a K-12 educational company or school with 501-1,000 employees
I used it for a project thesis for my school project. View full review »
reviewer911274
Practice Head BI at a tech services company with 1,001-5,000 employees
We are a solution provider and we provide different tools for our clients. Microsoft Azure SQL Data Warehouse is one of the solutions that we have implemented. The use cases vary depending on the client. We have a couple of clients who are moving their data from on-premises to Azure databases, and they are using this solution primarily for reporting analytics. They also use visualization tools on top of the reporting. View full review »
reviewer1294518
Solution Principal at a computer software company with 5,001-10,000 employees
We are a consulting agency and the Microsoft Azure SQL Data Warehouse is what we use for general BI reporting and visualization. View full review »
PradeepPV
Vice President Technologies at Excelencia
We are a software development company and this is one of the solutions that we recommend to our clients. The applications that we develop make use of this technology. View full review »
reviewer1041249
Project Manager at a tech services company with 5,001-10,000 employees
We primarily use this solution for source analytics and procurement. View full review »
Ankit Mittal
Director of Data Analytics Practice at a computer software company with 501-1,000 employees
The primary use case is for the fast retrieval of data, which is in the data warehouse on-premises and migrating it to the cloud. View full review »
Rajendran Veerappan
Director at Nihil Solutions
There are around 10 people using this solution within our organization and we have plans to increase the usage. View full review »
C K
Consultant at a tech services company with 51-200 employees
We use the private deployment model of this solution. View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,986 professionals have used our research since 2012.