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 / 30Project/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 / ExternalWeek 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.
1