Explain a complex dataset you have worked with, ideally similar to LG Smart TV usage or LG.com customer interaction data. Describe the dataset structure, the SQL data manipulation techniques you used to clean and summarize it, and the insight you derived. Your answer should make clear how you handled grouped metrics, time-based trends, and messy values such as NULLs or inconsistent labels.
Using aggregations to summarize large event-level datasetsApplying GROUP BY to compare customer or product segmentsUsing date functions for trend analysisHandling data quality issues with basic wrangling