Implement a data warehouse with Microsoft Fabric

At a glance

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

Prerequisites

Before starting this learning path, familiarity with the Microsoft Fabric interface and core concepts is recommended.

Modules in this learning path

Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.

Understand what a Fabric data warehouse is, why it provides full T-SQL transactional capabilities, and how to create, query, and transform data for analytics.

Learn how to load data into a Fabric warehouse using data pipelines, T-SQL, and Dataflow Gen2, and explore strategies for full loads, incremental loads, and slowly changing dimensions.

In this module, you'll learn how to query a data warehouse in Microsoft Fabric using the built-in SQL and visual query editors, and external client tools like SQL Server Management Studio.

Accelerate warehouse analytics with Copilot in Fabric—use AI chat, inline completions, and quick actions to generate, refine, explain, and fix T-SQL while applying best-practice prompting.

A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.

Learn how to protect sensitive data in a Microsoft Fabric warehouse using dynamic data masking, row-level security, column-level security, and SQL granular permissions.