COVID case study

Business Strategy Guided Project (completed March 19, 2021)

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets

<The Supply Chain Planning course walks learners through the critical first step in Supply Chain Management, planning. In the course project scenario, your company supplies Personal Protective Equipment and ventilators to hospitals and clinics across the US. You have been asked by your company’s executives and state health officials to prepare an analysis of the US, by state and region, identifying locations of highest need for supplies and ventilators. This is called a Supply Plan. Throughout the course you will walk through building the Supply Plan. You'll begin by extracting the needed data then preparing the data for a Supply Plan. You will then create a PivotTable to analyze the data. From here you will learn how to create a set of visualizations and then add these visualizations to a presentation so that you can report on your findings.>

Step-by-step:

Gather the proper data.

Prepare the data for analysis.

Build a pivot table with the data.

Use the pivot table to make visualizations of the pivot table.

Use the visualization to understand what's happening and to build a report on the data.

The COVID Tracking Project datasets:

Notice: The COVID Tracking Project has ended all data collection as of March 7, 2021. The existing API will continue to work until May 2021, but will only include data up to March 7, 2021.

https://covidtracking.com/data/api