Microsoft Trainings

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.

4 days + exam2,500+ professionals trained120+ countries

Trusted by 600+ organisations

  • Airbus
  • IBM
  • EY
  • HSBC
  • Deloitte
  • KPMG
  • Nestlé
  • Novartis
  • Roche
  • PWC
  • Swisscom
  • SAP
  • Dell
  • Santander
  • Etihad Airways
  • Cartier

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.

The two formats compared
Physical classroomOnline classroom
How you learnIn class, with the trainerLive online, with the trainer
WhereLausanne / MorgesFrom anywhere
StartNext: 14 Dec 20264 dates availableNext: 14 Dec 20264 dates available
Duration4 days of training + exam4 days of training + exam
LanguagesENFRENFR
Certificate of attendanceIncludedIncluded
Exam and certificationNot includedNot included
PricePersonalised offerPersonalised offer
Best forLearning in a group, away from the officeA live trainer without travelling
Next stepSee datesSee 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.

  1. Lausanne / MorgesLive onlineEN · FRBook
  2. Lausanne / MorgesLive onlineEN · FRBook
  3. Lausanne / MorgesLive onlineEN · FRBook
  4. Lausanne / MorgesLive onlineEN · FRBook
Show all 4 dates

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 team
DP-600Microsoft FabricFabric Analytics EngineerPower BI
Read 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 team
DP-600Microsoft FabricFabric Analytics EngineerPower BI
Read 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 team
DP-600Microsoft FabricFabric Analytics EngineerPower BI
Read 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 team
DP-600Microsoft FabricFabric Analytics EngineerPower BI
Read 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

    TUI
  • “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

    The Global Fund
  • “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

    MSC MEDITERRANEAN SHIPPING COMPANY SA

Who teaches the DP-600: Implementing Analytics Solutions Using Microsoft Fabric course

Manuel VARTANIAN
Manuel VARTANIAN

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.

15+ years across IT operations, business development, presales consultancy, and systems and security engineering. Microsoft Certified Trainer. Delivers Microsoft technology programmes to senior executives and IT professionals across the Middle East, Europe, and the USA.
15+Years of experience
MicrosoftCertified expert
Ops& Business development
EngineeringSystems & security
ramzi-aynati
Ramzi AYNATI

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.

17+ years specialising in web and application development, with deep research and implementation experience in artificial intelligence. Holds a master's degree in Mathematics. Microsoft Certified Trainer delivering Microsoft technology programmes for development teams.
17+Years of experience
MicrosoftCertified trainer
AIResearch & implementation
Web & App devSpecialized expertise
Meet all our trainers →

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?

WhatsApp

Last 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 logoAirbus
  • Altis logoAltis
  • BCEAO logoBCEAO
  • BCV logoBCV
  • Cargolux logoCargolux
  • Cartier logoCartier
  • Cofco Intl logoCofco Intl
  • Confédération SuisseConfédération Suisse
  • Council of Europe logoCouncil of Europe
  • Dell logoDell
  • Deloitte logoDeloitte
  • Devillard logoDevillard
  • Ebay logoEbay
  • Engie logoEngie
  • Etat de Fribourg logoEtat de Fribourg
  • Etihad Airways logoEtihad Airways
  • Eumetsat logoEumetsat
  • EY logoEY
  • Framatome logoFramatome
  • G42 logoG42
  • Gavi logoGavi
  • Republique et canton de Genève logoRepublique et canton de Genève
  • Groupe Mutuel logoGroupe Mutuel
  • HSBC logoHSBC
  • International atomic energy agency logoIAEA
  • IATA logoIATA
  • IBM logoIBM
  • international Labour organization logoILO
  • IMD logoIMD
  • KPMG logoKPMG
  • Kudelski Security logoKudelski Security
  • Loterie Romande logoLoterie Romande
  • MSC logoMSC
  • Nagra logoNagra
  • nespresso logoNespresso
  • Nestlé logoNestlé
  • Novartis logoNovartis
  • Payot SA logoPayot SA
  • Philips logoPhilips
  • PSA PanamaPSA Panama
  • PWC logoPWC
  • Richemont logoRichemont
  • Roche logoRoche
  • RTS Radio Télévision SuisseRTS
  • Santander logoSantander
  • SAP logoSAP
  • https://www.skyguide.ch/Skyguide
  • Société Générale logoSociete Generale
  • Swisscom logoSwisscom
  • SyzSyz
  • The Global fund logoThe Global fund
  • UNGSC logoUNGSC
  • International computing center logoUNICC