We may earn an affiliate commission when you visit our partners.
Mark Veljkov
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/yooo7h/using
Three deals to help you save
We found three deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until December 12
Annual Subscription Savings
Unlock programs from Google, Microsoft, and IBM and join 77% of learners who reported positive career outcomes.
Only $239!
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
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.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Prepares learners to create and lead real-world supply chain plans
Supply chain professionals seeking to improve their skills in supply chain planning
Teaches learners how to create critical visualizations and presentation materials for data-driven reporting
Requires learners to come into the course with a foundational knowledge of data analysis and statistical software
Save this course
Save Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets to your list so you can find it easily later:
Save
Save
Reviews summary
Covid-19 data analytics for supply chain management
learners say this course is a great project course for those interested in data and business analytics. The nice project uses practical data to teach students how to use pivot tables and Covid-19 data to make supply chain logistics decisions. This is a great course for both beginners and advanced learners with spreadsheet knowledge. However, a few students found the course to be too easy or too basic.
The explanations and instructions are clear.
"The explanation was clear and concise."
"I recommend doing the same excersise in Excel while you are using Rhyme."
"Nice and very short. Pretty basic things with Pivot Tables."
Suitable for beginners or those new to pivot tables.
"This guided project is very well driven for beginners, especially college students!"
"If you have no idea of excel, it's an excellent hands-on course."
"Its an Okay course if you have some spreadsheet knowledge but if you are new to this course then it a good explanatory course"
Students appreciate the practical project that utilizes real data.
"Thank you for this course.I get more knowledge about the supply chain."
"How to deep dive the data for taking quick decision using Pivot a Table for understanding supply chain demand vs availability."
"Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets is my dream made true!"
Some students experienced technical issues with the Rhyme cloud.
"Files did not load, the Rhyme cloud did not load."
"The coursera's virtual platform Rhyme was lagging and made the whole project experience not so pleasant. "
Some students found the content to be too basic or too easy.
"The course is too basic and probably ideal for college students."
"Too easy"
"The course is too easy for people who have some knowledge of excel including pivot table."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets with these
activities:
Brush Up on Data Analysis Techniques
Show steps
Ensure a solid foundation in data analysis by reviewing key concepts and techniques, empowering you to effectively interpret and present findings within the Supply Plan.
Browse courses on
Data Analysis
Show steps
-
Revisit fundamental concepts of data analysis, such as descriptive statistics, probability, and hypothesis testing.
-
Practice using data analysis tools and techniques through online tutorials or exercises.
Review Supply Chain Planning Basics
Show steps
Review foundational concepts in supply chain planning prior to taking the course, enabling you to build a stronger base for learning.
Show steps
-
Revisit definitions and concepts of supply chain planning, such as demand forecasting, inventory management, and transportation.
-
Identify the key components and processes involved in supply chain planning.
-
Consider real-world examples of successful supply chain planning.
Create a Course Resources Compendium
Show steps
Organize and review key course materials, including notes, assignments, quizzes, and exams, ensuring a comprehensive understanding of the subject matter.
Show steps
-
Review all course materials, including notes, assignments, quizzes, and exams.
-
Identify key concepts, definitions, and formulas.
-
Categorize and organize the materials logically.
-
Create a summary document or visual representation of the compiled materials.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete Step-by-Step Visualizations Tutorial
Show steps
Reinforce your understanding of creating visualizations by following guided tutorials that demonstrate step-by-step processes and techniques.
Browse courses on
Data Visualization
Show steps
-
Select a step-by-step tutorial on creating visualizations using a preferred tool or software like Tableau or Power BI.
-
Carefully follow the instructions in the tutorial to create a visualization.
-
Analyze the resulting visualization and identify areas for improvement.
Solve PivotTable Practice Problems
Show steps
Enhance your proficiency in using PivotTables by solving practice problems, solidifying your understanding of data manipulation and analysis techniques.
Browse courses on
PivotTables
Show steps
-
Find online resources or practice exercises that provide PivotTable problems.
-
Solve the problems independently, focusing on data summarization and analysis.
-
Check your solutions against provided answers or consult with peers for feedback.
Collaborate with Peers on Supply Plan Analysis
Show steps
Engage with fellow learners by collaborating on a Supply Plan analysis, fostering knowledge exchange, diverse perspectives, and improved understanding.
Browse courses on
Supply Chain Planning
Show steps
-
Form study groups with peers to discuss and analyze the Supply Plan together.
-
Share insights, identify patterns, and develop recommendations.
-
Provide feedback and constructive criticism on each other's analysis.
-
Prepare a joint presentation to share your findings and insights.
Build a Mini Supply Chain Model
Show steps
Apply your knowledge by creating a scaled-down model of a supply chain, enabling you to simulate real-world scenarios and gain practical experience.
Show steps
-
Define the scope and parameters of your mini supply chain model.
-
Gather data and identify key performance indicators to track.
-
Build the model using appropriate tools or software.
-
Simulate various scenarios and analyze the results.
-
Identify areas for improvement and refine your model.
Produce a Comprehensive Supply Plan Presentation
Show steps
Synthesize your knowledge by creating a comprehensive presentation that effectively conveys the Supply Plan analysis, demonstrating your understanding of key concepts and ability to communicate findings.
Browse courses on
Supply Chain Planning
Show steps
-
Review the Supply Plan, identify key insights, and develop a clear narrative.
-
Design visually appealing and informative slides using appropriate charts, graphs, and data visualizations.
-
Organize the presentation logically and ensure smooth transitions between slides.
-
Practice delivering the presentation to gain confidence and improve your communication skills.
Brush Up on Data Analysis Techniques
Show steps
Ensure a solid foundation in data analysis by reviewing key concepts and techniques, empowering you to effectively interpret and present findings within the Supply Plan.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Revisit fundamental concepts of data analysis, such as descriptive statistics, probability, and hypothesis testing.
- Practice using data analysis tools and techniques through online tutorials or exercises.
Review Supply Chain Planning Basics
Show steps
Review foundational concepts in supply chain planning prior to taking the course, enabling you to build a stronger base for learning.
Show steps
Show steps
Show steps
- Revisit definitions and concepts of supply chain planning, such as demand forecasting, inventory management, and transportation.
- Identify the key components and processes involved in supply chain planning.
- Consider real-world examples of successful supply chain planning.
Create a Course Resources Compendium
Show steps
Organize and review key course materials, including notes, assignments, quizzes, and exams, ensuring a comprehensive understanding of the subject matter.
Show steps
Show steps
Show steps
- Review all course materials, including notes, assignments, quizzes, and exams.
- Identify key concepts, definitions, and formulas.
- Categorize and organize the materials logically.
- Create a summary document or visual representation of the compiled materials.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete Step-by-Step Visualizations Tutorial
Show steps
Reinforce your understanding of creating visualizations by following guided tutorials that demonstrate step-by-step processes and techniques.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Select a step-by-step tutorial on creating visualizations using a preferred tool or software like Tableau or Power BI.
- Carefully follow the instructions in the tutorial to create a visualization.
- Analyze the resulting visualization and identify areas for improvement.
Solve PivotTable Practice Problems
Show steps
Enhance your proficiency in using PivotTables by solving practice problems, solidifying your understanding of data manipulation and analysis techniques.
Browse courses on
PivotTables
Show steps
Show steps
Show steps
- Find online resources or practice exercises that provide PivotTable problems.
- Solve the problems independently, focusing on data summarization and analysis.
- Check your solutions against provided answers or consult with peers for feedback.
Collaborate with Peers on Supply Plan Analysis
Show steps
Engage with fellow learners by collaborating on a Supply Plan analysis, fostering knowledge exchange, diverse perspectives, and improved understanding.
Browse courses on
Supply Chain Planning
Show steps
Show steps
Show steps
- Form study groups with peers to discuss and analyze the Supply Plan together.
- Share insights, identify patterns, and develop recommendations.
- Provide feedback and constructive criticism on each other's analysis.
- Prepare a joint presentation to share your findings and insights.
Build a Mini Supply Chain Model
Show steps
Apply your knowledge by creating a scaled-down model of a supply chain, enabling you to simulate real-world scenarios and gain practical experience.
Show steps
Show steps
Show steps
- Define the scope and parameters of your mini supply chain model.
- Gather data and identify key performance indicators to track.
- Build the model using appropriate tools or software.
- Simulate various scenarios and analyze the results.
- Identify areas for improvement and refine your model.
Produce a Comprehensive Supply Plan Presentation
Show steps
Synthesize your knowledge by creating a comprehensive presentation that effectively conveys the Supply Plan analysis, demonstrating your understanding of key concepts and ability to communicate findings.
Browse courses on
Supply Chain Planning
Show steps
Show steps
Show steps
- Review the Supply Plan, identify key insights, and develop a clear narrative.
- Design visually appealing and informative slides using appropriate charts, graphs, and data visualizations.
- Organize the presentation logically and ensure smooth transitions between slides.
- Practice delivering the presentation to gain confidence and improve your communication skills.
Career center
Learners who complete Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst collects, processes, and analyzes data to help businesses make informed decisions. This course can help you develop the skills needed to extract, clean, and analyze data. By creating visualizations based on your analysis, you gain the ability to prepare effective presentations and communicate your findings.
Business Analyst
Business Analyst
A Business Analyst helps businesses identify and solve problems through data analysis. This course provides a strong foundation in data analysis, specifically in the supply chain management field, preparing you to identify and address inefficiencies and drive business improvements.
Supply Chain Manager
Supply Chain Manager
A Supply Chain Manager manages the flow of goods and services within a company. This course will equip you with the knowledge to plan and manage supply chains effectively, optimizing resource allocation and ensuring efficient delivery.
Operations Manager
Operations Manager
An Operations Manager oversees the day-to-day operations of a company. This course will provide you with the skills needed to manage supply chain operations, ensuring smooth and efficient functioning.
Logistician
Logistician
A Logistician plans and manages the movement of goods and services. Through this course, you'll gain expertise in supply chain planning, allowing you to optimize logistics operations and ensure timely delivery.
Project Manager
Project Manager
A Project Manager plans, executes, and closes projects. This course will provide you with the skills needed to manage supply chain projects effectively, ensuring successful implementation and delivery.
Procurement Manager
Procurement Manager
A Procurement Manager is responsible for sourcing and purchasing goods and services. This course will provide you with the skills needed to manage supply chain procurement, ensuring cost-effective and timely acquisition of materials.
Inventory Manager
Inventory Manager
An Inventory Manager is responsible for managing inventory levels. This course will equip you with the knowledge and skills to optimize inventory management, minimizing waste and ensuring efficient operations.
Transportation Manager
Transportation Manager
A Transportation Manager is responsible for the movement of goods and services. This course will provide you with the skills needed to manage supply chain transportation, ensuring efficient and cost-effective delivery.
Warehouse Manager
Warehouse Manager
A Warehouse Manager is responsible for the day-to-day operations of a warehouse. This course will provide you with the skills needed to manage supply chain warehousing, ensuring efficient storage and retrieval of goods.
Demand Planner
Demand Planner
A Demand Planner forecasts demand for goods and services. This course will equip you with the knowledge and skills to analyze data and forecast demand, ensuring optimal supply chain planning and resource allocation.
Quality Control Manager
Quality Control Manager
A Quality Control Manager ensures the quality of goods and services. This course will provide you with the skills needed to manage supply chain quality control, ensuring compliance with standards and customer satisfaction.
Risk Manager
Risk Manager
A Risk Manager identifies and manages risks within a supply chain. This course may be useful in developing an understanding of risk management in supply chains, providing a foundation for identifying and mitigating potential risks.
Sustainability Manager
Sustainability Manager
A Sustainability Manager develops and implements sustainability strategies. This course may be useful in gaining an understanding of sustainability in supply chains, providing insights into environmental and social aspects of supply chain management.
Healthcare Analyst
Healthcare Analyst
A Healthcare Analyst analyzes data to identify trends and patterns in healthcare. This course may be useful in developing an understanding of data analysis in healthcare, providing a foundation for analyzing medical data and identifying opportunities for improvement.
For more career information including salaries, visit:
OpenCourser.com/course/yooo7h/using
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets.
This textbook provides a comprehensive overview of supply chain logistics management. It would be particularly useful for learners who want to gain a deeper understanding of the field.
Is commonly used by industry professionals. It provides a comprehensive overview of supply chain management and logistics, covering all the key concepts. It would be useful as an additional reading for learners who want to gain a deeper understanding of the field.
Provides a comprehensive overview of supply chain management, covering all the key concepts. It would be useful as an additional reading for learners who want to gain a deeper understanding of the field.
Provides a comprehensive overview of supply chain management, with a focus on logistics. It would be particularly valuable for learners who want to gain a deeper understanding of how to manage logistics operations.
Provides a comprehensive overview of supply chain management concepts and their practical applications. It covers topics such as supply chain design, inventory management, transportation, and logistics.
This textbook provides a comprehensive overview of supply chain analytics techniques. It covers topics such as data collection, data cleaning, data analysis, and data visualization.
Provides a practical guide to lean six sigma methodologies for improving supply chain performance. It covers topics such as process mapping, waste reduction, and continuous improvement.
Provides a visionary look at the future of supply chain management. It covers topics such as the digital supply chain, the circular economy, and the future of work.
Provides a simplified introduction to supply chain management concepts and their practical applications.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/yooo7h/using
Share
Similar courses
Here are nine courses similar to
Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets.
Supply Chain Design and Planning with Excel & Python.
OpenCourser.com/course/8ggbng/supply
Supply Chain Design and Planning with Excel & Python.
Most relevant
Supply Chain Planning
OpenCourser.com/course/v8odfe/supply
Supply Chain Planning
Most relevant
Supply Chain Planning and Strategy
OpenCourser.com/course/9qicwg/supply
Supply Chain Planning and Strategy
Most relevant
Supply Chains for Manufacturing: Inventory Analytics
OpenCourser.com/course/aqknwv/supply
Supply Chains for Manufacturing: Inventory Analytics
Most relevant
GST - Genesis and imposition!
OpenCourser.com/course/wu15xr/gst
GST - Genesis and imposition!
Most relevant
Supply Chain Software Tools
OpenCourser.com/course/qeopl7/supply
Supply Chain Software Tools
Most relevant
Supply Chain: Planning of Resources & Detailed Scheduling
OpenCourser.com/course/wapeit/supply
Supply Chain: Planning of Resources & Detailed Scheduling
Most relevant
AI and Gen-AI for Supply Chain Management
OpenCourser.com/course/n3zxwv/ai
AI and Gen-AI for Supply Chain Management
Most relevant
Demand Management in a Demand Driven Supply Chain
OpenCourser.com/course/jknhrv/demand
Demand Management in a Demand Driven Supply Chain
Most relevant
Effort
1.5
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Mark Veljkov
Language
English
Good to know
Prepares learners to create and lead real-world supply chain plans
Supply chain professionals seeking to improve their skills in supply chain planning
Teaches learners how to create critical visualizations and presentation materials for data-driven reporting
Requires learners to come into the course with a foundational knowledge of data analysis and statistical software
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser