Question: Using excel data sheet containing TB data with variables, hospital name, your primary goal is to conduct a comprehensive analysis of the data and create

Using excel data sheet containing TB data with variables, "hospital name", your primary goal is to conduct a comprehensive analysis of the data and create a pivot table on a new worksheet using all inserted cells. Varibale name are "facilityname", "periodname(date in month &year)","PHC headcount 5 years and older ", "Screen for TB 5 years and older", "Client 5 years and older eligible for TB test ","TB test 5 years and older using GeneXpert", "DS-TB bacteriologically confirmed 5 years and older", "DS-TB clinically diagnosed 5 years and older ","DS-TB treatment start 5 years and older".
a)Efficiently identify 3 High Burden facilities based on Headcount using any method, including PIVOT Table or other suitable techniques.
b) Generate a TB Cascade Graph representing the data for the identified 3 high burden facilities.
c) Identify issues related to data elements and assess the overall data quality based on the performance of the facilities.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!