- Module 1: Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Discover the capabilities Fabric has to offer, understand how it works, and identify how you can use Fabric for your analytics needs.
In this module, you'll learn how to:
- Describe end-to-end analytics in Microsoft Fabric
- Module 2: Get started with lakehouses in Microsoft Fabric
In this module, you'll learn how to:
- Describe core features and capabilities of lakehouses in Microsoft Fabric
- Create a lakehouse
- Ingest data into files and tables in a lakehouse
- Query lakehouse tables with SQL
- Module 3: Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data at scale.
In this module, you'll learn how to:
- Configure Spark in a Microsoft Fabric workspace
- Identify suitable scenarios for Spark notebooks and Spark jobs
- Use Spark dataframes to analyze and transform data
- Use Spark SQL to query data in tables and views
- Visualize data in a Spark notebook
- Module 4: Tables in a Microsoft Fabric lakehouse are based on the Delta Lake technology commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.
In this module, you'll learn how to:
- Understand Delta Lake and delta tables in Microsoft Fabric
- Create and manage delta tables using Spark
- Use Spark to query and transform data in delta tables
- Use delta tables with Spark structured streaming
- Module 5: Use Data Factory pipelines in Microsoft Fabric
In this module, you'll learn how to:
- Describe pipeline capabilities in Microsoft Fabric
- Use the Copy Data activity in a pipeline
- Create pipelines based on predefined templates
- Run and monitor pipelines
- Module 6: Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows (Gen2) for visually creating multi-step data ingestion and transformation using Power Query Online.
In this module, you'll learn how to:
- Describe Dataflow (Gen2) capabilities in Microsoft Fabric
- Create Dataflow (Gen2) solutions to ingest and transform data
- Include a Dataflow (Gen2) in a pipeline
- Module 7: Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.
In this module, you'll learn how to:
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage datasets within a data warehouse
- Module 8: Get started with Real-Time Analytics in Microsoft Fabric
In this module, you'll learn how to:
- Describe Real-Time Analytics in Microsoft Fabric
- Create Real-Time Analytics databases and tables
- Use KQL to query tables
- Module 9: Get started with data science in Microsoft Fabric by learning how to train a model in a notebook, and track your metrics with MLflow and experiments.
In this module, you'll learn how to:
- Understand the data science process
- Train models with notebooks in Microsoft Fabric
- Track model training metrics with MLflow and experiments
- Module 10: Use Data Activator in Microsoft Fabric to easily monitor and take action on your data.
- Understand Data Activator
- Understand triggers, conditions and actions in Data Activator
- Get data from Power BI Reports and EventStreams with Data Activator
- Assign data and create triggers in Data Activator
- Module 11: Administer Microsoft Fabric
In this module, you'll learn how to:
- Describe Fabric admin tasks
- Navigate the admin center
- Manage user access
Overview
Syllabus
- Module 1: Module 1: Introduction to end-to-end analytics using Microsoft Fabric
- Introduction
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Knowledge Check
- Summary
- Module 2: Module 2: Get started with lakehouses in Microsoft Fabric
- Introduction
- Explore the Microsoft Fabric Lakehouse
- Work with Microsoft Fabric Lakehouses
- Explore and transform data in a lakehouse
- Exercise - Create and ingest data with a Microsoft Fabric Lakehouse
- Knowledge check
- Summary
- Module 3: Module 3: Use Apache Spark in Microsoft Fabric
- 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
- Module 4: Module 4: Work with Delta Lake tables in Microsoft Fabric
- Introduction
- Understand Delta Lake
- Create delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
- Exercise - Use delta tables in Apache Spark
- Knowledge check
- Summary
- Module 5: Module 5: Use Data Factory pipelines in Microsoft Fabric
- Introduction
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
- Exercise - Ingest data with a pipeline
- Knowledge check
- Summary
- Module 6: Module 6: Ingest Data with Dataflows Gen2 in Microsoft Fabric
- 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
- Module 7: Module 7: Get started with data warehouses in Microsoft Fabric
- 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
- Module 8: Module 8: Get started with Real-Time Analytics in Microsoft Fabric
- Introduction
- What is Synapse Real-Time Analytics?
- Understand KQL database and tables
- Write queries with KQL
- Exercise: Explore Synapse Real-Time Analytics in Fabric
- Knowledge check
- Summary
- Module 9: Module 9: Get started with data science in Microsoft Fabric
- 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
- Module 10: Module 10: Get started with Data Activator in Microsoft Fabric
- Introduction
- Understand Data Activator
- Get started with Data Activator
- Understand triggers, conditions and actions in Data Activator
- Get data from Power BI Reports and EventStreams with Data Activator
- Assign data in Data Activator
- Create triggers in Data Activator
- Exercise – Use Data Activator in Fabric
- Knowledge check
- Summary
- Module 11: Module 11: Administer Microsoft Fabric
- Introduction
- Understand the Fabric Architecture
- Understand the Fabric administrator role
- Manage Fabric security
- Govern data in Fabric
- Knowledge check
- Summary
