Microsoft LevelUp - Data Warehousing with Microsoft Fabric

Data Warehousing with Microsoft Fabric

Duration - 8 Hours

Level - Intermediate

No. of learners - 6

Enroll Now

Last Updated Apr 2025

Style

Self paced

Target Audience

Technical Project Ready with Labs

Certification

Hands on Labs

Yes

Solution Areas

Azure - Data and AI, Unify your intelligent data & analytics platform

Course Overview

Overview

Data warehouses are analytical stores built on a relational schema to support SQL queries. In Microsoft Fabric, you can easily create a relational data warehouse within your workspace and integrate it with other elements of your end-to-end analytics solution. Microsoft Azure Synapse Analytics is another powerful platform for building and managing data warehouses, offering advanced analytics capabilities with integrated big data and data warehousing services. In this course, you will learn about data warehouses in Fabric, create a data warehouse, load, query, and visualize data, and explore how Azure Synapse Analytics complements these tasks by providing additional scalability, performance, and integration options.

Course Modules

Modules

Introduction to Data Warehousing in Microsoft Fabric

This module provides an overview of Microsoft Fabric, focusing on Data Warehousing and its integration with Lakehouse architecture. Learn to navigate the decision-making process between Data Warehouse and Lakehouse and understand how their combined capabilities enhance data management and analytics in Microsoft Fabric.

Implementing Microsoft Fabric Data Warehousing

This module guides you through creating a Data Warehouse in Microsoft Fabric, exploring data ingestion options, OneLake catalog, pipelines, and data flows. Learn to mirror databases, implement open mirroring, clone tables, and establish seamless Data Warehouse connectivity for efficient data management and integration.

Performance at scale with Data Warehousing in Microsoft Fabric

This module covers dimensional modeling in Microsoft Fabric Warehouse, querying and monitoring the Data Warehouse, and creating models for Power BI reports. Learn to collaborate effectively, manage security, and optimize performance for seamless data analysis and reporting.

Migrating from Azure Synapse Analytics to Data Warehouse in Microsoft Fabric

This module guides you through preparing for migration to Microsoft Fabric, exploring migration scenarios and design differences between Synapse dedicated SQL pools and Fabric Warehouse. Learn effective migration methods and strategies for transitioning workloads to the Data Warehouse in Microsoft Fabric seamlessly.