Office Location: 207,Express Scripts Hall

/ INFSYS 6849 - Data Warehouse Design and Implementation
Thursday6:55 pm to 9:35pm, SSB206

Instructor:Dr. Kailash Joshi

Office location:207,Express Scripts Hall

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

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

Course Materials

Suggested textbook:

Data Warehousing: Fundamentals for IT Professionals by PaulrajPonniah; 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.

Tentative Schedule (Changes to be announced)

Approx. Week & date / Topic / Internal / External
Week 1, 01/22 / Introductions and overview of the course / KJ
Week 2, 01/29 / DW overview - Cornel & Rob / KJ
Week 3, 02/05 / Ch1 & 2 / KJ
Week 4, 02/12 / Ch 9 / KJ
Week 5, 02/19 / Ch 10 / KJ
Week 6, 02/26 / Ch11 / KJ
Week 7, 03/05 / Guest Topic + Ch3 (Partly) / Guest Speaker
Week 8, 03/12 / Ch3 (Balance) / John Powell
Week 9, 03/19 / Ch5
Ch 6 / Yanhui Long
Jenny Brunnert
Week 10, 03/26 / Spring Break – no classes
Week 12, 04/02 / Ch 7
Ch 18 / Elaine Love
Sean Isserman
Week 13, 04/09 / Ch18 (any overflow if needed)
Ch 8 / Sean Isserman
Geoff Hickman
Week 14, 04/16 / Ch 12 / Rudy Kardjaja
Week 15, 04/23 / Ch 13 / Moying Zhou
Week 16, 04/30 / Ch 15 / Daniel Diecker
Week 17, 05/07 / Review
Week 18, 05/14 / Exam 1 in class
7:45 PM to 9:45 PM

Youtube Videos

BI/Data Warehouse Tools /
ETL Tools /
Master Data Management /

Intro to Hadoop HDFS /
State of the art database and DW technologies /

Attendance

Students are expected to attend all classes.If you have to be absent due to illness or injury, please notify meas soon as possible. Points will be deducted from your attendance score for each unexcused absence. All studentsare 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 comeprepared 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 typedwith 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.