Analytics Engineer at a tech services company with 51-200 employees
Real User
Dec 15, 2019
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.
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.
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.
Data Architect at a tech services company with 10,001+ employees
Real User
Nov 13, 2019
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.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Real User
Jul 28, 2019
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.
Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.
Microsoft Azure Synapse Analytics is built with these 4 components:
Synapse SQL
Spark
Synapse Pipeline
Studio
Microsoft Azure Synapse Analytics...
We primarily use this solution for source analytics and procurement.
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.
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.
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.
This is a data warehousing solution.
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.
We use the private deployment model of this solution.
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.