Course Overview
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.
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
Who should attend
This course is intended for data professionals with experience in data modeling, transformation, and analytics.
Certifications
This course is part of the following Certifications:
Prerequisites
Learners should have prior experience translating business requirements into analytical measures by using Structured Query Language (SQL) or Data Analysis Expressions (DAX). Experience building semantic models and reports in Power BI is recommended. Familiarity with Kusto Query Language (KQL) and Python is also helpful but not required.
Follow On Courses
- Design and implement cloud-native applications with Microsoft Azure Cosmos DB (DP-420T00)
- Implement data engineering solutions using Microsoft Fabric (DP-700T00)
- Power BI - Data Analyst (PL-300T00)
- Conception et mise en œuvre d'une solution de Data Science sur Azure (DP-100T01)
- Implement scalable database solutions using Azure SQL (DP-300T00)
Course Content
Explore analytics data stores in Microsoft Fabric
- Introduction to end-to-end analytics using Microsoft Fabric
- Discover and connect to data in OneLake
- Get started with lakehouses in Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Get started with Real-Time Intelligence in Microsoft Fabric
Design and transform analytics data in Microsoft Fabric
- Choose data stores in Microsoft Fabric
- Design dimensional models for analytics in Microsoft Fabric
- Transform data using Dataflows Gen2 in Microsoft Fabric
- Transform data using notebooks in Microsoft Fabric
- Transform data using T-SQL in Microsoft Fabric
Design and manage semantic models in Microsoft Fabric
- Create DAX calculations in semantic models
- Design semantic models for scale in Microsoft Fabric
- Optimize semantic model performance
- Enforce semantic model security
- Manage the semantic model development lifecycle
Prepare AI-ready analytics data in Microsoft Fabric
- Prepare the semantic layer for AI in Microsoft Fabric
- Understand Microsoft Fabric IQ fundamentals
- Create an ontology with Fabric IQ
Secure and govern analytics data in Microsoft Fabric
- Secure data access in Microsoft Fabric
- Secure a Microsoft Fabric data warehouse
- Govern data in Microsoft Fabric with Purview
- Govern analytics data in Microsoft Fabric
Français
Anglais
Italien
Espagnol
Portuguais
Allemand
Polonais
ukrainien
Allemagne
Pays-Bas
Pologne
Ukraine
Arabie Saoudite
Emirats-Arabes-Unis
Moyens Pédagogiques :