DP-602: Implement a Data Warehouse with Microsoft Fabric
Upcoming dates
Click a date to book online.
| Location | Sept 26 | Oct 26 | Nov 26 | Dec 26 |
|---|---|---|---|---|
| Auckland | ||||
| Wellington | ||||
| Virtual |
Overview
In this one-day course students explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.
This one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.
Who should attend
- Data Analysts
- Data Engineers
Prerequisites
- You should be familiar with basic data concepts and terminology.
What you'll learn
After completing this course, students will be able to:
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage fact tables and dimensions within a data warehouse
- Learn different strategies to load data into a data warehouse in Microsoft Fabric
- Learn how to build a data pipeline to load a warehouse in Microsoft Fabric
- Learn how to load data in a warehouse using T-SQL
- Learn how to load and transform data with dataflow (Gen 2)
- Use SQL query editor to query a data warehouse
- Explore how visual query editor works
- Learn how to connect and query a data warehouse using SQL Server Management Studio
- Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app
- Monitor current activity in the data warehouse with dynamic management views
- Monitor querying trends with query insights views
Course content
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
Common questions
When does DP-602: Implement a Data Warehouse with Microsoft Fabric next run?
The next date is Mon, 7 Sept 2026, and there are 4 further dates scheduled. Delivered ACE Training Wellington, live online, ACE Training Auckland. Every date and its format is listed on this page.
How much does DP-602: Implement a Data Warehouse with Microsoft Fabric cost?
From $950 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Can we pay by invoice instead of by card?
Yes. Choose 'Pay by invoice' when you book and we'll hold your place and send the invoice to your accounts address, with a purchase order number on it if you need one. You can also pay by card at the time of booking if that's easier.
Do I need any prior experience?
You should be familiar with basic data concepts and terminology.
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code DP602 when you enquire.