DATA WAREHOUSE (4/2 Credits)

Learning Outcomes:

On successful completion of this course, students will be able to: Explain the basic concepts, components and architecture of data warehouse; Explain the advantages of data warehouse utilization; Demonstrate how to design data warehouse; Analyze the strategy of design and implement data warehouse and why data warehouse is the suitable solution that appropriate to the need

Topics:

1. Data Warehouse Concepts
2. Data Warehouse Schema
3. A Method for Data Warehouse Design
4. Online Analytical Processing (OLAP)
5. Data Pre-processing and Extraction, Transformation, and Loading
6. Conceptual Data Warehouse Design
7. Logical Data Warehouse Design
8. Physical Data Warehouse Design
9. Data Analytics: Exploiting the Data Warehouse
10. New Data Warehouse Technologies
11. Big Data and NoSQL
12. Project
13. Project presentation
14. A Method for Data Warehouse Design
15. Data Warehouse Schema
16. Online Analytical Processing (OLAP)
17. Data Preprocessing and Extraction, Transformation, and Loading
18. Quiz
19. Conceptual Data Warehouse Design
20. Logical Data Warehouse Design
21. Physical Data Warehouse Design
22. Data Analytics: Exploiting the Data Warehouse
23. Review Materials and Project Collection