Present end-to-end analytics using Microsoft Fabric

• Identify Microsoft Fabric features.
• Implement Microsoft Fabric to meet your business analytics needs.
• Describe how Fabric supports AI capabilities through Copilot, Data Agents, and Fabric IQ.

Discover and connect to data in OneLake

• Describe the OneLake architecture and features.
• Browse and connect to data using the OneLake catalog.
• Discover streaming data in Real-Time hub.

Get started with lakehouses in Microsoft Fabric

• Describe the basic features and capabilities of lakehouses in Microsoft Fabric.
• Create a home by the lake.
• Ingest and transform data in the lakehouse.
• Query and analyze lakehouse data with SQL and Spark.

Get started with data warehouses in Microsoft Fabric

• Describe data warehouse concepts and the fundamentals of dimensional modeling.
• Create tables, load data, and understand how to ingest a fabric warehouse.
• Query and transform data using T-SQL and the visual query editor.
• Data warehouse data modeled for reporting and downstream consumption.
• Secure and monitor a date warehouse.

Get started with Real-Time Intelligence in Microsoft Fabric

• Describe real-time analytics, streams, and events.
• Understand Real-Time Intelligence components in Fabric.
• Ingest data and turn data into motion.
• Store and query data in KQL databases.
• Visualize streaming data with Real-Time dashboards.
• Automate actions with activator.

Choose data stores in Microsoft

• Describe analytical data store options in Microsoft Fabric.
• Analyze the capabilities of lakehouse, warehouse, and eventhouse solutions.
• Choose the appropriate data store for a business scenario.

Design dimensional models for analytics in Microsoft Fabric

• Describe the types of dimensional schemes for analytics.
• Design fact tables for business processes.
• Design dimension tables for descriptive attributes.
• Implement slowly changing dimension models.

Transform data using Dataflows Gen2 in Microsoft Fabric

• Create and configure Dataflows Gen2 in Microsoft Fabric.
• Apply Power Query transformations to prepare data.
• Optimize data flow performance with query folding.
• Upload transformed data to lakehouse or data warehouse destinations.

Transform data using notebooks in Microsoft Fabric

• Describe notebooks in Microsoft Fabric.
• Train and clean data using Spark SQL and PySpark.
• Combine and aggregate data using Spark, SQL, and PySpark.
• Write and size Delta tables appropriately.

Transform data using T-SQL in Microsoft Fabric

• Transform warehouse data using T-SQL queries
• Create views for reusable transformation logic.
• Generate stored procedures for processing reproducible data.
• Implement dimensional tables in a warehouse.

Create DAX calculations in semantic models

• Create calculated tables.
• Create calculated columns.
• Create measures using DAX.

Design semantic models for scaling in Microsoft Fabric

• Choose a storage mode based on data freshness, performance, and source location.
• Design relationships in a star schema to improve clarity and performance in a semantic model.
• Design calculations that remain performant and manageable as data volumes and team size grow.
• Configure semantic model settings that support large-scale consumption.

Optimize the performance of the semantic model

• Use Performance Monitor to identify performance bottlenecks.
• Optimize DAX calculations to improve query performance.
• Reduce cardinality levels to improve model efficiency.
• Implement aggregations to speed up queries on large datasets.
• Apply a systematic approach to solving common performance issues.

Enforce Semantic Model Security

• Implement row-level security by using DAX filter expressions and dynamic security models.
• Apply object-level security to hide tables and columns.
• Validate security roles and manage role membership.

Manage the semantic model development lifecycle

• Create reusable Power BI resources.
• Manage Power BI content in versioning.
• Manage semantic models with the XMLA endpoint.
• Deploy content in stages.
• Manage and monitor semantic models.

Prepare the semantic layer for AI in Microsoft Fabric

• Describe how AI systems consume data and metadata from semantic models.
• Design gold layers with AI-enabled naming, documentation, and structure.
• Configure the preparation of AI features in a semantic model, including verified responses and AI instructions.
• Explain how semantic models connect to the enterprise ontology in Fabric IQ.
• Validate AI readiness through testing and iteration.

Understand the fundamentals of Microsoft Fabric IQ

• Explain what Fabric IQ is and how ontologies define business vocabulary.
• Describe the role of ontology elements in creating entity types, properties, and relationships.
• Distinguish the roles of each Fabric IQ component: ontology elements, data agents, Graph in Microsoft Fabric, and Power BI semantic models.
• Compare the concept-based approach of ontology modeling with traditional use-case data modeling.

Create an ontology with Fabric IQ

• Evaluate two approaches to creating an ontology in Fabric IQ.
• Create an ontology manually by working with entity types, properties, keys, and relationships.
• Generate an ontology from a Power BI semantic model.
• Connect an ontology to data sources and preview the ontology.

Secure data access in Microsoft Fabric

• Describe the permissions model in Microsoft Fabric.
• Configure workspace and item permissions.
• Apply granular permissions.

Secure a Microsoft Fabric data warehouse

• Learn about the concepts of securing a data warehouse in Microsoft Fabric.
• Learn how to implement dynamic data masking to hide sensitive information.
• Learn how to configure row-level security to provide granular control.
• Learn how to implement column-level security to protect sensitive data.
• Learn how to set up granular permissions using T-SQL.

Govern data in Microsoft Fabric with Purview

• Describe the data governance features built into Microsoft Fabric.
• Make the case for adding Microsoft Purview for robust data governance and protection.
• Connect Microsoft Purview to Microsoft Fabric.
• Analyze Microsoft Fabric data in the Microsoft Purview hub.

Govern analytics data in Microsoft Fabric

• Apply data classification and sensitivity labels to fabric items.
• Use endorsements (promotion, certification and benchmarks) as a governance mechanism.
• Implement documentation practices for data discoverability.
• Describe how governance controls affect AI agent data consumption.
• Use OneLake catalog capabilities for data estate management.

Last updated: 20/08/2026

Participants in this training should have completed the “DP-900 Microsoft Azure Data Fundamentals” course or have an equivalent level of knowledge.

In this training, we mix theory with technical workshops to quickly make you operational. Additionally, each participant receives course materials at the end of the training.

One of our consultant trainers conducts the training. With solid field experience, they make the learning process both interactive and enriching.

For assessment, the trainer regularly asks questions and uses various methods to continuously measure your progress. This approach promotes a dynamic and engaging learning experience.

After the training, we ask you to complete a satisfaction questionnaire. Your feedback helps us to maintain and constantly improve the quality of our training.

Finally, we offer the flexibility to deliver this training both in-person and remotely, and it can be customized to meet your company’s specific needs upon request.

This training, which is part of a professional career path, prepares you for the “DP-600: Implementing Analytical Solutions with Microsoft Fabric” certification exam to obtain the title of Fabric Analytics Engineer Associate.

We recommend registering for the exam approximately one month after completing the training. The course materials provided during the training will help you properly review for your certification.

You can register for certification on the Microsoft site. If you would like to buy a certification voucher from us, or if you would like us to support you in this process, please contact us.

You can register for one of our training courses up to two business days before it starts, if there are still available places and you signed quote.

If you have specific needs related to a disability, please do not hesitate to make a request; we are happy to adjust our services according to the type of disability.