Work with Data Warehouses Using Microsoft Fabric: Enhance Data Efficiency and Performance.

Master the fundamentals of data warehousing with Microsoft Fabric. This Microsoft Applied Skills credential is designed for data engineers and IT professionals who want to efficiently manage, process, and analyze large datasets. Learn how to build and operate data warehouses that integrate seamlessly with other tools and services, ensuring optimal performance and scalability.

Whether you’re handling structured or unstructured data, this course will provide the skills to create a robust data warehouse solution tailored to your organization’s needs.

Microsoft Applied Skills – the new credentials to verify in-demand technical skills. Get trained and certified in 2024 with Microsoft Malaysia’s Learning Partner of the Year 2024 today.

Overview

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

Skills Covered

  • 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
  • Secure a Microsoft Fabric data warehouse

Prerequisites

  • You should be familiar with basic data concepts and terminology.

Target Audience

  • Data Analyst
  • Data Engineer

Course Curriculum

Module 1: 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.

Learning objectives

In this module, you learn how to:

  • Describe data warehouses in Fabric.
  • 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.

Prerequisites

Before starting this module, you should be familiar with the Microsoft Fabric interface and core concepts.

Module 2: 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.

Learning objectives

In this module, you’ll:

  • 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).

Prerequisites

Before starting this module, you should be familiar with the basic principles of a data warehouse.

Module 3: 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.

Learning objectives

In this module, you’ll:

  • 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.

Prerequisites

Before starting this module, you should be familiar with the basic principles of data warehousing.

Module 4: 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.

Learning objectives

After completing this module, you’ll be able to:

  • 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.

Prerequisites

Before starting this module, you should be familiar with Microsoft Fabric and Transact-SQL.

Module 5: 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.

Learning objectives

In this module, you’ll:

  • Learn the concepts of securing a data warehouse in Microsoft Fabric.
  • Learn how to implement dynamic data masking to obscure sensitive information.
  • Learn how to configure row-level security to provide granular control.
  • Learn how to implement column-level security to protect sensitive data.
  • Learn how to configure granular permissions using T-SQL.

Prerequisites

Before starting this module, you should be familiar with the Microsoft Fabric interface and core concepts.

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections

July 20, 2026 - July 20, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

July 20, 2026 - July 20, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200

October 19, 2026 - October 19, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

October 19, 2026 - October 19, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200
Trainocate exam and cert

Exam & Certification

To earn this Microsoft Applied Skills credential, learners demonstrate the ability to implement a data warehouse in Microsoft Fabric, including:

  • Creating a data warehouse
  • Loading, transforming, and querying data
  • Modeling a star schema
  • Managing security

Candidates for this credential should be familiar with data modeling, data transformation, and exploratory data analytics. They should also be able to query and change data by using T-SQL.

Training & Certification Guide

Mastery Program: Learn AI with Microsoft in 2025

Artificial Intelligence (AI) has been one of the hottest topics in the tech industry for the past decade. With its rapid advancements and potential to impact our daily lives, learning AI has become a highly sought-after skill.

We are thrilled to announce the launch of our Microsoft AI Mastery Program in 2024, made possible through our partnership with Microsoft, a renowned leader in AI technology. This program is tailored for individuals and tech professionals passionate about acquiring and mastering the fundamental and advanced principles of AI.

Top AI Skills Malaysia Needs Today: Advance Your IT Career in 2025

In the quest for AI-driven innovation, Malaysia seeks sharp minds with the right IT skills. Data science, machine learning—these are the tools in high demand. This article examines the AI skills Malaysia needs, the industries driving this change, and how to develop these skills to enhance your career trajectory.

Which AI Certification Is Right for You? A Role-by-Role Guide to Upskilling in 2025

Certifications are more than just a résumé boost—they’re often a key deciding factor. Employers are prioritizing candidates with industry-recognized credentials, not only for technical roles but also for positions in operations, strategy, and product development that now rely on data fluency and AI awareness.

Top 5 High-Paying Cloud Jobs in Malaysia & How to Get Them

In this blog, we break down the top five highest-paying cloud roles in Malaysia, what they entail, and how you can start building a career in this space.

Addressing the AI Skills Gap in Malaysia

The Artificial Intelligence (AI) surge across global industries has created immense potential for innovation and economic growth. For Malaysia, AI is pivotal in its ambition to become a digital-first economy. However, despite this goal, the country faces a significant AI skills gap—a shortfall in the number of skilled professionals equipped to meet the rising demands for AI expertise across various industries.

This blog examines the causes, impact, and initiatives underway to bridge this gap, ensuring Malaysia remains competitive in the digital age.

Top Microsoft Applied Skills Courses to Boost Your Career

Microsoft Applied Skills are scenario-based practical credentials that confirm your ability to tackle real-world challenges using Microsoft technologies.

In this article, we will dive into what these skills are, how they differ from traditional certifications, and the benefits they bring to your career. Expect insights on top courses, the assessment process, and tips for success.

Top AI Machine Learning Certifications to Boost Your Career in 2025

Looking to excel in AI and machine learning? The right certification can make all the difference. This article covers the top AI machine learning certifications for 2025 that can boost your career and validate your expertise in this ever-evolving field.

The Ultimate Guide to the Top Data and AI Skills for 2026

This guide serves as your comprehensive roadmap to navigating this new landscape. We will deconstruct the four essential pillars of Data and AI mastery for 2026, providing a clear blueprint for a future-proof career.

This cornerstone article will provide a high-level strategic overview, setting the stage for our deep-dive blog series that will explore each pillar in granular detail.

Mastering the Foundational Data Analytics Skills That Get You Hired in 2026

This article is your deep dive into the three non-negotiable, must-have data analytics skills that will get you hired in 2026.

Which AI and Machine Learning Skills Will Define 2026?

This article will guide you through the specific, advanced skills that separate a data professional from a true AI specialist in 2026.

Why Data Engineering is the Hottest Tech Career of 2026

In the race to dominate the AI-powered future, companies are investing billions in advanced algorithms and brilliant data scientists. This article explores the essential skills you need to become a data engineer and build the very backbone of AI.

4 Strategic AI Skills Every Manager Needs in 2026

This article breaks down the four essential strategic AI skills every leader needs to master to navigate this new frontier

DP-600T00: Microsoft Fabric Analytics Engineer

This Microsoft course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric.

DP-601T00: Implementing a Lakehouse with Microsoft Fabric

This DP-601T00: Implementing a Lakehouse with Microsoft Fabric course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept.

DP-602T00: Implement a data warehouse with Microsoft Fabric

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

DP-603T00: Implement Real-Time Intelligence Solution with Microsoft Fabric

Gain the skills to implement real-time analytics using Microsoft Fabric.

DP-604T00: Implement a data science and machine learning solution for AI in Microsoft Fabric

Explore the data science process and learn how to train machine learning models to accomplish artificial intelligence in Microsoft Fabric.

DP-605T00: Prepare and visualize data with Microsoft Power BI

The DP-605T00: Develop dynamic reports with Microsoft Power BI course is tailor-made for data analysts aiming to deepen their expertise.

Microsoft Certified: Power BI Data Analyst Associate

The Microsoft Certified: Power BI Data Analyst Associate certification equips professionals with advanced skills to prepare, model, visualize, and analyze data using Power BI.

Microsoft Certified: Azure AI Engineer Associate

This certification validates the skills of Azure AI Engineers in building, managing, and deploying AI solutions using Azure AI. Candidates participate in all phases of AI solution development, from design and development to deployment, integration, and monitoring.

Microsoft Certified: Azure Data Scientist Associate

The Microsoft Certified: Azure Data Scientist Associate certification is designed for professionals who specialize in data science and machine learning on the Azure platform.

Microsoft Certified: Fabric Analytics Engineer Associate

The Microsoft Fabric Analytics Engineer Associate certification (exam DP‑600) is an intermediate-level credential for data engineers and analysts.

Microsoft Certified: Fabric Data Engineer Associate

The Microsoft Certified: Fabric Data Engineer Associate certification is a role-based credential designed for professionals who specialize in data engineering on the Microsoft Fabric platform.

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes