IST 722 - Data Warehouse

Course Description

Introduction to concepts of business intelligence (BI) and the practice/techniques in building a BI solution. Focuses are on how to use data warehouses as a BI solution to make better organizational decisions.

Credit(s)

3.0

Pre-requisites

IST 659, OR IST 359 with a minimum grade of B or higher

Professor of Record

Michael Fudge

Audience

Graduate students

Learning Objectives

After taking this course, students will be able to: 

1. Describe various database constructs - ODS, Data Warehouse, Data Mart
2. Describe the components of a data warehouse
3. Differentiate between Ralf Kimball’s and Bill Inmon's approaches
4. Describe various integration approaches - ETL, EII, EAI
5. Describe a Master Data Management (MDM) solution
6. Create database objects using popular database management system products
7. Design and implement data warehouse and business intelligence components
8. Define the roles and responsibilities in the design and development of data warehouses
9. Differentiate various requirements gathering and dimensional modeling techniques
10. Define project management guidelines
11. Describe the data governance concepts
12. List some of the recent trends in Data Warehouse

Course Syllabi

IST 722 Intensive Course Syllabus- Khan, Humayun

IST 722 Spring 2021 Syllabus - Chad Harper

Other iSchool Courses