DP601: Implementing a Lakehouse with Microsoft Fabric

• An understanding of data management principles
• Experience with SQL databases
• Basic knowledge of cloud computing concepts

Audience

• Data engineers
• Database administrators
• Data analysts

Microsoft Fabric is a comprehensive data management platform designed to streamline the process of building and managing data lakes and warehouses.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals who wish to implement a lakehouse solution using Microsoft Fabric.

By the end of this training, participants will be able to:

• Understand the architecture and components of Microsoft Fabric.
• Configure and manage a Lakehouse using Microsoft Fabric.
• Ingest and transform data using Apache Spark.
• Utilize Delta Lake tables for versioning and managing data.
• Implement data ingestion pipelines with Dataflows Gen2.
• Orchestrate data pipelines using Data Factory.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to End-to-End Analysis with Microsoft Fabric

• Overview of Microsoft Fabric
• Understanding the Lakehouse Architecture
• End-to-End Analytics Workflow

Getting Started with Lakehouses in Microsoft Fabric

• Core Features and Capabilities of Lakehouses
• Creating and Configuring a Lakehouse
• Data Ingestion into Lakehouse Tables

Using Apache Spark in Microsoft Fabric

• Configuring Apache Spark in Microsoft Fabric
• Leveraging Spark for Distributed Data Processing
• Analyzing and Transforming Data with Spark DataFrames

Working with Delta Lake Tables in Microsoft Fabric

• Introduction to Delta Lake and Delta Tables
• Managing and Versioning Data with Delta Tables
• Implementing Data Transformations and Queries

Ingesting Data with Dataflows Gen2 in Microsoft Fabric

• Capabilities of Dataflows Gen2
• Designing Dataflow Solutions for Data Ingestion
• Integrating Dataflows into Data Pipelines

Using Data Factory Pipelines in Microsoft Fabric

• Overview of Data Factory Pipelines
• Building and Orchestrating Data Pipelines
• Automating Data Movements and Transformations

Summary and Next Steps