Topic 04 · DP-700 · DP-600

Warehouse and Dimensional Modeling

Learn how relational warehouse design supports reliable analytical reporting in Microsoft Fabric.

01 · Warehouse

A Fabric Warehouse provides a relational T-SQL surface for dimensional modeling and analytical workloads.

Separate measurable facts from descriptive dimensions so filters and aggregations behave predictably.

Choose full or incremental loading based on volume, change detection, and the required refresh window.

Preserve or overwrite dimension history according to the reporting requirement.

Know when to use a warehouse, how facts and dimensions relate, and how loading and historical-change decisions affect analytics.