Microsoft Fabric and the Modern Data Platform: Lakehouse Fundamentals

Microsoft Fabric brings data storage, pipelines, notebooks, warehousing and reporting into one platform. For teams already using Power BI, SQL or pipelines it is a natural next step, but it introduces new ideas such as lakehouses, OneLake and Spark.

This two-day course walks through the platform in the order data actually flows: ingest, store, transform, model and report. It is hands-on and assumes basic SQL. Product names, capacities and licensing change often, so check your tenant and current licensing before the course.

HRD Corp Training Provider Malaysia HRD Corp SBL-Khas Claimable

Programme Agenda

01

Day 1, 9:00 AM - 9:15 AM

Welcome and Programme Overview

Introduction to the session, objectives, and housekeeping.

02

Day 1, 9:15 AM - 10:15 AM

The Modern Data Platform and Where Fabric Fits

Data warehouse, data lake and lakehouse compared, what Fabric combines in one product, its main workloads and how it relates to Power BI and Azure data services.

03

Day 1, 10:15 AM - 10:30 AM

Break

04

Day 1, 10:30 AM - 12:30 PM

OneLake, Workspaces and Capacity

How data is stored and shared, workspaces and items, capacity and cost basics, shortcuts to existing data and organising a platform for several teams.

05

Day 1, 12:30 PM - 1:30 PM

Lunch

06

Day 1, 1:30 PM - 3:15 PM

Ingesting Data With Pipelines and Dataflows

Copying data from files, databases and applications, scheduling, handling failures and choosing between pipelines and dataflows.

07

Day 1, 3:15 PM - 3:30 PM

Break

08

Day 1, 3:30 PM - 4:45 PM

Lakehouse and Spark Notebooks

Tables and files in a lakehouse, the medallion pattern of raw, cleaned and curated layers, transforming data in notebooks and reading results with SQL.

09

Day 1, 4:45 PM - 5:00 PM

Day 1 Close

Recap and what to review before day two.

10

Day 2, 9:00 AM - 9:15 AM

Day 1 Review

Recap of day one and the questions it left open.

11

Day 2, 9:15 AM - 10:15 AM

Warehouse and Semantic Models

Building a warehouse for analysis, modelling facts and dimensions, creating a semantic model and keeping measures consistent for report builders.

12

Day 2, 10:15 AM - 10:30 AM

Break

13

Day 2, 10:30 AM - 12:30 PM

Reporting With Power BI

Building reports from the semantic model, refresh and direct access options, performance basics and sharing safely.

14

Day 2, 12:30 PM - 1:30 PM

Lunch

15

Day 2, 1:30 PM - 3:15 PM

Security, Governance and Data Quality

Workspace and item permissions, sensitivity labels, lineage, data quality checks, personal data under the PDPA and keeping costs predictable.

16

Day 2, 3:15 PM - 3:30 PM

Break

17

Day 2, 3:30 PM - 4:45 PM

Capstone: An End-to-End Pipeline

Participants ingest sample data, transform it through layers, model it and publish a report, then review design choices and next steps for their own organisation.

18

Day 2, 4:45 PM - 5:00 PM

Wrap-Up and Q&A

Key takeaways, next steps, and close.

Key Outcomes

  • Explain how Fabric combines storage, pipelines, notebooks, warehouse and reporting
  • Organise workspaces and understand capacity and cost basics
  • Ingest and schedule data with pipelines
  • Transform data through raw, cleaned and curated layers
  • Build a semantic model and report on it
  • Apply basic security, governance and quality checks

Training Mode   Physical / Online / Hybrid / e-learning

HRD Corp   SBL-Khas Claimable

Level   Intermediate, for data analysts, BI developers and data engineers with basic SQL and some Power BI experience.

Duration   2 Days (16 Hours)  |  9:00 AM to 5:00 PM daily

Venue   In-house at the client's premises, or delivered via the client's preferred platform (Microsoft Teams, Zoom, or equivalent)

Assessment   An end-to-end pipeline built in the capstone, plus a short knowledge check

Certificate   Certificate of Completion issued to all participants upon full attendance

Enquiries   Contact us to register or discuss scheduling

Frequently Asked Questions

Microsoft Fabric and the Modern Data Platform: Lakehouse Fundamentals runs for 2 days (16 hours) | 9:00 AM to 5:00 PM daily. It is delivered as an in-house closed group session, so the schedule can be adjusted to fit your team's working hours.

Yes. Delivery options are physical, online, hybrid, e-learning. In-house sessions run at your premises anywhere in Malaysia, online sessions run live over video conference, and hybrid combines both for teams split across sites.

Certificate of Completion issued to all participants upon full attendance. Each certificate carries a certificate number that can be checked at orbixtech.my/certificate-verify.

Level: Intermediate, for data analysts, BI developers and data engineers with basic SQL and some Power BI experience. The session is built around worked examples and group exercises rather than theory, so participants apply the material to their own organisation during the session.

Yes. Microsoft Fabric and the Modern Data Platform: Lakehouse Fundamentals is also available through the Orbix <a href="lms-malaysia">LMS and e-learning platform</a>, where participants work through the material on their own schedule and device rather than attending one fixed session. A knowledge assessment and certificate on completion work the same way as the instructor-led session.

Minimum 2 participants for an in-house or live online session. With only 1 participant, we deliver it as a one-to-one online session instead.

Yes. Many clients pair Microsoft Fabric and the Modern Data Platform: Lakehouse Fundamentals with our one-day <a href="training-team-building-malaysia">team building and high-performing teams programme</a> on the same engagement, so the budget and the day cover both.

Yes. Participants can follow up by email with questions that come up while applying what they learned, and we will point you to the right template, checklist or framework reference even after the session is over.