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