Microsoft
Development
General
Implementing Analytics Solutions Using Microsoft Fabric (DP-600)
Duration: 4 Days
About the course

An instructor‑led, 4‑day advanced training course focused on Microsoft Fabric analytics-engineering. It prepares data professionals to design, create, and manage enterprise-scale data analytics solutions—leveraging Fabric elements like lakehouses, data warehouses, semantic models, pipelines, and notebooks


Mapping to Certification Skills

Microsoft’s Exam DP‑600 “Skills Measured” outline aligns closely, covering:

  • Maintaining analytics solutions (security, governance, dev lifecycle) – 25‑30%
  • Preparing data (ingestion, transformation, modeling) – 45‑50%
  • Implementing and managing semantic models (security, deployment, optimization) – 25‑30%
Course content

1. Introduction & Fabric Fundamentals

  • Explore end‑to‑end analytics with Microsoft Fabric
  • Administer a Fabric environment (workspaces, security, governance)

2. Data Ingestion

  • Use Dataflows Gen 2
  • Ingest via Spark and Fabric notebooks
  • Orchestrate via Data Factory pipelines
  •  
  •  

3. Lakehouses

  • Introduction to lakehouses & medallion architecture
  • Employ Apache Spark in Fabric
  • Manage Delta Lake tables
  • Secure lakehouse resourcesn

4. Data Warehouses

  • Set up a Fabric data warehouse
  • Load, query, monitor, and optimize warehouse performance
  • Secure the data warehouse environment

5. Power BI Integration & Scalability

  • Create scalable model relationships
  • Optimize Power BI model performance and scalability

6. Power BI Security & Semantic Modeling

  • Implement model-level security (row/column/object-level)
  • Manage semantic models (.pbix/.pbids/.pbit, XMLA endpoint, deployment pipelines)

 

Who Should Attend
  • Data professionals experienced in data modeling and analytics (e.g., PL‑300: Power BI Data Analyst)
  • Familiar with SQL, KQL, or DAXl