Strategic: Long-term, senior executives, unstructured decisions.
Tactical: Mid-term, resource acquisition and control, semi-structured.
Operational: Short-term, daily transactions, structured and highly automated.
战略级： 长期计划、高级管理人员、非结构化决策。
战术级： 中期计划、资源获取与控制、半结构化决策。
操作级： 短期运行、日常事务交易、结构化且高度自动化。
Intelligence: Problem identification and data collection.
Design: Formulating and examining alternative paths.
Choice: Selecting the optimal path based on metrics.
Implementation: Operationalizing the solution.
情报阶段： 识别问题并收集相关数据。
设计阶段： 构想、制定并审查备选方案。
抉择阶段： 根据标准选择最佳方案。
实施阶段： 将选定方案付诸实际运行。
Explicit: Structured, written down, codified, and easily shared via IT repositories.
Tacit: Hard to formalize, experience-based, resides in minds. Codified using AI summarizing.
显性知识： 结构化的、书面记录的、易于通过 IT 仓库系统进行传授和分享。
隐性知识： 难以公式化、基于实践经验、存在于脑海中。可以使用 AI 总结进行编码。
Roll-Up: Aggregates data (less detail).
Drill-Down: Breaks data down (more detail).
Slice: Selects one dimension slice.
Dice: Filters on multiple dimensions.
上卷 (Roll-Up)： 聚合数据（细节减少）。
下钻 (Drill-Down)： 细分数据（细节增加）。
切片 (Slice)： 过滤并选出单个维度切片。
切块 (Dice)： 跨多个维度进行多维过滤。
Optimization: Finds the mathematically best solution (e.g., Linear Programming Simplex LP).
Descriptive: Simulates dynamic behaviors without solving for the single best option (e.g., Monte Carlo simulation).
Predictive: Forecasts future outcomes based on historical patterns.
优化模型： 寻找数学上的最佳解（例如线性规划单纯形 Simplex LP）。
描述性模型： 模拟动态系统行为而不直接求解单一最佳方案（例如蒙特卡洛模拟）。
预测模型： 基于历史规律和模式预测未来结果。
Data Mining: Discovers hidden trends, customer segments, and fraud vectors from transactional datasets.
What-If Analysis: Explores outputs by varying inputs (Scenario Manager).
Goal Seeking: Solves for the required input to achieve a target output value.
数据挖掘： 从交易数据集中发现隐藏趋势、客户细分和欺诈向量。
What-If 分析： 通过变动输入参数来观察输出结果变化（方案管理器）。
目标寻求 (Goal Seek)： 反向计算出达到特定预设目标输出值所需的输入值。
Design Goals: Minimized cognitive load, consistency, task efficiency, and visual clarity.
Command-line (CLI): Text-based syntax, high control but steep learning curve.
Menu-driven: Structured hierarchical choices, easy to learn.
GUI: Dynamic manipulation via charts and widgets.
设计目标： 认知负荷最小化、一致性、任务执行效率和视觉清晰度。
命令行交互 (CLI)： 基于文本的语法，控制力强但学习曲线陡峭。
菜单驱动交互： 结构化的分层选择，易于学习和操作。
图形界面 (GUI)： 通过图表和小部件进行动态可视化操作。
Navigation controls: Sidebars and tabs to switch tabs.
Data entry widgets: Sliders, inputs, and dropdown selectors.
Visual display panels: Charts, data tables, and KPI cards.
Notifications: Warnings and alert badges for threshold violations.
导航控件： 用于切换选项卡和页面的侧边栏与标签页。
数据输入小部件： 滑块、文本框和下拉选择器。
可视化显示面板： 图表、数据表和 KPI 卡片。
通知区域： 用于警告阈值超限和异常警示的徽标与弹窗。
Technical Feasibility: Availability of technology, hardware, and analytical skills.
Economic Feasibility: Cost-benefit ratios, capital expenditures, and ROI projection.
Organizational Feasibility: Alignment with corporate processes and user acceptance.
技术可行性： 技术工具、硬件资源和分析技能的可用性。
经济可行性： 成本效益对比分析、资本支出和投资回报率 (ROI) 预测。
组织可行性： 系统设计与企业业务流程的契合度及用户接受度。
Presentation Layer: Web-based client interface where users interact.
Application/Logic Layer: Mid-tier servers handling modeling calculations, business rules, and solvers.
Data Layer: The underlying database systems, ETL engines, and historical warehouses.
表示层 (Presentation)： 用户交互的基于 Web 的客户端界面。
应用/逻辑层 (Application/Logic)： 处理建模分析计算、业务规则和求解器的中间件服务器。
数据层 (Data)： 底层的数据库系统、ETL 引擎和历史数据仓库。
Use Case Diagrams: Illustrates system features, boundaries, and actor interactions (e.g., Administrator, Manager).
Sequence Diagrams: Chronicles dynamic, time-ordered user-system message streams and object lifelines.
用例图 (Use Case)： 图示展示系统功能范围、边界以及不同角色（如管理员、经理）的交互。
顺序图 (Sequence)： 按时间轴顺序描述用户与系统之间的动态消息交互流及对象生命周期。
Class Diagrams: Defines database entity tables, private attributes (`-`), public operations (`+`), and multiplicities (e.g., `1..*`).
OO Benefits: Allows model reusability, modular solver swaps, and clean data encapsulation.
类图 (Class)： 定义静态数据库实体表，规定私有属性 (`-`)、公共方法 (`+`) 和关联多重性规则（如 `1..*`）。
面向对象优势： 提供模型可重用性、求解器模块化替换及清晰的数据封装。
Direct Cutover: High risk, low cost; immediate shutdown of old system.
Parallel Running: Low risk, high cost; both systems run concurrently.
Phased Rollout: Incremental module activation.
Pilot Study: Departmental trial deployment first.
直接切换： 高风险、低成本；立即停用旧系统并启用新系统。
并行运行： 低风险、高成本；新旧两套系统同时运行以防出错。
分阶段引入： 增量式按模块逐步激活部署。
试点研究： 先在单个部门开展试运行部署。
User Acceptance Testing (UAT): Validates that the system operates per business specifications.
Evaluation Metrics: Measures execution speeds, calculations accuracy, decision quality improvement, and user satisfaction.
用户验收测试 (UAT)： 验证系统运行是否契合企业最初的业务规划要求。
评估指标： 评估处理速度、计算准确度、决策品质改善度以及最终用户满意度。
Business Context: An IT consultancy wants to achieve a Target Net Operating Profit of MYR 150,000. Determine how many software licenses must be sold.
Step-by-Step Setup:
RM 80,000, Selling Price = RM 2,500, Variable Cost = RM 800.I4: =(F4 * D4) - (B4 + (F4 * C4)).$I$4 | To Value: 150000 | By Changing Cell: $F$4 (Sales Units).业务背景： 一家 IT 咨询公司希望实现 150,000 令吉 (MYR) 的目标营业净利润。确定需要销售多少套软件许可。
分步操作指南：
RM 80,000，销售单价 = RM 2,500，单位可变成本 = RM 800。I4 输入利润公式： =(F4 * D4) - (B4 + (F4 * C4))。$I$4 | 目标值：150000 | 可变单元格：$F$4（销售数量）。Business Context: Optimize production quantities for 3 products (Standard DSS, Premium BI, Custom AI) to maximize total profit under development hour and server capacity limits.
Step-by-Step Setup:
G7: =SUMPRODUCT(Unit_Profits, Production_Units).$G$7 → Max.$F$4:$F$6 (Production Units).$C$4:$C$6 <= $E$4:$E$6 (Resource Limits).业务背景： 优化 3 种产品（标准 DSS、高级 BI、定制 AI）的生产数量，在开发工时与服务器容量限制下实现总利润最大化。
分步操作指南：
G7： =SUMPRODUCT(单位利润, 生产数量)。$G$7 → 最大值 (Max)。$F$4:$F$6（生产数量）。$C$4:$C$6 <= $E$4:$E$6（资源上限）。Business Context: Compare 3 strategic market scenarios (Best Case, Base Case, Worst Case) based on fluctuating selling prices and costs.
Step-by-Step Setup:
$D$4:$E$4, Values = Price: 3000, Cost: 600.$D$4:$E$4, Values = Price: 1800, Cost: 1000.$I$4. Excel generates a consolidated side-by-side executive scenario table!业务背景： 基于波动的销售单价与成本，对比 3 种战略市场方案（最佳情况、基准情况、最坏情况）。
分步操作指南：
$D$4:$E$4，设定值 = 单价: 3000, 成本: 600。$D$4:$E$4，设定值 = 单价: 1800, 成本: 1000。$I$4。Excel 将自动生成并列的高管方案总结对比表！Predict future quarterly revenue using Excel Forecast Sheet and Exponential Smoothing:
使用 Excel 预测工作表和指数平滑法预测未来季度收入：
Build an interactive enterprise dashboard connecting raw CSV datasets:
DBSS2643_Enterprise_BI_Dataset.csv into Power BI Desktop / Looker Studio.Profit Margin % = DIVIDE(SUM(Net_Profit_MYR), SUM(Gross_Revenue_MYR), 0).构建连接原始 CSV 数据集的交互式企业级仪表板：
DBSS2643_Enterprise_BI_Dataset.csv 导入 Power BI Desktop 或 Looker Studio。Profit Margin % = DIVIDE(SUM(Net_Profit_MYR), SUM(Gross_Revenue_MYR), 0)。Scope: Chapters 1–4. Test your knowledge against official course quiz questions: 范围：第 1–4 章。基于官方课程测验试卷进行自测：
1. Which of the following best defines a Decision Support System (DSS)?以下哪项最准确地定义了决策支持系统 (DSS)？
2. In Simon’s Phases of Decision Making, which phase involves scanning the environment to identify conditions requiring a decision?在西蒙的决策阶段模型中，哪一个阶段涉及扫描环境以识别需要决策的条件？
3. Knowledge that is subjective, personal, and hard to formalize is known as:主观的、个人化的且难以公式化的知识被称为：
4. A Data Warehouse is characterized by which of the following?数据仓库具有以下哪项特征？
5. What does ETL stand for in the context of data warehousing?在数据仓库上下文中，ETL 代表什么？
6. Which component of a DSS is responsible for storing and managing the mathematical and analytical models?DSS 的哪一个组件负责存储和管理数学和分析模型？
7. “What-if” analysis is primarily associated with which DSS capability?“What-if”分析主要与 DSS 的哪项功能相关联？
8. Which of the following is NOT one of the three fundamental components of a DSS architecture?以下哪项不属于 DSS 架构的三大基本组件？
9. Metadata is best defined as:元数据 (Metadata) 的最佳定义是：
10. OLAP (Online Analytical Processing) tools are primarily used for:OLAP（联机分析处理）工具的主要用途是：
Core Concept: Differentiate between Structured and Unstructured decisions with practical examples.
Core Concept: Describe the three (3) main components of a DSS architecture (Data, Model, Dialog).
Scenario A: A logistics company implements an Excel solver model to schedule route timelines. This represents: 场景 A：物流公司应用 Excel 求解器模型规划路线时间表。这代表：
Scenario B: A store manager runs a Power BI dashboard query to inspect last month's inventory totals. This represents: 场景 B：商店经理运行 Power BI 仪表板查询来检查上个月的库存总量。这代表：
Write the Excel PMT formula to calculate monthly payments for: 6% annual rate, 24 periods, and $15,000 loan. 编写 Excel PMT 公式以计算月还款额：年利率为 6%，还款期为 24 个月，贷款本金为 15,000 美元。
Write a UML class notation line representing a private attribute named 'salary' of type double. 编写一个 UML 类声明文本，表示一个类型为 double、名为 salary 的私有属性。
Interact with real-time decision support widgets below to visualize What-If sensitivity, Goal Seek targets, Decision Trees, and OLAP Cube operations: 与下方实时决策支持小部件交互，直观体验 What-If 敏感性分析、目标寻求、决策树和 OLAP 立方体操作：
Adjust market probabilities to see how the Expected Monetary Value (EMV) updates live on the decision tree diagram:
Click buttons to simulate Roll-Up, Drill-Down, Slice, and Dice operations on the data cube:
Download full template workbooks, sample CSV datasets, DAX libraries, and Looker Studio guides:
| Decision Domain | Metric Name | Excel Formula Syntax | DSS Decision Utility |
|---|---|---|---|
| What-If Analysis | Break-Even Volume | =Fixed_Cost / (Price_Per_Unit - Variable_Cost_Per_Unit) |
Calculates minimum sales units needed to avoid loss. |
| Optimization | Max Profit (Solver LP) | =SUMPRODUCT(Unit_Profits, Optimal_Production_Units) |
Linear Programming solution under resource constraints. |
| Risk Analytics | Expected Monetary Value (EMV) | =SUMPRODUCT(State_Probabilities, Strategy_Payoffs) |
Decision Tree evaluation under uncertainty. |
| Capital Budgeting | 3-Year Net Present Value (NPV) | =NPV(Discount_Rate, Cash_Flow_Y1, Cash_Flow_Y2, Cash_Flow_Y3) - Initial_Capex |
Evaluates IT DSS project financial feasibility. |
| Loan Financing | Monthly Payment (PMT) | =PMT(Annual_Rate / 12, Total_Months, -Loan_Principal) |
Determines monthly debt service for hardware acquisitions. |