BUSBIS 1670 - DATA WAREHOUSING

Minimum Credits: 3
Maximum Credits: 3
A data warehouse refers to an enterprise-level, centralized repository that stores current and historical data, which is used for managerial reporting and decision making. A data warehouse differs from a relational database used for facilitating transactions both in architecture and use. In this course, students will learn the architectural concepts of data warehouses such as the star schema and the processes involved in utilizing data warehouses for enterprise data management. Such processes include the extract, transform, and load (ETL) steps of populating data warehouses from disparate data sources, and online analytical processing (OLAP) for querying and managerial reporting. This course will emphasize a hands-on approach and the acquisition of the following skills: ¿ Dimensional design process for a data warehouse ¿ Executing ETL steps for data management ¿ OLAP for managerial reporting and decision-making The primary mode of learning will be through hands-on exercises and cases. A major component of the course grade stems from the course project that is done individually. Students should expect intensive out-of-class readings and practice sessions to get the most out of this course.
Academic Career: Undergraduate
Course Component: Lecture
Grade Component: Letter Grade
Course Requirements: PREQ: BUSBIS 1605

Click here for class schedule information.

Add to Portfolio.

Close Window