Data Handling

Databases and ASCII files are the survey equivalent of housework—unglamorous and only noticed when they're not taken care of.

Planning and Restructuring

Whether at the survey draft stage or when you're trying to crunch the results, sometimes the database needs a bit of rearranging:

• Integrating several survey versions into one system
• Changing the values used in fields
• Preparing files for transfer to another system
• Incorporating external data into a questionnaire, such as purchase history

Data Cleaning

Even with Web surveys or kiosks where there's no data entry, you'll still need a touch of data cleaning to get the highest quality information:

• Clearing empty or invalid submissions from the file
• Consolidating Other responses and short text values such as cities or products so they can be counted
• Coding comments and other verbatims into categories such as "Front desk" or "Room service."