Perform code-free transformation at scale with Azure Data Factory or Azure Synapse Pipeline

Data Engineer
Data Scientist
Data Factory
Synapse Analytics

In this module, you will learn how to perform common data transformation and cleansing activities within Azure Data Factory without using code.

Learning objectives

  • Introduction
  • Explain Data Factory transformation methods
  • Describe Data Factory transformation types
  • Exercise - Author an Azure Data Factory mapping data flow
  • Debug mapping data flow
  • Exercise - Use Data Factory wrangling data
  • Exercise - Use compute transformations within Data Factory
  • Exercise - Integrate SQL Server Integration Services packages within Data Factory
  • Knowledge check
  • Summary


The student should be able to:

  • Log into the Azure portal
  • Explain and create resource groups
  • Describe Azure Data Factory core components
  • Ingest data into Azure Data Factory using the Copy Activity