HFR: DDC Soft Launch

Dec 18, 2020

Transcript

1. HFR + DDC Soft Launch 2020-12-18
2. Due to the importance of tracking progress towards meeting targets, quarterly reporting is no longer sufficient to monitor progress toward reaching epidemic control. Therefore, GH/OHA, in coordination with OGAC, is mandating that all PEPFAR activities move to monthly reporting on select MER indicators HFR Purpose How do we effectively and efficiently process, store, and manage +1 million new data points every month? HFR Problem
3. before DDC field data submissions process, validate & transform store & manage export & connect analyze & visualize
4. DDC before DDC current DDC field data submissions process, validate & transform store & manage export & connect analyze & visualize
5. DDC before now future all of FY20 FY21Q1 FY21Q2 Data Processing HFRG Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Field Error Ownership ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Data Management HFR Server Team Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Reliability ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Data Usage HFRG Time ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Connectivity ⬤ ⬤ ⬤ Where have improvements been made? Problematic Working well Room for improvement Connect TBW to MySQL DB
6. DDC before now future all of FY20 FY21Q1 FY21Q2 Data Processing HFRG Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Field Error Ownership ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Data Management HFR Server Team Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Reliability ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Data Usage HFRG Time ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Connectivity ⬤ ⬤ ⬤ Where have improvements been made? ▲ ▲ ▲ ▲ ▲ ▲ ▲ ▲ ▲ Setbacks comparing before DDC to where we are now Improvements
7. DDC before now future all of FY20 FY21Q1 FY21Q2 Data Processing HFRG Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Field Error Ownership ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Data Management HFR Server Team Time ⬤ ⬤ ⬤ Speed ⬤ ⬤ ⬤ Transferable ⬤ ⬤ ⬤ Reliability ⬤ ⬤ ⬤ Visibility ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Data Usage HFRG Time ⬤ ⬤ ⬤ Accessibility ⬤ ⬤ ⬤ Connectivity ⬤ ⬤ ⬤ Where have improvements been made?
8. Threats to Success M/CIO software approval & access to sub-systems External reliance for any changes Tableau & R direct connection to DDC
9. Where are we going? Self-service interface for data entry and access DDC direct connection to DATIM Tableau & R direct connection to DDC More automation error reporting Improved turnaround time
10. How do we effectively and efficiently process, store, and manage +1 million new data points every month? HFR Problem
11. HFR + DDC Soft Launch 2020-12-18
12. Notes and Attribution • Prepared for the DDC Soft Launch ◦ B.Kagniniwa & N.McDavid (presenters) ◦ A.Chafetz (content development) • Images Sourced from the Noun Project ◦ launch by Olivia from the Noun Project ◦ lab by ibrandify ◦ CSV by Stock Image Folio ◦ astronomy by ibrandify ◦ abduct by ibrandify