Microsoft
Development
General
Implementing Analytics Solutions Using Microsoft Fabric (DP-600)
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