DEV Community

Cover image for Understanding Azure Synapse Analytics
BPB Online
BPB Online

Posted on • Updated on

Understanding Azure Synapse Analytics

Azure Synapse Analytics is not just a data warehouse. It also provides the capability for big data analytics, data integration, and data visualization along with data warehousing, and all of these features are available at one stop.

You can persist the data in Azure Synapse and perform the following types of analytics:

  • Descriptive analytics helps you describe what is happening in the business using the data ingested in the Azure Synapse data warehouse. You can leverage the dedicated SQL pool or the serverless SQL pool to store the data and perform descriptive analytics.

  • Diagnostic analytics helps you diagnose why a particular phenomenon occurs in the business. You can leverage the serverless SQL pool to perform diagnostic analytics on data stored in a data lake or data warehouse.

  • Predictive analytics helps you predict what will happen in the future based on the trends and patterns studied from the business data. You can leverage Spark pool and Azure Machine Learning services or Azure Databricks to perform these analytics.

  • Prescriptive analytics helps you execute actions based on real-time or near real-time analysis of the data. You can leverage Spark pool and Azure Stream Analytics or any other real-time streaming technology to perform these analytics.

You can use any of the following languages to perform data analytics using Azure Synapse and easily build Big data engineering and Machine learning solutions:

  • SQL
  • Python
  • .NET
  • Java
  • R
  • Scala

You can either use provisioned or serverless infrastructure to perform analytics using Azure Synapse. Azure Synapse supports SQL and Spark Analytics Runtime. Azure Synapse Pipelines help you integrate with various data sources like Azure Data Lake, Azure Cosmos DB, Azure SQL, and many more, and help you perform ETL (extract, transform, load) operations. Azure Synapse pipelines are based on Azure Data Factory. You can perform all these actions using Synapse Analytics Studio. You can also use Azure Databricks and Azure Synapse pipelines to perform rich analytics on complex data sets.

Hope this was helpful.

Discussion (0)