Item: Azure Synapse Analytics
Rating: 9
Author: Verified User

Overall Satisfaction with Azure Synapse Analytics

Use Cases and Deployment Scope

In my organization , Azure Synapse Analytics plays a vital role cause it really helps in data integration, transformation and reporting process.
It serves the foundation of our enterprise data ware house from multiple sources including Salesforce , Pardot , HubSpot, Share point and our internal data base etc.
It really helps to consume less time to make reports on Power BI

Pros and Cons

Pros

Seamless Data fetching across multiple sources
Handle easily large data set on SQL Query
Deep Integration with Power BI for real time dashboards and reports

Cons

They have limited UI responsiveness and usability in Synapse Studio.
Limited custom visualization in synapse
Spark performance is inconsist.

Return on Investment

It really helps to action in less time
Really helps to track campaign ROI
Scalability for growing data needs

Usability

I gave 9 rating overall, cause it has significantly improved our data integration, reporting efficiency and decision making capabilities.
It handles large data set very well with a very less run time and easily integrate with Power BI to , which help us to get real time insight across marketing , sales and operation.

Alternatives Considered

Azure Data Factory
Google BigQuery
Snowflake

Our team evaluated multiple platform as I mentioned above , but we stacks up Azure Synapse Analytics because :
1. Easy UI and Unified platform advantage
2. Tight integrations with MS ecosystem.
3.Cost control and flexibility.
4.Security and Compliance

Key Insights

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?

I wasn't involved with the implementation phase

Would you buy Azure Synapse Analytics again?

Yes

Other Software Used

Salesforce CRM Analytics, Bullhorn ATS & CRM, Draup for Sales

Likelihood to Recommend

It basically handle large data sets across multiple channels for different business units.
Example : we consolidate lead gen, campaign spend, sales pipeline etc.
It also create automated data flow that pulls from various sources like Salesforce , Excel , Pardot and SQL database. It also cleaning , transforming and sorting the data for Power BI dashboards without manual efforts.

Comments

Please log in to join the conversation

Why Azure Synapse Analytics became our Go - to - data analytics platform