Your question is SQL and Power BI Data Prep. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Tell me about how you use SQL and Power BI to clean and shape data, including joins, datetime functions, subqueries, CTEs, views, indexing, and performance optimization.