Microsoft - Fabric Analytics Engineer Associate Study Guide

2: Prepare data

This chapter walks through the data-plane work an analytics engineer performs on Microsoft Fabric before a semantic model ships. It covers connecting to sources, discovering assets through the OneLake catalog and the Real-Time hub, ingesting with the right item type, choosing between a Lakehouse, a Warehouse, and an Eventhouse, and shaping the results with SQL, KQL, DAX, the Visual Query Editor, views, functions, and stored procedures.