刘潇:《决策支持系统与数据仓库》


Course Description

This course provides an overview of the theoretical and practical aspects of Decision Support Systems (DSS). The course consists of three modules. The first module concentrates on basic concepts on decision, decision-making, and kinds of DSS-model. The second module
discusses how to develop spreadsheet-based DSS using Excel and VBA, with an emphasis on data analysis from management decision perspective. The last module introduces most popular Enterprise DSS solution----Business Intelligence, which integrated database, data
warehouse, OLAP and data mining, with an emphasis on the process of data warehousing.

Learning Objectives
Following completion of this course, students are expected to: a) be familiar with basic DSS concepts; b) distinguish among individual, group and organizational DSS and specialized DSS tools and techniques; c) be aware of DSS implementation with Excel or BI tools, in the
real life decision situations; and d) gain some hands-on experiences by developing a small-scale DSS.

Course Format
This course will use lectures and labs as the primary learning formats. The course time is equally divided between lectures and labs. Lectures and labs are offered in parallel but with self-contained materials throughout the semester.
Lectures are on Wednesday from 10:20am – 12:10am and will typically take the form of some presentation of theoretical material and class discussion.
Lab sessions are arranged on Friday from 10:10am – 12:00am after the lecture sessions. The objective is to provide students with hand-on instructions and exercises on the development of DSS applications using Microsoft Excel, Visual Basic programming language and SQL
Server 2005, which is required by the course project.
Lecture slides and Case study background will be posted on BB by Friday in prior week to give students sufficient time to prepare the class. It is very important to read the assigned materials before attending class.

详细的课程介绍 >>

在线课件浏览:

  1-Introduction to course-课程介绍
  2-Introduction decision making-决策的基本概念
  3-Concepts of System-系统的基本概念
  4-Introduction to MSS-管理支持系统
  5-Concepts of DSS-DSS的概念及演化
  6-Frameworks of DSS-决策支持系统类型
  7-Introdution to Model-模型概述
  8-Breakeven point model-盈亏平衡模型
  9-Simulation modeling-仿真模型
  10-Data warehousing 数据仓库的概念
  11-OLAP and MDX--MDX基础
  12-Business Intelligent-商务智能简介

  13-Case study-案例研究-Foodmart公司的客户价值评价和客户细分
  13-Case study参考阅读-Mining changes in customer behavior in retail marketing C