Training Microsoft

Training goals

code: DP-600T00 | version: A

This course covers how to prepare, enrich, and serve data for analysis by consumers such as data analysts, report developers, and AI agents. The course focuses on designing dimensional models and transforming data by using dataflows, notebooks, and T-SQL across lakehouses, warehouses, and eventhouses in Microsoft Fabric. The course also covers building and optimizing semantic models, managing the analytics development lifecycle, and enforcing security and governance across data assets.

 

Audience Profile:
This course is intended for data professionals with experience in data modeling, transformation, and analytics. Learners should have prior experience translating business requirements into analytical measures by using SQL or DAX. Experience building semantic models and reports in Power BI is recommended.

 

Conspect Show list

  • Explore analytics data stores in Microsoft Fabric
    • Module 1: Introduction to end-to-end analytics using Microsoft Fabric
    • Module 2: Discover and connect to data in OneLake
    • Module 3: Get started with lakehouses in Microsoft Fabric
    • Module 4: Get started with data warehouses in Microsoft Fabric
    • Module 5: Get started with Real-Time Intelligence in Microsoft Fabric
  • Design and transform analytics data in Microsoft Fabric
    • Module 1: Choose data stores in Microsoft Fabric
    • Module 2: Design dimensional models for analytics in Microsoft Fabric
    • Module 3: Transform data using Dataflows Gen2 in Microsoft Fabric
    • Module 4: Transform data using notebooks in Microsoft Fabric
    • Module 5: Transform data using T-SQL in Microsoft Fabric
  • Design and manage semantic models in Microsoft Fabric
    • Module 1: Create DAX calculations in semantic models
    • Module 2: Design semantic models for scale in Microsoft Fabric
    • Module 3: Optimize semantic model performance
    • Module 4: Enforce semantic model security
    • Module 5: Manage the semantic model development lifecycle
  • Prepare AI-ready analytics data in Microsoft Fabric
    • Module 1: Prepare the semantic layer for AI in Microsoft Fabric
    • Module 2: Understand Microsoft Fabric IQ fundamentals
    • Module 3: Create an ontology with Fabric IQ
  • Secure and govern analytics data in Microsoft Fabric
    • Module 1: Secure data access in Microsoft Fabric
    • Module 2: Secure a Microsoft Fabric data warehouse
    • Module 3: Govern analytics data in Microsoft Fabric
Download conspect training as PDF

Additional information

Prerequisites

Experience with data modeling, transformation, and analytics. Prior experience translating business requirements into analytical measures using SQL or DAX. Experience building semantic models and reports in Power BI. Familiarity with KQL and Python is helpful but not required.
Difficulty level
Duration 4 days
Certificate

The participants will obtain certificates signed by Microsoft (course completion). This course will help prepare you for the Microsoft Certified: Fabric Analytics Engineer Associate certification exam (Exam DP-600), which is available through the Pearson VUE test centers.
Trainer

Microsoft Certified Trainer (MCT)

Other training Microsoft | Data & AI

Microsoft show more courses
Contact form

Please fill form below to obtain more info about this training.






* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

TRAINING PRICE FROM 1900 EUR

  • In order to propose a date for this training, please contact the Sales Department