Preparing for Data Analysis Spreadsheet

Preparing for Data Analysis Instructions

M&E | Track Resource Download



Preparing for Data Analysis

Are you a refugee service provider looking to conduct data analysis to gain better insights into your program(s)? Whether you are exporting data from a centralized database, working from a spreadsheet or data tracker, or analyzing survey results, you will first need to carefully prepare your data before proceeding. Good data preparation limits data errors and inaccuracies, makes sure data is consistent, and allows for better analysis. Although it can be time consuming, preparation is critical to improving your data quality.

These instructions provide guidance for preparing your data for analysis, including processes known as data “cleaning,” data transformation, and de-identification.  The tool contains a spreadsheet and accompanying instructional document that walk through the process of preparing data for analysis step by step using a sample data set.