Deloitte Interview Question

sql basic, window functions, duplicate find and removing query to write, optimizing the query. in pbi rls, optimization, sum & sumx difference, transformations applied. in 2nd round intro, rls, optimization, project work flow.