This is an example of a simple banner

Training: Implementing a Lakehouse with Microsoft Fabric (DP-601)

Ref. DP-601
Duration:
1
 jour
Exam:
Optionnel
Level:
Intermédiaire

Implementing a Lakehouse with Microsoft Fabric (DP-601)

Understanding lakehouse implementation with DP-601

Data processing and analysis play a key role in the success of modern businesses. This course, titled “Implementing a Lakehouse with Microsoft Fabric (DP-601),” teaches you how to centralize and efficiently leverage your data. You will learn to use Microsoft Fabric to meet your organization’s analytics needs.

Through this training, you will master the creation and management of a data lakehouse, combining the flexibility of data lake storage with the analytical power of a warehouse. You will explore the essential features of Microsoft Fabric, including the use of Apache Spark and Delta Lake tables. This practical course will help you transform raw data into actionable insights.

A practical and comprehensive approach

You will complete exercises to create lakehouses, ingest data, and orchestrate processes. You will also learn how to organize your data using the medallion architecture to optimize the performance and readability of analytics. Each module provides concrete skills that can be directly applied to your

Télécharger le PDF de la formation

Participant Profiles

  • Data Analyst
  • Data Engineer
  • Data Scientist

Objectives

  • Create a lakehouse with Microsoft Fabric
  • Use Apache Spark for analytics
  • Leverage Delta Lake tables
  • Ingest data with Gen2 dataflows
  • Orchestrate data processes
  • Design a medallion architecture

Prerequisites

  • Understand data terminology
  • Know the basics of data storage
  • Have basic data analytics knowledge

Course Content

Module 1: Introduction to end-to-end analytics with Microsoft Fabric

  • Discover the features of Microsoft Fabric
  • Understand how the platform works
  • Identify use cases for analytics needs
  • Collaborate with data teams
  • Enable and configure Microsoft Fabric

Module 2: Getting started with lakehouses in Microsoft Fabric

  • Explore the Microsoft Fabric lakehouse
  • Work with lakehouses in Microsoft Fabric
  • Transform data within a lakehouse
  • Create and configure a lakehouse

Module 3: Using Apache Spark in Microsoft Fabric

  • Prepare to use Apache Spark
  • Run Spark code
  • Work with data in a Spark Dataframe
  • Use Spark SQL for queries
  • Visualize data in a Spark notebook

Module 4: Working with Delta Lake tables in Microsoft Fabric

  • Understand the Delta Lake format
  • Create and manage Delta tables
  • Optimize Delta table performance
  • Use Delta tables with Spark
  • Integrate Delta tables with streaming data

Module 5: Ingesting data with Dataflows Gen2 in Microsoft Fabric

  • Understand Dataflows Gen2 in Microsoft Fabric
  • Explore Dataflows Gen2 functionalities
  • Integrate Dataflows Gen2 with Pipelines

Module 6: Orchestrating processes and data movement with Microsoft Fabric

  • Understand pipelines in Microsoft Fabric
  • Use the Copy Data activity
  • Leverage pipeline templates
  • Run and monitor pipelines

Module 7: Organizing a Fabric lakehouse using medallion architecture design

  • Describe the medallion architecture concept
  • Implement medallion architecture in Fabric
  • Query and report on data in the lakehouse
  • Best practices for managing your lakehouse

Documentation

  • Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

  • This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Maximize the value of your data with Microsoft Fabric

In an environment where data is a strategic asset, knowing how to collect, process, and analyze it effectively is essential. The DP-601 training teaches you how to leverage Microsoft Fabric to transform your data into actionable insights. This course guides you through building a data lakehouse, combining the flexibility of data lake storage with the analytical power of a warehouse. This hybrid approach simplifies managing large-scale data while ensuring optimal performance.

A unique platform for integrated data processing

Microsoft Fabric stands out for its ability to centralize and harmonize data from various sources. By integrating tools like Apache Spark and Delta Lake, this SaaS platform offers a comprehensive solution for businesses looking to optimize their analytics processes. The course shows you how to configure a data lakehouse environment, leveraging Microsoft Fabric’s advanced features to process large data volumes quickly and accurately.

Faster and more reliable analytics with Apache Spark

The use of Apache Spark plays a key role in large-scale data analysis. This distributed processing engine enables complex calculations to be executed quickly. You will learn how to write and run Spark code to manipulate large datasets while using Spark SQL to perform fast and accurate queries. This approach helps you extract relevant insights in minimal time.

Optimize data storage and management with Delta Lake

Delta Lake tables add an extra layer to data management. With this optimized storage format, you can ensure the integrity and performance of your analytics. The course teaches you how to create and configure Delta tables, emphasizing best practices for optimizing storage and accelerating data processing. You will also learn how to manage real-time data streams by integrating various sources to enrich your analytics.

Automate and orchestrate your data processes

To ensure seamless processing, it is essential to automate data ingestion and transformation. The course shows you how to use Data Factory to create Gen2 dataflows and integrate them into your processing pipelines. With Power Query Online, you can configure transformation processes without writing code, making data more accessible to business teams. Pipeline orchestration automates repetitive tasks while ensuring workflow monitoring and optimization.

Structure your data for more efficient analytics

Designing a medallion architecture is an innovative approach to organizing your data. By structuring information into Bronze, Silver, and Gold layers, you can control processing levels and ensure analysis quality. The Bronze layer stores raw data, the Silver layer cleans and enriches information, and the Gold layer offers datasets ready for advanced analytics. This methodology makes data more accessible, improves query performance, and ensures data traceability and reliability.

Practical and directly applicable skills

Throughout the course, you will complete practical exercises to apply the concepts covered. You will learn how to create a lakehouse, write Spark code, and configure ingestion pipelines. Each module includes real-world use cases inspired by common business challenges. By the end of the course, you will be able to deploy a complete data lakehouse solution, leveraging Microsoft Fabric’s advanced features to turn your data into a strategic asset.

FAQ

What is the duration of the training?

The DP-601 course consists of several modules, with a total duration of about six hours, including practical exercises.

Does this course require advanced technical skills?

No, you only need to understand data terminology and basic storage concepts. Some knowledge of analytics is also recommended.

What are the benefits of Microsoft Fabric for businesses?

This platform simplifies large-scale data management by centralizing information and accelerating analytics processes. It enhances team performance and optimizes decision-making through reliable insights.

How can I access Microsoft Fabric?

Microsoft Fabric is a SaaS solution accessible via a web browser. No additional software is required, making deployment and use straightforward.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge
Mois actuel

ven30Mai09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven30Mai09:00ven17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-601

ven04juil09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven04juil09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-601

ven08Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven08Aoû09:00ven17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-601

ven12Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven12Sep09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-601

ven17Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven17Oct09:00ven17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-601

ven21Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-601

ven21Nov09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-601

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request