Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Implement a data warehouse with Microsoft Fabric

Microsoft via Microsoft Learn

Overview

  • Module 1: Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.

    In this module, you'll learn how to:

    • Describe data warehouses in Fabric
    • Understand a data warehouse vs a data Lakehouse
    • Work with data warehouses in Fabric
    • Create and manage datasets within a data warehouse
  • Module 2: Explore the process of loading data into a warehouse in Microsoft Fabric.

    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).
  • Module 3: Learn how to query a data warehouse in Microsoft Fabric using different tools.

    In this module, you'll:

    • 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.
  • Module 4: 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.

    After completing this module, you'll be able to:

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

Syllabus

  • Module 1: Module 1: Get started with data warehouses in Microsoft Fabric
    • Introduction
    • Understand data warehouse fundamentals
    • Understand data warehouses in Fabric
    • Query and transform data
    • Prepare data for analysis and reporting
    • Secure and monitor your data warehouse
    • Exercise - Analyze data in a data warehouse
    • Knowledge check
    • Summary
  • Module 2: Module 2: Load data into a Microsoft Fabric data warehouse
    • Introduction
    • Explore data load strategies
    • Use data pipelines to load a warehouse
    • Load data using T-SQL
    • Load and transform data with Dataflow Gen2
    • Exercise: Load data into a warehouse in Microsoft Fabric
    • Knowledge check
    • Summary
  • Module 3: Module 3: Query a data warehouse in Microsoft Fabric
    • Introduction
    • Use the SQL query editor
    • Explore the visual query editor
    • Use client tools to query a warehouse
    • Exercise: Query a data warehouse in Microsoft Fabric
    • Knowledge check
    • Summary
  • Module 4: Module 4: Monitor a Microsoft Fabric data warehouse
    • Introduction
    • Monitor capacity metrics
    • Monitor current activity
    • Monitor queries
    • Exercise - Monitor a data warehouse in Microsoft Fabric
    • Knowledge check
    • Summary

Reviews

Start your review of Implement a data warehouse with Microsoft Fabric

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.