You are here

CIT 828: Business Intelligence, Data Warehousing, and Data Mining
Credit Hours: 3
Prerequisites: None

Course Objective:
This course provides opportunities for students to study and apply business intelligence, data warehousing and data mining technologies and techniques. These technologies and techniques help to realize competitive advantages in business and advance analysis of data in public sector applications. This course is intended to develop the following capabilities:
  • be able to define business process requirements that capture the business needs. Define the problem statement, objective of the data warehouse, capabilities, and functionalities.
  • understand the basic concepts of dimensional modeling, such as facts, dimensions, the data warehouse bus matrix, and other Elective concepts.
  • be familiar with the following design issues: System sizing consideration, configuration consideration, software installation and configuration.
  • understand how to develop the specification for the ETL system.
  • be able to implement the ETL system for a data warehouse.
  • be able to conduct physical design of Analysis Service OLAP Database.
  • understanding the basic concepts of business intelligence applications.
  • be able to specify the business intelligence applications.
  • understanding how reporting services work and where it fits in the overall DW/BI system.
  • be able to implement procedures for managing and maintaining the data warehouse.

Course Description:

Business intelligence is a data driven decision support system that relies on advanced data analysis techniques obtained through data warehousing and data mining. This course provides students with deeper knowledge, advanced skills and understanding to allow them to contribute to the development and design of all three of these inter-related methodologies and technologies. Topics to be covered include business intelligence principles; competitive intelligence (including the ethics of competitive intelligence); distributed data management; data warehousing methods, concepts and applications of data mining; dashboards; on-line analytic processing (OLAP), advanced business analytics; business requirement analysis; dimensional modeling; physical design, extraction-transformation-load (ETL) design and development; Analysis Services; and visualization.

Mode of Delivery:

  • Lectures, student presentations, and course projects. Students will gain hands-on experience through Microsoft SQL Server 2005 Toolkit. Each student prepares a final paper on one of the major topics in the course.

Assessment:

  • Assignments, exams, and term paper
Last modified: Wednesday, 12 March 2008, 03:10 PM