Implementing a Lakehouse with Microsoft Fabric - Applied Skills Workshop Training in Canada

This one-day instructor-led course provides data professionals with the knowledge and practical skills required to implement and manage Lakehouse solutions using Microsoft Fabric. Aligned with the Microsoft DP-601 Applied Skills curriculum, the course focuses on building, ingesting, transforming and analysing data within Microsoft Fabric Lakehouses using Apache Spark, Delta Lake and Fabric data integration tools.

Through a combination of instructor-led learning and hands-on labs, learners explore Lakehouse architecture, Apache Spark, Delta Lake tables, Dataflows Gen2, Data Factory Pipelines and Medallion Architecture. By the end of the course, participants will be able to confidently implement and manage Microsoft Fabric Lakehouses that support scalable analytics workloads.

Prerequisites

Participants should have:

• A basic understanding of data analytics and business intelligence concepts.
• Experience working with relational databases and SQL.
• Familiarity with Microsoft Fabric concepts is recommended.
• An understanding of data transformation and modelling concepts.
• Experience with cloud-based data platforms is beneficial.

Target audience

This course is designed for:

• Data engineers implementing Microsoft Fabric solutions.
• Analytics engineers working with enterprise data platforms.
• Data professionals working with analytical and engineering workloads.
• Data analysts looking to develop Microsoft Fabric Lakehouse skills.
• Professionals preparing for the Microsoft Applied Skills credential: Implement a Lakehouse with Microsoft Fabric.

By the end of this course, learners will be able to:

• Create and manage Microsoft Fabric Lakehouses.
• Ingest and prepare data using Dataflows Gen2 and Data Factory Pipelines.
• Process and analyse data using Apache Spark, Spark SQL and Spark notebooks.
• Create, manage and optimise Delta Lake tables.
• Implement data transformation and orchestration workflows within Microsoft Fabric.
• Apply Microsoft Fabric best practices when implementing and managing Lakehouse solutions.

Module 1: Explore end-to-end Analytics using Microsoft Fabric

• Explore end-to-end analytics using Microsoft Fabric.
• Understand the role of Lakehouses in modern analytics solutions.
• Explore Microsoft Fabric architecture and capabilities.
• Understand how OneLake supports unified data storage.
• Identify analytics scenarios supported by Microsoft Fabric.

Module 2: Get Started with Lakehouses in Microsoft Fabric

• Understand Lakehouse architecture and capabilities.
• Create and configure a Microsoft Fabric Lakehouse.
• Ingest, store and organise data in a Lakehouse.
• Query and analyse Lakehouse data.
• Prepare data for analytical workloads.

Module 3: Use Apache Spark in Microsoft Fabric

• Understand Apache Spark concepts and architecture.
• Run Spark workloads within Microsoft Fabric.
• Work with Spark DataFrames and Spark SQL.
• Analyse and transform data using Spark notebooks.
• Visualise and explore data within Spark environments.

Module 4: Work with Delta Lake Tables in Microsoft Fabric

• Understand Delta Lake architecture and capabilities.
• Create and manage Delta Lake tables.
• Use Delta tables with Spark workloads.
• Optimise Delta Lake performance and reliability.
• Work with streaming and transactional data.

Module 5: Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Explore data ingestion techniques within Microsoft Fabric.
• Create and manage Dataflows Gen2.
• Transform data using Power Query Online.
• Implement multi-step ingestion and transformation processes.
• Prepare data for Lakehouse storage and analysis.

Module 6: Orchestrate Processes and Data Movement with Microsoft Fabric

• Understand Data Factory pipeline capabilities.
• Create and configure data pipelines.
• Use Copy Data activities for data movement.
• Orchestrate ingestion and transformation workflows.
• Monitor and manage pipeline execution.

Exams and assessments

This course prepares learners for the Microsoft Applied Skills credential: Implement a Lakehouse with Microsoft Fabric. Throughout the course, learners complete practical labs and guided exercises that reinforce the skills required to implement, manage, and optimise Microsoft Fabric Lakehouse solutions. The exam is not included but is available seaprately.

Hands-on learning

This course includes:

• Practical Microsoft Fabric Lakehouse labs.
• Hands-on exercises creating and managing Lakehouses.
• Guided activities using Apache Spark, Spark SQL and Delta Lake.
• Practical exercises using Dataflows Gen2 and Data Factory Pipelines.
• Real-world Lakehouse ingestion, transformation and orchestration scenarios.
• Instructor-led demonstrations using Microsoft Fabric.