CODEWITHSUNDEEP
azureazure-analysis-servicesazure-synapse
Raju Joseph
Raju Joseph

Reputation: 533

Azure Analysis Services versus Synapse Analytics

Can someone explain what is the difference between Azure Analysis Services and Azure Synapse Analytics? Why would one use Analysis Services over Synapse Analytics?

Thanks,

Upvotes: 8

Views: 11779

Answers (2)

Karan Bhatia
Karan Bhatia

Reputation: 53

Azure Analysis Services - can be used

  • when small volume of data is to be analyzed,
  • for detailed analysis,
  • to form dashboard development,
  • when concurrency required is high (thousands of users)

Azure Synapse Analytics - can be used

  • when very high volumes of data is to be analyzed,
  • when analysis involves complex queries,
  • when concurrency required is low (128 users or few)
  • for data mining.

Upvotes: 3

David דודו Markovitz
David דודו Markovitz

Reputation: 44941

Azure Synapse Analytics is a rebrand of Azure SQL Data Warehouse (GA) with additional Analytics/Streaming/ML enhancements (currently at Public Preview).
here

Azure Analysis Services (AAS) is the Azure PaaS version for SQL Server Analysis Services.
here.

Please note -

"Power BI Premium is the focus for enterprise BI and the primary target for future investments. In time, Power BI Premium will provide a superset of the capabilities when compared to Azure Analysis Services."
here

Upvotes: 10

Related Questions