2019-07-28T07:35:00Z

What is your primary use case for Microsoft Azure Synapse Analytics?

83

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
3131 Answers

author avatar
Top 5LeaderboardReal User

We have been using Microsoft Azure Synapse Analytics as our proof of concept in our data warehouse. As for the analytics part, we have not used it because we do not have any SQL pools. We think it is a bit more than we need because our data is not implicated and the data sets are not very large. It is mostly been used for the detection functions and to link up the sources.

2021-08-17T18:39:37Z
author avatar
Top 5Real User

The healthcare sector is looking for how to accomplish certain processes because currently a lot of it is pure logistics. The goal is to announce and to make processes more transparent and see if they can be made more efficient. This is where business analytics comes in. The organization is using different kinds of information sources, such as electronic client dossiers or HR systems. They will see what kind of knowledge is required, how the patient or the clients are experiencing what quality of health, and create dashboards to see how the organization is doing. This will show which areas they can improve and which areas are already more efficient to make them more visible. This should allow a better understanding from the management, organization, and healthcare professional.

2021-05-17T12:28:28Z
author avatar
Top 5LeaderboardReal User

We're using this solution for analytics and its modeling capabilities. It allows you to have your visualization on top of your synapse analytics. We are partners with Microsoft.

2021-03-11T12:40:17Z
author avatar
Top 20Real User

It is for business intelligence. We are gathering all the data from legacy systems and transforming the data. We are then pushing the data back towards Power BI.

2021-02-23T09:59:56Z
author avatar
Top 10Real User

We're using this solution for general data integration. We are customers of Microsoft Azure Synapse Analytics and I'm a data specialist.

2021-02-06T07:34:59Z
author avatar
Top 20Real User

We are using it internally and afterward some of the outcomes are made public, either to customers or in different projects. It's mainly for preparing internal documents when we use Word. Otherwise, we use it for externally or for a lot of PowerPoint and Excel for budget purposes. Being a small company, we don't need a very sophisticated software solution, so with an Excel spreadsheet, we can handle the different budget of different projects simultaneously.

2021-01-28T22:53:34Z
author avatar
Top 5LeaderboardReal User

We use the solution on our servers for analytics.

2021-01-27T17:20:19Z
author avatar
Top 20Real User

We are an IT service provider. We develop solutions for our clients and this solution is used in some aspects of that.

2020-12-31T08:39:34Z
author avatar
Top 5Real User

I work with Azure Synapse Analytics, Power BI, and Premier as a data administrator, using Microsoft's Azure cloud infrastructure. Azure Synapse Analytics is the principal data administration tool for our internal data warehousing, but we also use it for our customers' data warehousing and analytics in different industries. For data entry, we use Microsoft Power BI. Internally, we have about 200 personnel currently using Azure Synapse Analytics, including data specialists, service managers, and other tech workers. It is not extensively used by all, however, because we don't often use it for very large amounts of data, except where financial data is involved.

2020-12-31T07:00:12Z
author avatar
Top 20MSP

I work for a consulting firm, with many different use cases. Synapse DW is for traditional data warehousing with a large amount of volume, that requires you to do reporting. In terms of Synapse Analytics, I haven't put it in yet, but I'm looking at it for kind of one-stop-shop or Swiss Army Knife type projects. They've been asking for a factory or creating something that connects to the cosmos to turn it into analytics reportings, just sort of needless connecting and just making it easy from a developer standpoint to deliver on any sort of business analytics that needs to be done.

2020-12-28T16:02:54Z
author avatar
Top 20Real User

Our primary use case is to process data and provide it to our clients.

2020-12-23T01:30:36Z
author avatar
Top 5Real User

We are using this solution for data warehousing and analytics.

2020-12-16T06:41:32Z
author avatar
Top 5Real User

We are using this product data warehousing and analytics.

2020-12-15T23:36:52Z
author avatar
Top 20Real User

We are mainly using this solution as an interface between the Data Lake and the users. We are consultants and this product assists with the services that we offer for our clients. Our company has a large number of consultants who are working in this space.

2020-11-26T21:01:19Z
author avatar
Top 10Real User

Our general use case is for government purposes, and therefore, I really can't get into too much detail about it.

2020-11-20T10:07:03Z
author avatar
Top 10LeaderboardReal User

Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across.

2020-10-19T09:33:00Z
author avatar
Top 20Real User

I used it for a project thesis for my school project.

2020-10-11T08:58:07Z
author avatar
Real User

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.

2020-09-13T07:02:24Z
author avatar
Top 20Real User

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.

2020-09-10T07:35:43Z
author avatar
Top 20LeaderboardReal User

There are around 10 people using this solution within our organization and we have plans to increase the usage.

2020-08-24T05:54:00Z
author avatar
Top 20Real User

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.

2020-08-02T08:16:00Z
author avatar
Consultant

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.

2020-07-29T07:45:56Z
author avatar
Top 5Real User

We are a consulting agency and the Microsoft Azure SQL Data Warehouse is what we use for general BI reporting and visualization.

2020-07-12T11:48:49Z
author avatar
Real User

We primarily use this solution for source analytics and procurement.

2019-12-18T05:44:00Z
author avatar
Top 20Real User

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.

2019-12-15T05:58:00Z
author avatar
Top 20Real User

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.

2019-12-12T07:48:00Z
author avatar
Real User

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.

2019-12-11T05:40:00Z
author avatar
Real User

This is a data warehousing solution.

2019-11-13T05:29:00Z
author avatar
Real User

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.

2019-11-13T05:28:00Z
author avatar
Consultant

We use the private deployment model of this solution.

2019-09-23T06:34:00Z
author avatar
Real User

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.

2019-07-28T07:35:00Z
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
534,226 professionals have used our research since 2012.