← Back to Hub ← 返回主页

Week 8: Model Components (Part 2) 第 8 周：模型组件（二）

Learning Objectives 学习目标

  • Perform What-If analysis and Scenario Manager setups.
  • Differentiate What-If from Goal Seeking.
  • Explain Data Mining concepts and Model Base Management System features.

Step-by-Step Guide 分步指南

5.4 Data Mining Concepts

  • Data Mining Definition: The process of identifying valid, novel, potentially useful, and ultimately understandable patterns in structured and unstructured datasets.
  • Core Applications:
    • Market Basket Analysis: Identifying purchase affinities (e.g., customers who buy Bread also buy Butter).
    • Customer Churn Prediction: Modeling customer behaviors to predict when they will cancel a service.
    • Fraud Detection: Analyzing transaction variances to detect stolen credit cards.

Real-world Case: Capital One

  • Capital One uses data mining algorithms to analyze transactional velocity and geographic location.
  • If card purchase anomalies are detected (e.g., gas purchase in London 10 mins after dining in NY), the card is frozen immediately.

Reference: Capital One Data Analytics Strategy

5.5 Model Base Management System (MBMS)

  • MBMS Functions: Coordinates model execution, model storage, updates models dynamically, and allows linking of different models.
  • Goal Seek Optimization: A backwards-calculation analytical tool. User specifies a desired final result (target), and the system calculates the necessary input value (e.g., finding interest rate needed to hit a target monthly payment).
  • What-If Scenario Analysis: A forwards-calculation analytical tool. User changes input variables (e.g., product cost rises by 10%), and the system calculates the resulting shift in total profit.

Real-world Case: Tesla

  • Tesla planners run What-If simulations on supply chain models to observe total cost changes if raw lithium pricing fluctuates.
  • They use Goal Seek to find the exact battery cell production efficiency required to sell the Model 3 at a target retail price.

Reference: Tesla Impact & Operations Report

What-If Analysis vs. Goal Seeking

Feature What-If Analysis (Scenario Manager) Goal Seeking
Flow Direction Forward Analysis: Input → Output Backward Analysis: Target → Input
User Operation User changes values of input cells manually or via scenarios. User sets target output cell value, solver changes inputs.
Variables Limit Can vary multiple inputs concurrently. Restricted to solving one input variable.
Typical Business Query What will profit be if marketing cost increases by 20%? What price should we set to achieve exactly $10k net profit?
Model Base Management (MBMS)

A software component that catalogs, builds, stores, and executes various computational models without requiring user code modification.

5.4 数据挖掘概念

  • 数据挖掘定义： 在结构化和非结构化数据集中识别有效、新颖、潜在有用且最终可理解的模式的过程。
  • 核心应用场景：
    • 购物篮分析 (Market Basket Analysis)： 识别购买关联性（例如，购买面包的客户也倾向于购买黄油）。
    • 客户流失预测 (Churn Prediction)： 对客户行为进行建模，以预测他们何时会取消服务。
    • 欺诈检测 (Fraud Detection)： 分析交易波动和异常，以检测被盗刷的信用卡。

真实企业案例：第一资本 (Capital One)

  • Capital One 使用数据挖掘算法来分析交易速度和地理位置。
  • 如果检测到信用卡刷卡异常（例如，在纽约用餐 10 分钟后在伦敦购买汽油），该卡将立即被冻结。

参考链接： Capital One 数据分析战略

5.5 模型库管理系统 (MBMS) & 决策分析

  • MBMS 功能： 协调模型运行、存储模型、动态更新模型，并允许将不同的模型进行串联。
  • 目标求解 (Goal Seek)： 逆向计算分析工具。用户指定一个期望的最终结果（目标），系统计算出达到此结果所需的输入值（例如，计算达到每月目标还款额所需的利率）。
  • What-If 情景分析： 正向计算分析工具。用户改变输入变量的值（例如，产品成本上涨 10%），系统计算出最终总利润的相应变化。

真实企业案例：特斯拉 (Tesla)

  • 特斯拉计划人员对供应链模型运行 What-If 模拟，以观察如果原材料锂价格波动时总成本的变化。
  • 他们使用 目标求解 (Goal Seek) 来计算电池单体生产效率必须达到的具体值，以便按目标零售价销售 Model 3。

参考链接： 特斯拉影响与运营报告

What-If 分析与目标求解对比

特性维度 What-If 分析（方案管理器） 目标求解 (Goal Seek)
分析流方向 正向分析：改变输入 → 观察输出 逆向分析：设定目标 → 计算输入
用户操作方式 用户手动或通过方案管理器修改输入单元格的值。 用户指定输出的目标数值，求解器自动推算输入值。
变量限制 可以同时变动多个输入参数变量。 通常局限于求解单个输入自变量。
业务提问示例 如果营销费用增加 20%，净利润将如何变化？ 要达到 1 万美元净利润，我们需要将售价定在多少？
模型库管理系统 (MBMS)

负责编目、构建、存储和执行各种计算模型的软件组件，用户无需修改底层代码即可运行模型。

Concept Visualization 概念可视化

Inputs (X)Results (Y)What-If (Forwards)Goal Seek (Backwards)

Educational Infographic 教学信息图

Visual concept map explaining the key module topic: 解释该模块核心主题的视觉概念图：

What-If Analysis Change Input → Observe Output Goal Seek Set Target Output → Solve Input

📊 Practical Decision Support Suite (Week 8) 📊 实用决策支持套件（第 8 周）

📗 Excel Goal Seek & What-If Scenario Manager

Master Goal Seek and Scenario Manager for business decision modeling:

  • Goal Seek Execution: Data Tab → What-If Analysis → Goal Seek.
    • Set cell: $I$4 (Net Operating Profit) To value: 100000.
    • By changing cell: $F$4 (Target Sales Units). Excel calculates the exact sales volume needed!
  • Scenario Manager: Create 3 Scenarios (Best Case: Price = RM 1,500; Base Case: Price = RM 1,200; Worst Case: Price = RM 900) to generate an executive Summary Table.

掌握用于商业决策建模的目标寻求 (Goal Seek) 和方案管理器 (Scenario Manager)：

  • 目标寻求操作步骤： 数据选项卡 → What-If 分析 → 目标寻求。
    • 设置单元格：$I$4（营业净利润） 目标值：100000。
    • 通过更改单元格：$F$4（目标销售数量）。Excel 会自动反算出所需的精确销售量！
  • 方案管理器： 创建 3 种方案（最佳情况：单价 = RM 1,500；基准情况：单价 = RM 1,200；最坏情况：单价 = RM 900），并生成高管总结报告。

🐍 Python Scikit-Learn Decision Tree Data Classifier

Run this Python script to train a decision tree classifier on customer metrics to predict enterprise software renewal likelihood:

运行此 Python 脚本，在客户指标上训练决策树分类器，以预测企业软件续约概率：

Tips 提示

Goal Seek is BACKWARDS (starts with target result), while What-If is FORWARDS (starts with input change). Differentiating this is highly critical for exam questions.
目标求解是逆向计算（从目标结果开始），而 What-If 是正向计算（从输入变化开始）。区分这一点对考试题目非常关键。

Knowledge Check 知识自测

1. Which analytics tool starts with a target result and works backward to find the input? 哪种分析工具从目标结果开始，逆向计算以寻找输入？

Show Explanation 显示解析
Correct Answer: Option 2 正确选项：选项 2

2. The process of finding transaction patterns in credit cards is called: 在信用卡中查找交易模式的过程被称为：

Show Explanation 显示解析
Correct Answer: Option 2 正确选项：选项 2

3. What-If analysis is classified as a: What-If 分析被分类为：

Show Explanation 显示解析
Correct Answer: Option 1 正确选项：选项 1

Practical Exercise 实践练习

Task 1: Excel PMT formula for monthly payment for 5% annual interest, 12 months, and 10000 principal. 任务 1: Excel PMT 公式：计算 5% 年利率、12 个月、10000 本金的月还款额。

Task 2: SQL query to update interest rate to 0.06 in 'Parameters' table where Name is 'Interest'. 任务 2: SQL 查询：更新 'Parameters' 表中 Name 为 'Interest' 的利率值为 0.06。

Task 3: Excel formula to find minimum value in cells C1 through C5. 任务 3: Excel 公式：寻找单元格 C1 到 C5 的最小值。

Revision Guide 复习指南

Revision Checklist:

  • I can define forward What-If analysis and Scenario comparisons.
  • I can execute Goal Seeking to find single variable targets in Excel.
  • I understand the function of a Model Base Management System (MBMS).

Key Concepts to Remember:

  • Data Mining Concepts:
    • Data Mining Definition: The process of identifying valid, novel, ...
    • Model Base Management System (MBMS):
      • MBMS Functions: Coordinates model execution, model storage, updat...

Matching Game 配对游戏

Match the term on the left with its definition on the right. 将左侧的术语与右侧的定义进行配对。

Goal Seek
Subsystem that coordinates and executes decision models协调和执行决策模型的子系统
Data Mining
Identifying novel patterns in large data warehouses在大型数据仓库中识别新颖的模式
MBMS
Backwards calculation to find input variable for a target output逆向计算以查找目标输出的输入变量
What-If
Forwards calculation to find result variable for an input shift正向计算以查找输入变化的结果变量