YoVDO

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

Offered By: Coursera Project Network via Coursera

Tags

Business Software Courses Data Analysis Courses Logistics Courses Presentation Skills Courses Supply Chain Management Courses PivotTables Courses

Course Description

Overview

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.

Taught by

Mark Veljkov

Related Courses

Analyze Data with Microsoft Excel
Codecademy
Conditional Formatting, Tables and Charts in Microsoft Excel
Coursera Project Network via Coursera
Data for Business Analysts Using Microsoft Excel
Microsoft via Coursera
Create Charts and Dashboards Using Microsoft Excel
Coursera Project Network via Coursera
Microsoft Excel for Your Business
CreativeLive