Digging a Pit of Success for Your Organization

Digging a Pit of Success for Your Organization: Embracing an R-Based Ecosystem in the Federal Government
RStudio Conf 2022

How does a US federal agency analyze tens of millions of records across 30,000 sites in over 50 countries analyze these data efficiently and effectively? Five years ago, our team ventured beyond the confines of (largely) Excel and towards leveraging R to be more efficient in our analysis and workflows since data is instrumental to the mission of ending the global HIV epidemic. We have created our own 'pit of success', providing analysts the infrastructure and support needed to ease the learning of and working with R in our specific context. We will be sharing our experiences in digging this 'pit of success' that organizations would benefit from.

Resources
coRps GitHub repo of presentations and materials - https://github.com/USAID-OHA-SI/coRps

coRps R Building Blocks Series - https://usaid-oha-si.github.io/learn/categories/#rbbs

Our R Packages - https://usaid-oha-si.github.io/tools/

About USAID's Office of HIV/AIDS - https://www.usaid.gov/global-health/health-areas/hiv-and-aids

About The US Presidents Emergency Plan for AIDS Relief (PEPFAR) - https://www.state.gov/pepfar/

PEPFAR public data - https://data.pepfar.gov/

Transcript

1. Digging a PIT OF SUCCESS for Your Organization Aaron Chafetz Office of HIV/AIDS Senior Economist This presentation was made possible by the support of the American people through the United States Agency for International Development (USAID) under the U.S. President's Emergency Plan for AIDS Relief (PEPFAR). The contents in this presentation are the sole responsibility of the author, and do not necessarily reflect the views of USAID, PEPFAR or the United States Government. RStudio Conf 2022
2. Aaron Chafetz Office of HIV/AIDS Senior Economist
3. PEPFAR US President's Emergency Plan for AIDS Relief
4. Drowning in data Swimming in data
5. www.quickmeme.com/meme/3p99g3
6. Recognizing when we outgrow our old things
7. Motivating others to run a marathon
8. The Pit
9. Uphill battle
10. The Pit Fall downhill
11. Presentation from useR 2016 Hadley Wickham Chief Scientist at RStudio https://slides.nyhackr.org/presentations/The-Tidyverse_Hadley-Wickham.pdf
12. Why arenʼt we all already doing this?
13. Packages Buy In Community
14. PACKAGES
15. Repeating routine tasks each quarterly cycle
16. OHA Packages usaid-oha-si.github.io/tools/
17. si_setup() si_paths() load_secrets() clean_indicator()
18. - Standardize workflows, better consistency - Improve reproducibility and efficiency - Make work more approachable
19. BUY IN
20. Bringing others to the table
21. Bringing leadership onboard
23. Selling colleagues on benefits
24. > print('hello world') [1] "hello world"
25. Supporting teammates in making incremental changes Paper Airplane by Landan Lloyd from NounProject.com
26. COMMUNITY
28. Targeted and applicable approach for process and data
29. Catering to the needs of the community github.com/USAID-OHA-SI/coRps
30. https://usaid-oha-si.github.io/learn/categories/#rbbs
31. Continuing our effort to expand our R user base and work
32. achafetz@usaid.gov bit.ly/3J1Cn5n additional resources my contact info
33. Digging a PIT OF SUCCESS for Your Organization Aaron Chafetz achafetz@usaid.gov Office of HIV/AIDS Senior Economist This presentation was made possible by the support of the American people through the United States Agency for International Development (USAID) under the U.S. President's Emergency Plan for AIDS Relief (PEPFAR). The contents in this presentation are the sole responsibility of the author, and do not necessarily reflect the views of USAID, PEPFAR or the United States Government. RStudio Conf 2022
34. Resources • coRps GitHub repo of presentations and materials ◦ https://github.com/USAID-OHA-SI/coRps • coRps R Building Blocks Series ◦ https://usaid-oha-si.github.io/learn/categories/#rbbs • Our R Packages ◦ https://usaid-oha-si.github.io/tools/ • About USAID's Office of HIV/AIDS ◦ https://www.usaid.gov/global-health/health-areas/hiv-and-aids • About The US President's Emergency Plan for AIDS Relief (PEPFAR) ◦ https://www.state.gov/pepfar/ • PEPFAR public data ◦ https://data.pepfar.gov/
35. Notes and Attributions • Prepared for RStudio Conf 2022 at National Harbor [July 29, 2022] ◦ Author - Aaron Chafetz, Senior Economist, USAID/Office of HIV/AIDS ◦ Contributors - Tim Essam, Senior Data Scientist, USAID/Office of HIV/AIDS • Unless otherwise cited, all images are CC-0 License  and icons developed by author • Image Sources ◦ Excel meme - http://www.quickmeme.com/meme/3p99g3 ◦ Hadley Wickham (2016) presentation - https://slides.nyhackr.org/presentations/The-Tidyverse_Hadley-Wickham.pdf ◦ Rube Goldberg Machine - https://en.wikipedia.org/wiki/Rube_Goldberg_machine ◦ Paper Airplane by Landan Lloyd from NounProject.com ◦ Skydiving - Sky Antonio (Adobe Stock Photos) ◦ Photography (Unsplash) by Quaritsch Photography, Johanna Steppan, Stormseeker, sporlab, Fabrizio Conti, Majharul Islam, Wil Stewart, Hennie Stander, Leone Venter, Jonas Jacobsson, CHUTTERSNAP, Ricardo IV Tamayo, Dan Asak, and Ben Green
36. This presentation was made possible by the support of the American people through the United States Agency for International Development (USAID) under the U.S. President's Emergency Plan for AIDS Relief (PEPFAR). The contents in this presentation are the sole responsibility of the author, and do not necessarily reflect the views of USAID, PEPFAR or the United States Government.