Future University In Egypt (FUE)
Future University is one of most promising private universities in Egypt. Through excellence in teaching, research and service, Future University strives to provide a comprehensive, high-quality education that prepares our graduates to be future leaders.
mainLogo
90th Street
New Cairo
Egypt

Course List

Data Warehousing

  • Course Code :
    ISY 442
  • Level :
    Undergraduate
  • Course Hours :
    3.00 Hours
  • Department :
    Department of Information Systems

Instructor information :

Area of Study :

This course introduces the basic concepts of data warehouse applications and lifecycle. The Design Concepts of Data Warehouse. Designing a Dimensional Model. Introducing Business Intelligence Applications. Also, the course equips students with some hands-on example of a simple data warehouse implementation.

For further information :

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 :

Data Warehousing

Course outcomes:

a. Knowledge and Understanding:

1- Be conversant in the basic concepts of Data Warehouse
2- Be familiar with the Data Warehouse Lifecycle
3- Be familiar with basic concepts of Data Warehouse design
4- Be familiar with the basic concepts of designing Dimensional Model
5- Be familiar with Business Intelligence applications

b. Intellectual Skills:

1- Describe and evaluate a real Data Warehouse applications in local Business community

c. Professional and Practical Skills:

1- Develop a working application using a commercial data warehouse software tool

d. General and Transferable Skills:

1- Think logically, manage time effectively and work independently

For further information :

Data Warehousing

Course topics and contents:

Topic No. of hours Lecture Tutorial/Practical
Data Warehouse Concepts 3 2 2
Data Warehouse Design Concepts 3 2 2
Data Warehouse Lifecycle 3 2 2
Dimensional Model Concepts 3 2 2
Dimensional Model Design 3 2 2
Midterm Exam I 2 1 2
Designing the Physical Database 3 2 2
Concepts of Extract, Transform 3 2 2
Concepts of Load (ETL) 3 2 2
Concepts of Business Intelligence Applications 3 2 2
Concepts of Business Intelligence Applications 3 2 2
Midterm Exam II 2 1 2
Designing and Developing Business Intelligence Applications 3 3 3
Presentation/Discussion of Case Studies 3 3 3

For further information :

Data Warehousing

Teaching And Learning Methodologies:

Teaching and learning methods
• Lectures
• Practical training
• Self-Study
• Open Discussion
• Presentation
• Project
• Web site searches

For further information :

Data Warehousing

Course Assessment :

Methods of assessment Relative weight % Week No. Assess What
Final Exam 40.00 15
Mid-Term Exam1 15.00 6
Mid-Term Exam2 15.00 12
Project 20.00 14
Research/Presentation 10.00 14

For further information :

Data Warehousing

Books:

Book Author Publisher
The Data Warehouse Lifecycle Toolkit Ralph Kimball John Wiley

For further information :

Follow us on

Visit the Faculty

ADS