|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/business-analytics-2
课程评论：没有评论
课程名称：高级商业分析：Excel优化与模拟 课程概述：本课程旨在帮助学习者掌握使用Excel构建和分析模型以解决现实商业问题的高级技能。参与者将学习如何运用Solver优化决策过程，进行敏感性分析以改进模型结果，并应用高级整数规划技术处理复杂情境。课程还涵盖了解决分配和运输问题的复杂方法，并介绍了模拟技术以分析不确定性。 课程大纲： 1. **Excel建模：初级到高级** - 本模块对如何在Excel中建模商业问题及使用Solver求解进行快速回顾。 2. **敏感性分析** - 学习线性规划问题的公式化和利用Excel Solver求解的基础，随后介绍敏感性分析。此分析帮助我们检查在某些参数变化时，最优解是否会改变，并估算潜在利润损失。 3. **高级整数规划** - 深入学习整数规划，这是一种要求决策变量为整数的优化技术。模块通过Excel的Solver来建模和解决高级整数规划问题，帮助应对如生产数量、预算限制内的项目选择等离散决策。 4. **高级运输问题** - 本模块聚焦于解决实际物流与运营挑战，教授如何使用数学模型和优化技术高效分配任务和运输商品。通过评估解决方案的可行性与最优性，提升决策能力。 5. **模拟** - 本模块介绍模拟这一建模工具，用于分析复杂系统，特别是在不确定性和波动因素显著的情况下。学习如何在Excel中实施模拟，以支持决策和风险分析，适用于财务预测、库存管理和项目调度等多种商业分析问题。 通过本课程，您将掌握一系列实用的分析技能，提升对复杂商业问题的解决能力。
Name:Modeling in Excel: Elementary to Advanced
Description:In this module, we do a quick review of how to model business problems in Excel and how to solve for them using Solver.
Name:Sensitivity Analysis
Description:We have learned about how to formulate linear programming problems and how to solve them using Excel Solver. In this module, we will learn about sensitivity analysis. So far in all of our models, we assumed that we know every coefficient with certainty. This unfortunately is hardly the case in real life. Sensitivity analysis allows us to quickly check whether our optimal solution changes when certain parameters change. For example, what if you were not able to receive as much supply as predicted? Would your optimal solution change? How much profit would you expect to lose? By the end of this module, you will know how to answer questions like these.
Name:Advanced Integer Programming
Description:In this module, we dive into the powerful technique of integer programming, a branch of optimization that requires decision variables to be whole numbers, making it particularly valuable for real-world business decisions. Unlike linear programming, integer programming is essential when dealing with constraints that require discrete decisions, such as determining the number of products to manufacture, selecting projects within budget limits, or optimizing logistics and workforce scheduling. Using Excel's Solver, you'll learn how to model and solve advanced integer programming problems. This module will equip you with a versatile and widely applicable skill set, helping you approach complex decisions with confidence and precision.
Name:Advanced Transportation Problems
Description:In this module, you will dive into the fascinating world of optimization and decision-making to tackle real-world logistical and operational challenges. Explore how businesses assign tasks efficiently, transport goods cost-effectively, and manage complex networks of supply and demand. You will learn to build mathematical models that represent these problems and master powerful optimization techniques. Discover how to evaluate solutions for feasibility and optimality, and transform mathematical results into strategic insights for decision-making in Excel using Solver. By the end of this module, you’ll have the skills and confidence to address complex business challenges and add significant value to organizational operations.
Name:Simulation
Description:In all of the optimization problems we studied, we assumed that the values of the parameters were known exactly. We tried to study the impact of uncertainty in our parameters through sensitivity analysis. While sensitivity analysis is useful, it cannot capture large deviations or simultaneous changes to many parameters. In this module, we will learn a new modelling tool called simulation. Simulation is a powerful technique used to model and analyze complex systems, especially when uncertainty and variability are key factors. In this module, we will explore how to use Excel to build simulations that aid in decision-making and risk analysis in business contexts. By learning to implement simulations in Excel, you will gain practical skills that can be applied to a variety of business analytics problems, including financial forecasting, inventory management, and project scheduling.
This course equips learners with advanced skills in building and analyzing models using Excel to solve real-world business problems. Participants will learn to optimize decision-making processes using Solver, conduct sensitivity analysis to refine model outcomes, and apply advanced integer programming techniques to tackle complex scenarios. The course also covers sophisticated methods for solving assignment and transportation problems and introduces simulation techniques to analyze uncertainty a
