Information Technology 442

ITEC 442: Data Warehousing, Mining, and Reporting

Prerequisite: ITEC 340 (Grade of "C" or better)

Credit Hours: (3)

A continuation of principles of database systems covering techniques for modeling, managing, and analyzing large data sets. This course lays the foundation for business intelligence by providing in-depth coverage of data warehousing, data mining, and reporting.

Detailed Description of Content of Course

Topics include:
1. Introduction to business intelligence
2. Data warehousing
    a. Dimensional Modeling
    b. Warehouse aggregates
    c. Data Quality
    d. Extract, Transform, and Load (ETL) process
    e. Physical design
    f. Data warehousing lifecycle
3. Reporting and Data Analysis
    a. Online Analytical Processing (OLAP)
    b. Commercial Query and Reporting Tools
4. Data Mining
    a. Data Mining Methodology
    b. Statistical Methods
    c. Decision Trees
    d. Association Rules
    e. Clustering
    f. Neural Networks
    g. Data Preparation

Detailed Description of Conduct of Course

Techniques for modeling, managing, analyzing, and visualizing data are discussed and practiced.  Students complete assignments in data warehousing, data mining, and reporting.
Goals and Objectives of the Course

Students who complete the course will be able to:    
1. Design a basic Star schema, explain the challenges of dimensional modeling, and describe best practices.
2. Design a basic ETL process and explain the challenges of the ETL process.
3. Identify valuable aggregates for a given problem.
4. Describe different types of reports and reporting requirements.
5. Describe the limitations of SQL with respect to analytical reports.
6. Describe the six common data mining tasks.
7. Describe three data mining techniques.
8. Explain the value of transactional data with respect to business intelligence.
9. Explain the importance of data quality and the challenges of producing high quality data.

Assessment Measures

Students will be evaluated based on assignments and a minimum of two examinations.

Other Course Information


Review and Approval

September 25, 2001         New course proposal      John P. Helm, Chair
October 26, 2007              Update                         Art Carter, Chair
November XX, 2010          Update                         Art Carter, Chair

Revised: June 1, 2012

Revised: 2014