This assignment is intent to measure student ability to design and implement a data warehouse to support decision making.

Assignment 2

This assignment is intent to measure student ability to design and implement a data warehouse to support decision making. Students are given a choice to develop a data warehouse solution to support decision making of certain goals. Students can use Oracle Warehouse Builder (OWB) or any other tool to design and implement data warehouse. This project will be 80 points for the report and 20 points for the presentation.

The report should consist of the following sections:

1. Introduction (5 points)
1. Background information about the company and/or the industry related to the project 

2. Motivation of the project 

2. Project Objectives (5 points)
1. Define the objectives of the project? What is/are the problem(s) that the project seeks 
to solve? 

2. How can DW play a role in achieving these objectives? 

3. Data Sources utilized (5 points) 


a. What are databases or datasets used in the project
4. Extraction, transformation and loading processes (15 points)

a. How did the data get retrieved? integrated? cleaned? transform? loaded?

5. Data warehouse design (15 points)
1. Provide the design approach for the DW? 

2. Provide DW schema 

6. DW Implementation steps (15 points)
1. What is the software used to implement the DW? 

2. Steps undertaken to implement the DW 

7. Developing OLAP cubes, front-end application, and reports to support decision 
making (15 points)
1. Creating OLAP cubes 

2. Visualizing of the information of the DW 

3. Answering the questions that support decision making 


8. Conclusion (5 points)

1. Summary of the project 

2. What are the lessons learned from the project? 

3. What kind of issues have you encountered during the project? And have you encountered them?