OVC Dashboard (FY19Q2) Updates

[shapaklyak]

List and track updates needed to the OVC dashboard for FY19 Q2 based on feedback from others, and on changes to MSD structure.

Action: Determine if a new OVC dashboard file is needed or if we should refresh the existing one. Will depend on level of effort in revision of visuals and structure.

[shapaklyak]

Updates to R Code using Genie pull

• [x] remove Age/Sex/Service data from standardizeddisaggregate for OVC_SERV
• [x] remove "Exited without Graduation" data from otherdisaggregate
• [x] remove "Transferred" data from otherdisaggregate

Updates to Dashboard: Drafts posted on pepfar.net (Prevention --> Working Folder -->OVC-->Drafts)

Historically Approved dashboards: Prevention --> Projects --> OVC

• [x] Add SNU1 Filter to OVC Dashboard
• [x] Reshape dataset and structure from wide to long
• [x] Update visuals to address new disaggs for OVC_SERV: Age/SexProgramStatus

Tab specific updates in Dashboard

• [x] Remove completeness of data tab

OVC SERV x OU

• [x] table 1/visual 1: Keep as it (update title [move to 2]
• [x] tbl.2/fig. 2: keep (active + grad under 18) [move to 1]
• [x] tbl.3/fig.3: remove, update title of tb.1/fig1
• [x] tbl4/fig.4: [move to 3]

OVC_SERV x SNU

• [x] repeat from new OVC SERV x OU
• [ ] update OVC_SERV results by program status to only be under 18

OVC SERV x OU x Age

• [x] fig.1 - keep as is (make sure under 18)
• [x] fig.2 - keep as is

OVC SERV x AgeSex

• hold for now

per 4/30 call

OVC SERV x Prg.Status

• [x] stacked bar with over 18 and under 18
• [x] program status by fine age bands (look at pano requirements submitted)

OVC_SERV x AgencyIM

• [x] combine into one chart -- stacked bar w/under and over 18; include filter for under and over 18

OVC_HIVSTAT x OU

• [x] keep figure 1, rename "test not indicated"
• [x] figure 2: OVC HIV STAT POS & % receiving ART
• [x] remove figure 3
• [x] remove table 1
• [ ] trends for OVC HIVSTAT (parking lot)

OVC_HIVSTAT Cascade

• [x] use mock-up sent to panorama team, and move ovc hiv stat pos from third column to bottom so it is in line with receiving/not receiving ART.
• [x] add in proportions where possible.

OVC HIVSTAT Reference Table

• keep

[erinschelar]

Hints from Katya:

• save charts as template to easily adjust formatting -hide pivot table selections as final step to not confuse users -filters not linked across tabs, do as final step -OVC_SERV x OU x Age: may want to put tables beneath charts if too many rows with all OU data added -protect workbook with "OVC2019" -use ageasentered when we want to see the 1-4 and 5-9 age bands -hide blank rows in slicers -OVC_HIVSTAT flow legend is made of images