data-practitioner video for a retail company has daily sales data coming from multiple stores, but some records have missing or corrupted values in the “Sales
A retail company has daily sales data coming from multiple stores, but some records have missing or corrupted values in the “Sales Amount” field. You need to clean and prepare this data to ensure it’s suitable for further analysis in BigQuery. Which of the following approaches would best help you handle these issues?