Domain 1: Maintain a data analytics solution
25–30%
- Implement security and governance (workspace roles, RLS, CLS, OLS, sensitivity labels, endorsement)
- Maintain the analytics development lifecycle (Git, .pbip, deployment pipelines, XMLA endpoint, reusable assets)
Domain 2: Prepare data
45–50%
- Get data (connections, OneLake catalog, shortcuts, data stores: Lakehouse/Warehouse/Eventhouse, OneLake integration)
- Transform data (views, stored procedures, star schema, denormalization, aggregation, joins, data quality, type conversion)
- Query and analyze (Visual Query Editor, T-SQL, KQL, DAX)
Domain 3: Implement and manage semantic models
25–30%
- Design and build (storage modes, star schema, relationships, DAX variables, calculation groups, field parameters, composite models)
- Optimize (Performance Analyzer, DAX performance, Direct Lake configuration, incremental refresh)