BUSINESS INTELLIGENCE AND ANALYTICS (4 Credits)

Learning Outcomes:

On successful completion of this course, students will be able to: Explain basic concepts of Data Warehouse, Data Warehouse development, architecture, and business intelligence applications; Design a dimensional and physical model for data warehouse; Comprehend ETL strategies; Develop business intelligence applications.

Topics:

1. Introduction to Data Warehouse;
2. Introduction to Kimball Lifecycle;
3. Collecting the Requirements;
4. Dimensional Modelling 1;
5. Dimensional Modelling 2;
6. Designing the Physical Database and Planning for Performance;
7. Designing and developing the ETL System;
8. What is business intelligence;
9. Data Visualization;
10. Business intelligence dashboard;
11. Enrichment Activity: Case Study and Tutorial in Data Warehouse;
12. Enrichment Activity: Project Presentation 1;
13. Enrichment Activity: GUEST LECTURE;
14. Enrichment Activity (Lab): ETL with Pentaho Data Integration tool;
15. Enrichment Activity: Project Presentation 2;
16. Enrichment Activity: GUEST LECTURE.