management information system instructor: fei tian associate professor cell: 13705606629 email:...

Management Information System

Instructor: Fei Tian Associate Professor

Cell: 13705606629Email: [email protected]: 210.45.208.10/dep/tf/index.htm

Session 14

mailto:[email protected]

Session 14

Decision-making Support Systems and Business Intelligence

[email protected] MIS 3-14:3/32

Agenda:

1. DSS

2. GDSS

3. ESS

4. Assignment


DECISION-SUPPORT SYSTEMS (DSS)

• DSS1) Computer system at the management level of

an organization

2) Combines data, analytical tools, and models

3) Supports semi-structured and unstructured decision-making


MIS and DSS

1. MIS 1) Provides reports based on routine flow

of data

2) Assists in general control of the organization

2. DSS – Emphasizes change, flexibility, rapid response,

models, assumptions, ad hoc queries, and display graphics


Types of Decision-Support Systems

1. Model-driven DSS– Primarily stand-alone – Uses model to perform “what-if” and other kinds of analy

sis

2. Data-driven DSS– Allows users to extract and analyze useful information fro

m large databases

3. Datamining– Finds hidden patterns and relationships in large databases

to infer rules– Knowledge discovery


Overview of a DSS


Example of DSS: Cargo Booking System

CargoBookingAgent Request

Cargo Size,Rate Data

CargoAvailabilityForecast

PassengerForecast Data

Confirm/Reject

1CARGO

RESERVATIONSYSTEM

2

FLIGHTSCHEDULE

SERVER

5

PASSENGERRESERVATION

SYSTEM

4

xxx

Availability/Minimum Price

PassengerBookingAgent

CARGOPROFREVENUE

MANAGEMENT SYSTEM

3


Components of Decision-Support Systems

1. DSS database: collection of current or historical data2. DSS software system: collection of software

tools/mathematical and analytical models 3. User interface: easy interaction4. Model5. Abstract representation illustrating components or

relationships 6. Sensitivity analysis

– Asks “what-if” questions repeatedly to determine the impact of change


Sensitivity Analysis


DSS for Supply Chain Management

1. Comprehensive examination of supply management chain

2. Searches for most efficient and cost-effective combination

3. Reduces overall costs

4. Increases speed and accuracy of filling customer orders


DSS for Customer Relationship Management

1. Uses data mining to guide decisions

2. Consolidates customer information into massive data warehouses

3. Uses various analytical tools to slice information into small segments


DSS for Customer Analysis and Segmentation


Agenda:

1. DSS

2. GDSS

3. ESS

4. Assignment


What Is a GDSS?

• GROUP DECISION-SUPPORT SYSTEMS (GDSS)

1) Interactive computer-based system

2) Facilitates solution to unstructured problems

3) Set of decision makers working together as a group


Elements of GDSS1. Hardware: Conference facility, electronic hardware2. Software tools: Tools for organizing ideas, gathering

information, and ranking and seeking priorities1)Electronic questionnaires2)Electronic brainstorming tools3)Idea organizers4)Questionnaire tools5)Tools for voting or setting priorities6)Stakeholder identification and analysis tools

3. People: Participants, trained facilitator, staff supporting hardware and software


GDSSGroup Interaction

SessionManager

SessionPlanning

IdeaGeneration

IdeaOrganization

Prioritizing

PolicyDevelopment

BrainstormingTopic Commenter

Group Outliner

Idea OrganizerIssue AnalyzerGroup Writer

Vote SelectionAlternative Eval.QuestionnaireGroup Matrix

Policy FormationStakeholder ID.

Organizational Memory

Enterprise AnalyzerGraphical BrowserGroup Dictionary

Brief Case• Access to information

• Personal productivity


How GDSS can Enhance Group Decision-Making

1. Improved preplanning

2. Increased participation

3. Open, collaborative meeting atmosphere

4. Criticism-free idea generation

5. Evaluation objectivity


Agenda:

1. DSS

2. GDSS

3. ESS

4. Assignment


Executive Support in the Enterprise--ESS

1.Executive Support Systems (ESS):1)Information system at strategic level of an

organization2)Addresses unstructured decision-making through

advanced graphics and communications

2.The Role of Executive Support Systems in the Organization1)Brings together data from the entire organization 2)Allows managers to select, access, and tailor data 3)Enables executive and any subordinates to look at

the same data in the same way


ESS for business intelligence

1. Identifies changing market conditions2. Formulates responses3. Tracks implementation efforts4. Learns from feedback5. Monitoring corporate performance: balanced

scorecard systems1)Model for analyzing firm performance2)Supplements traditional financial measures with

measurements from additional business perspectives


Enterprise Wide Reporting and Analysis

• Strategic performance management tools for enterprise systems

1) SAP: Web-enabled mySAP.com™, Management Cockpit

2) PeopleSoft: Web-enabled Enterprise Performance Management (EPM)

3) Oracle: Strategic Enterprise Management


决策支持系统与商业智能

• 企业活动1) 经营：在“市场机会”与“内部能力”间求取最大的平

衡与发展，以战略为主，同时也受到外部环境的制约。（ what ）

2) 管理：战术，（ how,who ）交易管理：交易，交易管理，企业功能决策管理 : 决策、规则（ SOP ）


未来应用软件

信息范围

流程管理 /信息管理

知识管理

交易自动化

内部的、单个的内部的、联合的供应链

经营领域

ERP 标准设置

以前的发展情况 ERP 数据库的基线功能自动化的排序

ERP 软件包的初级功能，同时具有捆绑软件的附加功能

高级决策支持系统经营智能软件包

供应链管理和集成


案例背景1.模拟了一家销售电子产品，书籍，电影和音乐的零售店在 2000-2001 年的销售情况

2.包含了 5 个层次（ 5 个角度）来勘察零售店的销售数据1)客户2)地理位置3)产品4)促销信息5)时间

3.包含了 10000 个客户信息和 40000 多条购买纪录4.从 5 个方面来形成零售店的商务智能报表

1)财务信息（利润，预测）2)人力资源信息3)投资信息4)产品销售信息5)供应商信息

5.OLAP 数据仓库仓库中1)数据仓库： \Tutorial\TUTORIAL_DATA_7200.mdb2)元数据库： \Tutotrial\TUTORIAL_METADATA_7200.mdb


数据模型—维和度量 “ 嘿 … 我卖掉了价值 1 亿美元的货物”

月份1 2 3 4 76 5

产品

牙膏

果汁可乐牛奶

奶油

肥皂

地区西

南北

维度：产品、地区、时间分层汇总路径产品地区时间行业国家年

类别地区季度产品城市月周部门天


Assignment for Session 14

• Individual Complete the review questions on pp.489: 1,3,6,12


Group Assignment for PART III

1. Reading textbook chapter 9 and 10

2. Group case study: write and submit and presentation

1) Amazon.com vs. Barnes & noble: the battle of the Bookstore. (pp.326-329)

2) Answer all questions.

management information system instructor: fei tian associate professor cell: 13705606629 email:...

Documents

customer information

useful information

customer analysis

decision makers

support systemsdss database

management level

organizationcombines

collection of current