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

Overview

Class Central Tips

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.

Syllabus

Project Name

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.