2026 Spring > 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 - Open to IT-BS and CM majors. Students in partner programs may register for this course starting 01/05/2026. Guest students and non-partner program students may submit registration requests starting 01/15/2026
| Section | Class Number | Schedule/Time | Instructor | Location | |
|---|---|---|---|---|---|
| 01 | 3625 | M 4:00 - 6:45 pm |
Kim,Jin | Wheatley-Peters W02-0107 | |
|
Session:
Regular
Class Dates:
01/26/2026 - 05/13/2026
Capacity:
35
Enrolled:
25
Status:
Open
Credits:
3/3
Class Notes:
This course uses course material available through the Healey Library and other sources. There is no cost for the course material for this course. For more information about no-cost course material, please visit open.umb.edu.
Pre Requisites:
Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411 - Open to IT-BS and CM majors. Students in partner programs may register for this course starting 01/05/2026. Guest students and non-partner program students may submit registration requests starting 01/15/2026
Course Attributes:
Library and other resources, no cost materials
|
|||||
| 02 | 7337 | W 5:30 - 8:15 pm |
Kim,Jin | Wheatley-Peters W01-0029 | |
|
Session:
Regular
Class Dates:
01/26/2026 - 05/13/2026
Capacity:
35
Enrolled:
22
Status:
Open
Credits:
3/3
Class Notes:
This course uses course material available through the Healey Library and other sources. There is no cost for the course material for this course. For more information about no-cost course material, please visit open.umb.edu.
Pre Requisites:
Pre-req: IT 110 or MSIS 110 and IT/MSIS 230L or MSIS 411
Course Attributes:
Library and other resources, no cost materials
|
|||||