Quick analysis of WHO data--domain experience not required
See more projectsIntensity
28hr/week
Duration
1day
Location
Remote
Project Overview
1 to 8 years professional experience
Corporate Strategy & Development - Strategy Development
The goal of this project is to arrive at global, regional, and country-specific rankings of disease burden (measured by WHO Disease Adjusted Life Years [DALYs]) and market potential (measured by WHO Total Health Expenditures [THEs] and the 5-year WHO THE CAGR). Ideal start time is ASAP and I'm available to answer questions at any time but 9AM PST 8/9 is a hard deadline.
Specific tasks:
1. Complete the AFRbyCountry tab as it has been laid out and also create similar tabs for every other region (AMR, SEAR, EUR, EMR, WPR).
2. Add global and regional total THEs and 2014-2019 THE CAGRs to the Summary tab
3. In a new tab, create a list of all diseases that includes their 2014 global health expenditures and the projected % growth in those expenditures (2014 vs 2019). RANK() each disease by each of these metrics independently and then SUM() those ranks and RANK() that SUM()
4. In separate tabs, create rankings of diseases for each region as well
Specific tasks:
1. Complete the AFRbyCountry tab as it has been laid out and also create similar tabs for every other region (AMR, SEAR, EUR, EMR, WPR).
2. Add global and regional total THEs and 2014-2019 THE CAGRs to the Summary tab
3. In a new tab, create a list of all diseases that includes their 2014 global health expenditures and the projected % growth in those expenditures (2014 vs 2019). RANK() each disease by each of these metrics independently and then SUM() those ranks and RANK() that SUM()
4. In separate tabs, create rankings of diseases for each region as well
Additional Notes
Excel proficient. Can begin immediately. Preferred Skills and Certifications
Functional
Strategy Development
About The Client
Top Skills Hiring For
Strategy Development
8 years
Time On Graphite
1
Hiring Managers