DP-601: Implement a Lakehouse with Microsoft Fabric

Course Description:

Accelerate your data modernization journey by mastering the implementation of a lakehouse architecture using Microsoft Fabric, the unified analytics platform. This instructor-led course guides data professionals through building scalable, secure, and performant lakehouse solutions that combine the best features of data lakes and data warehouses.

Learn to architect and manage Delta Lake tables, integrate diverse data sources into OneLake, and leverage Microsoft Fabric’s built-in analytics workloads to enable real-time insights. Gain practical knowledge in securing data, optimizing query performance, and enabling seamless integration with Power BI and Azure Synapse Analytics.

This course features 40% to 50% hands-on exercises, providing practical experience with Microsoft Fabric lakehouse implementations.

Target Audience:

This course is designed for:

• Data engineers, data architects, and analytics professionals developing lakehouse solutions on Microsoft Fabric

• Business intelligence developers and data platform specialists modernizing data environments

• IT professionals preparing for Microsoft certifications related to data engineering with Microsoft Fabric

• Anyone interested in leveraging unified data management and analytics with Microsoft Fabric lakehouse technology

Prerequisites:
Basic knowledge of data lakes, SQL, and cloud data concepts. Familiarity with Azure or Power Platform is helpful.

Course Outline:

Module 1: Understanding Lakehouse Architecture and Microsoft Fabric

• Explore the fundamentals of lakehouse architecture and its role in unified analytics

• Learn about Microsoft Fabric’s platform components including OneLake and analytics workloads

• Compare traditional data lakes, data warehouses, and the lakehouse paradigm

Module 2: Building and Managing Delta Lake Tables in Microsoft Fabric

• Create, configure, and manage Delta Lake tables for reliable data storage

• Implement schema enforcement and schema evolution for evolving datasets

• Handle data ingestion from various structured and unstructured sources

Module 3: Securing Data in the Microsoft Fabric Lakehouse

• Apply role-based access control (RBAC) and manage user permissions

• Utilize data encryption, sensitivity labels, and compliance controls

• Monitor lakehouse activities with auditing and data governance tools

Module 4: Optimizing Lakehouse Performance and Scalability

• Tune lakehouse performance using partitioning, caching, and materialized views

• Scale compute and storage resources independently for efficiency

• Leverage serverless compute and auto-scaling capabilities within Fabric

Module 5: Integrating Lakehouse Data with Power BI and Azure Synapse Analytics

• Connect Power BI directly to lakehouse Delta tables for real-time reporting

• Combine lakehouse data with Azure Synapse Analytics for advanced analytics workloads

• Design dashboards and reports that provide actionable insights from lakehouse data

Module 6: Automating Lakehouse Workflows and Operations

• Build and schedule data pipelines using Microsoft Fabric’s orchestration tools

• Implement data lifecycle management including retention and archival

• Set up monitoring, alerts, and troubleshooting for lakehouse environments

Delivery Format:

• Live instructor-led training with expert-led demonstrations

• 40% to 50% practical, hands-on exercises in a Microsoft Fabric environment

• Real-world scenarios to build applied skills in lakehouse implementation