Please answer this question using Power BI. QUESTION 1: The director of York Region’s Infectious Disease Control Divisio
Posted: Sun Jul 10, 2022 11:27 am
Please answer this question using Power BI.
QUESTION 1:The director of York Region’s Infectious Disease Control Divisionwants to better understand theworkload associated with our COVID case counts to optimize staffingassignments.You have been asked to develop a dashboard to support thesestaffing decisions, with a focuson three case investigation teams:
o The Institutional Outbreak teamo Travel Case Management teamo Community Case Management team (who follow up on all cases thatare notassociated with outbreaks or travel).
The data is available on http://york.ca/covid19data, downloadedfrom the bottom left corner ofthe dashboard.Please prepare a feature visual that would be used to support theabove business problem: You can use any method you like to prepare thevisualization.o PowerBI is preferred as it is our standard internal visualizationsoftware.o Tableau or other visualization software is also acceptable. Please include a paragraph explaining your design choices inpreparing this visual.
QUESTION 2:You have been assigned to work with an epidemiologist to understandCOVID trends over timein York Region. The epidemiologist will help to explain the contentand the clinical value of thedata you are working with. As the statistical data analyst, yourrole is to develop thedashboard visualization.The project deliverable is a dashboard that the epidemiologist canuse for weekly presentationsto a group of COVID case investigators and management. Thispresentation will highlight anychanges in the recent trends as well as any subpopulations withhigher risk (subpopulations canbe defined by age group, municipality or vaccination status orother relevant characteristics).The epidemiologist wants the dashboard to show rates over time,with the following formula:
Total COVID Cases/Hospitalizations/Deaths per week
Total Population
Since severe outcomes (hospitalizations and deaths) are lesscommon than cases, theepidemiologist is expecting the trend to be very noisy and thinksthis might be confusing to theaudience of case investigators.Our COVID-19 database includes a table of all confirmed COVID-19cases from the beginning ofthe pandemic to present, including: demographic characteristic (age, gender, residentiallocation); severity information (hospitalization and/or fatality); COVID-19 disease details (variant of concern or mutation ofinterest); vaccination status (doses and brands); testing type and history (PCR or Rapid Antigen Test); and involvement in an long-term care home or retirement home outbreak(if relevant).
Please prepare an analysis plan for how you would develop therequested dashboard,including the following: An outline of the analysis steps you would take to prepare thisdashboard. Bullet points are acceptable. The outline may include: data preparation steps, analysismethods, softwarechoices, plan for interpretation and analysis, any secondaryanalyses of interest, andother considerations for the analysis. Please include a brief explanation of the decisions that wentinto preparing thisanalysis plan, including your understanding of the audience’sneeds, and yourrationale for the visualization and analysis choices to meet thatneed. You do not need to do the analysis, instead outline the analysisplan
QUESTION 1:The director of York Region’s Infectious Disease Control Divisionwants to better understand theworkload associated with our COVID case counts to optimize staffingassignments.You have been asked to develop a dashboard to support thesestaffing decisions, with a focuson three case investigation teams:
o The Institutional Outbreak teamo Travel Case Management teamo Community Case Management team (who follow up on all cases thatare notassociated with outbreaks or travel).
The data is available on http://york.ca/covid19data, downloadedfrom the bottom left corner ofthe dashboard.Please prepare a feature visual that would be used to support theabove business problem: You can use any method you like to prepare thevisualization.o PowerBI is preferred as it is our standard internal visualizationsoftware.o Tableau or other visualization software is also acceptable. Please include a paragraph explaining your design choices inpreparing this visual.
QUESTION 2:You have been assigned to work with an epidemiologist to understandCOVID trends over timein York Region. The epidemiologist will help to explain the contentand the clinical value of thedata you are working with. As the statistical data analyst, yourrole is to develop thedashboard visualization.The project deliverable is a dashboard that the epidemiologist canuse for weekly presentationsto a group of COVID case investigators and management. Thispresentation will highlight anychanges in the recent trends as well as any subpopulations withhigher risk (subpopulations canbe defined by age group, municipality or vaccination status orother relevant characteristics).The epidemiologist wants the dashboard to show rates over time,with the following formula:
Total COVID Cases/Hospitalizations/Deaths per week
Total Population
Since severe outcomes (hospitalizations and deaths) are lesscommon than cases, theepidemiologist is expecting the trend to be very noisy and thinksthis might be confusing to theaudience of case investigators.Our COVID-19 database includes a table of all confirmed COVID-19cases from the beginning ofthe pandemic to present, including: demographic characteristic (age, gender, residentiallocation); severity information (hospitalization and/or fatality); COVID-19 disease details (variant of concern or mutation ofinterest); vaccination status (doses and brands); testing type and history (PCR or Rapid Antigen Test); and involvement in an long-term care home or retirement home outbreak(if relevant).
Please prepare an analysis plan for how you would develop therequested dashboard,including the following: An outline of the analysis steps you would take to prepare thisdashboard. Bullet points are acceptable. The outline may include: data preparation steps, analysismethods, softwarechoices, plan for interpretation and analysis, any secondaryanalyses of interest, andother considerations for the analysis. Please include a brief explanation of the decisions that wentinto preparing thisanalysis plan, including your understanding of the audience’sneeds, and yourrationale for the visualization and analysis choices to meet thatneed. You do not need to do the analysis, instead outline the analysisplan