What you'll learn

This course focuses on one of the key objectives of Microsoft Fabric Analytics Engineer certification - DP-600, which is to prepare and serve data.

Microsoft Fabric is a unified analytics platform that can handle huge volumes of data, process data faster, and serve multiple use cases. It is a new offering from Microsoft that integrates into the Power BI platform and brings data integration, enterprise data warehousing, and big data analytics together.

In this course, Microsoft Fabric Analytics Engineer: Prepare and Serve Data, you’ll gain the ability to ingest, transform, and serve the data using Microsoft Fabric.

First, you’ll learn the architecture of Fabric and how to set up the environment.

Then, you’ll learn about Lakehouse, its different components, how to store data, how to process it using Apache Spark, and how to explore it using SQL endpoint.

Next, you’ll see how to access and ingest data in Fabric using shortcuts, Data Flows, and Data Factory pipelines.

Then you’ll learn about Warehouse, how it differs from Lakehouse, its components and features, and how to store and process data in it.

Finally, you’ll learn how to do performance optimization in Fabric.

By the end of this course, you’ll have the skills and knowledge to prepare and serve the data by building an end-to-end Medallion architecture.