1 – Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

2 – Discover and connect to data in OneLake

• Understand OneLake
• Browse and connect to data in OneLake
• Discover streaming data in Real-Time hub

3 – Get started with lakehouses in Microsoft Fabric

• Describe lakehouse features and capabilities
• Ingest and transform data in a lakehouse
• Query and analyze lakehouse data
• Module assessment

4 – Get started with data warehouses in Microsoft Fabric

• Understand data warehouses
• Understand data warehouses in Fabric
• Query and transform data
• Model data in a warehouse
• Secure and monitor a warehouse
• Module assessment

5 – Get started with Real-Time Intelligence in Microsoft Fabric

• 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
• Module assessment

6 – Choose data stores in Microsoft Fabric

• Describe analytical data store options
• Evaluate lakehouse capabilities
• Evaluate warehouse capabilities
• Evaluate eventhouse capabilities
• Case study – Choose data stores for an integrated analytics solution
• Module assessment

7 – Design dimensional models for analytics in Microsoft Fabric

• Describe dimensional schema types
• Design fact tables
• Design dimension tables
• Implement slowly changing dimensions

8 – Transform data using Dataflows Gen2 in Microsoft Fabric

• Understand Dataflows Gen2
• Transform data with Power Query
• Optimize Dataflows Gen2 performance

9 – Transform data using notebooks in Microsoft Fabric

• Describe notebooks in Fabric
• Shape and clean data
• Combine and aggregate data
• Write and size Delta tables

10 – Transform data using T-SQL in Microsoft Fabric

• Transform data with T-SQL queries
• Create views for reusable logic
• Build stored procedures
• Implement dimensional tables

11 – Create DAX calculations in semantic models

• Create calculated tables
• Create calculated columns
• Understand implicit measures
• Create explicit measures
• Use iterator functions

12 – Design semantic models for scale in Microsoft Fabric

• Choose a storage mode
• Design star schema for semantic models
• Design scalable calculations
• Configure settings for scale
• Module assessment

13 – Optimize semantic model performance

• Use Performance analyzer to diagnose issues
• Optimize DAX calculations
• Reduce cardinality for better performance
• Implement aggregations
• Troubleshoot common performance issues

14 – Enforce semantic model security

• Implement row-level security
• Apply object-level security
• Test security and manage roles
• Module assessment

15 – Manage the semantic model development lifecycle

• Create reusable Power BI assets
• Manage Power BI content in version control
• Manage semantic models with the XMLA endpoint
• Deploy content through stages
• Maintain and monitor semantic models
• Module assessment

16 – Prepare the semantic layer for AI in Microsoft Fabric

• Understand what AI needs from your data
• Design gold layers with AI in mind
• Prepare a semantic model for AI
• From semantic models to enterprise ontology
• Validate AI readiness
• Module assessment

17 – Understand Microsoft Fabric IQ fundamentals

• Get started with Fabric IQ
• Explore Microsoft Fabric IQ components
• Understand the ontology modeling paradigm
• Module assessment

18 – Create an ontology with Fabric IQ

• Choose an ontology creation approach
• Build an ontology manually
• Generate an ontology from a Power BI semantic model
• Connect an ontology to data
• Configure ontology relationships
• Preview the ontology
• Module assessment

19 – Secure data access in Microsoft Fabric

• Understand the Fabric security model
• Configure workspace and item permissions
• Apply granular permissions
• Module assessment

20 – Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL
• Module assessment

21 – Govern data in Microsoft Fabric with Purview

• Govern data in Microsoft Fabric
• Why use Microsoft Purview with Microsoft Fabric?
• Govern data in the Microsoft Purview hub
• Module assessment

22 – Govern analytics data in Microsoft Fabric

• Classify and protect data in Microsoft Fabric
• Endorse and document data assets
• Govern data for AI consumption