This is a dedicated watch page for a single video.
A data analyst needs to transform and clean a dataset before analysis in BigQuery. The dataset has inconsistent date formats, missing values, and outliers. Which tool would be most appropriate for this task?