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;
6. Transformation, and Loading;
7. Physical Data Warehouse Design;
8. Data Analytics: Exploiting the Data Warehouse;
9. Big Data and NoSQL;
10. A Method for Data Warehouse Design;
11. Data Warehouse Schema;
12. Online Analytical Processing (OLAP);
13. Data Pre-processing and Extraction;
14. Transformation, and Loading;
15. Quiz;
16. Data Analytics: Exploiting the Data Warehouse;
17. Review Materials and Project Collection;
18. Conceptual Data Warehouse Design;
19. Logical Data Warehouse Design;
20. Physical Data Warehouse Design;
21. Conceptual Data Warehouse Design;
22. Logical Data Warehouse Design;
23. New Data Warehouse Technologies;
24. Project;
25. Project presentation.