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
   

   View Slide

2. Aaron Chafetz
   Office of HIV/AIDS
   Senior Economist
   

   View Slide

3. PEPFAR
   US President's Emergency Plan for AIDS Relief
   

   View Slide

4. Drowning
   in data
   Swimming in data
   

   View Slide

5. www.quickmeme.com/meme/3p99g3
   

   View Slide

6. Recognizing when we
   outgrow our old things
   

   View Slide

7. Motivating others
   to run a marathon
   

   View Slide

8. The Pit
   

   View Slide

9. Uphill battle
   

   View Slide

10. The Pit
    Fall downhill
    

    View Slide

11. Presentation from useR 2016
    Hadley Wickham
    Chief Scientist at RStudio
    https://slides.nyhackr.org/presentations/The-Tidyverse_Hadley-Wickham.pdf
    

    View Slide

12. Why arenʼt we
    all already
    doing this?
    

    View Slide

13. Packages
    Buy In
    Community
    

    View Slide

14. PACKAGES
    

    View Slide

15. Repeating
    routine tasks
    each quarterly
    cycle
    

    View Slide

16. OHA
    Packages
    usaid-oha-si.github.io/tools/
    

    View Slide

17. si_setup()
    si_paths()
    load_secrets()
    clean_indicator()
    

    View Slide

18. - Standardize workflows,
    better consistency
    - Improve reproducibility
    and efficiency
    - Make work more
    approachable
    

    View Slide

19. BUY IN
    

    View Slide

20. Bringing others
    to the table
    

    View Slide

21. Bringing
    leadership
    onboard
    

    View Slide

22. View Slide

23. Selling colleagues
    on benefits
    

    View Slide

24. > print('hello world')
    [1] "hello world"
    

    View Slide

25. Supporting
    teammates in making
    incremental changes
    Paper Airplane by Landan Lloyd from NounProject.com
    

    View Slide

26. COMMUNITY
    

    View Slide

27. View Slide

28. Targeted and
    applicable
    approach for
    process and data
    

    View Slide

29. Catering to the
    needs of the
    community
    github.com/USAID-OHA-SI/coRps
    

    View Slide

30. https://usaid-oha-si.github.io/learn/categories/#rbbs
    

    View Slide

31. Continuing our effort
    to expand our R user
    base and work
    

    View Slide

32. achafetz@usaid.gov
    bit.ly/3J1Cn5n
    additional
    resources
    my contact info
    

    View Slide

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
    

    View Slide

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/
    

    View Slide

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
    

    View Slide

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.
    

    View Slide