Training: Implement analytics solutions using Microsoft Fabric (DP-600)

Module 1: Introduction to end-to-end analytics using Microsoft Fabric

• Discover the components of Microsoft Fabric
• Explore the workspace and Fabric experiences
• Understand the end-to-end data flow

Module 2: Get started with lakehouses in Microsoft Fabric

• Create and configure a lakehouse
• Ingest data into the lakehouse
• Explore and transform data

Module 3: Use Apache Spark in Microsoft Fabric

• Configure Spark in Microsoft Fabric
• Load and explore data with DataFrames
• Use Spark SQL to query data
• Visualize data in notebooks
• Optimize Spark performance

Module 4: Work with Delta Lake tables in Microsoft Fabric

• Understand the Delta Lake format
• Create and manage delta tables
• Use time travel features
• Perform streaming operations with Delta
• Optimize delta tables

Module 5: Orchestrate processes and data movement with Microsoft Fabric

• Create and configure data pipelines
• Use the Copy Data activity
• Parameterize and schedule pipelines
• Monitor pipeline execution

Module 6: Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Create a Gen2 dataflow
• Transform data with Power Query Online
• Configure data destinations

Module 7: Get started with data warehouses in Microsoft Fabric

• Create a Fabric data warehouse
• Understand schemas and tables
• Load data into the warehouse
• Query data with T-SQL
• Manage warehouse security

Module 8: Get started with Real-Time Intelligence in Microsoft Fabric

• Discover Real-Time Intelligence
• Create a KQL database
• Ingest real-time data
• Query data with KQL
• Create real-time dashboards
• Configure alerts

Module 9: Get started with data science in Microsoft Fabric

• Discover data science tools in Fabric
• Train and evaluate Machine Learning models
• Deploy and use models

Module 10: Administer a Microsoft Fabric environment

• Configure workspaces and capacities
• Manage users and permissions
• Monitor usage and performance
• Configure governance settings

Module 11: Load data into a Microsoft Fabric data warehouse

• Use COPY INTO for bulk loading
• Configure loading pipelines
• Transform data during loading
• Monitor and optimize operations

Module 12: Query a data warehouse in Microsoft Fabric

• Write advanced T-SQL queries
• Create views and stored procedures
• Use analytical functions
• Optimize query performance

Module 13: Monitor a Microsoft Fabric data warehouse

• Use Dynamic Management Views (DMV)
• Analyze performance metrics
• Diagnose and resolve issues

Module 14: Secure a Microsoft Fabric data warehouse

• Implement column-level security
• Configure row-level security
• Manage dynamic data masking
• Audit data access

Module 15: Create DAX calculations in semantic models

• Create calculated tables and columns
• Write DAX measures
• Use time intelligence functions
• Optimize DAX expressions
• Implement advanced calculations

Module 16: Design scalable semantic models

• Apply star schema modeling best practices
• Configure relationships and cardinality
• Implement role management
• Optimize models for large volumes
• Use composite models

Module 17: Optimize a model for performance in Power BI

• Analyze performance with DAX Studio
• Use Best Practice Analyzer
• Optimize DirectQuery queries
• Configure aggregations
• Reduce model size
• Monitor report performance

Module 18: Create and manage Power BI assets

• Publish and share reports
• Configure Power BI workspaces
• Manage datasets and dataflows
• Schedule data refresh

Module 19: Enforce Power BI model security

• Implement Row-Level Security (RLS)
• Configure Object-Level Security (OLS)
• Test and validate security roles

Module 20: Secure data access in Microsoft Fabric

• Configure granular permissions
• Manage workspace access
• Implement secure data sharing

Module 21: Govern data in Microsoft Fabric with Purview

• Discover Microsoft Purview in Fabric
• Classify and label sensitive data
• Track data lineage