Data Warehousing
Applied Computer Science · 3 hrs Lecture
Offered: Winter Only, Even Year
Hard to catch. Runs in even-numbered years only, next in 2026. Miss it and the following chance is 2028.
ACS-4904 prerequisites
3 courses appear in this chain, up to 2 levels deep. 1 is needed whichever route you take: ACS-3902
Show the chainHide the chain
any one of
Add your completed courses to see which of these you've already done and what you could take next. They stay on this device.
Where ACS-4904 counts
Counts toward 4 more as one option among several, not as a course you must take:
Read from the departments' own calendar pages, where 50 of 208 programs are only partly machine-readable, so treat these as a minimum rather than the full list. Confirm with an academic advisor.
Description
This course explores the role of data warehouses in supporting decision-making in organizations. Topics include definition of a data warehouse; extracting, cleansing, and transforming data; building and maintaining the warehouse; meta data; dimensional analysis and multidimensional modeling; multidimensional data structures; Star schemas; OLAP (On Line Analytical Processing); drilling down and across; and web deployment.
Requisite courses
ACS-3902 with a minimum grade of C [prerequisite(s)].
From the 2026-27 undergraduate calendar. Always verify details on WebAdvisor or with an academic advisor before registering.