Azure Synapse Analytics

“Azure Synapse Analytics is a limitless analytics service, that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.”

I hope you got announcement about Azure synapse analytics(public preview) this week – A single platform to build end-to-end analytics from ingestion to visualization by data engineer, scientist, analyst, architect and BI developer .

Below two images will give you more clarify of Azure Synapse Analytics and Modern Data Warehouse.

Well proven architecture with lot of customers is being used. It used many services in different layers to achieve the goal.

Azure Synapse Analytics give you a single service to achieve the same goal with many flexible way and integration all in to one bundle. Work data engineers, data scientist , developer and visualization experts in one product.

Above image shows you the Synapse Studio ,gives single view for each and every role in your big data echo system.

Some of key features and area.

  1. Enterprise data warehouse
    1. Build your data warehouse on the proven foundation of the industry’s top-performing T-SQL engine.
  2. Data Discovery, Exploration and Transformation
    1. Exploring and analyzing datalake and operational data together  in real time using serverless and provisioned.
    2. Direct link to database to operation database for data analysis and reporting without impacting production.
  3. Choice of languages
    1. Use your preferred language, including T-SQL, Python, Scala, Spark SQL, and .Net—whether you use serverless or provisioned compute resources.
  4. Code-free data orchestration (ETL)
    1. Build end to end ETL/ELT processes in a code-free visual environment to easily ingest data from more than 85 native connectors.
  5. Deeply integrated Apache Spark and SQL engines
    1. Enhance collaboration among data professionals working on advanced analytics solutions. Easily use T-SQL queries on both your data warehouse and embedded Spark engine.
  6. Streaming ingestion & analytics
    1. Perform real-time analytics on streaming data directly in your data warehouse.
  7. Integrated AI and BI
    1. Complete your end-to-end analytics solution with deep integration of Azure Machine Learning and Power BI.
    2. Invoke machine learning model in T-SQL query, Bring model close to data.
  8. Industry-leading management and security
    1. Use built-in features to ensure your data and processes are seen by only those with authorized access.

Videos URLs

  1. Get Started link –
  2. Recoded Demo for analytics user –
  3. Recorded demo for developers and Architect –
  4. Recorded demo for PowerBI user –