What you'll bring
- DAX: time intelligence, context transition, iterators; able to debug filter context
- Data modelling: star schema, cardinality and filter direction, many-to-many and role-playing dimensions
- Power Query/M: query folding, parameters, incremental refresh
- SQL: strong T-SQL, performant views, facts/dimensions/SCDs
- Performance tuning: Performance Analyzer, DAX Studio
- Power BI Service: workspaces, apps, gateways, refresh, deployment pipelines, capacity/Fabric
- Security: RLS/OLS, sensitivity labels, sharing governance
- Release practice: Git with PBIP/TMDL, Tabular Editor, CI/CD
- Report design: drill-through, bookmarks, tooltips, clear UX for business users
