Simple play icon Course
Skills Expanded

Microsoft Fabric Analytics Engineer: Prepare and Serve Data

by Mohit Batra

This course will teach you Microsoft Fabric and its features - OneLake, Lakehouse, Warehouse, Data Flows, and Data Pipelines - and how to use them to ingest, transform, and serve data.

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.

Table of contents

Course Overview
2mins

About the author

Mohit is a Data Engineer, a Microsoft Certified Trainer (MCT) and a consultant. Mohit has 15+ years of extensive experience in architecting large scale Business Intelligence, Data Warehousing and Big Data solutions with companies like Microsoft and some leading investment banks. As an expert in his field, Mohit has often shared his knowledge in Azure, Spark, SQL Server and Power BI at various public forums and as a corporate trainer. Mohit truly loves to teach and enjoys producing high-quality,... more

Ready to upskill? Get started