Regency EF
Interactive and Dynamic Statistical Reports Using R Shiny Apps Integrated with REDCap: Example from Arkansas Active Kids Study (304073)
Shasha Bai, Center for Biostatistics at OSUMC
Elisabet Borsheim, University of Arkansas for Medical Sciences
Anthony Goudie, Arkansas Center Health Improvement
*Zhuopei Hu, University of Arkansas for Medical Sciences
Julie Nick, Arkansas Children's Research Institute
Judith Weber, University of Arkansas for Medical Sciences
Keywords: R, Shiny, REDCap, interactive and dynamic report
Background: R Shiny combines the power of R computing and JAVA visualization to build interactive web apps. REDCap (Research Electronic Data Capture) is a well-established secure data collection tool for managing surveys and database. Arkansas Active Kids (AAK) study is a study aims to investigate the relationship between physical activity, physical fitness, diet and metabolic factors in prepubertal children. We use AAK study as an example to demonstrate the periodic and repeated generation of interactive statistical reports to showcase the progress of recruitment and lab visit. Methods: One longitudinal REDCap project with multiple events was created to conduct data collection which includes screening, lab visit, surveys, daily logs, and lab measurements. An API token was used to load all the data into the R environment. A dynamic Shiny App containing multiple webpages showcases a comprehensive report of recruitment figures, study progress figures and other analysis tables. Conclusion: By using R Shiny integrated with REDCap, we created a streamlined way to show the recruitment progress to investigators while increasing programming efficiency and maintaining reproducibility.