Apply to USF Now | Graduate Admissions | Events & Workshops | Giving to the Office of Graduate Studies

Graduate Course Proposal Form Submission Detail - ISM6201

Edit function not enabled for this course.

Current Status: Approved, Permanent Archive - 2007-06-21
Submission Type:
Course Change Information (for course changes only):

  1. 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 Email
    Joan Moceri 9747770

  2. 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.


    Course Description

    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.

  3. Justification

    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.

  4. Other Course Information

    A. Objectives

    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.

    D. Textbooks

    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

  5. Course Concurrence Information

- if you have questions about any of these fields, please contact or