Introduction
Explore end-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Knowledge Check
Summary

Introduction
Explore the Microsoft Fabric lakehouse
Work with Microsoft Fabric lakehouses
Explore and transform data in a lakehouse
Exercise – Create a Microsoft Fabric lakehouse
Knowledge check
Summary

Introduction
Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook
Exercise – Analyze data with Apache Spark
Knowledge check
Summary

Introduction
Understand Delta Lake
Create delta tables
Optimize delta tables
Work with delta tables in Spark
Use delta tables with streaming data
Exercise – Use delta tables in Apache Spark
Knowledge check
Summary

Introduction
Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines
Exercise – Ingest data with a pipeline
Knowledge check
Summary

Introduction
Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Exercise – Create and use a Dataflow Gen2 in Microsoft Fabric
Knowledge check
Summary

Introduction
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Exercise – Analyze data in a data warehouse
Knowledge check
Summary

Introduction
What is real-time data analytics ?
Real-Time Intelligence in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions
Exercise – Explore Real-Time Intelligence in Fabric
Knowledge check
Summary

Introduction
Understand the data science process
Explore and process data with Microsoft Fabric
Train and score models with Microsoft Fabric
Exercise – Explore data science in Microsoft Fabric
Knowledge check
Summary

Introduction
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Knowledge check
Summary

Introduction
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Exercise – Analyze data in a data warehouse
Knowledge check
Summary

Introduction
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2
Exercise: Load data into a warehouse in Microsoft Fabric
Knowledge check
Summary

Introduction
Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse
Exercise: Query a data warehouse in Microsoft Fabric
Knowledge check
Summary

Introduction
Monitor capacity metrics
Monitor current activity
Monitor queries
Exercise – Monitor a data warehouse in Microsoft Fabric
Knowledge check
Summary

Introduction
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Knowledge check
Summary

Introduction
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge
Exercise – Create DAX Calculations in Power BI Desktop
Summary

Introduction
Choose the best storage mode
Configure semantic models for large data
Work with relationships
Write DAX for readability with complex calculations
Create dynamic calculation elements
Exercise – Design a scalable semantic model
Knowledge check
Summary

Introduction to performance optimization
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Check your knowledge
Summary

Introduction
Create reusable Power BI assets
Manage development lifecycle for Power BI assets
Use lineage view and endorse data assets
Manage a Power BI semantic model using XMLA endpoint
Exercise: Create reusable Power BI assets
Knowledge check
Summary

Introduction
Restrict access to Power BI model data
Restrict access to Power BI model objects
Apply good modeling practices
Exercise: Enforce model security
Knowledge check
Summary

Introduction
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Knowledge check
Summary

Introduction
Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions
Exercise: Secure data access in Microsoft Fabric
Knowledge check
Summary

Introduction
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Knowledge check
Summary

Introduction
Govern data in Microsoft Fabric
Why use Microsoft Purview with Microsoft Fabric?
Govern data in the Microsoft Purview hub
Knowledge check
Summary