DATA WAREHOUSE (2/1 Credits)

Learning Outcomes:

On successful completion of this course, students will be able to: Identify the basic concepts, components and architecture of data warehouse; Explain the requirements and how to design data warehouse; Describe the advantages of data warehouse utilization; Analyse data warehouse design and implementation strategy and the reason why data warehouse is the suitable solution.

Topics:

1. Evaluation of Decision Support Systems;
2. The Data Warehouse Environment;
3. The Data Warehouse and Design;
4. Granularity in the Data Warehouse;
5. The Data Warehouse and Technology;
6. The Distributed Data Warehouse;
7. External/Unstructured Data and the Data Warehouse;
8. Migration to the Architected Environment;
9. Executive Information System and the Data Warehouse;
10. ERP and the Data Warehouse;
11. The Data Warehouse and the Web;
12. Data Warehouse Design and Building Review;
13. Data Warehouse in Retail Sales: A Case Study.