Evaluation Data Analysis

Data analysis for evaluation is about looking for and investigating patterns through either quantitative (numerical) or qualitative (textual and/or visual) data. If using both kinds of data, consideration must be given to how these methods will be combined to enrich, examine, explain, and triangulate findings.

Evaluation data analysis requires proactive thinking and planning. For quantitative data, the type of statistical software best suited for the types of analyses desired must be considered. For many, Microsoft Excel is their go-to for (quantitative) statistical analysis. Although it can serve as a tool for basic analysis, it is also highly error-prone, limited in analysis capabilities, and limited in graphical data representation. Statistical packages, such as SPSS, R, Stata, etc., allow for more advanced analytics. Commonly used evaluation data analysis packages for qualitative data include Atlas.ti, Dedoose, NVivo, and MAXQDA.

Questions you must consider before conducting evaluation data analysis include, but not limited to:

  • Are you interested in specific questions that focus on positive topics (emphasis on positive holistic vision)?
  • Where is the data located? Will you need to analyze from external sources as well?
  • Do you need permission to access the data?
  • What size is each data set?
  • How familiar are you with each database?
  • In what form is the data?
  • Is each individual source complete and accurate?
  • What do you need to do to clean the data (for inconsistencies or redundant values)?
  • Do you need to convert the data before you can analyze it?
  • Can you change the data in its original location or do you need to move it to another location?
  • If using different sources, how will you connect the data?
  • Will your data model scale?
  • Will you be able to later add data sources to your model and use it?
  • Do you need summary tables to consolidate data for future analysis?
  • Does your server have sufficient software and hardware to conduct the type of analysis you are seeking?
  • How often will you need to import data?

Within each of the planning links below, we provide a definitions, how we can help you, and articles and whitepapers that will help you on your journey.

Evaluation Services