Unlock the potential of data analytics with this comprehensive course on implementing a lakehouse using Microsoft Fabric. Participants will explore how Microsoft Fabric integrates data lake flexibility with data warehouse analytics, providing a robust solution for end-to-end enterprise analytics. Through hands-on exercises and detailed lessons, you'll learn to leverage Microsoft Fabric for creating, managing, and optimizing data lakehouses, enhancing your analytics capabilities.This course delves into key technologies like Apache Spark and Delta Lake, guiding you through their implementation and usage within Microsoft Fabric. By the end of the course, you'll be proficient in data ingestion, transformation, and orchestration using advanced tools and techniques, positioning yourself to drive impactful data-driven decisions within your organization.Audience ProfileThis course is ideal for data professionals, data engineers, and analytics practitioners looking to enhance their skills in modern data architectures. It is also beneficial for IT managers and business analysts seeking to implement robust data solutions using Microsoft Fabric.PrerequisitesYou should be familiar with basic data concepts and terminology.Course OutlineModule 1: Introduction to end-to-end analytics using Microsoft FabricExplore end-to-end analytics with Microsoft FabricData teams and Microsoft FabricEnable and use Microsoft FabricModule 2: Get started with lakehouses in Microsoft FabricExplore the Microsoft Fabric LakehouseWork with Microsoft Fabric LakehousesExplore and transform data in a lakehouseExercise - Create and ingest data with a Microsoft Fabric LakehouseModule 3: Use Apache Spark in Microsoft FabricPrepare to use Apache SparkRun Spark codeWork with data in a Spark dataframeWork with data using Spark SQLVisualize data in a Spark notebookExercise - Analyze data with Apache SparkModule 4: Work with Delta Lake tables in Microsoft FabricUnderstand Delta LakeCreate delta tablesWork with delta tables in SparkUse delta tables with streaming dataExercise - Use delta tables in Apache SparkModule 5: Ingest Data with Dataflows Gen2 in Microsoft FabricUnderstand Dataflows Gen2 in Microsoft FabricExplore Dataflows Gen2 in Microsoft FabricIntegrate Dataflows Gen2 and Pipelines in Microsoft FabricExercise - Create and use a Dataflow Gen2 in Microsoft FabricModule 6: Use Data Factory pipelines in Microsoft FabricUnderstand pipelinesUse the Copy Data activityUse pipeline templatesRun and monitor pipelinesExercise - Ingest data with a pipelineModule 7: Organize a Fabric lakehouse using medallion architecture designDescribe medallion architectureImplement a medallion architecture in FabricQuery and report on data in your Fabric lakehouseConsiderations for managing your lakehouseExercise - Organize your Fabric lakehouse using a medallion architecture
Overview
Taught by
ONLC Training Centers
