GACS/ACS-4904-001 Data Warehousing

Possible Letter Grades

vs

"S" Standing Grades

Ron McFadyen, 3D21

ron.mcfadyen@gmail.com

Jan 6	Course Outline - wrong text listed Textbook: Star Schema, The complete reference by Adamson
Jan 8	Introduction Chapter 1 / Chapter 2 Northwind OLTP database Assignment 1
Jan 13	Chapter 3 (type 2 updated Jan 15)
Jan 15	Chapter 4 DrillAcrossDb (updated with 4 queries a, b, c, d Queries a and b are phase 1 Queries c and d are phase 2 Query c uses union (see SQL view) Query d summarizes c. Previous tests (2018Test1, 2018Test2)
Jan 20	Chapter 5 conformed dimensions Chapter 6 more on dimensions
Jan 22	Assignment 1 due Send to 4904-001@acs.uwinnipeg.ca Hand in the database (OLTP tables and Star Schema tables) with the two queries
Jan 27	Review Assignment 1 – sample solution Assignment 2 – due Feb 10 Chapter 7 Hierarchies
Jan 29++	Chapters 8, 9, 10 · Types 1, 2, (3, 1/2 ß ignore for now) · Multi-valued dimensions/bridges · Hierarchies/bridges o Sample db with hierarchy bridge Nested Sets (intro)
	For Assignment 2: holidays 94 95 96
Feb 5	Test
Feb 10	Review recursive hierarchies From test Nested sets a database immediate children
Feb 12	TESTS returned ß see secretary if you were not present DRAFT … Assignments 3,4,5 Recursive hierarchies (handout) Ch 12 Types of fact tables
Feb 24	Aggregates Assignment 2 marked Concerns? à see instructor
Feb 26	Ch 12/14 Factless and Pivoted fact tables indexes Assignments 3, 4, 5
Mar 2	HOBI-TI (handed out; available at https://dl.acm.org/) 20xx exam HOBI is not covered on Mar 4 test
Mar 9	Ch 8 (revised) Types 1, 2, 3, 1/2
Mar 11	Return & review tests Not present à see ACS secretary for test Average: 30.7/40 Median: 31.5/40 3 students 40/40
Mar 16++	Term marks to date Please review – let me know of any errors
Mar 18	No office hours HOBI and Time-HOBI slides · would have covererd during a class
Mar 23	"S" Standing Grades vs Possible Letter Grades Ch 17: Extract Transform Load (ETL) Loading data incrementally into a star