BCIS 4660

BCIS 4660: Data Warehousing
Spring 2008

Final Grades have been posted. Have a nice summer!

Classroom:
Instructor:
Office:
Office hours:
Office phone:
E-mail:

CURY 204, M 6:30 – 9:20 pm
Dr. Nick Evangelopoulos
BUSI 302G
MTu 1:00-2:00 PM; W 5:30-6:30PM (Frisco); and by appointment
(940) 565-3056
evangeln@unt.edu (preferred way to contact me)

Syllabus

BCIS4660Syl_Evangelopoulos_C08.pdf

ITDS tutoring hours

Textbooks

Required: Pratt and Adamski, Concepts of Database Management, 5th Edition, Course Technology, 2005
Required: Adamson and Venerable, Data Warehouse Design Solutions, Wiley, 1998
Optional: Marakas, George, Modern Data Warehousing, Mining, and Visualization, Prentice Hall, 2003

Lecture Slides

Lecture01_PrattChap1_Spring2008.ppt [1.55MB]
Lecture02_PrattChap2_Spring2008.ppt [2.14MB]
Lecture03a_PrattChap3_Spring2008.ppt [1.35MB]
Lecture03b_PrattChap4_Spring2008.ppt [1.90MB]
Lecture04a_Pratt05_Spring2008.ppt [993KB]
Lecture04b_NormalizationExamples_Spring2008.ppt [456KB]
Lecture05a_PrattChap6a_Spring2008.ppt [575KB]
Lecture05b_PrattChap6b_Spring2008.ppt [835KB]
Lecture06a_MarakasChap1_Spring2008.ppt [1.71MB]
Lecture06b_AdamsonChap1_Spring2008.ppt [315KB]
Lecture07a_MarakasChap2_Spring2008.ppt [454KB]
Lecture07b_AdamsonChap2_Spring2008.ppt [1.40MB]
Lecture08b_OODBMSs_Spring2008.ppt [820MB]
Lecture09a_SASEnterpriseMiner1_Spring2008.ppt [402KB]
Lecture10_MarakasChap3_Spring2008.ppt [7.36MB]
Lecture11_AdamsonChap8_Spring2008.ppt [194MB]
Lecture12a_AdamsonChap9_Spring2008.ppt [182MB]
Lecture12b_MarakasChap6_Spring2008.ppt [527MB]
Lecture12c_DataLoading_Spring2008.ppt [177MB]
Lecture13a_ MarakasChap7_Spring2008.ppt [838MB]
Lecture13b_ Visualization_Spring2008.ppt [417MB]

Homework Assignments

BCIS4660Assignments1-9_Spring2008.ppt [321KB] - Exercises 1-9
Assignment1_PartialSolutions_Spring2008.doc [38KB]
Assignment2_PartialSolutions_Spring2008.doc [78KB]
Assignment3a_sp2008_PartialSolutions.doc [36KB]
Assignment4a_PartialSolutions_Spring2008.doc [40KB]
Assignment4b_PartialSolutions_Spring2008.doc [32KB]
Assignment5a_PartialSolutions_Spring2008.ppt [291KB]
Assignment5b_PartialSolutions_Spring2008.ppt [157KB]
Assignment5_PartialSolutions_Spring2008.doc [70KB]
Assignment6a_PartialSolutions_Spring2008.doc [40KB]
Assignment6a_Instructions_Spring2008.ppt [264KB]
Assignment7_PartialSolutions_Spring2008.ppt [281KB]
Assignment8d_PartialSolutions_Spring2008.ppt [281KB]
Assignment8_Report5_Spring2008.ppt [281KB]
NOTE: A db file that combines the 12 regional dbs (PPex7_AllTeams.mdb) is listed under "data files" below. Use this file for HW8.
Assignment9a_PartialSolutions_Spring2008.ppt [170KB]
Assignment9_TeamEvaluationForm_2008.doc [26KB]
PPex10_SamplePresentation.pdf [100KB] (SAMPLE PRESENTATION!) Please note that this sample presentation has been posted here in order to provide you with some general guidance. Recreating an exact replicate of the sample presentation will not earn you a top grade!

Exams

Spring2008_BCIS4660ex1guide_Evangelopoulos.pdf [25KB]
Spring2008_BCIS4660PracticeMidTerm_WithKey.pdf [13KB]
Spring2008_BCIS4660ex2guide_Evangelopoulos.pdf [26KB]
Spring2008_BCIS4660PracticeFinal_WithKey.pdf [15KB]
BCIS4660_PopQuizzes1-8_Spring2008.pdf [83KB]
BCIS4660_PopQuizzes1-8_Spring2008.ppt [577KB]

Posted Grades

PostedGrades_4660_sp2008.htm (E1-2, Q1-9, Dropped Quizzes, HW1-9, Pres, Bonus, Peer Evaluation, Total Points, %, Letter Grade)
Exam 1 grade distribution
Exam 2 (Final) grade distribution
Click here to look up your PIN

Data Files and Software

PPex7_AllTeams.mdb [1.72MB] (use this version for HW8)
premiere-products.mdb [400KB] (Orders have 2007 dates, use this version for HW6)
henry-books.mdb [456KB] (year 2010 edition)
premiere-products.mdb [400KB] (year 2010 edition)
TimeTable2007.xls [93KB] (years 2006-2007)
SQLResWords.htm [15KB]
hmeq.sas7bdat [625KB] - This is the data set for the Data Mining case