Building Data Lakes and Lakehouses with Microsoft Fabric

Master the transactional capabilities of Delta Lake, which are essential for ensuring data reliability in your Fabric Lakehouse. You will get a practical understanding of how ACID (Atomicity, Consistency, Isolation, and Durability) principles are implemented in Delta tables. Through hands-on exercises, you will learn to query historical data versions, recover data from errors or failures, and manage schema evolution as your data requirements change. This module will equip you with technical skills to build robust, enterprise-grade data systems that maintain integrity even with multiple, simultaneous operations.

Design and implement a multi-layered data organization strategy using the medallion architecture pattern. You'll work with three distinct data layers: Bronze Layer (store raw, unchanged data), Silver Layer (cleanse and transform data, applying data quality controls), and Gold Layer (business-ready, curated datasets optimized for analytics). Through hands-on exercises, you'll create each layer, develop data quality controls and transformations, and build datasets that are ready for business analysis. By the end of this module, you'll be able to implement a full medallion architecture that provides a balance between raw data accessibility and quality control.

Develop comprehensive data ingestion capabilities for Fabric Lakehouse using the right tool for each scenario through hands-on implementation of Dataflows Gen2 for easy in-browser table loads, Pipelines for orchestrating and scheduling copy/ELT operations, Notebooks for custom code and transformations, and EventStreams for real-time data processing. This practical exercise guides learners through landing data as Delta in OneLake, mapping to Lakehouse tables, setting refresh schedules, and selecting appropriate ingestion approaches for different scenarios within the Fabric web experience. Learners will demonstrate mastery of versatile data ingestion by successfully implementing multiple ingestion methods and articulating scenario-based tool selection decisions that optimize data loading efficiency and reliability across diverse data ingestion requirements.

Configure the access layers of your Fabric Lakehouse to make your data available to users while keeping it secure. You will get hands-on experience by creating a complete, end-to-end solution. This includes setting up SQL Analytics endpoints (enabling efficient data querying), connecting to Power BI (visualization and reporting), implementing fine-grained permissions (precise access control), and integrating with Microsoft Entra ID (secure, enterprise-grade authentication). By the end of this module, you'll be able to create an enterprise-ready Lakehouse environment that enables self-service analytics without compromising data security.