Skip to Main Content
UMass Chan Medical School, Lamar Soutter Library. Education. Research. Health Care. Empowering the future. Preserving the past.
UMass Chan Medical School Homepage Lamar Soutter Library Homepage

Analysis-Ready Data Sets Tutorial

Step by step tutorial on how to make your data analysis-ready using Excel or REDCap.

Welcome!

Introduction

When working on a research project, take steps to ensure that your data is safe, authentic, and available. 

In addition, take steps to ensure that your data is usable.

To be useful to yourself, other researchers, or biostatisticians, data sets should:

  • facilitate clear and unambiguous communication
  • be useable by current software applications
  • provide traceability between analysis data and its source data
  • be linked to machine-readable metadata
  • be analysis-ready

Analysis Data Model (ADaM)
Clinical Data Interchange Standards Consortium (CDISC)

Analysis Ready Data Sets

Analysis-ready data sets have been conscientiously collected and reviewed so that analysis of the data yields clear, consistent, and error-free results to the greatest extent possible.

Tutorial Agenda

This tutorial will cover the following concepts for preparing analysis-ready data sets:

  • Creation/formatting
  • Validation
  • Standardization
  • Cleaning
  • Documentation