К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Optimization for Decision Making · LearnSpace
Назад в каталог
courseraАнализ данных

Optimization for Decision Making

Курс от University of Minnesota
Начальный≈ 13.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

In this data-driven world, companies are often interested in knowing what is the "best" course of action, given the data. For example, manufacturers need to decide how many units of a product to produce given the estimated demand and raw material availability? Should they make all the products in-house or buy some from a third-party to meet the demand? Prescriptive Analytics is the branch of analytics that can provide answers to these questions. It is used for prescribing data-based decisions. The most important method in the prescriptive analytics toolbox is optimization. This course will introduce students to the basic principles of linear optimization for decision-making. Using practical examples, this course teaches how to convert a problem scenario into a mathematical model that can be solved to get the best business outcome. We will learn to identify decision variables, objective function, and constraints of a problem, and use them to formulate and solve an optimization problem using Excel solver and spreadsheet.

Навыки, которые вы освоите

Model OptimizationMathematical ModelingMicrosoft ExcelOperations ResearchDecision MakingAnalyticsData-Driven Decision-MakingBusiness ModelingBusiness MathematicsGraphingSpreadsheet SoftwareProcess OptimizationBusiness AnalyticsApplied Mathematics

Программа курса

4 модулей · 51 учебных материалов

01Module 1: Introduction to Linear Programming 15 материалов

Course Introduction

"Analytics for Decision Making" Specialization OverviewВидео"Optimization for Decision Making" Course OverviewВидеоMeet Your Instructor: Soumya SenВидео

Module 1 Lesson 1: Optimization in Decision-Making Contexts

Module 1 Overview: An Introduction to Linear ProgrammingВидео

Учитесь у экспертов

Soumya Sen

Associate Professor

Optimization for Decision Making
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 13.6 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Гаитянский, Тайский, Индонезийский, Шведский, Турецкий, Испанский, Дари, Хинди, Японский, Казахский, Польский

Часть программы вашего университета
Modeling Approaches to Decision MakingВидео
Applications of Optimization – Part 1Видео
Applications of Optimization – Part 2Видео
Read this article on Optimization in Prescriptive AnalyticsЧтение
What are some problems you could reformulate into optimization problems?Обсуждение

Module 1 Lesson 2: Optimization Formulation

How to Setup a Linear Optimization ProblemВидеоOak Barrel Brewery: An Example Linear Program ProblemВидео

Module 1 Lesson 3: A Linear Programming Exercise

Luxury Sofas Problem: A Practice ExerciseВидеоSolution to the Luxury Sofas Practice ProblemВидео

Module 1 Wrap Up

Module 1 Practice ExerciseЗаданиеModule 1 Graded ExerciseЗадание
02Module 2: Solving Linear Programs10 материалов

Module 2 Lesson 1: Graphical Methods for Optimization Solution

Module 2 OverviewВидеоSolving Linear Optimization Problems - Part 1aВидеоSolving Linear Optimization Problems - Part 1bВидеоSolving Linear Optimization Problems - Part 2ВидеоSolving Linear Optimization Problems - Part 3Видео

Module 2 Lesson 2: Sample Problem - Solving a Production Optimization Problem

Example Problem: How Many Items of Two Products Should a Manufacturer Produce? (Part 1)ВидеоExample Problem: How to Plot the Feasible Region of the Problem (Part 2)ВидеоExample Problem: Finding the Optimal Solution for the Problem (Part 3)Видео

Module 2 Wrap Up

Module 2 Practice Exercise: A Retail Butcher ShopЗаданиеModule 2 Graded Exercise: Giapetto's Woodcarving CompanyЗадание
03Module 3: Alternative Specifications & Special Cases in Linear Optimization9 материалов

Lesson 1: Alternative Specifications and Shadow Prices

Module 3 Overview: Alternative Specifications and Shadow PricesВидеоImpact of Changes to Model Parameters - Part 1ВидеоImpact of Changes to Model Parameters - Part 2ВидеоWhat to Do When There are Multiple Optimal SolutionsВидео

Lesson 2: Special Conditions in LP Models

Redundant ConstraintsВидеоUnbounded SolutionsВидеоInfeasible SolutionВидео

Module 3 Wrap Up

Module 3 Practice Exercise: An Automobile ManufacturerЗаданиеModule 3 Graded Exercise: Dorian Auto ManufacturerЗадание
04Module 4: Modeling & Solving Linear Problems in Excel17 материалов

Lesson 1: Solving Optimization in Excel

Module 4 Overview: Modeling & Solving Linear Problems in ExcelВидеоIntroduction to Spreadsheet SolversВидеоSteps in Implementing an LP Model in ExcelВидеоOrganizing LP model data in ExcelВидео

Lesson 2: Example Solutions with Excel Solver

Optimal Solution with Excel Solver - Example 1ВидеоOptimal Solution with Excel Solver - Example 2ВидеоOptimal Solution with Excel Solver - Example 2 SolutionВидео

Lesson 3: A Computer Gaming Company's "Make Versus Buy" Decision Problem Case Example

Case Exercise: "Make vs. Buy" Decision (A Computer Gaming Company)ВидеоMake vs. Buy Decision: LP FormulationВидеоMake vs. Buy Decision: Excel Solution Part 1 (Set Up the Problem)ВидеоMake vs. Buy Decision: Excel Solution Part 2 (Using Excel Solver)Видео

Module 4 Wrap Up

Module 4 Practice Exercise: Calmetal, a Manufacturing Firm ExampleЗаданиеModule 4 Graded Exercise: A Medical Device ExampleЗаданиеCongratulations on Finishing the "Optimization for Decision Making" CourseВидео

OPTIONAL Lesson: Master of Science in Business Analytics (MSBA) Program

Carlson School of Management: Master of Science Program in Business Analytics (MSBA)ВидеоCarlson School of Management: MSBA Program WebsiteЧтениеManagement Information Systems (MIS) Research CenterЧтение