
You are given NIKE retail reporting tables with missing values in product, order, and inventory fields. Explain how you would investigate the missingness in SQL, decide whether to preserve, filter, default, or impute values, and ensure the logic is reliable for dashboard consumers.
Profiling missing values with SQLClassifying nulls with business logicDetecting join-driven missingnessChoosing safe reporting defaultsThe interviewer is looking for a SQL-first data wrangling answer, not a generic machine learning discussion about imputation. Focus on how you would inspect the data, encode rules in SQL, and communicate trade-offs to dashboard users.