Introduction to Data Engineering with Azure

Introduction to Data Engineering with Azure

0%

1. Getting Started with Azure and Core Tools

Have a deep dive into the foundational concepts and tools required to begin your journey with Microsoft Azure. You'll explore cloud computing basics, learn how to organize and manage resources efficiently using Azure Resource Groups, and set up core services like Blob Storage and Azure SQL Database. Additionally, you’ll secure sensitive data with Azure Key Vault and gain an overview of Azure Data Factory (ADF) to understand its role in modern data engineering workflows.

Getting Started

Understanding Azure Subscriptions

Organizing Resources with Resource Groups

Using Azure Blob Storage for Data Storage

Setting Up Azure SQL Database

Managing Credentials with Azure Key Vault

Introduction to Azure Data Factory

2. Foundations of Azure Data Factory

Explore the core functionalities of Azure Data Factory (ADF), a powerful tool for creating and automating ETL/ELT workflows. In this section, you'll learn how to configure services, datasets, and pipelines while exploring key activities such as Copy, Lookup, and Script. You'll also work with advanced features like the ForEach activity for iteration and pipeline parameters for flexibility.

Linked Services

What is ADF Pipeline?

Script Activity

Lookup Activity

Dataset Parameters

ForEach Activity

Execute Pipeline Activity

3. Data Flows and Transformations in ADF

This section focuses on leveraging Azure Data Factory's data flow capabilities to transform and enrich your data. You'll learn to connect various data sources, create derived columns, and merge datasets using joins. Practical examples will guide you through filtering, sorting, conditional splits, and aggregating data to generate meaningful insights. By mastering these transformations, you'll be equipped to build robust, efficient ETL workflows tailored to real-world data engineering challenges.

Understanding Data Flows in Azure Data Factory

Derived Column Transformation

Combining Data with Joins

Using Conditional Split and Filtering in ADF

Grouping, Select, and Sort Transformations in ADF

4. Practical Problem Solving with ADF

Apply your knowledge to real-world data engineering scenarios in this hands-on section. You'll tackle practical challenges like loading and analyzing data for different categories, identifying patterns, and assessing financial health using advanced ADF workflows. By solving these problems, you'll gain experience in designing end-to-end data solutions, working with diverse datasets, and generating actionable insights.

Challenge: Loading Data to Several Tables

Solving Loading Data Challenge

Challenge: Conducting Transaction Analysis

Solving Conducting Analysis Challenge

Course Content

Introduction to Data Engineering with Azure

Introduction to Data Engineering with Azure

1. Getting Started with Azure and Core Tools

Getting Started Understanding Azure Subscriptions Organizing Resources with Resource Groups Using Azure Blob Storage for Data Storage Setting Up Azure SQL Database Managing Credentials with Azure Key Vault Introduction to Azure Data Factory

2. Foundations of Azure Data Factory

Linked Services Datasets What is ADF Pipeline?Script Activity Lookup Activity Dataset Parameters ForEach Activity Execute Pipeline Activity

3. Data Flows and Transformations in ADF

Understanding Data Flows in Azure Data Factory Derived Column Transformation Combining Data with Joins Using Conditional Split and Filtering in ADF Grouping, Select, and Sort Transformations in ADF

4. Practical Problem Solving with ADF

Challenge: Loading Data to Several Tables Solving Loading Data Challenge Challenge: Conducting Transaction Analysis Solving Conducting Analysis Challenge

Derived Column Transformation

Derived columns allow you to enhance your data by creating new fields or modifying existing ones based on business logic. This functionality is vital for enriching your dataset to better serve downstream processes such as analytics, reporting, or machine learning.

For instance, you might create a FullName field by concatenating first and last names or derive a DiscountedPrice based on an existing Price field and a discount rate.

How to Create Derived Columns in ADF

Add a new Data Flow in the Author section of Azure Data Factory Studio;
Drag a Derived Column Transformation from the toolbox onto the Data Flow canvas and connect it to your data source;
In the Derived Column Transformation settings, define the column name for the new or modified field, such as DeathRate;
Write an expression using ADF's expression language. For example, to calculate a death rate: iif(TotalDeaths > 0, (Covid19Deaths * 100.0) / TotalDeaths, 0.0);
Validate the configuration by previewing the data to ensure the derived column is calculated correctly;
Connect the transformed data to a Sink Transformation to send it to a destination, such as a SQL table or Blob Storage, for further processing.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 2

some-alt