- Home
- Training
- Microsoft Trainings
- DP-600: Implementing Analytics Solutions Using Microsoft Fabric
DP-600: Implementing Analytics Solutions Using Microsoft Fabric
Abilene Academy, Switzerland's #1 PECB Titanium Partner, builds your competence to deploy Microsoft Fabric analytics solutions with a 99% pass rate. Course length: 4 days of training + exam.
Trusted by 600+ organisations
What you will learn in the DP-600: Implementing Analytics Solutions Using Microsoft Fabric course
Learning outcomes
- Design a Microsoft Fabric analytics architecture for enterprise reporting needs
- Build ingestion workflows with Dataflows Gen2, notebooks, and pipelines
- Structure lakehouses with Bronze, Silver, and Gold layers
- Implement relational warehouses and query them with T-SQL
- Create semantic models with scalable relationships and storage choices
- Enforce row-level and object-level security in Power BI
- Optimize model and query performance with diagnostic tools
What You'll Master
- Assess enterprise analytics requirements and map them to Fabric components
- Produce lakehouse, warehouse, and semantic model assets for reporting
- Conduct data ingestion and transformation with dataflows, notebooks, and pipelines
- Evaluate model performance, scalability, and security before deployment
- Manage end-to-end analytics delivery across Microsoft Fabric workloads
Course description
Enterprise analytics teams in 2025 and 2026 face two pressures at once: they must deliver faster and they must prove data quality, security, and traceability across the full analytics chain. Microsoft Fabric matters because it brings ingestion, engineering, warehousing, semantic modeling, and visualization into one SaaS environment. That matters for organizations that need fewer handoffs, tighter governance, and clearer ownership of analytics assets. For professionals moving beyond isolated Power BI reporting, DP-600 marks the shift toward enterprise-scale solution design.
During the course, participants build analytics assets step by step. They ingest data with Dataflows Gen2, Spark, and Fabric notebooks. They orchestrate movement and transformation with Data Factory pipelines. They create and structure lakehouses, apply medallion architecture, work with Delta tables, and load relational warehouses for SQL-based analytics. They then connect these assets to semantic models in Power BI, define relationships, improve performance, and apply security controls. Exercises and case work force participants to choose the right Fabric component for each delivery scenario instead of memorizing feature lists.
The training addresses problems that many vendor courses leave vague. Participants work through documentation gaps between ingestion, storage, and reporting layers. They clarify accountability when data engineers, analysts, and BI owners share the same platform. They test evidence quality by checking whether transformations, model relationships, and security rules stand up to review. They also practice cross-functional communication so technical decisions remain defensible to platform owners, managers, and audit stakeholders.
By the end, participants can design a Fabric-based analytics architecture, build core assets, secure and optimize semantic models, and justify technical choices against enterprise requirements. They leave ready to sit the DP-600 exam and to produce delivery outputs that teams can review, operate, and scale. That includes pipelines, notebooks, lakehouse structures, warehouse objects, semantic models, and performance and security decisions that hold up in production.
DP-600: Implementing Analytics Solutions Using Microsoft Fabric course program
The program runs over 4 days of training.
Module 1Ingest Data with Dataflows Gen2 in Microsoft Fabric
Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.
Module 2Ingest data with Spark and Microsoft Fabric notebooks
Discover how to use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse. Fabric notebooks provide a scalable and systematic solution.
Module 3Use Data Factory pipelines in Microsoft Fabric
Microsoft Fabric includes Data Factory capabilities, including the ability to create pipelines that orchestrate data ingestion and transformation tasks.
Module 4Get started with lakehouses in Microsoft Fabric
Lakehouses merge data lake storage flexibility with data warehouse analytics. Microsoft Fabric offers a lakehouse solution for comprehensive analytics on a single SaaS platform.
Module 5Organize a Fabric lakehouse using medallion architecture design
Explore the potential of the medallion architecture design in Microsoft Fabric. Organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics.
Module 6Use Apache Spark in Microsoft Fabric
Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data in a Lakehouse at scale.
Module 7Work with Delta Lake tables in Microsoft Fabric
Tables in a Microsoft Fabric lakehouse are based on the Delta Lake storage format commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.
Module 8Get started with data warehouses in Microsoft Fabric
Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
Module 9Load data into a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Module 10Query a data warehouse in Microsoft Fabric
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Module 11Monitor a Microsoft Fabric data warehouse
A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Module 12Understand scalability in Power BI
Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.
Module 13Create Power BI model relationships
Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
Module 14Use tools to optimize Power BI performance
Use tools to develop, manage, and optimize Power BI data model and DAX query performance.
Module 15Enforce Power BI model security
Enforce model security in Power BI using row-level security and object-level security.
DP-600: Implementing Analytics Solutions Using Microsoft Fabric exam and certification
- Certificate type
- Professional Certificate
- Certification body
- Microsoft
Who should take DP-600: Implementing Analytics Solutions Using Microsoft Fabric , and prerequisites
DP-600: Implementing Analytics Solutions Using Microsoft Fabric is written for these roles: Power BI Analyst, Data Engineer, and Analytics Architect.
Power BI Analyst
Extend reporting into Fabric architecture
Data Engineer
Build governed analytics assets end to end
Analytics Architect
Defend platform design and delivery choices
- Power BI Data Analyst: You already build models and reports, but you need to extend your work into Fabric lakehouses, pipelines, and enterprise deployment decisions.
- Data Engineer moving into Fabric: You manage ingestion and transformation, but you need a structured path to semantic models, warehouse design, and analytics delivery.
- Analytics Solution Architect: You must choose the right Fabric components, define ownership boundaries, and defend architecture decisions across teams.
- BI Lead or Analytics Manager: You oversee reporting delivery and need a practical view of scalability, model security, and operational governance in one platform.
Prerequisites
Participants need prior hands-on experience in data modeling, data extraction, and analytics delivery. They should already work comfortably with Power BI or an equivalent analytics stack and should read SQL, DAX, or KQL at a practical level. Experience comparable to PL-300 is strongly recommended. Without that baseline, participants struggle to connect Fabric components into an end-to-end solution and spend too much effort on fundamentals instead of enterprise design and implementation decisions.
DP-600: Implementing Analytics Solutions Using Microsoft Fabric formats, languages and duration
DP-600: Implementing Analytics Solutions Using Microsoft Fabric takes 4 days of training + exam and is available in these formats: Physical classroom and Online classroom. It is taught in English and French.
| Physical classroom | Online classroom | |
|---|---|---|
| How you learn | In class, with the trainer | Live online, with the trainer |
| Where | Lausanne / Morges | From anywhere |
| Start | Next: 14 Dec 20264 dates available | Next: 14 Dec 20264 dates available |
| Duration | 4 days of training + exam | 4 days of training + exam |
| Languages | ENFR | ENFR |
| Certificate of attendance | ||
| Exam and certification | ||
| Price | Personalised offer | Personalised offer |
| Best for | Learning in a group, away from the office | A live trainer without travelling |
| Next step | See dates | See dates |
Included in every format
- Lifetime access to course material
- Certificate of attendance
DP-600: Implementing Analytics Solutions Using Microsoft Fabric dates and locations
The next DP-600: Implementing Analytics Solutions Using Microsoft Fabric session starts on 14 December 2026 in Lausanne / Morges (Physical classroom and Online classroom). 4 dates are open until June 2027, each one in both formats: Physical classroom and Online classroom.
- Lausanne / MorgesLive onlineEN · FRBook
- Lausanne / MorgesLive onlineEN · FRBook
- Lausanne / MorgesLive onlineEN · FRBook
- Lausanne / MorgesLive onlineEN · FRBook
DP-600: Implementing Analytics Solutions Using Microsoft Fabric : frequently asked questions
What is the DP-600 certification and what does it validate?
The DP-600 exam leads to the Microsoft Certified: Fabric Analytics Engineer Associate credential, which validates the ability to design and implement end-to-end analytics solutions using Microsoft Fabric. Certified engineers can build medallion lakehouses, orchestrate ingestion pipelines, create enterprise semantic models in Power BI, and apply row-level security.
“DP-600 is not a Power BI upgrade exam. It is a platform engineering certification for people who design entire analytics delivery chains.”Our expert teamRead the full answer →
Who should take DP-600 training?
DP-600 is designed for Power BI data analysts extending into Fabric lakehouses and pipelines, data engineers moving into semantic model and warehouse design, and analytics architects defending component choices. PL-300 equivalent experience is strongly recommended before attending.
“DP-600 rewards the analytics professional who has worked in both ends of the stack — the engineer who models data and the analyst who reports it.”Our expert teamRead the full answer →
What is Microsoft Fabric and how does DP-600 relate to it?
Microsoft Fabric is an end-to-end analytics SaaS platform that unifies data engineering, warehousing, semantic modeling, and visualization in one environment. DP-600 is the primary certification for Fabric analytics engineers, covering lakehouse architecture, ingestion pipelines, relational warehouses, Power BI semantic models, and security controls.
“Microsoft Fabric doesn't make analytics easier by adding more tools. It makes it easier by replacing five tools with one governance layer. That is the design shift DP-600 certifies.”Our expert teamRead the full answer →
What are the prerequisites for DP-600 training?
DP-600 requires hands-on experience in data modeling and analytics delivery, practical knowledge of SQL, DAX, or KQL, and comfort with Power BI or an equivalent analytics stack. PL-300 equivalent experience is strongly recommended.
“The prerequisite for DP-600 is not a course or certification. It is having built something — a model, a pipeline, a report — that a production team depends on.”Our expert teamRead the full answer →
What participants say about DP-600: Implementing Analytics Solutions Using Microsoft Fabric
“Had a great experience learning with Abilene Academy, it has been an extremely long time since I have attended an external formal training outside of the business organization I work in. I found this training to be truly beneficial for me to attend. the overall delivery of the course by Henri was superb, he kept us well engage despite having half of the room online and half face to face. The communication from the advisors from the initial enquiry regrading the course up until now has also been great! definitely recommending to my colleagues. Thank you!”
Tracey Gillett
Crisis and Operations Management

“Henri and Alexis conducted a focused, intensive four-day ISO/IEC 27001 Lead Implementer Course of immediate relevance to The Global Fund. Participants representing both IT and Risk are now better prepared to design and operationise a corporate ISMS.”
Andreas Tamberg
Senior advisors enterprise risk management

“Another stellar training course run by Abilene, thank you for the outstanding organization and logistics. The PECB training material is very rich, well presented with clear explanations and notes.”
Simon Baynes
BCMS Manager

Who teaches the DP-600: Implementing Analytics Solutions Using Microsoft Fabric course
Microsoft Trainings
A skilled specialist on Microsoft products. Has more than 15 years of empirical experience in several domains among which are Operations and Business Development, Commercial and Presales Consultancy, System and Security Engineering. Over the last five years, his training schedules extended to top executives and IT Business professionals in the Middle East, Europe, and USA.
Microsoft Trainings
Specialized in Web and Application Development and has done extensive research and implementation in Artificial Intelligence. Holder of a master’s degree in Mathematics, Ramzi is also a Microsoft Certified Trainer with more than 17 years of experience.
Your training pathway
Train your whole team in DP-600: Implementing Analytics Solutions Using Microsoft Fabric
We run private sessions for teams, at your site or online, on dates that suit you.
Prefer to message us?
WhatsAppLast updated:
Train with practitioners. Pass with confidence.
Abilene Academy is the only PECB Titanium Partner in Switzerland — the highest accreditation tier in the industry — delivering certified training in information security, data protection, AI governance, and GRC compliance. 99% exam pass rate. 2,500+ professionals trained across 120+ countries and trusted by 600+ organizations. Multilingual programmes available.
- 99%
- Exam pass rate
- 2,500+
- Professionals trained
- 120+
- Countries reached
- Titanium
- The only PECB Titanium Partner in Switzerland
- ✓
- Certification included
- Multilingual
- EN · FR · ES · DE · IT and more
Organisations that trained with Abilene Academy
Trusted by 600+ organisations in 120 countries
Airbus
Altis
BCEAO
BCV
Cargolux
Cartier
Cofco Intl
Confédération Suisse
Council of Europe
Dell
Deloitte
Devillard
Ebay
Engie
Etat de Fribourg
Etihad Airways
Eumetsat
EY
Framatome
G42
Gavi
Republique et canton de Genève
Groupe Mutuel
HSBC
IAEA
IATA
IBM
ILO
IMD
KPMG
Kudelski Security
Loterie Romande
MSC
Nagra
Nespresso
Nestlé
Novartis
Payot SA
Philips
PSA Panama
PWC
Richemont
Roche
RTS
Santander
SAP
Skyguide
Societe Generale
Swisscom
Syz
The Global fund
UNGSC
UNICC