Integrate Azure Synapse Analytics with Azure Data and AI services

Go to class
Write Review

Free Online Course: Integrate Azure Synapse Analytics with Azure Data and AI services provided by Microsoft Learn is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge.

Overview
    • Module 1: Build reports using Power BI within Azure Synapse Analytics
    • In this module, you will:

      • Describe the Power BI and Synapse workspace integration
      • Understand Power BI data sources
      • Describe optimization options
      • Visualize data with serverless SQL pools
    • Module 2: Integrate machine learning within Azure Synapse Analytics
    • In this module, you will:

      • Describe Azure Machine Learning and how it integrates with an Azure Synapse Analytics workspace
      • Describe Azure Machine Learning AutoML
      • Understand how to score machine learning models with PREDICT

Syllabus
    • Module 1: Build reports using Power BI within Azure Synapse Analytics
      • Introduction
      • Describe the Power BI and Synapse workspace integration
      • Exercise - Connect to Power BI from Synapse
      • Understand Power BI data sources
      • Exercise - Create a new data source to use in Power BI
      • Exercise - Create a new Power BI report in Synapse Studio
      • Describe Power BI optimization options
      • Exercise - Improve performance with materialized views and result-set caching
      • Visualize data with serverless SQL pools
      • Knowledge check
      • Summary
    • Module 2: Integrate machine learning within Azure Synapse Analytics
      • Introduction
      • Describe Azure Machine Learning and how it integrates with an Azure Synapse Analytics workspace
      • Exercise - Create an Azure Machine Learning linked service
      • Describe Azure Machine Learning AutoML
      • Exercise - Trigger an AutoML experiment using data from a Spark table
      • Understand how to score machine learning models with PREDICT
      • Exercise - Enrich data using trained models with the PREDICT function
      • Knowledge check
      • Summary