Course Listings

all > UGRD > it > it 471

Data Warehousing for Business Intelligence

Course #: IT 471

Description:
this course provides students with the technical skills required to plan and implement a data warehouse using a database management system. It describes basic data warehousing concepts. The course covers design and implementation of data marts and operational data stores. Topics include dimensional data modeling for warehouses, CUBES and storage modes including MOLAP, ROLAP and HOLAP, and data warehousing infrastructure and analytical service tool selection. This course involves designing a data warehousing system and the implementation of a database with a stare schema, gathering data from primary data sources, transforming data, and loading it into a database management system. Students create cubes using OLAP and analyze cube data using client application.

Pre Requisites: Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411

Offered in:

2023 Fall

Section Class Number Schedule/Time Instructor Location
01 3635 Th
5:30 - 8:15 pm
Jiang,Shan McCormack M01-0608
Session: Regular
Class Dates: 09/05/2023 - 12/13/2023
Capacity: 30
Enrolled: 30
Status: Closed
Credits: 3/3
Class Notes: This section is administered by the College of Management.
Pre Requisites: Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411
Course Attributes:
02 11963 Tu
5:30 - 8:15 pm
Jiang,Shan McCormack M02-0420
Session: Regular
Class Dates: 09/05/2023 - 12/13/2023
Capacity: 30
Enrolled: 21
Status: Open
Credits: 3/3
Class Notes: This section is administered by the College of Management.
Pre Requisites: Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411
Course Attributes:

2024 Fall

Section Class Number Schedule/Time Instructor Location
01 3467 Th
5:30 - 8:15 pm
Jiang,Shan McCormack M01-0209
Session: Regular
Class Dates: 09/03/2024 - 12/13/2024
Capacity: 30
Enrolled: 0
Status: Open
Credits: 3/3
Class Notes: This section is administered by the College of Management.
Pre Requisites: Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411
Course Attributes:

2024 Spring

Section Class Number Schedule/Time Instructor Location
11 9693 W
5:30 - 8:15 pm
Banjo,Temitayo McCormack M03-0430
Session: Regular
Class Dates: 01/22/2024 - 05/08/2024
Capacity: 35
Enrolled: 34
Status: Closed
Credits: 3/3
Class Notes:
Pre Requisites: Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411
Course Attributes: