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

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

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

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

Advanced Models for Decision Making

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

О курсе

Business analysts need to be able to prescribe optimal solution to problems. But analytics courses are often focused on training students in data analysis and visualization, not so much in helping them figure out how to take the available data and pair that with the right mathematical model to formulate a solution. This course is designed to connect data and models to real world decision-making scenarios in manufacturing, supply chain, finance, human resource management, etc. In particular, we understand how linear optimization - a prescriptive analytics method - can be used to formulate decision problems and provide data-based optimal solutions. Throughout this course we will work on applied problems in different industries, such as: (a) Finance Decisions: How should an investment manager create an optimal portfolio that maximizes net returns while not taking too much risks across various investments? (b) Production Decisions: Given projected demand, supply of raw materials, and transportation costs, what would be the optimal volume of products to manufacture at different plant locations? (c) HR Decisions: How many workers need to be hired or terminated over a planning horizon to minimize cost while meeting operational needs of a company? (c) Manufacturing: What would be the profit maximizing product mix that should be produced, given the raw material availability and customer demand? We will learn how to formulate these problems as mathematical models and solve them using Excel spreadsheet.

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

Mathematical ModelingMicrosoft ExcelInventory ControlWorkforce PlanningManufacturing OperationsSupply Chain PlanningBusiness AnalyticsFinancial ModelingAnalyticsBusiness AnalysisResource PlanningResource AllocationTransportation, Supply Chain, and LogisticsCash ManagementApplied MathematicsProduction ProcessSupply ChainOperations ManagementOperations ResearchWorkforce Management

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

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

01Module 1: LPs for Financial Decisions17 материалов

"Advanced Models for Decision Making" Course Introduction

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

Module 1 Lesson 1: An Investment Problem

Module 1 Overview: LPs for Financial DecisionsВидео

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

Soumya Sen

Associate Professor

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 13.8 ч

4 модулей

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

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

Часть программы вашего университета
An Investment Decision ProblemВидео
Formulating an Investment Optimization ProblemВидео
Entering the Investment Optimization Problem in ExcelВидео
Finding the Optimal Investment StrategyВидео
Understanding the Impact of Parameter ChangesВидео
Applications of Linear OptimizationЧтение

Module 1 Lesson 2: A Multi-Period Financial Problem

A Multi-Period Cash Flow Decision ProblemВидеоFormulating a Cash Flow Optimization Problem Part 1ВидеоFormulating a Cash Flow Optimization Problem Part 2ВидеоEntering the Cash Flow Optimization Problem in ExcelВидеоFinding the Optimal Cash FlowВидео

Module 1 Exercises

Module 1 Practice Exercise: Banking Investments DecisionЗаданиеModule 1 Graded Exercise: Banking Loan DecisionЗадание
02Module 2: LP for Supply Chain Decisions12 материалов

Module 2 Lesson 1: A Transportation Problem

Module 2 Overview: LP for Supply Chain DecisionsВидеоA Transportation Decision ProblemВидеоFormulating a Transportation Problem Part 1ВидеоFormulating a Transportation Problem Part 2ВидеоEntering the Transportation Problem in ExcelВидеоSolving the Transportation ProblemВидео

Module 2 Lesson 2: A Production & Inventory Planning Problem

Model for Production and Inventory Decision ProblemВидеоFormulating an Inventory Planning Problem Part 1ВидеоFormulating an Inventory Planning Part 2ВидеоEntering the Inventory Planning in Excel Видео

Module 2 Exercises

Module 2 Practice Exercise: Army Transportation DecisionЗаданиеModule 2 Graded Exercise: A Car Manufacturing DecisionЗадание
03Module 3: LP for Staffing Decisions14 материалов

Module 3 Lesson 1: A Staffing Scheduling Problem

Module 3 Overview: LP for Staffing DecisionsВидеоThe Model Setup for Staffing Decision ProblemВидеоFormulating a Staffing Decision Problem Part 1ВидеоFormulating a Staffing Decision Problem Part 2ВидеоEntering the Problem in ExcelВидеоSolving the Staffing Decision Problem in ExcelВидеоSolving the Inventory Planning ProblemВидеоWhy Prescriptive Analytics and Decision optimization are Crucial (IBM)Чтение

Module 3 Lesson 2: Office Assignment Decision Problem

The Model Setup for Office Assignment DecisionsВидеоFormulating the Office Assignment Decision ProblemВидеоEntering the Office Assignment Problem in ExcelВидеоSolving the Office Assignment Decision ProblemВидео

Module 3 Exercises

Module 3 Practice Exercise: An Amusement Park Staffing DecisionЗаданиеModule 3 Graded Exercise: An Airline Pilot Staffing DecisionЗадание
04Module 4: LP for Production Decisions17 материалов

Module 4 Lesson 1: A Product Mix Problem

Module 4 Overview: LP for Production DecisionsВидеоThe Model Setup for a Product Mix ProblemВидеоFormulating a Product Mix Optimization ProblemВидеоSetting up the Product Mix problem in ExcelВидеоSolving the Product Mix Optimization ProblemВидео

Module 4 Lesson 2: A Blending Problem

The Model Setup for a Blending Optimization ProblemВидеоFormulating a Blending Optimization ProblemВидеоSetting Up the Blending Decision Problem in ExcelВидеоSolving the Blending Optimization ProblemВидеоUsing Linear Optimization to Improve the WorkplaceОбсуждение

Module 4 Exercises

Module 4 Practice Exercise: A Pharmaceutical Company's DecisionЗаданиеModule 4 Graded Exercise: Electronics Product Mix DecisionsЗаданиеAnalytics Trends 2021 and BeyondЧтениеCongratulations on Finishing the "Advanced Models 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Чтение