This course will give you a good introduction to Microsoft Fabric and hands-on experience in all major components of the solution.

When you have completed this course, you should:
• Know what Microsoft Fabric is
• Know how Microsoft Fabric fits into the modern data landscape
• Know what different parts of Microsoft Fabric are and
o Where they fit into a modern data solution
o When to pick what component and why
• Have at least a basic understanding of how each component works through hands-on experience
• Be in a position to decide whether Microsoft Fabric is the right solution for your organization
• Be able to plan the right implementation of Microsoft Fabric for your organization

Many of the tools in the Microsoft Fabric toolbox are not new.
But all of them have either new features or new architecture.

The focus of the course will be on what is new and different while also making sure everyone understands the role of each component.

Course description:

Module 1 Introduction

• Introduction to Microsoft Fabric
o What is it
o How does it fit into the modern data landscape
o Components of Microsoft Fabric
o What is OneLake and how is that like Azure Data Lake Gen2 and how is it different
o OneLake details – how does it work
o Popular patterns when working with Microsoft Fabric
o Concepts in Microsoft Fabric that might be confusing

Module 2 Ingestion

Part 1 Fabric Data Factory
• Introduction to data ingestion to Microsoft Fabric
• Landing data in OneLake
• Introduction to Fabric Data Factory
• Popular loading patterns with Data Factory
• Exercise – Loading data from database with Fabric Data Factory

Part 2 Data Flow Gen2
• Introduction to Data Flow Gen2
• Differences between Data Flow Gen2 and Data Flow Gen1
• When to use Data Flow Gen2 instead of Fabric Data Factory
• Exercise – Load data from files with Data Flow Gen2

Module 3 Transformation

Part 1 introduction
• The choice
o Spark or SQL – which engine to choose
o Self-service option with Data Flow Gen2
• Data Lakehouse pattern
• Tips and tricks on how to organize your workspaces

Part 2 Synapse Engineering (AKA Spark engine)
• Introduction to Spark
• Why use Spark in Microsoft Fabric
• Transferring your SQL skills to Spark
• Cleaning data in Spark
• Exercise – Use Spark to clean data

Part 3 Synapse Datawarehouse (AKA SQL engine)
• Introduction to Synapse Datawarehouse
o The merge of Azure Synapse SQL pools and Azure Synapse Serverless SQL pools
• Why use SQL in Microsoft Fabric
• Cleaning data in the SQL engine
• Exercise – Using SQL engine to clean data
• Exercise – Using data from Spark in the SQL Engine

Module 4 Service layer
• Introduction to Power BI
• Power BI Direct Lake mode and how it differs from Import and Direct Query mode
• Other options for service layer

Module 5 other parts of Microsoft Fabric

Part 1 Real-Time Analytics
• Introduction to Synapse Real-Time Analytics
• KQL databases and queries
o Exercise – Stream data to OneLake

Part 2 - Alerting
• Introduction to Data Activator
• Types of monitoring with Data Activator
o Exercise – Monitor Power BI Dataset

Module 6 Administration and governance
• The admin tools and tasks
• Workspace management
• Permissions, security and licenses
• Endorsement, classification and lineage
• Beyond Fabric governance

Module 7 Wrap up and quiz
• Wrap up and recap
• Quiz with prices