MEAPSA

Load data into a Microsoft Fabric data warehouse

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Data Analyst

Data Engineer

Fabric

Module Objectives

In this module, you'll:

Learn different strategies to load data into a data warehouse in Microsoft Fabric.
Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
Learn how to load data in a warehouse using T-SQL.
Learn how to load and transform data with dataflow (Gen 2).

Units

Introduction min
Explore data load strategies min
Use data pipelines to load a warehouse min
Load data using T-SQL min
Load and transform data with Dataflow Gen2 min
Exercise: Load data into a warehouse in Microsoft Fabric min
Knowledge check min
Summary min

Prerequisites

Before starting this module, you should be familiar with the basic principles of a data warehouse.