← Back to Hub ← 返回主页

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

Learning Objectives 学习目标

  • Define the core Decision Support System concepts.
  • Explain the components of a Business Intelligence framework.
  • Analyze the business utility of BI applications.

Step-by-Step Guide 分步指南

1.4 The Concept of Decision Support Systems

  • DSS Definition: An interactive, flexible, and adaptable computer-based information system specifically designed to support the solution of a non-structured management problem.
  • Key Characteristics: High adaptability, user-friendly graphical interface, flexible modeling capabilities, and supports both semi-structured and unstructured decision tasks.

Real-world Case: FedEx

  • FedEx developed a Route Optimization DSS to calculate complex, unstructured package delivery pathways.
  • The system adapts dynamically to daily changes in weather, traffic congestion, and package volume.

Reference: FedEx Route Optimization Success

1.5 A Framework for Business Intelligence

  • BI Definition: An umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies.
  • Core BI Components:
    • Data Warehouse: The source database containing consolidated historical data.
    • Business Analytics: Tools for mining, reporting, and online analysis (OLAP).
    • Business Performance Management (BPM): Executive monitoring dashboards and KPIs.
    • User Interface: Visual interactive dashboards.
  • DSS vs. BI Comparison: DSS is typically analyst-focused, construction-oriented, and handles individual decisions, whereas BI is enterprise-wide, executive-focused, and reporting-driven.

Real-world Case: Amazon

  • Amazon implements an enterprise-wide BI framework that feeds transaction data into huge data lakes.
  • Analytics models then automatically display daily sales KPIs on corporate performance dashboards.

Reference: Amazon AI and Big Data Analytics

The Business Intelligence (BI) Framework

Component Role in Framework Technical Elements Business Value
Data Warehouse Central Repository Database tables, ETL pipelines, metadata Provides a 'single source of truth' for business data
Business Analytics Data Analysis Data mining, forecasting, statistical modeling Identifies trends, patterns, and anomalies in sales or operations
Performance Mgmt Strategic Alignment KPI dashboards, balanced scorecards Monitors corporate performance against target goals
User Interface Interactive Visualization Web dashboards, interactive charts Allows users to easily slice, filter, and view reports

Real-World BI Example: Retail Performance

A global supermarket uses a BI system. Data Warehouse: integrates transactional database logs from thousands of checkouts. Analytics: detects that beer and diapers are often purchased together on Friday evenings. Dashboard: alerts branch managers to stock these items adjacent to each other, resulting in a 15% sales increase.

1.4 决策支持系统 (DSS) 概念

  • DSS 定义： 交互式、灵活且适应性强的基于计算机的信息系统，专门设计用于支持非结构化管理问题的解决方案。
  • 核心特征： 高度适应性、用户友好的图形界面、灵活的建模能力，支持半结构化和非结构化决策任务。

真实企业案例：联邦快递 (FedEx)

  • 联邦快递开发了路线优化 DSS，用于计算复杂的、非结构化的包裹递送路径。
  • 该系统可根据每天的天气、交通拥堵和包裹量的变化进行动态调整。

参考链接： 联邦快递路线优化成功案例

1.5 商业智能 (BI) 框架

  • BI 定义： 结合了架构、工具、数据库、分析工具、应用软件和方法论的综合性术语。
  • 核心 BI 组件：
    • 数据仓库 (DW)： 包含整合历史数据的源数据库。
    • 业务分析 (Analytics)： 用于数据挖掘、报表生成和联机分析 (OLAP) 的工具。
    • 业务绩效管理 (BPM)： 执行层监控仪表板与关键绩效指标 (KPI)。
    • 用户界面 (UI)： 可视化的互动式控制面板。
  • DSS 与 BI 的对比： DSS 通常侧重于分析师、面向系统构建、处理单项决策；而 BI 则是企业范围的、侧重于高管、以报表和关键指标驱动。

真实企业案例：亚马逊 (Amazon)

  • 亚马逊实施了企业范围的 BI 框架，将交易数据输入庞大的数据湖。
  • 分析模型随后会自动在公司业绩仪表板上显示每日销售 KPI。

参考链接： 亚马逊人工智能与大数据分析

商业智能 (BI) 系统框架

核心组件 框架角色 技术元素 商业价值
数据仓库 中央数据存储库 数据库表、ETL 流水线、元数据 为业务数据提供“单事实来源”
商业分析 数据深入分析 数据挖掘、预测分析、统计建模 识别销售或运营中的趋势、模式和异常值
绩效管理 战略目标对齐 KPI 仪表板、平衡计分卡 监控企业实际绩效是否达到预设目标
用户界面 交互式可视化 Web 仪表板、交互式图表 允许用户轻松切片、过滤并查看报表

真实 BI 案例：零售业绩优化

某全球连锁超市使用 BI 系统。 数据仓库： 整合数千个收银台的交易数据库日志。 商业分析： 发现周五晚上啤酒和尿布经常一起被购买。 仪表板： 警示门店经理将这些商品相邻摆放，使销售额提升了 15%。

Concept Visualization 概念可视化

1. Data Source2. Warehouse3. Analytics4. Dashboard

Educational Infographic 教学信息图

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

Data Warehouse Central Repository Cleaned Data Business Analytics Queries & Reports Data Mining BPM Matrix Performance & KPIs Portfolio scoring User Dashboard Interactive UI Visual Charts

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

📊 Power BI vs. DSS Architecture Comparison

Understand how DSS capabilities integrate with modern Business Intelligence (BI) tools:

  • Business Intelligence (BI): Focuses on reporting, data visualization, and querying historical databases (e.g. Power BI dashboards).
  • Decision Support Systems (DSS): Focuses on mathematical modeling, optimization (Excel Solver), and What-If scenario simulations.

📗 Excel BI Data Connection Setup

Data Tab -> Get Data -> From Database -> From SQL Server / Power BI Dataset Formula for BI Measure: =SUM(Sales_MYR) / COUNT(Transactions)

Tips 提示

Focus on understanding the four components of BI (DW, Analytics, BPM, UI) and how they differ from traditional DSS.
重点理解 BI 的四个组成部分（数据仓库、业务分析、业务绩效管理、用户界面）以及它们与传统 DSS 的区别。

Knowledge Check 知识自测

1. Which of the following is NOT a core component of a BI framework? 以下哪项不是 BI 框架的核心组件？

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

2. DSS focuses primarily on support for: DSS 主要侧重于支持：

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

3. A Business Performance Management (BPM) component in BI contains: BI 中的业务绩效管理 (BPM) 组件包含：

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

Practical Exercise 实践练习

Task 1: DAX query to calculate total sales from Sales[Amount] column. 任务 1: DAX 查询：计算 Sales[Amount] 列的总销售额。

Task 2: Write an SQL statement to count the total number of records in the 'Customers' table. 任务 2: 编写一个 SQL 语句，计算 'Customers' 表中的总记录数。

Task 3: Write an Excel formula to calculate the average of cells A1 through A10. 任务 3: 编写一个 Excel 公式，计算单元格 A1 到 A10 的平均值。

Revision Guide 复习指南

Revision Checklist:

  • I can define DSS concepts and how they differ from MIS.
  • I understand the four components of the Business Intelligence framework.
  • I can explain how BI helps organizations make data-driven decisions.

Key Concepts to Remember:

  • The Concept of Decision Support Systems:
    • DSS Definition: An interactive, flexible, and adaptable computer-...
    • A Framework for Business Intelligence:
      • BI Definition: An umbrella term that combines architectures, tool...

Matching Game 配对游戏

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

Business Analytics
Dashboard visualization for corporate metrics公司指标的仪表板可视化
BPM
Tools for OLAP, data mining, and interactive reporting用于 OLAP、数据挖掘和交互式报告的工具
User Interface
Historical repository of integrated corporate data整合公司数据的历史存储库
Data Warehouse
Performance monitoring and executive KPIs业绩监控和高管 KPI