DP-602: Implement a Data Warehouse with Microsoft Fabric
Course Overview
Unlock the power of enterprise-grade data warehousing by learning to implement scalable, high-performance data warehouse solutions with Microsoft Fabric. This instructor-led course teaches data professionals how to design, build, and manage modern data warehouses that enable integrated analytics across the organization.
You’ll explore how to leverage Microsoft Fabric’s data warehouse capabilities to ingest, model, and optimize large datasets for analytics workloads. Learn to architect data storage, apply performance tuning techniques, and integrate with Power BI for advanced business intelligence and reporting.
This course features 40% to 50% hands-on exercises, providing practical experience implementing data warehouses within Microsoft Fabric.
Target Audience:
This course is ideal for:
Data engineers, data architects, and analytics professionals building scalable data warehouse solutions
BI developers and data platform specialists modernizing legacy data infrastructure
IT professionals preparing for certifications related to data warehousing and Microsoft Fabric
Anyone interested in mastering data warehouse implementation using Microsoft Fabric
Prerequisites:
Familiarity with SQL, data modeling concepts, and cloud data platforms is recommended. Experience with Azure or Power BI is beneficial.
Course Outline:
Module 1: Introduction to Data Warehousing and Microsoft Fabric
Understand the fundamentals of data warehousing and its role in enterprise analytics
Explore Microsoft Fabric’s data warehouse architecture and core components
Compare data warehouse, data lake, and lakehouse paradigms within Microsoft Fabric
Module 2: Designing and Building Data Warehouse Solutions in Microsoft Fabric
Plan and implement fact and dimension tables using best practices in data modeling
Ingest and transform data from diverse sources into the data warehouse
Apply schema design and optimize storage structures for query performance
Module 3: Optimizing Data Warehouse Performance
Implement indexing, partitioning, and compression techniques
Use materialized views and caching to accelerate query responses
Manage workload concurrency and scale compute resources efficiently
Module 4: Securing and Governing Data Warehouse Workloads
Apply role-based access control (RBAC) and data encryption to protect sensitive data
Use sensitivity labels, auditing, and compliance features within Microsoft Fabric
Implement data governance policies to ensure regulatory compliance
Module 5: Integrating Data Warehouse with Power BI and Analytics Workloads
Connect Power BI datasets directly to data warehouse tables for live reporting
Build end-to-end analytics solutions combining Microsoft Fabric data warehouses with lakehouse and real-time analytics
Design reports and dashboards to drive actionable business insights
Module 6: Automating Data Warehouse Operations
Create and schedule data pipelines for automated data ingestion and transformation
Monitor and troubleshoot data warehouse performance and health
Implement backup, recovery, and disaster recovery strategies
Delivery Format:
Instructor-led training with expert demonstrations
40% to 50% hands-on exercises in a Microsoft Fabric environment
Practical scenarios designed to build real-world data warehouse skills
Ready to Get Started?
Join thousands of professionals who have advanced their careers with our training programs.
Join Scheduled Training
Find upcoming sessions for this course and register for instructor-led training with other professionals.
View ScheduleCustom Training Solution
Need training for your team? We'll create a customized program that fits your organization's specific needs.
Get Custom Quote