Microsoft - Fabric Analytics Engineer Associate Study Guide

3: Implement and manage semantic models

This chapter builds the tabular model that turns a shaped Lakehouse or Warehouse into a report-ready analytics surface. It walks through storage-mode selection, star-schema and many-to-many patterns, DAX authoring, calculation groups and field parameters, large semantic model storage format, and composite models, and pairs each pattern with the Direct Lake, incremental-refresh, and VertiPaq tuning knobs that keep the model performant at enterprise scale.