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.
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
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
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)
1. LDA-based Dark Web Analysis
2. Analyzing and Profiling Attacker
Behavior in Multistage Intrusions
3. Emerging Infectious Disease: A
Computational Multi-agent Model