Your question is Cleaning Data for Dashboard Tables. 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).
Explain your SQL-first process for turning messy source data into a clean dataset that can power a reliable ABC Education dashboard. Focus on how you inspect data quality, define the target grain, standardize categories and dates, join lookup tables safely, and validate the final output before it reaches a visualization layer.