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 SBL-Khas Claimable
Programme Agenda
Day 1, 9:00 AM - 9:15 AM
Welcome and Programme Overview
Introduction to the session, objectives, and housekeeping.
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.
Day 1, 10:15 AM - 10:30 AM
Break
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.
Day 1, 12:30 PM - 1:30 PM
Lunch
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.
Day 1, 3:15 PM - 3:30 PM
Break
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.
Day 1, 4:45 PM - 5:00 PM
Day 1 Close
Recap and what to review before day two.
Day 2, 9:00 AM - 9:15 AM
Day 1 Review
Recap of day one and the questions it left open.
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.
Day 2, 10:15 AM - 10:30 AM
Break
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.
Day 2, 12:30 PM - 1:30 PM
Lunch
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.
Day 2, 3:15 PM - 3:30 PM
Break
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.
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