DP‑600 Course Outline: Implementing Analytics Solutions with Microsoft Fabric

Gain the skills to design, build, and deploy end-to-end analytics solutions using Microsoft Fabric. This course prepares you for the Fabric Analytics Engineer Associate (DP‑600) certification.

Module 1: Introduction to Microsoft Fabric

• Overview of Microsoft Fabric architecture
• Core Fabric workloads: Data Engineering, Data Factory, Synapse, Power BI
• Lakehouse and OneLake fundamentals
• Fabric capacity and workspace management

Module 2: Data Engineering in Microsoft Fabric

• Working with Lakehouses, Warehouses, and Delta tables
• Ingesting and transforming data using Dataflows Gen2
• Building data pipelines with Data Factory
• Optimising data performance and storage

Module 3: Designing and Modelling Analytics Solutions

• Building semantic models in Power BI
• Model relationships, DAX calculations, and measures
• Implementing star schema and modelling best practices
• Performance tuning for large-scale data models

Module 4: Advanced Analytics with Synapse

• Notebook development using Spark
• Data exploration and machine learning integration
• Building SQL analytics within Fabric Warehouse
• Monitoring and debugging Synapse activity

Module 5: Operationalising Analytics Solutions

• End-to-end pipeline orchestration
• Automating data refreshes and workloads
• Implementing CI/CD with Fabric and Power BI
• Deployment pipelines and version control

Module 6: Security, Governance & Compliance

• Data governance with Microsoft Purview
• Row-level security (RLS) and object-level security (OLS)
• Data sensitivity labels and policy enforcement
• Workspace roles, permissions, and best practices

Module 7: Exam Preparation & Practice

• DP-600 exam format and skills measured
• Practice scenarios and real-world case studies
• Exam tips, strategies, and certification roadmap