Try our new research platform with insights from 80,000+ expert users
reviewer1072665 - PeerSpot reviewer
Managing Director at a consultancy with 1-10 employees
Real User
Good scalability and stability but needs user training
Pros and Cons
  • "The stability is pretty good."
  • "The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."

What is our primary use case?

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.

How has it helped my organization?

When connecting one project to the other, especially when it's handled by the same project director, the possibility of linking one spreadsheet to the other has been useful. Also, when using a Word document and making a link to another document based on an Excel spreadsheet, that's very useful. It's also great that we can interrelate one document to the other and sometimes one project to the other.

What is most valuable?

The macro functions of Excel are very useful. 

The stability is pretty good.

The solution has the potential to scale.

What needs improvement?

The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.

If the project keeps growing we will need to link some of the documents to the data warehouse. However, at that time, I'm not sure about the possibility of keeping the same systems that we are using right now. We may need some kind of migration. I cannot say for sure, as I am not an expert. We'll need advice on that.

The initial setup is not straightforward.

The solutions not user-friendly and does require training of some sort.

The solution requires a lot of the memory of the different devices.

Buyer's Guide
Microsoft Azure Synapse Analytics
May 2025
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.

For how long have I used the solution?

We've been using the solution for a while. We use it pretty much every day and have used it over the past 12 months.

What do I think about the stability of the solution?

My intention is to increase productivity. As long as a project can still be handled the way they are, we will keep using the current system. If we see a better alternative with better productivity achievement, we will most probably think about migration. For now, we find it to be stable and acceptable.

What do I think about the scalability of the solution?

We do plan to increase usage and we may hire a consultant to help with an expansion in a few months. This will likely happen, however, anything can change in terms of the business and the larger industry.

Scalability is good. I foresee scalability in terms of the possibility of using more features and the only difficult thing that I see already is the macros of the Excel spreadsheets. I also know that it has a good opportunity for scalability, in terms of the more complex tasks that can be achieved. 

Currently, we have ten people on the solution.

How are customer service and support?

We use an outsourcing service for technical support. We've been satisfied with their level of service.

Which solution did I use previously and why did I switch?

We haven't used a different product. We've always used Microsoft.

How was the initial setup?

The initial setup is complex. It's not straightforward.

In many ways, implementation is a never-ending process, as there are always things to improve. In a few months, most of our people are familiar with the product and have a good sense of the basics, however, there's always more to do.

What about the implementation team?

There was actually one consultant at the beginning of the project. We will also definitely need someone for future migration. However, it's not something that we are considering at present. It's something we'll need to do probably in the next few months. It will depend on the growth of the business.

What's my experience with pricing, setup cost, and licensing?

The licensing is okay. There might be a few extra fees in addition to the standard license.

What other advice do I have?

I'm just an end-user and customer.

I'd rate the solution at a seven out of ten.

I'd rate them higher if they could make it more user-friendly in terms of those more sophisticated capabilities that the system offers. Also, the training requires long hours. That's something difficult to organize when people have to be allocated to specific training sessions, instead of being on the projects. There's a kind of complex way of balancing the possibility of some people using the more sophisticated solutions and getting trained. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1488372 - PeerSpot reviewer
Associate Manager at a consultancy with 501-1,000 employees
Real User
Easy to develop, stable, and subscriptions flexible
Pros and Cons
  • "We have found that it is easy to develop and to do the analytics in the modules of data."
  • "More integration is needed to improve the product for the future."

What is our primary use case?

We use the solution on our servers for analytics.

What is most valuable?

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

What needs improvement?

More integration is needed to improve the product for the future. There needs to be more flexibility when developing applications with this product.

For how long have I used the solution?

I have been using the solution for six months.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

We have three to four people using the product.

What's my experience with pricing, setup cost, and licensing?

The solution is subscription-based. You can also pay to use the product as you go. This is an advantage, you only get charged for the time you actually use it.

What other advice do I have?

I would recommend this solution to others.

I rate Microsoft Azure Synapse Analytics a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Microsoft Azure Synapse Analytics
May 2025
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
Mullai Selvan - PeerSpot reviewer
Project Manager at MAQ Software
Real User
Very scalable with good documentation and fair pricing
Pros and Cons
  • "The pricing seems to be quite fair."
  • "The initial setup has a bit of a learning curve."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

There aren't any features that are really lacking in the solution. We don't really have any issues with it in its current form.

When we used the on-premises deployment model, we had data latency issues and suffered from page performance problems. However, since we've moved to the cloud, we haven't had these problems.

The initial setup has a bit of a learning curve.

For how long have I used the solution?

We've been using the solution for the past 18 months so far.

What do I think about the stability of the solution?

The solution seems to be scalable. We haven't had any issues with bugs or glitches. It doesn't crash or freeze. It's quite good.

What do I think about the scalability of the solution?

The scalability has been pretty good, in our experience. We have been able to scale it twice to the number of users we needed. We were also able to double the amount of data load. We haven't had issues. If a company needs to expand, it should be able to do so without problems.

How are customer service and technical support?

We've dealt with technical support and have found them to be quite responsive and knowledgeable. We're quite satisfied with the level of support we have been getting so far. They're helpful.

How was the initial setup?

It's hard to gauge the difficulty or simplicity of the setup. For our company, we were learning the processes as we were doing it. In that sense, it was challenging due to the fact that we had to learn and then do. After a period of time, we were able to get comfortable.

What about the implementation team?

We handled the implementation ourselves. We taught ourselves about the process as we went.

What's my experience with pricing, setup cost, and licensing?

We pay a licensing fee on a monthly basis. We find the pricing to be fair among the competition.

What other advice do I have?

We're just end-users and customers. We don't have a business relationship with the organization.

We're using the latest version of the solution right now.

I'd recommend the solution to other organizations.

I'd rate the solution at a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer993231 - PeerSpot reviewer
Director Of Software Development at a healthcare company with 5,001-10,000 employees
Real User
Straightforward to set up and it has good data processing capabilities
Pros and Cons
  • "The architecture, including compute and storage, is good."
  • "The performance and data consistency need to be improved."

What is our primary use case?

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

What is most valuable?

The most valuable feature is data processing.

The architecture, including compute and storage, is good.

What needs improvement?

The performance and data consistency need to be improved.

Support for PSQL functionality should be included, as it is something that is missing right now.

For how long have I used the solution?

I have used Microsoft Azure Synapse Analytics over the past 12 months.

What do I think about the stability of the solution?

The stability has been getting much better. Two years back, there were issues with it.

What do I think about the scalability of the solution?

Scalability is something that is improving.

How was the initial setup?

The initial setup is straightforward.

What about the implementation team?

We deployed it ourselves.

What other advice do I have?

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1466190 - PeerSpot reviewer
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
User-friendly, has a good dashboard, and meets the needs of our clients
Pros and Cons
  • "It's user-friendly and has a good dashboard."
  • "I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."

What is our primary use case?

We are using this product data warehousing and analytics.

What is most valuable?

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.

What needs improvement?

I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head.

For how long have I used the solution?

I have been using Microsoft Azure Synapse Analytics for a couple of years.

What do I think about the stability of the solution?

It's a stable product and we're satisfied and comfortable with it. Our clients and partners have found it to be very stable and scalable, as well.

What do I think about the scalability of the solution?

Synapse Analytics is a scalable product.

How are customer service and technical support?

Generally, support from Microsoft is always good. I can't recall the specific instance where we had to contact them, but it was good.

How was the initial setup?

The initial setup is very straightforward. It only took five minutes to set up.

What about the implementation team?

We deployed the solution in-house, and we also deploy it for our clients.

What's my experience with pricing, setup cost, and licensing?

This is a cost-effective product.

What other advice do I have?

I highly recommend this solution to others, and we recommend it to our clients.

Overall, it's exceptionally good.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer1466190 - PeerSpot reviewer
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
Cost-effective, reliable data warehousing that is user-friendly, and it is easy to scale
Pros and Cons
  • "They are very reliable and cost-effective."
  • "I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."

What is our primary use case?

We are using this solution for data warehousing and analytics.

What is most valuable?

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.

What needs improvement?

I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.

For how long have I used the solution?

I have been using this solution for a while, I would say approximately two years.

We are using the latest version. It's always updated on the cloud.

What do I think about the stability of the solution?

We found it to be a very stable product.

What do I think about the scalability of the solution?

It's a scalable solution and we find it to be easy to scale.

How are customer service and technical support?

Generally, support from Microsoft is always good.

I can't recall where we had an issue that we had to contact technical support, but the support is very good.

How was the initial setup?

The initial setup was very straightforward. It took only five minutes to set up.

What about the implementation team?

We completed the deployment in-house, we did it ourselves. We also implement it for our clients. 

It's pretty straightforward, we do not need help with this.

What's my experience with pricing, setup cost, and licensing?

Because it's a cloud solution, the cost is a different convention and the licensing costs are not the same.

What other advice do I have?

I would highly recommend this solution to others who are interested in using it. We recommend it to our clients.

It's exceptionally good, and our clients and other partners find it both stable and scalable.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer1389924 - PeerSpot reviewer
Co Founder & CTO at a manufacturing company with 1-10 employees
Real User
Provides good insights into vehicle data
Pros and Cons
  • "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."
  • "It could be more stable."

What is our primary use case?

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. 

For how long have I used the solution?

I have been using Microsoft Azure SQL Data Warehouse for three years. 

What do I think about the stability of the solution?

It could be more stable. 

What do I think about the scalability of the solution?

It is a Cloud platform and so it is easy to scale.

How are customer service and technical support?

When it comes to first level support, most of the time it's not a technical issue, it's a configuration issue where data mismatches. I get support anytime I want. Within an hour I can get anybody on the call and get the issue resolved. They have a one-to-one support channel which we can email when we require assistance.

How was the initial setup?

We installed Datawarehouse in a couple of minutes. However, the configuration based on our data models took time. It can take us weeks because that's where our optimization sits. Just tuning the parameters can take several days' at a time. 

What's my experience with pricing, setup cost, and licensing?

The price of the package is not expensive and depends on how much it is used.

What other advice do I have?

I would rate Microsoft Azure SQL Data Warehouse a nine out of ten. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1423767 - PeerSpot reviewer
Software Engineer at a educational organization with 501-1,000 employees
Real User
It is well-structured and provides good performance
Pros and Cons
  • "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."
  • "I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good.

For how long have I used the solution?

I have been using Microsoft Azure SQL Data Warehouse for three months.

How was the initial setup?

It was ready when I started to use it. I just had to do my project.

What's my experience with pricing, setup cost, and licensing?

Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle.

Which other solutions did I evaluate?

I am also using an Oracle solution. Oracle has been in the database field for a longer time, and it provides you more familiar terms that the users understand. When users start to work with an Oracle solution, they are more familiar with the terms. They just need basic training to understand it, but with Microsoft Azure SQL Data Warehouse, they have to be a little bit more experienced. In order to understand this product better, they have to know how other Microsoft products work.

What other advice do I have?

It is a powerful asset if we can use it and learn more about it. If Microsoft can give some free training sessions for students and amateurs, it would be helpful in knowing more about this product from inside. 

I would rate Microsoft Azure SQL Data Warehouse an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Product Categories
Cloud Data Warehouse
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.