Data Management and Statistical Services

Data Management – REDCap

As a service to HHRI and HCMC researchers, the HHRI has partnered with HCMC to manage accounts and provide a secure server to host REDCap, as an onsite resource for managing surveys and clinical research databases

How do I access HCMC REDCap?

For access to HCMC REDCap, go to https://redcap.hcmed.org/redcap/

How can I sign up for REDCap access?

To sign up for a REDCap account, send a request to researchinquiry@mmrf.org

 What is REDCap?

REDCap (Research Electronic Data Capture) is a free, secure, web-based application. REDCap can provide researchers with a professionally managed, secure, web based, HIPAA compliant environment for building and managing web-based research projects.  REDCap was developed by Vanderbilt University and funded by the NIH. REDCap has a fast and flexible set-up for customized data entry forms and surveys, and allows you control access to your projects through secure login. To learn more about REDCap and REDCap Survey, demonstration and tutorial videos are currently available on the REDCap Consortium website:

Home page: https://www.project-redcap.org
Instructional videos: https://projectredcap.org/resources/videos/

How does REDCap work?

REDCap provides web-interface to a central database, facilitating tailored data collection for specific projects.  REDCap is accessible from any device with an internet connection, so you can run it on an ipad as well as a laptop. When you enter data into REDCap, it runs on HCMC servers, but it is displayed on your local monitor. It looks and feels as if it is running on your own computer, but it isn’t. This provides great security because files containing sensitive data never leave our secure servers. You can import data into REDCap as well as export data from REDCap, for statistical analyses via other programs.

Who can access and use REDCap at HCMC?

REDCap access is available to all HCMC faculty and staff and to non-HCMC collaborators who are working with a member of the HCMC community.  REDCap is open source so the software is no cost and HCMC has agreed to provide access to secure servers for data storage.  However, individual research programs are responsible for setting up and managing project specific REDCap databases.

What security measures will be in place?

REDCap is housed on a virtual server at Hennepin County Medical Center’s (HCMC) data center at First Databank in Eagan. First Databank is a locked and guarded data center staffed at all hours (24 X 7). Entrance to the data center requires use of a card key to unlock the data center door and a second card key lock secures the cage that the servers reside within. The security of the data center is further protected by an Operations desk that is staffed 24×7 and by a security camera system. REDCap servers are behind HCMC’s firewall and protected by intrusion detection systems. All electronic connections to the REDCap environment are encrypted. The data stored in the REDCap MySQL database server can be accessed by the REDCap end users by logging into https://redcap.hcmed.org and opening the REDCap project(s) that they have been granted access to by the owners of the projects. Only system administrators are authorized to access the back-end database server.

How will data be backed up?

The virtual server that houses the database is backed up nightly at 7pm with a copy of the server image retained for 14 days.

 

Statistical and Analytical Services

The MMRF has identified two referral options to connect MMRF and HCMC researchers with statistical services when they do not otherwise have access to this resource for their projects. One option is the MMRF’s Chronic Disease Research Group (CDRG) and the other is the University of MN’s Biostatistical Design and Analysis Center (BDAC). Both options are described below (hourly rates are updated annually).

 

CDRG

CDRG can offer statistical support for HCMC faculty or trainees across all clinical areas. Rates depend on the particular needs, requiring either MS-level (approximately $80/hour) or PhD-level (approximately $125/hour) statisticians. Areas of expertise include:

  • Study design and data management
  • Sample size estimate/power analyses
  • Support for statistical section methods for grant applications
  • Inferential statistics, survey data and survival analysis
  • Generalized linear modeling
  • Longitudinal analysis
  • Methods for handling confounding
  • Mixed effects models

To explore working with CDRG for your statistical and analytical needs, please complete the PDF form found here and send it to Dave Gilbertson, the co-Director of CDRG, at dgilbertson@cdrg.org

 

BDAC

BDAC offers biostatistical consulting and analysis at a rate and level of service appropriate to the needs of the researcher. Rates range from a Statistician/Data Base Programmer ($103.00/hour) to a Faculty Statistician ($125.00/hour). Services available include:

  • Study design consultation and evaluation
  • Sample size and power calculation
  • Writing statistical analysis section for grant proposals
  • Protocol Development and review
  • Data Analysis as specified in the study protocol
  • Optimization of data collection methodology
  • Tables, graphs, and summarization of analysis results
  • Interpretation of analysis results
  • Review of statistical analysis and results for manuscripts
  • Assistance and writing and reviewing the statistical methods for manuscripts

BDAC services can be requested via their portal at  http://z.umn.edu/ctsirequest. You will be asked to log in with a U of MN x500 username and password. If you do not have one, you will need to create a guest account and submit a “New Request.” After you’ve completed the registration and submitted your information, someone on the BDAC team will contact you after their weekly review meeting.