We just raised a $30M Series A: Read our story

Microsoft Azure Synapse Analytics Valuable Features

JS
Information Architect at Systems Analysis & Design Engineering

What I use the most is the tool to identify the upgrades. When you have a data warehouse on-premise you have jobs that run. Similar to an SQL agent, you are not comparing apples to apples, there are differences between the way the jobs are run on Azure versus the on-premises.

We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud.

They can be leary of moving to the cloud, They want to determine when someone has access to the client's data when sharing, and are in the same environment, that the data is secure. Essentially, they are accountable and need to be able to identify how secure their data is for their clients.

View full review »
CHTO at Timp-iT

The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems. We are trying to get these organizations to work with the architecture. This should allow these organizations if there is a new product or a new piece of software that is introduced to be able to handle operations themselves. For example, being able to attach the new product to a Power Bl, create a connector, or create interactive information exchange between these two or more different information systems. Standardization and simplicity, are key features.

The solution can integrate well if there is a connector. It will integrate perfectly with the Office 365 suite and Workspace 365.

View full review »
SS
Sr. Teradata Consultant at a tech services company with 201-500 employees

With this solution, I can better understand buying patterns and user habits. I can tell in real-time a customer's review and purchase based on that. I can tell that from the cloud data of Azure Data Warehouse.

The solution offers a variety of different features.

There are two layers, so data storage and computation are separated.

For the customer, there aren't any storage limitations, so you are able to explore and size of data including megabytes and terabytes. Once you have stored the data you can analyze the data that if you have in order to write some complex queries. After that, the solution makes it possible to visualize that data itself. 

The computation makes it so that you can run scenarios without an impact on your storage location.

If you compare the product to other solutions, you'll notice it takes less time for less cost. All other vendors have different architecture so their pricing is a little bit different and they are charging pricing per second. Microsoft charges per unit, or DTU, Data Transfer Unit. It will charge based on how much data you are consuming and how much data you are doing transactions with. It is monthly not daily.

Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task.

The solution is consistently improving a lot of things, including security features. There are eight or nine different security features there. You can even encrypt your data.

View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,136 professionals have used our research since 2012.
STI Data Leader at grupo gtd

We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for different sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on.

It is our main data warehouse solution, and the one big feature I appreciate is all its various analytics functions. The built-in analytics also makes it an attractive option for our customers, where we act as a service provider for them.

View full review »
DR
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees

The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage.

View full review »
Enterprise Solutions at Celebal Technologies

Some of the most valuable features would include Familiarity for practitioners like us and also familiarity for the businesses. SQL servers have been around for several decades and there are many who are familiar with SQL servers, such as SSIS and SSRS.

They are available on the Cloud, and the platform is very intuitive.

It integrates very well with Power BI, which I would rate as the best self-service BI. All the data warehouses eventually end up in BI or Machine Learning. 

Instant Apps that are more integrated rather than desperate components. You need to get different components engineered together, and with SQL everything comes together.

Instant Apps is a combination of your Spark compute platform, your SQL data platform, and your object storage. It's a platform that is integrated all together. 

It's easy to work with a faster turnaround time on my project deliveries.

Also, the integration with Power BI self-service is much, much easier and familiar.

You can have several SQL servers, they have large .NET artifacts that combine various components together very well.

View full review »
ML
Managing Director at a consultancy with 1-10 employees

The macro functions of Excel are very useful. 

The stability is pretty good.

The solution has the potential to scale.

View full review »
Analytics Engineer at a tech services company with 51-200 employees

The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis. We have a nightly load where all of the data is updated, and it is a very good feature.

The transaction log shipping gives us the ability to replicate the database onto different servers for backup and synchronization.

View full review »
JL
Senior Architect at a tech services company with 51-200 employees

I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.

View full review »
NN
Data Architect at a insurance company with 1,001-5,000 employees

The solution's scalability is very, very good. It's one of the most important aspects for us. 

We really need our data to stay in Western Europe. As an insurance company, it's important for our business. Microsoft can guarantee that it stays in Western Europe. That way, data is not processed anywhere else.

It's widely acknowledged as an excellent product throughout the industry. There's a lot of knowledge about it in the Netherlands as well. It makes it very easy to find a consultancy and also employees who can help us with its modern architecture.

The initial setup is easy. You don't need extensive training. It's an intuitive process.

View full review »
JM
Practice Director at a tech services company with 51-200 employees

The solution is scalable.

It's better than a similar solution offered by Amazon.

Technical support is okay in terms of the help they provide.

View full review »
JT
Senior Project Manager at a tech company with 501-1,000 employees

We're able to generate some dynamic reports. I find that very valuable to be able to see our data in such unique ways.

The pricing is pretty good.

The product is very user friendly.

View full review »
STI Data Leader at grupo gtd

The stability of the solution is pretty good. It's one of the solution's most valuable aspects.

The useability, the user interface, is very user-friendly.

View full review »
MS
Project Manager at a tech services company with 501-1,000 employees

The dashboards are good.

We haven't had any issues when it comes to customization.

The security seems to be okay. It hasn't given us any problems and we don't feel insecure.

The pricing seems to be quite fair.

I know their roadmap, and I am looking forward to what they have already published.

We've been happy with the level of reporting and documentation on offer.

View full review »
NT
Senior Systems Analyst at a non-profit with 201-500 employees

The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.

View full review »
VP
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees

The solution has been reliable so far.

The product is scalable, or, at least, that is my understanding. 

We've had a good experience with technical support in general. They are helpful. 

The solution has proven to be very user-friendly.

View full review »
AP
Data Architect at a tech services company with 51-200 employees

The most important feature for me is the integration with PolyBase.

Other valuable features for me are advanced threat protection and data privacy.

View full review »
RP
Software Engineer at a educational organization with 501-1,000 employees

I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements.

It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works.

View full review »
JS
Practice Head BI at a tech services company with 1,001-5,000 employees

The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.

When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.

View full review »
JS
Solution Principal at a computer software company with 5,001-10,000 employees

The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs. This is better than Amazon Redshift, where the costs continue to accumulate.

The documentation is good.

View full review »
Vice President Technologies at Excelencia

The best part is the easy and user-friendly administration and handling of the data.

View full review »
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees

The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.

View full review »
JS
Project Manager at a tech services company with 5,001-10,000 employees

The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack.

View full review »
BI Consultant at a tech services company with 11-50 employees

The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

Pretty much all of the features are valuable. The storage, compute, all essentially differentiate what you do.

They are very reliable and cost-effective. It meets the client's requirements.

It's user-friendly, has a good dashboard, and my team is happy with everything.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

Pretty much all of the features are valuable, including storage and compute. All of the features are essential to what you do.

It's very reliable and cost-effective. It meets the needs of our clients.

It's user-friendly and has a good dashboard.

View full review »
SB
Co-owner, Director at a tech services company with 1-10 employees

The whole solution is interesting for us.

View full review »
Azure Data Specialist at a financial services firm with 5,001-10,000 employees

I like the solution because it's very interactive and provides flexibility. It's mostly a drag-and-drop procedure. It also provides a lot of design choices.

View full review »
Director of Data Analytics Practice at a computer software company with 501-1,000 employees

The most valuable feature is performance gains.

The scalable nature of the data warehouse on the cloud, and the flexibility that you get, and important features.

View full review »
Enterprise architect at a computer software company with 201-500 employees

I like that the overall deployment and integration is pretty fast and then you also have virtualization to Power BI so it's also quite cost-effective.

View full review »
RV
Director at Nihil Solutions

Microsoft Azure uses the Massively Parallel Processing concept for data warehousing. The speed is great and the architecture is excellent. 

View full review »
HG
Director Of Software Development at a healthcare company with 5,001-10,000 employees

The most valuable feature is data processing.

The architecture, including compute and storage, is good.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

We have found that it is easy to develop and to do the analytics in the modules of data.

View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,136 professionals have used our research since 2012.