South Africa Weekly Dashboard - Siyenza Support

[jb3436]

Status: Approved
Code: https://github.com/south-africa-strategic-information/Siyenza

Email Response Approving Engagement

South Africa Engagement Email June 2019.docx

Subject : NEW ICPI Engagement with South Africa Team

Dear South Africa Team (Country Team and HQ),

Please share with colleagues we may have missed

CCd: Chair, PPM, ECT POC, Agency Leads, PCO, ICPI Leads, ECT Management, PRIME

Thanks to you and the team for your request. Please see below for details of the decision.

Summary of Request

Title: Support Weekly Siyenza Dashboard Population & Develop Transition Plan

Request:

There has been an interagency request for the PEPFAR coordination office (PCO) to work with ICPI to support maintenance and update of the interagency Siyenza monitoring dashboard moving forward. The PCO was asked to identify a solution with ICPI that does not rely exclusively on agency S staff. Given that CDC/USAID do not have staff to support the interagency merge and dashboard update process starting next week, there is an urgent need for ICPI support.

Interim /Short term Support Request and Deliverables:

1. PCO to identify ICPI staff who can support the dashboard update process, beginning week of June 3 (Yaa Obeng Aduasare is the suggested analyst to support as she has been involved in FF/FB and Siyenza since the start).

Longer term Request/Deliverables

2. ICPI to support South Africa PCO to automate the dashboard process so it can be more easily done 'in-house'

   1. improve the R merge script so that it does not require update / changes each week and develop an R-shiny (web) app for the merge script.
   2. improve the excel dashboard so it does not require calculations / tables to be modified each week.

3. Once Tanzania- ECT3 Request, Virtual Support #2 is completed, PCO will be able to run the files internally each week in a 2-step process:

   1. Execute merge of agency files each week using the shiny app
   2. Use the output dataset to update the dashboard without need to 'intervene' on script or on dashboard.

Deliverables/Outputs

1.Interim weekly dashboard generation by ICPI
2. Capacity Building of automation of dashboard generation
1.Virtual support
2. TDY
3. Reverse TDY
3. Sustainable solution for dashboard generation (potentially R Shiny App)
4. Automated and sustainable dashboard generation by country team

Requestor(s):

1. Dieter Schlodder - PCO South Africa
2. Sarah Porter - CDC SI Lead
3. Ambereen Jaffer - USAID SI Lead

Status: APPROVED

• Submitted Mon 6/3
• Discussed at leads Mon 6/3&10
• Approved 6/10
• Email Sent 6/10

Analysts Assigned – Engagement POCs:

• Analysts Weekly LOE = 2-4 hours
  • Yaa Obeng Aduasare (Peace Corps) - Peace Corps Agency POC for South Africa
  • Aliyah Abdul-Wakil (CDC/GDIT) – SI M&E ISME South Africa
• Engagement POCs:
  • Yaa Obeng Aduasare
  • Jasmine Buttolph

Resources:

GitHub Summary of Request and Updates:

#67

SharePoint Folder (pepfar.net)

Where products related to this engagement will be stored:

ICPI > Engagements > South Africa

Next Steps and Persons responsible:

• 6-8 weeks** (June 3- July 29)**

• June 3- July 29: Yaa Obeng Aduasare will support the weekly update of the dashboard for 6-8 weeks

• July 15-29: Yaa will work with Dieter, to develop a sustainable solution that can be transitioned over to the PCO and they will update the dashboard together for ** 2-3 weeks**

• Late July/August:

  • oo Dieter Schloder to schedule a TDY to ICPI for 2 weeks
  • oo To be scheduled at a time when he is available to dedicate time to absorb the responsibility of the dashboard long term (Suggest late July or early August)
  • oo Dieter will work with his leadership and with ICPI on logistics
  • oo A TDY SOW will be drafted by Dieter and Yaa once the time frame has been identified

• Project Management

  • oo The ICPI coordination office and engagements team will manage this project and will collaborate with requestors and analysts for ongoing technical inputs (Jasmine Buttolph and Jenny Hurst)
  • oo The updates on the project will be reported out on the weekly ICPI inbrief and regular project updates will be communicated to this group via email (Jasmine Buttolph)
  • oo As weekly dashboards and other products are generated, they will be stored in a central place and the link to those resources will be shared as part of the project updates (Yaa Obeng Aduasare and others)

Please feel free to contact ICPI@state.gov if you have any questions, concerns, or if you would like any additional information.

On behalf of the ICPI leads,

ICPI

[jb3436]

Follow up email to confirm Below Items

Email Sent by Yaa 6/17
Subject: Siyenza Interagency Dashboard Process
Response by Dieter 6/18

1. Frequency of dashboard updates

   1. Weekly OR Bi-weekly? Weekly

2. Timelines for submission (have they stayed the same ?)
   Still Weekly pending final review of reporting proposal. Datamerge done Tuesday, Prelim dashboard discussed 14:00 SA time, Final Dashboard done by Wednesday COB.

3. Timelines for additions

   1. Indicators (?) Additional indicators are being reviewed.
   2. New Targets (?) New targets are being reviewed, I am setting up a meeting tomorrow to review this.
   3. Variable to indicate graduated sites (?) Graduation still being reviewed. Will discuss in meeting tomorrow.

4. Process for the development of the R Shiny App

   1. Can the team share a set of requirements? Will loop in Abe to discuss. Will a call be helpful?

[jb3436]

Updates to Key Dates

Planning for sustainable solution for dashboard: July 1-12
Dieter is potentially coming to ICPI August 12-23

Frequency of Dashboard

Weekly

[jb3436]

Updates

1. We will start work on the sustainable dashboard 8-12 July
2. There will be a weekly dashboard going forward to allow us to continue our NDoH engagement
   a. The calls will (maybe) be every other week in line with the TX_CURR pulls
3. There is a Siyenza site within our general documents folder that I’ve been adding things to. We also have a more permanent and official site that will be updated before use.

TDY to ICPI

September will be a more appropriate time to come, as there will be more people in the office and Dieter will have more learning opportunities during that time.

Is it possible to move the training to September?

[jb3436]

Code Storage in GitHub

Code stored in South Africa's GitHub Repo for Siyenza
https://github.com/south-africa-strategic-information/Siyenza