← Back to Hub ← 返回主页

Week 1: Overview of Business Intelligence & Decision Support (Part 1) 第 1 周：商业智能与决策支持概述（一）

Learning Objectives 学习目标

  • Define computerized decision support systems and business intelligence frameworks.
  • Explain the levels of managerial decision-making (Strategic, Tactical, Operational).
  • Identify information system capabilities for decision support.

Step-by-Step Guide 分步指南

1.1 Changing Business Environment and Decision Support

  • Business Volatility: Modern environments are subject to rapid shifts in customer demand, global supply chains, and technology.
  • Information Overload: Managers are overwhelmed by structured and unstructured data from internal and external sources.
  • Need for Computerized Support: Traditional manual decisions are too slow and error-prone; DSS provides the speed and analytical depth needed.

Real-world Case: Walmart

  • Walmart utilizes global real-time inventory databases to monitor product levels across thousands of stores instantly.
  • This computerized support enables rapid restocking decisions before stockouts occur.

Reference: Walmart Supply Chain Success Model

1.2 Managerial Decision Making

  • Strategic Level: Long-term (1-5 years) decisions handled by senior executives (e.g., corporate mergers). Issues are unstructured.
  • Tactical Level: Mid-term (months-1 year) decisions handled by middle managers (e.g., budget allocation). Issues are semi-structured.
  • Operational Level: Short-term (days-weeks) decisions handled by frontline supervisors (e.g., daily employee scheduling). Issues are structured.

Real-world Case: Zara (Inditex)

  • Strategic: Executive decision to expand stores into a new country.
  • Tactical: Region managers deciding seasonal inventory layouts.
  • Operational: Store managers managing cashier shift scheduling daily.

Reference: Zara Rapid-Fire Fulfillment Case Study

1.3 Information System Support for Decision Making

  • Operational Support: Transaction Processing Systems (TPS) automate structured, high-volume tasks.
  • Tactical Support: Management Information Systems (MIS) provide summary reports, queries, and dashboard visualization tools.
  • Strategic Support: Executive Information Systems (EIS) offer prediction modeling, simulation, and industry-trend forecasting tools.

Real-world Case: General Electric (GE)

  • GE uses industrial IoT sensors to send machine transaction logs (TPS level) to central dashboards.
  • Executives then use simulation algorithms (EIS level) to predict machine fatigue and plan maintenance schedules.

Reference: GE Big Bet on IoT and Decision Support

Comparison Table: Managerial Levels

Decision Level Time Horizon Primary Users Decision Type Examples
Strategic Long-term (1-5 years) Senior Executives Unstructured Mergers, new product lines, factory location selection
Tactical Mid-term (months-1 year) Middle Managers Semi-structured Budget allocation, warehouse layout, marketing campaigns
Operational Short-term (days-weeks) Frontline Supervisors Structured Daily employee scheduling, inventory restocking, cashier balancing
Business Volatility

Frequent and rapid shifts in market demand, competitor actions, and technology that demand automated analytics.

Strategic Alignment

Ensuring that daily operational tasks directly feed into and support the long-term strategic goals of the company.

1.1 快速变化的商业环境与计算机决策支持

  • 商业波动性： 现代环境面临客户需求、全球供应链和技术的快速变化。
  • 信息过载： 管理者被来自内部和外部的结构化与非结构化数据所淹没。
  • 计算机化支持的需求： 传统的常规手动决策过慢且易出错；DSS 提供了所需的决策速度和分析深度。

真实企业案例：沃尔玛 (Walmart)

  • 沃尔玛利用全球实时库存数据库立即监控数千家门店的商品级别。
  • 这种计算机化决策支持使他们能够在发生缺货之前做出快速补货决策。

参考链接： 沃尔玛供应链成功模型

1.2 管理决策制定

  • 战略级： 由高级管理层处理的长期（1-5年）决策（例如，公司合并）。问题类型通常是非结构化的。
  • 战术级： 由中层经理处理的中期（数月-1年）决策（例如，预算分配）。问题类型通常是半结构化的。
  • 操作级： 由基层主管处理的短期（数天-数周）决策（例如，日常员工排班）。问题类型通常是结构化的。

真实企业案例：飒拉 (Zara)

  • 战略级决策： 高管决策将门店扩展到一个新的国家。
  • 战术级决策： 区域经理决定季节性库存布局。
  • 操作级决策： 门店经理管理每日收银员换班排班。

参考链接： Zara 快速响应履行案例分析

1.3 信息系统对决策制定的支持

  • 操作级支持： 事务处理系统 (TPS) 自动执行大量、常规的结构化任务。
  • 战术级支持： 管理信息系统 (MIS) 提供汇总报告、数据查询和仪表板可视化工具。
  • 战略级支持： 执行信息系统 (EIS) 提供预测建模、模拟和行业趋势预测工具。

真实企业案例：通用电气 (GE)

  • GE利用工业物联网传感器将机器运行日志（TPS级）发送到中央控制面板。
  • 高级管理层随后使用模拟算法（EIS级）来预测机器废损并安排维护计划。

参考链接： GE在物联网与决策支持上的大赌注

对比表：管理决策层级

决策层级 时间维度 主要用户 决策类型 典型示例
战略级 (Strategic) 长期 (1-5 年) 高级管理层 非结构化 企业并购、开设新产品线、选址新建厂房
战术级 (Tactical) 中期 (数月-1 年) 中层管理层 半结构化 预算分配、仓库布局调整、营销活动规划
操作级 (Operational) 短期 (数天-数周) 基层主管 结构化 日常员工排班、库存补货、收银机结算
商业波动性

市场需求、竞争对手行动和技术的频繁且快速的变化，需要自动化分析支持。

战略对齐

确保日常操作任务直接服务并支持公司的长期战略目标。

Concept Visualization 概念可视化

InputProcessOutput

Educational Infographic 教学信息图

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

Strategic Level Unstructured Goals Senior Executives Tactical Level Semi-Structured Mid-Level Managers Operational Level Structured Tasks 基层主管 / Frontline

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

📗 Excel Managerial Decision Hierarchy Matrix

Learn how to categorize strategic, tactical, and operational business decisions in Excel:

| Decision Level | Time Horizon | Decision Structure | Information Need | Excel Formula Example | |---|---|---|---|---| | Strategic | Long-Term (3-5 yrs) | Unstructured | Summary & External Data | =NPV(Discount_Rate, Future_Cash_Flows) | | Tactical | Mid-Term (1 yr) | Semi-Structured | Filtered Regional Data | =SUMIFS(Sales, Region, "North", Quarter, "Q3") | | Operational | Short-Term (Daily) | Structured | Detailed Transaction Data | =IF(Stock_Level <= Reorder_Point, "REORDER", "OK") |

🐍 Python Decision Level Classifier

Tips 提示

Always remember the chronological levels of decision-making: Strategic -> Tactical -> Operational. Strategic is handled by senior executive managers, operational by supervisors.
始终记住决策制定的层级顺序：战略级 -> 战术级 -> 操作级。战略级由高管处理，操作级由基层主管处理。

Knowledge Check 知识自测

1. Which level of decision-making deals with long-term goals? 哪种级别的决策制定涉及长期战略目标？

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

2. The IPO cycle in computer systems stands for: 计算机系统中的 IPO 循环代表：

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

3. Semi-structured decisions are defined as: 半结构化决策的定义是：

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

4. A major driver for computerized decision support is: 计算机化决策支持的主要驱动力是：

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

5. Operational control decisions deal primarily with: 操作控制级决策主要处理：

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

Practical Exercise 实践练习

Task 1: Excel formula to return 'Profit' if cells B5 (sales) is greater than C5 (cost), else 'Loss'. 任务 1: Excel 公式：如果单元格 B5（销售额）大于 C5（成本）则返回 'Profit'，否则返回 'Loss'。

Task 2: Write an SQL query to retrieve all active dashboards from a metadata table named 'Dashboards'. 任务 2: 编写一个 SQL 查询，从名为 'Dashboards' 的元数据表中检索所有状态为 Active 的仪表板。

Task 3: Power BI connects to data sources. Which editor tool is used to transform data before loading? 任务 3: Power BI 连接 to 数据源。在加载数据之前，使用哪个编辑器工具来转换数据？

Revision Guide 复习指南

Revision Checklist:

  • I can define computerized decision support and BI.
  • I understand the difference between Strategic, Tactical, and Operational decisions.
  • I can identify the capabilities of information systems in decision making.

Key Concepts to Remember:

  • Changing Business Environment and Decision Support:
    • Business Volatility: Modern environments are subject to rapid shi...
    • Managerial Decision Making:
      • Strategic Level: Long-term (1-5 years) decisions handled by senio...
      • Information System Support for Decision Making:
        • Operational Support: Transaction Processing Systems (TPS) automat...

Matching Game 配对游戏

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

DSS
Interactive computer support for decision making用于决策制定的交互式计算机支持
Strategic Level
Mid-term resource allocation and semi-structured decisions中期资源分配和半结构化决策
Operational Level
Long-term corporate goals and unstructured decisions长期公司目标和非结构化决策
Tactical Level
Short-term daily tasks and structured decisions短期日常任务 and 结构化决策