DP-601 Implementing a Lakehouse with Microsoft Fabric
Data landscapes are growing more complex – and the need for platforms that seamlessly connect processing, storage, and analysis is increasing. Microsoft Fabric provides this framework as an end-to-end analytics environment.
Key topics
- Build and operate lakehouse structures in Microsoft Fabric.
- Design data processes end-to-end from source to report.
- Store structured and unstructured data on a shared foundation.
- Process large data volumes efficiently with Spark.
- Set up reports and analytics on consistent, centralized data.
Prerequisite
Anyone with experience in BI, data analysis, or cloud-related technologies is well prepared for the content of this course.
Target group
Everyone responsible for projects in data engineering, business intelligence, or data-driven IT solutions.
Lakehouse skills lay the technical groundwork for analytics environments that keep pace with growing demands.
- Building end-to-end analytics workflows from source to insight
- Enabling data team collaboration on a unified platform
- Setting up and using Microsoft Fabric productively
- Exploring the structure and concept of the Fabric Lakehouse
- Practical use of the Lakehouse in Microsoft Fabric
- Analyzing and transforming data in the Lakehouse
- Getting started with the fundamentals of Apache Spark
- Writing and executing Spark scripts
- Processing data with Spark DataFrames
- Writing SQL queries with Spark SQL
- Visualizing analysis results in Spark notebooks
- Understanding the concept and benefits of Delta Lake
- Creating and configuring Delta tables
- Applying Spark operations to Delta tables
- Managing streaming data with Delta tables
- How Dataflows Gen2 work and where they fit
- Exploring Dataflows Gen2 capabilities hands-on
- Combining Dataflows Gen2 with data pipelines
- Structure and behavior of data pipelines
- Configuring and using Copy Data activities
- Using predefined templates for faster pipeline setup
- Starting, monitoring, and controlling pipeline runs
- A unified data platform reduces complexity, speeds up analysis, and turns raw data into a direct foundation for decision-making.
- Particularly relevant for data engineering, analytics, and BI roles that plan and implement scalable data architectures.
- Data silos, slow pipelines, and inconsistent datasets are systematically eliminated through an integrated architecture.
- A foundation in data processing, SQL, and cloud concepts makes it easier to get started and speeds up practical implementation.
- Concrete use cases from everyday work are at the core: data integration, transformation, and analysis are built directly within the platform.
- Growing data volumes and real-time requirements are driving demand for modern, centrally managed analytics platforms.
- Specialized knowledge in data engineering and analytics increases market value and opens new project opportunities in the cloud space.
- Well-structured data flows and optimized architectures deliver faster results and consistently high data quality.