List of Courses

Information
Description
Outcomes
Contents
Methodologies
Assessment
Books

Data Warehousing

Course Code :
IS442
Level :
Undergraduate
Course Hours :
3.00 Hours
Department :
Department of Information Systems

Instructor information :

Title:Lecturer
Name: Mohamed Attia Mohamed
Office hours:1-Hours

Area of Study :

Gather requirements for data warehousing. Explain data warehouse architecture. Design a dimensional model for data warehousing. Design a physical model for data warehousing. Discuss extract, transform and load strategies. Identify Online Analytical Processing (OLAP) databases. Design and develop business intelligence applications. Expand and support a data warehouse. Use effectively communication skills.

For further information :

Telephone: 16383 (16FUE)
E-mail: [email protected]

Data Warehousing

Introduction to Data Warehousing, Evolution of DSS, DW General Topics, Data Warehouse Structure: Granularity, Data Warehouse Design, Building Dimensional DW, OLAP tools, Aggregates, ELT Extraction/Transformation/ Load processes and tools, Issues of DW Architecture, Enterprise DW vs. Data Marts, DW and Data Mining

For further information :

Telephone: 16383 (16FUE)
E-mail: [email protected]

Data Warehousing

NAQAAABET

Course outcomes:

a. Knowledge and Understanding:

1-	Discuss the concepts of data warehousing and data mining.
2-	Explain data warehouse architectures, OLAP and the project planning aspects in building a data warehouse
3-	Discuss extract, transform and load strategies
4-	Explain the role played by knowledge in a diverse range of intelligent systems

b. Intellectual Skills:

1-	Apply the dimensional modeling technique for designing a data warehouse
2-	Develop a data warehouse architecture

c. Professional and Practical Skills:

1-	Identify Online Analytical Processing (OLAP) databases
2-	Design and develop business intelligence applications.

d. General and Transferable Skills:

1-	Work in a team effectively and efficiently considering time and stress management
2-	Apply communication skills and techniques in presentations and report writing for range of audiences using various methods and tools

For further information :

Telephone: 16383 (16FUE)
E-mail: [email protected]

Data Warehousing

Course topics and contents:

Topic	No. of hours	Lecture	Tutorial/Practical
Data Warehouse Concepts	4	2	2
Data Warehouse Design Concepts	4	2	2
Data Warehouse Lifecycle	4	2	2
Dimensional Model Concepts	4	2	2
Dimensional Model Design	4	2	2
Designing the Physical Database	4	2	2
Concepts of Extract, Transform	4	2	2
Concepts of Load (ETL)	4	2	2
Mid-Term Exam	2
Concepts of Business Intelligence Applications	4	2	2
Concepts of Business Intelligence Applications	4	2	2
Designing and Developing Business Intelligence Applications	4	2	2
Presentation/Discussion of Case Studies	4	2	2
Final Exam	2

For further information :

Telephone: 16383 (16FUE)
E-mail: [email protected]

Data Warehousing

Teaching And Learning Methodologies:

Teaching and learning methods
Interactive Lectures including discussion
Practical Lab Sessions
Self-Study (Project / Reading Materials / Online Material / Presentations)
Case Studies
Problem Solving