ICPI / Prevention-Cluster

Analytic requests/activities related to Prevention
1 stars 1 forks source link

OVC FY19Q2 Data Cleaning/Dashboard Update #40

Open jleehurst opened 5 years ago

jleehurst commented 5 years ago

OVC dashboard and dossier updates @jleehurst @erinschelar

1. SNU tab o May need to look at comparison of SNUs with finer age/sex to examine proportion 10-14 etc ? Is it better to look at proportion active/grad <18 o Make IP/IM boxes smaller

2. OU x Age tab o Need to remove targets from the figures, too hard to review o Add pie chart for <18 back in
o Need to see targets and results by age/sex (and achievement): one option to put this figure in but have a separate table so we can see the targets and results where age bands don't align ?Do we need to have unknown age? o Useful to somewhere be able to see proportion of ages across OUs, potential to filter by sex? Could add this as a fourth figure on the first OVC_SERVxOU tab

3. Program status tab o Need to see results and targets for active, grad, exit, transfer to PEPFAR, transfer to non-PEPFAR o This figure is hard to look at because of different axes, maybe we take out the coarse ages and just format to look like Pano (or stacked bars instead of the pies and bar chart)? o Age/sex/active and age/sex/grad results, could even just be a table? Or perhaps make sex a slicer option for the figure below instead.

4. HIVSTAT tab o Add data tables o Need to have way to compare partner data ? Other questions missing ? Ratio