INFSYS 6849 - Data Warehouse Design and Implementation



Instructor: Dr. Kailash Joshi

Office location: 207, Express Scripts Hall

Address: joshi on domain    Phone: (314) 516-6123

Please refer to Canvas for office hours and Myview for classroom and time.

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. 


Please see for the schedule.