Discover the capabilities of data analytics through this in-depth training on building a lakehouse with Microsoft Fabric. This course teaches data specialists how Microsoft Fabric merges the flexibility of data lakes with the power of data warehouse systems, delivering a thorough system for full-spectrum business analytics. Through practical exercises and thorough instruction, you will understand how to build, handle, and enhance data lakehouses with Microsoft Fabric, strengthening your ability to analyze information and derive insights.
This comprehensive course introduces important systems like Apache Spark and Delta Lake and walks you through their use with Microsoft Fabric. After finishing, you will have strong knowledge of loading, handling, and coordinating information using state-of-the-art methods. You will be ready to guide data-driven outcomes within your business context.
Intended Audience:
This program suits information specialists, data engineers, analytics experts, and individuals interested in advancing their knowledge in contemporary data systems. IT directors and business experts seeking to launch strong information management approaches utilizing Microsoft Fabric will also find this course valuable.
Required Knowledge:
Familiarity with elementary data ideas and sector language is recommended.
Curriculum Outline
Module 1: Complete Business Analytics Using Microsoft Fabric
- Learn about complete business analytics with Microsoft Fabric
- Understand data team structures and Microsoft Fabric applications
- Activate and engage with Microsoft Fabric
Module 2: Getting Started With Microsoft Fabric Lakehouses
- Study the Microsoft Fabric Lakehouse Architecture
- Collaborate with Microsoft Fabric Lakehouses
- Investigate and modify information in a lakehouse
- Hands-on Exercise: Build and Import Data Into a Microsoft Fabric Lakehouse
Module 3: Using Apache Spark in Microsoft Fabric
- Set Up Your Environment for Apache Spark
- Carry Out Spark Code
- Manipulate Information in a Spark Information Collection
- Work with Information Using Spark Query Language
- Build Information Visuals in a Spark Workspace
- Hands-on Exercise: Examine Information Using Apache Spark
Module 4: Handling Delta Lake Information Systems in Microsoft Fabric
- Study Delta Lake Concepts and Advantages
- Build delta system tables
- Use delta information in Spark
- Use delta systems with live information feeds
- Hands-on Exercise: Use delta systems in Apache Spark
Module 5: Using Dataflows Gen2 to Upload Information in Microsoft Fabric
- Comprehend Dataflows Gen2 in Microsoft Fabric
- Work with Dataflows Gen2 in Microsoft Fabric
- Combine Dataflows Gen2 with Pipelines in Microsoft Fabric
- Hands-on Exercise: Build and Use a Dataflow Gen2 in Microsoft Fabric
Module 6: Building Data Pipelines in Microsoft Fabric
- Comprehend Data Pipeline Concepts
- Use the Transfer Information Task
- Use Pre-Built Pipeline Layouts
- Begin and Review Pipeline Processes
- Hands-on Exercise: Transfer Information Using a Pipeline
Module 7: Building a Fabric Lakehouse Using a Three-Layer Structure
- Clarify Three-Layer Architecture Concepts
- Build a Three-Layer Architecture in Fabric
- Explore and Summarize Information in Your Fabric Lakehouse
- Managing Your Lakehouse; Critical Factors
- Hands-on Exercise: Arrange Your Fabric Lakehouse Using a Three-Layer Structure
