Skip to Main Content

All of Us Research Program: Research Project 1

A guide to help you better understand the All of Us Research Program and how to use the Researcher Workbench to further your research.

Research Statement

This demonstration aims to evaluate the effectiveness of metformin in managing glycemic control among individuals diagnosed with type 2 diabetes, as measured by hemoglobin A1c levels. Using data from the All of Us Research Program, we will study A1c levels in a cohort of patients who have been prescribed metformin, excluding those who were pregnant during the study period. The goal in this research could be to identify patterns in A1c outcomes and assess the impact of metformin therapy on long-term glycemic control in a diverse population.

Creating a new Workspace

Workspace name

Data access tier: Registered Tier (The Registered Tier includes data from electronic health records (EHRs), wearables, surveys, and physical measurements) OR Controlled Tier (In addition to the data in the Registered Tier, the Controlled Tier dataset contains genomic data in the form of short-read whole genome sequences (WGS), long-read WGS, structural variants, and genotyping arrays; previously suppressed demographic data fields from EHRs and surveys; and unshifted dates of events). USD has access to Controlled Tier.

Dataset version: Select which version of Curated Data Repository you wish to query in this workspace—recommended - Most recent version. 

Research Use Statement Questions 

  1. What is the primary purpose of your project?
  2. Please provide a summary of your research purpose by responding to the questions below
    1. What are the specific scientific question(s) you intend to study, and why is the question important (i.e. relevance to science or public health)?
    2. What are the scientific approaches you plan to use for your study? Describe the datasets, research methods, and tools you will use to answer your scientific question(s).
    3. What are the anticipated findings from the study? How would your findings contribute to the body of scientific knowledge in the field?
  3. The All of Us Research Program encourages researchers to disseminate their research findings to both scientific and lay/community audiences, to maximize the value of the resource and to recognize the contributions of participant partners. Please tell us how you plan to disseminate your research findings. Choose as many options below as applicable, and specify details in the text box, if available.
  4. The All of Us Research Program would like to understand how (or if) your research outcome may fit into the All of Us Research Program Scientific Framework. Please select all of the statements below that describe the outcomes you anticipate from your research.
  5. Population of interest. Will your study focus on any historically underrepresented populations?
  6. All of Us has a policy on respectful research involving American Indian and Alaska Native (AI/AN) populations. The following questions are intended to assess the relevance of the policy to your research.
    1. Does your research plan require any of the following with respect to individuals who self-identify as American Indian or Alaska Native (AI/AN) or who are genetically similar to populations with inferred Indigenous American genetic ancestry? Select the option that best describes your plans.
    2. Please explain your response by sharing specific details about your study design.
  7. Request for Review of Research Purpose Description. Would you like to request a review of your research purpose statement by the Resource Access Board?

creating a new workspace

Creating Cohort - What is your study group?

Include: type 2 diabetes (condition) AND metformin (drug) AND a1c (labs & measurements)

Exclude: pregnant (condition)

creating cohort

Creating Concept Set(s) - Data about your study group

  1. Metformin (drug)
  2. A1c (labs & measurement)

creating concept sets

Dataset Builder

Combine the Cohort AND Concept Sets

  • You can drop the column you might not need in your analysis here, under the “3. Select Values (Columns)”.
  • 4. Preview Dataset” offers the opportunity to preview the dataset before exporting it for analysis.

 

 

dataset buider

Analyze

Select your preferred programming language to use from Python, R, and SAS.

analyze

Footer for USD LibGuide v2.0