INFSYS 6849 - Data Warehouse Design and Implementation Thursday 6:55 pm to 9:35pm, SSB 206

Instructor: Dr. Kailash Joshi

Office location: 207, Express Scripts Hall

Office hours: Tuesday 6:00 pm – 6:45 PM, and other times by appointment

Address: joshi using umsl domain edu Phone: (314) 516-6123

Course Materials

Suggested text book:

Data Warehousing: Fundamentals for IT Professionals by Paulraj Ponniah; 2nd Edn. Publisher: Wiley, John & Sons, Incorporated

Other material/s assigned in class

Additional Books Suggested:

Star Schema: The Complete Reference by Christopher Adamson

The Data Warehouse Lifecycle Toolkit by Ralph Kimball

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball

Corporate Information Factory by W. H. Inmon

Course Description

Prerequisites: INFSYS 6845 or instructor's permission.

The course will cover different design configurations for structuring and organizing data in a data warehouse. Formal methodologies for the development of data warehouses will also be discussed and implemented.

Grading Policy

Class Presentations	30
Project/Paper	30
Exam	30
Attendance and Class Participation	10
Total:	100%

Final letter grades will be assigned at the end of the semester.

Please see mygateway.umsl.edu for the schedule.

Attendance

Students are expected to attend all classes. If you have to be absent due to illness or injury, please notify me as soon as possible. Points will be deducted from your attendance score for each unexcused absence. All students are expected to be punctual to class; being habitually late is inappropriate and unprofessional. If you have to leave a class early for legitimate reasons, please let me know in advance.

Class participation

It is essential that you come prepared to class with the proper text and other necessary materials. You should be ready to take part in class discussions. In addition to class participation, you will spend time outside of class to complete your assignments and to build skills.

Assignments:

All assignments are mandatory. Assignments with more than one page must be either stapled, or paper clipped before submission. All assignments must be typed with double line spacing, with a clearly readable font size. Assignments that require submission via MyGateway must be submitted by the stipulated date and time mentioned.

Exams

Any exam schedule conflicting with other exams should be reported to the instructor at least one week prior to the examination to qualify for an alternative test date.

Policy Statements:

University policy clearly defines the requirements for academic honesty and defines disciplinary actions to which a student may be subject to if these requirements are violated. University rules and regulations must be followed at all times. Civility is a basic requirement. Cell phones, pagers, personal digital assistants and MP3 players should not be used during class time. This syllabus may be revised at the discretion of the instructor without prior notification or consent of the student.