Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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,

like image 451
Raju Joseph Avatar asked Jan 01 '23 06:01

Raju Joseph


2 Answers

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

like image 127
David דודו Markovitz Avatar answered Jan 16 '23 19:01

David דודו Markovitz


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.
like image 29
Karan Bhatia Avatar answered Jan 16 '23 18:01

Karan Bhatia