Microsoft Fabric Analytics Engineer: Prepare and Serve Data

Focused View

Mohit Batra

3:03:02

0 View

1. Course Overview

1. Course Overview.mp4

02:07

2. Getting Started with Microsoft Fabric

1. Course Introduction.mp4

02:16

2. Understanding Microsoft Fabric Architecture.mp4

07:05

3. Setting up the Environment.mp4

05:26

4. Scenario - Building a Medallion Architecture.mp4

03:04

5. Defining Medallion Architecture Using Task Flows.mp4

03:18

6. Understanding Delta Lake on OneLake.mp4

07:30

3. Working with Lakehouse in Microsoft Fabric

1. Module Overview.mp4

00:36

2. Understanding Lakehouse.mp4

06:58

3. Uploading Files and Creating Tables in Lakehouse.mp4

03:38

4. Understanding Apache Spark Architecture and Execution.mp4

05:55

5. Configuring Apache Spark Pools.mp4

05:49

6. Using Notebooks with Lakehouse.mp4

07:14

7. Working with Objects in Lakehouse SQL Endpoint.mp4

03:38

4. Ingesting Data in Microsoft Fabric

1. Module Overview.mp4

00:33

2. Options to Access and Ingest Data in OneLake.mp4

03:19

3. Accessing External Data Using Shortcuts.mp4

07:19

4. Ingesting Data Using Dataflows Gen2.mp4

09:58

5. Ingesting Data Using Data Factory Pipelines.mp4

08:37

6. Ingesting Data Using Mirroring.mp4

06:44

5. Cleaning and Transforming Data in Microsoft Fabric

1. Module Overview.mp4

00:44

2. Understanding and Creating Apache Spark DataFrames.mp4

06:08

3. Applying Schemas.mp4

03:55

4. Analyzing and Cleaning Data.mp4

05:28

5. Applying Transformations.mp4

07:36

6. Running SQL Queries on DataFrames.mp4

03:22

7. Saving Processed Data to OneLake.mp4

06:52

6. Working with Warehouse in Microsoft Fabric

1. Module Overview.mp4

00:40

2. Understanding Warehouse.mp4

06:26

3. Differences Between Lakehouse and Warehouse.mp4

03:35

4. Ingesting Data Using T-SQL.mp4

03:47

5. Ingesting Data Using Dataflows and Data Factory Pipelines.mp4

05:10

6. Working with Objects in Warehouse.mp4

05:09

7. Creating Shortcut to Warehouse Tables in Lakehouse.mp4

01:51

7. Performance Optimization in Microsoft Fabric

1. Module Overview.mp4

00:32

2. Optimizing and Z-ordering Delta Tables.mp4

07:31

3. Cleaning Delta Table Files with Vacuum.mp4

04:45

4. Enabling Auto Optimization & V-ordering on Delta Tables.mp4

06:26

5. Course Summary.mp4

02:01

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Mohit Batra

Instructor's Courses

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, engaging learning materials for his sessions. In his free time, Mohit loves to read, enjoys photography and music.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.