Implementing a Data warehouse with Microsoft Fabric – Applied Skills Workshop

Overview

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

Prerequisites

You should be familiar with basic data concepts and terminology.

Outline

Module 1: Get started with data warehouses in Microsoft Fabric

Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

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

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

Module 3: Query a data warehouse in Microsoft Fabric

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.

• 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: Monitor a Microsoft Fabric data warehouse

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.

• Introduction
• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Exercise – Monitor a data warehouse in Microsoft Fabric
• Knowledge check
• Summary