Laboratory Task 1

Laboratory Task 1#

Genheylou Felisilda - DS4A

Dr. Jake is a medical doctor and the CEO of Astro JR, a giant pharmaceutical company in the Philippines. To support the production and use of AstroJR’s COVID19 vaccine, this company has implemented a number of business intelligence and data analytics tools. Your task is to provide the appropriate and necessary analytical questions Dr. Jake must ask his analytics team in order to provide better deployment and production of COVID19 vaccines around the world using descriptive, predictive, and prescriptive analytics.

Descriptive: How many infected cases since last week? Diagnostic: What factor affects the demand of AstroJR’s COVID19 vaccine? Predictive: How many deaths next week? Prescriptive: If the number of cases will increase next week, how many hospital staff should be here to adequately treat the influx of patients?

  1. Descriptive:
    • How many vaccines were distributed to each region in the last month?
    • What is the daily vaccination rate per city over the past three months?
  2. Diagnostic:
    • Which demographic groups are receiving the least number of vaccines, and why?
    • How does vaccine supply chain delay impact the vaccination rate in different regions?
  3. Predictive:
    • Based on current trends, how many people are likely to be fully vaccinated by the end of the next quarter?
    • How many new COVID-19 cases are expected in the next month in regions with low vaccination coverage?
  4. Prescriptive:
    • If a particular region experiences a surge in COVID-19 cases, how should vaccine stock be reallocated to meet demand?
    • What is the optimal vaccination schedule to achieve herd immunity in the shortest time possible?