Introduction to Microsoft Fabric

Course details

Explore the extensive features of Microsoft Fabric. Start with the essentials, such as setting up a tenant and utilizing OneLake. Master the organization, loading, and transformation of data through pipelines, dataflows, and notebooks. Gain proficiency in applying T-SQL commands, configuring real-time analytics, and creating detailed paginated reports. Enhance your data management skills with structured approaches for both Fabric Warehouse and Fabric Lakehouse configurations. Additionally, explore machine learning experiments, manage data with Data Activator, and use Purview’s admin monitoring tools. By the end of this course, you’ll be ready to streamline data processes, generate real-time analytics, innovate with machine learning, and make data-driven decisions more effectively.

Concepts

0. Introduction

01 - Introduction to Microsoft Fabric

1. Get Started with Microsoft Fabric

02 - Learning objectives
03 - Understand challenges in data analytics
04 - Appreciate the Microsoft Fabric vision
05 - Enable Microsoft Fabric on an existing Power BI tenant
06 - Set up a new Microsoft Fabric tenant
07 - Choose the right Fabric license

2. Explore the Microsoft Fabric Platform

08 - Learning objectives
09 - Understand OneLake
10 - Organize data in a data warehouse
11 - Organize data in a lakehouse
12 - Load and transform data through pipelines and dataflows
13 - Analyze data with semantic models and reports
14 - Work with data through notebooks
15 - Apply advanced data science
16 - Implement real-time analytics
17 - Act on your data with Data Activator
18 - Monitor and manage with Purview
19 - Choose roles in Fabric

3. Load Data into Fabric

20 - Learning objectives
21 - Create a pipeline to load data
22 - Configure shortcuts
23 - Synchronize data with the OneLake explorer
24 - Use a notebook to turn files into tables

4. Load and Transform Data with Dataflows

25 - Learning objectives
26 - Create a dataflow to load data
27 - Use a dataflow to turn files into tables
28 - Transform data with dataflows

5. Manage Data with Fabric Warehouse

29 - Learning objectives
30 - Apply T-SQL to set up a warehouse
31 - Query data
32 - Create reports with the default semantic model

6. Manage Data with Fabric Lakehouse

33 - Learning objectives
34 - Set up a lakehouse
35 - Query the SQL analytics endpoint
36 - Create reports with the default semantic model
37 - Create a custom semantic model on lakehouse data

7. Analyze Data through Semantic Models

38 - Learning objectives
39 - Understand Direct Lake
40 - Create DAX measures
41 - Create visual reports
42 - Create paginated reports

8. Apply Real-Time Analytics

43 - Learning objectives
44 - Ingest streaming data in Fabric
45 - Configure a KQL database
46 - Set up a streaming semantic model
47 - Build real-time reports

9. Take Action through Data Activator

48 - Learning objectives
49 - Understand Data Activator
50 - Set up triggers

10. Apply Data Science

51 - Learning objectives
52 - Run ML experiments in Fabric
53 - Predict outcomes using ML models

11. Manage Fabric Usage

54 - Learning objectives
55 - Get insights through the Purview hub
56 - Access admin monitoring

Summary

57 - Summary