Prevention Reference Tables QC

[kimisatoPC]

Request from Caroline Cooney via Heather Watts to QC the Prevention Reference Tables sent out during RPMs. Now that Panorama includes Q2/Q4 data, the data don't match in Pano vs. final.datim vs. Tableau dashboard.

Kimi will check PP_PREV, GEND_GBV, KP_PREV Katya: OVC_SERV

[shapaklyak]

Review of FY17 Results

• Error in nb.3 below, fix by selecting only "total Numerator" in Tableau OVC_SERV by PSNU tab (currently program status & total numerator selected)

  

• Note: Need to update OVC dashboard - Results and Trends by SNU tab, fyi @erinschelar

• Will continue to review additional Tableau tabs

Nb.	Tableau tab	Tableau	Pano	final.datim	OVC dashboard
1	OVC_SERV by OU Total N (program status)	14,241	14,241	14,241	14,241
2	OVC_SERV by IM Total N (program status)	14,241	14,241	not checked	14,241
3	OVC_SERV by PSNU Total N (program status)	2,894	1,418	1,418	8,114

[shapaklyak]

• Error in nb.4 below in Panorama percentage calculating program status: 10,978/14,241 is not 93%, will be submitting zendesk ticket fyi @erinschelar

Nb.	Tableau tab	Tableau	Pano	final.datim	OVC dashboard
1	OVC_SERV by OU Total N (program status)	14,241	14,241	14,241	14,241
2	OVC_SERV by IM Total N (program status)	14,241	14,241	not checked	14,241
3* (fail)	OVC_SERV by PSNU Total N (program status)	2,894	1,418	1,418	8,114
4* (fail)	OVC SERV Program status FY17APR	77.1% Active	93% Active	77.1 % Active	77.1% Active
5	OVC SERV Program Status FY18 Targets	87.9% Active	not in Pano	87.9% Active	not in dashboard

[shapaklyak]

Disregard the OVC Tableau QC fail (nb3) - was using an older version. The 02-27 Tableau workbook doesn't have OVC in it. Inconsistency in OVC dashboard (nb3) and Panorama (nb4) still stand though.

[kimisatoPC]

Panorama Global View summing Numerator and Denominator values for PP_PREV.

Recommendation to use final.datim OR Prevention reference tables. Kimi will submit a Pano zendesk ticket regarding data issue.