Question

A data analyst imports a customer file where a single column named 'Location' contains values like 'Austin, TX, 78701'. The reporting requirements specify that city, state, and ZIP code must each be filterable independently in the dashboard. Which data preparation technique should the analyst apply to meet this requirement?

Accepted Answer

Parse the 'Location' field by splitting it on the comma delimiter into separate City, State, and ZIP columns

Answer

Normalize the 'Location' values to a 0-to-1 scale so they can be filtered

Answer

Aggregate the 'Location' field to count distinct values per region

Answer

Pivot the table so each unique 'Location' value becomes its own column