Graduate Course Proposal Form Submission Detail - ISM6201
Edit function not enabled for this course.
Approved, Permanent Archive
Course Change Information (for course changes only):
- Department and Contact Information
Tracking Number Date & Time Submitted 1667 2007-03-27 Department College Budget Account Number IS/DS Department BA 1407-000-00 Contact Person Phone Joan Moceri 9747770 email@example.com
- Course Information
Prefix Number Full Title ISM 6201 Data Warehousing Is the course title variable? N Is a permit required for registration? N Are the credit hours variable? N Is this course repeatable? If repeatable, how many times? 0 Credit Hours Section Type Grading Option 3 C - Class Lecture (Primarily) R - Regular Abbreviated Title (30 characters maximum) Data Warehousing Course Online? Percentage Online -
As a prerequisite, students should have had at least two courses covering relational database systems (usually including ISM 6218: Advanced Database Systems), or significant work experience.
This course is designed for the MS graduate student and interested MBA students. The course covers the rapidly emerging data warehousing and data mining technologies that are likely to play a strategic role in business organizations.
A. Please briefly explain why it is necessary and/or desirable to add this course.
Data warehouses provide the infrastructure for emerging business intelligence techniques, including navigation through online analytic processing (OLAP) interfaces and more automated data mining techniques. Graduate business students should be familiar w
B. What is the need or demand for this course? (Indicate if this course is part of a required sequence in the major.) What other programs would this course service?
This course serves as a component in the data and knowledge management course sequence in the ISDS/COBA Master of Science program. The three-course package of Advanced Database Systems, Data Warehousing, and Data Mining provide the student with detailed technical coverage of current business intelligence issues, along with the skills necessary to create an effective information infrastructure.
C. Has this course been offered as Selected Topics/Experimental Topics course? If yes, how many times?
The Data Warehousing course has been offered each fall (1998-2006), a total of nine times.
D. What qualifications for training and/or experience are necessary to teach this course? (List minimum qualifications for the instructor.)
An instructor for Data Warehousing should have a strong database background, along with knowledge of dimensional modeling and data warehouse design techniques. In addition, the instructor should be familiar with one or more state-of-the-art data warehousing systems, typically offered by leading database vendors, to offer a project-based experience. This includes knowledge of the database engine and presentation technologies like online analytic processing (OLAP) tools.
- Other Course Information
The objectives of the course are: 1) to introduce students to important aspects of enterprise-class data infrastructure technologies, 2) to review data warehousing design approaches (and case studies) 3) to introduce presentation technologies such as online analytic processing (OLAP) tools, and 4) to provide hands-on experience with enterprise-class tools for data warehouse development.
B. Learning Outcomes
Students who complete this course will be able to: 1) identify opportunities for using data warehousing technologies, 2) be more effective team members on such projects, 3) write analytic queries using SQL and other tools, 4) be able to design data warehouses and dimensional models, and 5) be familiar with the tools to develop and administer data warehouses.
C. Major Topics
The major course topics include an overview of business intelligence technologies, data warehouse design and dimensional modeling, analytic SQL queries, interface design using online analytic processing (OLAP) tools, administering and tuning the data warehouse, data quality, and project management issues.
Required Text: Kimball, Reeves, Ross, Thornthwaite, The Data Warehouse Lifecycle Toolkit, John Wiley & Sons, 1998.
E. Course Readings, Online Resources, and Other Purchases
F. Student Expectations/Requirements and Grading Policy
G. Assignments, Exams and Tests
H. Attendance Policy
I. Policy on Make-up Work
J. Program This Course Supports
- Course Concurrence Information