Implement a Data Warehouse with Microsoft Fabric

Subjects

Get started with data warehouses in Microsoft Fabric

• Describe data warehouses in Fabric.
• Understand a data warehouse vs a data Lakehouse.
• Work with data warehouses in Fabric.
• Create and manage fact tables and dimensions within a data warehouse.

Load data into a Microsoft Fabric data warehouse

• 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).

Query a data warehouse in Microsoft Fabric

• Use SQL query editor to query a data warehouse.
• Explore how visual query editor works.
• Learn how to connect and query a data warehouse using SQL Server Management Studio.

Monitor a Microsoft Fabric data warehouse

• Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
• Monitor current activity in the data warehouse with dynamic management views.
• Monitor querying trends with query insights views.

Secure a Microsoft Fabric data warehouse

• Learn the concepts of securing a data warehouse in Microsoft Fabric.
• Learn how to implement dynamic data masking to obscure sensitive information.
• Learn how to configure row-level security to provide granular control.
• Learn how to implement column-level security to protect sensitive data.
• Learn how to configure granular permissions using T-SQL.