Decision Support Systems Project | Excel, Minitab, & Cognos | Review Attached PDF

Decision Support Systems Project Guidelines (Team) 40%

Due April 30, 2015 at 9:00am in Moodle; presentation in Class

Build a data and business intelligence system. This can be an internal or external or both type of problem. Integrate the course concepts into Part I (1 and 2). Use references, at least 10; 3 must be academic. The report is to be structure as below and use the subheadings.

I hope we will have three Business Intelligence systems to work with. We have Cognos and Tableau to work with. This project requires presenting the data in Excel, Access, SPSS, Cognos and Tableau.

Part I (10%): Project Topic & Outline due

1. Define the problem. 2. Develop a proposal (Justification, Benefits, Integrate with course material and other internet and

academic research material) 3. Find data

Part II (10%) Due

4. Build an Access and Excel model. Build a MiniTab, SPSS or SAS data model. Show queries in Access and Excel. Show the appropriate analyses in SPSS.

5. Summary- What is this project all about. Find the appropriate academic literature. Research question- What are your research questions? Theses are to be supported with your data analyses. Contribution- What is the value of theses analyses?

6. What are the Attributes, Independent, and dependent variables? 7. What are the dimensions of the model?

Part III (20%) Build the BI model, write the report and PowerPoint Presentation; Present in class.

8. Implement the system using software using: Excel, Minitab or SPSS, Access, Cognos and Tableau.

9. Compare and contrast Cognos with Tableau. 10. Present the system- Demonstration of systems and presentation of steps 1-7, use overheads and

Presentation software (i.e. PowerPoint).

Graphs, charts, diagrams, tables, flow charts, pictures and drawings are welcome. This can be a real system or a potential system.