Catalog Description

Provide a comprehensive discussion on advanced database system, data warehousing, online analytical processing, data mining, decision support systems, artificial intelligence and other Business Intelligence topics.

Course Description:  This course provides a comprehensive discussion of and practical experience in advanced database techniques, data visualization, data warehousing, online analytical processing (OLAP), data mining, decision support systems (DSS), artificial intelligence (AI) methods and other Business Intelligence (BI) topics. Students gain practical experience using contemporary BI tools and technologies, and apply sound design principles for creating intelligent solutions to realistic business problems. Prerequisite: CPSC5000 or approval of department head 

 

Overview:Organizations rely on computer-based information system for capturing, analyzing, and distributing the information required to develop, implement, and evaluate corporate strategies in all functional areas. Managing data as a corporate resource requires a deep understanding of business processes and of the underlying structure of the data needed to support them.  Business intelligence refers to the process of capturing and storing data to be transformed into useful information to support managerial decision-making. The focus of this course is on concepts central to the management of data resources and the development of business intelligence capabilities.  There is a mixture of theoretical and practical topics including case studies and a significant hands-on component.

Textbooks:

Decision Support and Business Intelligence Systems, 9th Edition, Efraim Turban, University of Hawaii, Jay E. Aronson, University of Georgia, Ting-Peng Liang, National Sun Yat-Sen University, Ramesh Sharda, Oklahoma State University, ISBN-10: 0131986600, ISBN-13: 9780131986602, Publisher: Prentice Hall, Copyright: 2007

Delivering Business Intelligence with Microsoft SQL Server 2008, by Brian Larson, ISBN 978-0-07-154944-8, McGraw Hill, 2009

IBM Cognos Business Intelligence V10.1 Handbook. 

 

Business Intelligence: A Managerial Approach 2/e   by E. Turban, R. Sharda, D. Delen, D. King. Pearson Prentice Hall, Inc. 2010. ISBN-13: 978-0-13-610066-9. ISBN-10: 0-13-610066-X.

Lecture 1: Decision Support Systems and Business Intelligence

Lecture 2: Decision Making, Systems, Modeling and Support

Lecture 3: Decision Support Systems Concepts, Methodologies, and Technologies: An Overview

Lecture 4: Modeling and Analysis

Lecture 5: Basic Classification

Lecture 6: More Classification, Neural Networks

Lecture 7: Basic Association

Lecture 8: Basic Clustering

Lecture 9: Text and Web Mining

Lecture 10: Data Warehouse

Course Projects

1. Creating Data Mart

2. Using Integration Services for Populating Data Mart

3. Cubism – Measures and Dimensions

4. Special Features of OLAP Cubes

5. Writing a New Script – MDX Scripting

6. Introduction to Data Mining

7. Delivering Business Intelligence with Reporting Services

8. Excel Pivot Tables and Pivot Charts (practice only)

Sample Projects:

1. LDA-based Dark Web Analysis

2. Analyzing and Profiling Attacker Behavior in Multistage Intrusions

3. Emerging Infectious Disease: A Computational Multi-agent Model