INFSYS 6849 - Data Warehouse Design and Implementation

Tuesday 6:55 pm to 9:35pm, ESH106



Instructor: Dr. Kailash Joshi

Office location: 207, Express Scripts Hall

Office hours: Monday 6 pm 7 PM, and other times by appointment

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


Course Materials

Text Book:


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


Data Warehousing in the Age of Big Data by Krish Krishnan, 2013 or newer, Morgan Kaufmann, USA (Pdf or text)


The course will cover topics in data warehouse concepts, planning and requirements analysis, architecture and infrastructure, data design and preparation, and data warehouse design and implementation. The primary focus will on the development of suitable dimensional schemas for online analytical processing and navigation.


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.



Grading Policy


Class Presentations











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


Please see for the schedule.



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 classes 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.



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.



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.