/
Azure Analytics Services

Azure Analytics Services

Owned by thierry sinassamy
Last updated: Dec 20, 2023
2 min read

Azure Synapse Analytics

  • Combination of data warehousing and big data analytics.

  • Has tools for data integration and analytics (e.g., apache Spark, SQL).

  • Is powered by massively parallel processing (MPP).

 

If we want to read and access dta externally, we can use the builin T-SQL. PolyBase, Azure Synapse Link.

In Synapse, we can have the built-in serverless option or we can build our own dedicated pools.

If we want to be more predictive using machine learning, we can use Spark Notebooks.

 

Azure Stream Analytics

  • Used to analyze large volumes of streaming data from multiple sources.

  • Helps to extract insight out of data streams by using :

    • Static or slow-changing reference data (Blob Storage or SQL DB)

    • Azure ML for complex querying and real-time data scoring

  • Responds to queries by trigerring communications/workflows or by sending data to dashboards or storage.