PMTCT HEI Dashboard - Githubissues

nmcdavid commented 6 years ago

Worked with a group of PMTCT HEI SMEs to inform the development of an excel-based tool (OU specific Site x IM tool & Global PSNU x IM tool). 10-weeks were dedicated to developing tool

Working with Katie O'Connor and Aliyah Abdul-Wakil

Used Kenya for the draft tool

nmcdavid commented 5 years ago

Developed Site-level tool we are comfortable bringing to ICPI leads for review.

Working on Global PSNU x IM tool, based on same format.

nmcdavid commented 5 years ago

Completed draft of Global PSNU x IM tool. Will send to Katie O'Connor and Aliya Abdul-Wakil for review

Some changes to note that I will incorporate in the Site x IM Draft

To reduce the size and increase the speed of the tool
- Removed zeros from dataset (used field settings of pivot table to "show items with no data to preserve structure of reference tables and visuals)
- Removed EID Coverage calculated indicator
Updated the R-code to create a column that would serve as the "period slicer" - this way the slicer only includes FY18 quarters
Slicers are connected to all tables in the tool and will carry over from tab to tab

nmcdavid commented 5 years ago

Links to draft tools below

Draft Kenya Site x IM tool (currently being reviewed by Katie O'Connor) link

Draft Global PSNU x IM tool (currently being reviewed by Katie O'Connor) link

nmcdavid commented 5 years ago

Created final Global dashboard and OU-specific dashboards which have been posted to pepfar.net

USAID-OHA-SI / TeamTracking

PMTCT HEI Dashboard #32