How would you deal with a messy data set?
Anonymous
One of the first things I would do is run some quick summary reports/statistics to check data types. Next, I would check for duplicate data and typos. In some cases, it might be more efficient to create an additional table (i.e., normalize a data set) for analysis.
Check out your Company Bowl for anonymous work chats.