$30 off During Our Annual Pro Sale. View Details »

Digging a Pit of Success for Your Organization

Aaron
July 25, 2022

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/

Aaron

July 25, 2022
Tweet

More Decks by Aaron

Other Decks in Technology

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. [email protected]
    bit.ly/3J1Cn5n
    additional
    resources
    my contact info

    View Slide

  33. Digging a
    PIT OF SUCCESS
    for Your Organization
    Aaron Chafetz
    [email protected]
    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