Strong knowledge of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and visualization best practices. Strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations.