Session 17

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Tuesday, March 6, 2007

  • Demonstration of PlanningDSS.com, a model-driven, web-based group DSS
  • Submit Tutorial 2 "List Management and Pivot Tables". On p. 87 Figure 2-25 after step 3 print rows 1-7, page 103 step 6 print, page 108 print AgeAnalysis step 5 (values will differ from Fig. 2-45), page 113 step 3 print drill down results (values will differ from Fig. 2-49). (5 points)
  • Questions about Project Deliverable #2. Model specification and project plan (25 points); Due Tues., March 27. Example cost estimation for a custom bookcase.
  • Ask Dan! What do I need to know about Data Warehousing/OLAP?
  • Discuss Ch. 8. Building Data and Document-driven DSS
    1. How does a Data-driven DSS differ from a Document-driven DSS? analysis tools? type of data? type of users? type of decision questions? type of architecture? type of development approach used?
    2. What are 5 ways that managers can increase the chances for success of a data or a document-driven DSS?
    3. How do DSS and operating data differ? Data structures? Time span? Summarization? Data volatility? Data dimensions? Metadata?
    4. What are two examples of data dimensions?
    5. What is OLAP?
    6. What is an example of a document-driven DSS?
    7. Why is normalization not required (and is usually not desirable) for DSS data?
    
major features of data-driven DSS from a user's perspective:

 1) Ad hoc data filtering and retrieval. 

 2) Alerts and triggers. 

 3) Create data displays. 

 4) Data management. 

 5) Data summarization. 

 6) Excel integration. 

 7) Metadata creation and retrieval. 

 8) Report design, generation and storage. 

 9) Statistical analysis. 

 10) View predefined data displays. 

 11) View production reports.

To Do and Upcoming

  • For Class Session 18 -- Thursday, March 8
    1. Complete and submit Tutorial 3. On page 139 Enter your name in the left section of the worksheet header, print the CallAnalysis-3 workbook in landscape orientation so that both the data and chart are on the printout (see Figure 3-17). On page 151 add your name in the header of the Four Final Charts worksheet and print the Charts worksheet in landscape orientation. Complete and submit Case 2 step 4 p. 163-164. Submit 3 sheets. (5 points)
  • For Class Session 19 -- Tuesday, March 20
  • Read Vollmer Anderson Clayton and Documentum BFGoodrich (BFG) Aerospace Optimizing Aircraft Maintenance
  • Review for Exam #2 on Thursday, March 22; Format is 28 2 pt. multiple choice questions on DSS Book Ch. 5-8; 10 2 pt. multiple choice and short answer questions on Excel Tutorials; Choose 4 of 5 short answer questions (3 pts. each); and choose three (3) 4 pt. questions about assigned DSS cases (open book/notes). Total 100 points. Probably no Excel hands-on.