Plays with Power BI nicely
Updated July 21, 2022

Plays with Power BI nicely

Scott Kennedy | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Azure Synapse Analytics (Azure SQL Data Warehouse)

Microsoft Azure Synapse Analytics (formally Azure SQL Data Warehouse) is being used as our marketing data warehouse. We are pulling data down from a number of different API's such as Facebook ads, Google ads and Google analytics, and then pumping that information back into the Azure Synapse Analytics Warehouse on a daily basis.
  • They unify many data sources easily
  • There is some "code free" ETL work it enables
  • There is some AI integration that works nice
  • The cost structure is difficult to understand
  • The job scheduling capabilities aren't easy to use
  • The logging metrics aren't easy to see
  • Ability to remove dependency on data gateway
  • data processing speed
  • serverless maintainance
  • Easy database management using modern tools
  • Easy integration with Power BI
  • Cloud-native HTAP
Azure Synapse Analytics stacks up well against the competitors I mentioned above. Technically, Azure SQL Datawarehouse is an upgraded version of the Azure SQL Database. So, the choice to move from one to the other depends on the processing needs of your company. If you need more power, go with the data warehouse.

Do you think Azure Synapse Analytics delivers good value for the price?

Yes

Are you happy with Azure Synapse Analytics's feature set?

Yes

Did Azure Synapse Analytics live up to sales and marketing promises?

Yes

Did implementation of Azure Synapse Analytics go as expected?

Yes

Would you buy Azure Synapse Analytics again?

Yes

Azure Synapse Analytics is very well suited for companies that are using the Microsoft Power BI analytics tool (business intelligence). The reason being, you don't need to provide a data gateway to move data from your database to the reporting service online if you are using this type of database. This is a huge win for processing data.