As a participant in the Candidate Preparation Program, you should have specific skills in designing, creating, and managing analytical resources, such as semantic models, data warehouses, or lakehouses. Your responsibilities in this role include: Prepare and enrich data for analysis Ensure the safety and maintenance of analytical assets Implement and manage semantic models You'll work closely with stakeholders to define business requirements and collaborate with architects, analysts, engineers, and administrators.
Duration - 10 Hours
Level - Intermediate
Style - Self paced
Course Type - Credential Ready
Certification - Yes
Hands on Labs - No
Solution Areas - Cloud and AI Platforms, Build a unified, governed data and AI estate (Core), Modernize your data to drive results and leverage AI (Core)
Featured Product - Microsoft Fabric
In this introductory module, we will walk you through the key information you need to know before starting your certification prep course. You'll gain a clear understanding of the steps, expectations, and benefits
In this Module you will learn about the following topics : Understanding Fabric, Understand Data Teams and Roles, Fabric admin center and admin tasks, manage user access, Dataflow (Gen2) capabilities in Microsoft Fabric, Dataflow (Gen2) solutions to ingest and transform data, Using a Dataflow (Gen2) in a pipeline, Ingesting external data to Fabric lakehouses using Spark, Configuring external source authentication and optimization, Loading data into lakehouse as files or as Delta tables, Read and write optimizations, Pipeline capabilities in Microsoft Fabric, Add Copy Data activity in a pipeline, How to create pipelines based on predefined templates, How to Run and monitor pipelines
In this module learn about choosing the right data stores in Fabric, Designing the dimensional models for analytics, Fact table & its types, SCD's, Transforming data using Dataflow Gen2, Query Folding, Transforming data using notebooks, Optimizing Delta tables, Transforming data using T-SQL, Loading patterns
In this module learn about Calculated Tables, Columns and Measure, Iterator functions, Designing the semantic model for scalability, Direct lake architecture, Optimizing semantic model for performance, Enforcing Semantic model security, RLS & OLS, Managing the semantic model development lifecycle, Reusable assets, Deployment Pipelines
In this module learn about preparing the semantic layer for AI, Creating an ontology with Fabric IQ, Generating ontology, validating, Securing data access in MS Fabric, Governance in MS Fabric, Endorsement
In this exam preparation module, learn effective preparation strategies for the certification exam, including sample questions and study tips.
This Practice Lab module gives you hands-on lab exercises to reinforce your learning. Please note that lab seats are limited and assigned on a first-come, first-served basis, so access may not be available to all learners enrolled in this course.
Take this assessment to validate your skills gathered from the self-paced online learning course completed in this course to mark your completion.
If you have further questions or need support, don’t forget to join our scheduled Office Hours for expert guidance.
(2).PNG?lmsauth=5e795da5d686ce9f06e769cf64ac963c5b80b9f4)
Intermediate
(2).PNG?lmsauth=7daa9154fae4cbdb0112e15b5df9efcc4848f708)
Intermediate
(2).PNG?lmsauth=f47212df1971764e27fd26ba1a72f5814704f860)
Advanced
(2).PNG?lmsauth=56b05a0d3a8439f238809f5c7521c6da5e25bd6e)
Intermediate
Last Updated 28 Sep 2026