1 / 28

Mgt 240 Lecture

Mgt 240 Lecture. Decision Support Systems March 3, 2005. Miscellaneous. Exam 2 Week after spring break Sample questions are available Exam help session Monday, March 14 from 7-9pm in L050 Reading outlines available for material in text Review slides! Homework 4

dotty
Download Presentation

Mgt 240 Lecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mgt 240 Lecture Decision Support Systems March 3, 2005

  2. Miscellaneous • Exam 2 • Week after spring break • Sample questions are available • Exam help session Monday, March 14 from 7-9pm in L050 • Reading outlines available for material in text • Review slides! • Homework 4 • Correct answer for relational table structure question

  3. Reading Outlines • Questions?

  4. Decision Support Systems

  5. Programmed versus Nonprogrammed Decisions • Programmed decisions • Easy to computerize • Example? • Nonprogrammed decisions • Rules and relationships not defined • Problem is not routine • Not easily quantifiable • Example?

  6. What is a DSS? • A DSS is a computer-based tool, controlled by the end user, used to support and improve decision making in semi-structured and unstructured problem situations. • The DSS helps to impose structure on the decision-making process, and helps to bring together human judgment and computerized information. • The DSS supports but does not replace the role of the end user in the decision process.

  7. Components of a DSS

  8. Decision Making Stages

  9. Stages of the Decision Making Process: Intelligence • Problems or opportunities are identified or defined

  10. Intelligence Phase DSS tools • Excel • List capabilities: Sorting, filtering • Pivot tables • Charting • Gourmet1

  11. Intelligence Phase DSS Tools • Xcelsius • Overview • Executive Dashboard • Identify, track, trend, and correct problems as managers evaluate the health of key areas of their organization • Identify operational efficiencies • Proactively identify and apply corrective measures

  12. Executive Dashboard Features Dashboard Screen: The dashboard page displays the overall health of key performance indicators. Each box represents a key performance indicator (KPI) and the health for corresponding periods. The default executive dashboard shown can be unique to the individual logged in, or shared by the entire organization.

  13. Executive Dashboard Features View Screen: The View screen gives a snapshot picture of the key performance indicator (KPI). Charts display supporting data, while text details the criteria and justification for each KPI.

  14. Executive Support Systems (ESS) in Perspective • Tailored to individual executives • Easy to use • Drill down capabilities • Support need for external data • Can help when uncertainty is high • Future-oriented • Linked to value-added processes

  15. Capabilities of an ESS • Support for defining an overall vision • Support for strategic planning • Support for strategic organizing & staffing • Support for strategic control • Support for crisis management

  16. Stages of the Decision Making Process: Design • Alternative solutions to the problem or opportunity are developed

  17. Design Phase DSS Tools • Excel • What if analysis • Data tables • Scenario manager • Inn example • Meeting, Brainstorming, and Decision Making Tools for groups

  18. Characteristics of a GDSS • Special design • Ease of use • Flexibility • Decision-making support • Anonymous input • Reduction of negative group behavior • Parallel communication • Automated record keeping

  19. GDSS Alternatives

  20. The GDSS Decision Room

  21. Problem Solving or Choice Approaches • Optimization: find the best solution • Satisficing: find a good solution • Heuristics: rules of thumb

  22. Optimization, Satisficing, and Heuristic Approaches

  23. Stages of the Decision Making Process: Choice • Selecting a course of action • Excel • Solver • Sale example • Expert systems • Intended to perform at the level of a human expert in a particular domain • Decision Tree Analysis • Decision ToolPak • Add-in to Excel that facilitates construction of decision trees

  24. User Expert Knowledge Documented Knowledge User Interface Knowledge Engineer Inference Engine Blackboard Knowledge Base User Environment Development Environment Common Expert System Architecture

  25. Data Warehouses, Data Marts, and Data Mining • Data Warehouse - a database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers. • Data Mart – a subset of a data warehouse. • Data Mining - an information analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

  26. Elements of a Data Warehouse

  27. Common Data Mining Applications

  28. Comparison of OLAP and Data Mining

More Related