DP-602: Implement a Data Warehouse with Microsoft Fabric provides a practical and structured introduction to designing, building, and managing a data warehouse using Microsoft Fabric. The course focuses on how modern data warehousing supports analytics at scale, and how Microsoft Fabric brings together ingestion, transformation, storage, and security in a unified platform. Participants learn how to load and transform data, work with SQL-based analytics, manage performance and scalability, and apply governance and security controls within a Fabric-based data warehouse. The course combines conceptual understanding with hands-on exercises, enabling participants to translate theory into real-world implementation scenarios.
This course is designed to help professionals understand how a data warehouse is implemented as part of a modern analytics architecture. You will work with common data warehousing patterns, explore how Microsoft Fabric supports enterprise analytics workloads, and learn how to manage and optimize a warehouse for reporting and analytical use cases.
By the end of the course, participants will have a clear understanding of how to build reliable, scalable, and secure data warehouse solutions in Microsoft Fabric, and how these solutions integrate with broader analytics and reporting environments.
|
|
At a glance |
Level: Intermediate
Product: Microsoft Fabric
Audience/Role: Data Engineer
Subject: Data engineering, Data analytics
|
|
Prerequisites |
You should be familiar with basic data concepts and terminology.
Target audienceThis course is intended for:
Get 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.
Load 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.
Query 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.
Monitor 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.
Secure 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.
This one-day, instructor-led training is recommended as preparation for the assessment Implement a data warehouse in Microsoft Fabric
Microsoft Applied Skills is a new scenario-based credential that proves your proficiency in skill sets specific to critical business problems, so you can make a bigger impact on your projects, your organization, and your career.
Pris: 9 500 NOK.
Kurset varer i 1 dag, kl. 09:00–16:00.
Instruktørledet klasserom eller live virtuelt. Fokus på demonstrasjoner og praktiske gjennomganger i Microsoft Fabric.
Engelsk kursmateriell, instruktør norsk eller engelsk.
Kurset passer for Data Engineers (og analytikere med SQL-erfaring) som vil implementere og drifte data warehouse i Microsoft Fabric.
Grunnleggende kjennskap til databegreper og terminologi. Erfaring med SQL er en fordel.
Oppstart i Fabric Warehouse: opprette, integrere og forstå DW-rollen i ende-til-ende-analytikk
Laste data: strategier og T-SQL i et full-transaksjonelt Fabric-miljø
Spørring: SQL Query Editor, visuell editor og SSMS-tilkobling
Overvåkning: kapasitet/aktivitet, query insights og DMVs
Sikkerhet: tilgangsstyring og beste praksis
Kurset er anbefalt forberedelse til Microsoft Applied Skills-vurderingen Implement a data warehouse in Microsoft Fabric. (Selve vurderingen er ikke inkludert.)
Digital kursdokumentasjon. Ved klasseromskurs er lunsj og bevertning inkludert.
Ja – vi skreddersyr agenda, kildedata og øvelser til deres miljø og leverer gjerne bedriftsinternt (norsk/engelsk).
Vil du bygge videre etter DP-602? Her er de mest relevante neste stegene – alle kan skreddersys og leveres bedriftsinternt.
DP-601: Implementing a Lakehouse with Microsoft Fabric (Applied Skills) – lakehouse og medallion i praksis.
DP-700: Microsoft Fabric Data Engineer – ingest/transform, pipelines og sanntid i Fabric.
DP-600: Microsoft Fabric Analytics Engineer – enterprise-analyse, semantiske modeller og styring.
PL-300: Design and Manage Analytics Solutions Using Power BI – datamodellering, DAX og deling av innsikt.
DP-300: Administering Microsoft Azure SQL Solutions – drift, ytelse og HADR for SQL-arbeidslaster.
Merk: Vi tilbyr også flere Fabric-relaterte kurs (f.eks. DP-603/DP-604) og andre DP-løp ved behov – ta kontakt hvis du vil ha en anbefaling tilpasset deres miljø.
