ETL/ELT In The Cloud Using Data Factory

Trainer(s): Dennes Torres
Provider: DPS 2022 (Data Platform Summit)
Duration: 8 Hours
Subtitles: Yes
Price: USD 149.5

Abstract: Data Factory is a powerful member of the Azure data platform. We can build powerful ETL solutions with no code and migrate existing on premise SSIS solutions to the cloud.

Come to this full day session to discover how it works and what you can build. This demo-packed preconference will show many different examples and scenarios illustrating common ETL/ELT challenges in an enterprise data platform.

Modules:

  1. Data Factory – Basic Concepts
  2. The Flexibility of the Copy Data Activity
  3. Download from the web using the Web Activity
  4. Datasets
  5. Managing Source and Destination Datasets
  6. Azure SQL Datasets
  7. Azure Storage Datasets
  8. Using Schema Drift
  9. Creating the destination Schema
  10. Dataflows
  11. PowerQuery
  12. Data Factory Examples
  13. Incremental Loading Data
  14. Loading data into Slowly Changing Dimensions
  15. Managing the Development
  16. Managing Execution
  17. SSIS