Bsc. I.T.

Business Intelligence Syllabus

I Business intelligence: Effective and timely decisions, Data, information and knowledge, The role of mathematical models, Business intelligence architectures, Ethics and business intelligence

Decision support systems: Definition of system, Representation of the decision-making process, Evolution of information systems, Definition of decision support system, Development of a decision support system
II Mathematical models for decision making: Structure of mathematical models, Development of a model, Classes of models

Data mining: Definition of data mining, Representation of input data , Data mining process, Analysis methodologies

Data preparation: Data validation, Data transformation, Data reduction
III Classification: Classification problems, Evaluation of classification models, Bayesian methods, Logistic regression, Neural networks, Support vector machines.

Clustering: Clustering methods, Partition methods, Hierarchical methods, Evaluation of clustering models
IV Business intelligence applications: Marketing models: Relational marketing, Sales force management

Logistic and production models: Supply chain optimization, Optimization models for logistics planning, Revenue management systems.

Data envelopment analysis: Efficiency measures, Efficient frontier, The CCR model, Identification of good operating practices
V Knowledge Management: Introduction to Knowledge Management, Organizational Learning and Transformation, Knowledge Management Activities, Approaches to Knowledge Management, Information Technology (IT) In Knowledge Management, Knowledge Management Systems Implementation, Roles of People in Knowledge Management.

Artificial Intelligence and Expert Systems: Concepts and Definitions of Artificial Intelligence, Artificial Intelligence Versus Natural Intelligence, Basic Concepts of Expert Systems, Applications of Expert Systems, Structure of Expert Systems, Knowledge Engineering, Development of Expert Systems

Business Intelligence Practicals

Practical NoDetails
1 Import the legacy data from different sources such as ( Excel , SqlServer, Oracle etc.) and load in the target system. ( You can download sample database such as Adventureworks, Northwind, foodmart etc.)
2 Perform the Extraction Transformation and Loading (ETL) process to construct the database in the Sqlserver.
3a Create the Data staging area for the selected database.
3b Create the cube with suitable dimension and fact tables based on ROLAP, MOLAP and HOLAP model.
4a Create the ETL map and setup the schedule for execution.
4b Execute the MDX queries to extract the data from the datawarehouse.
5a Import the datawarehouse data in Microsoft Excel and create the Pivot table and Pivot Chart
5b Import the cube in Microsoft Excel and create the Pivot table and Pivot Chart to perform data analysis
6 Apply the what – if Analysis for data visualization. Design and generate necessary reports based on the data warehouse data.
7 Perform the data classification using classification algorithm.
8 Perform the data clustering using clustering algorithm.
9 Perform the Linear regression on the given data warehouse data.
10 Perform the logistic regression on the given data warehouse data.

Business Intelligence Reference Books

Title Business Intelligence: Data Mining and Optimization for Decision Making
Authors Carlo Vercellis
Publisher Wiley
Edition 1st
Year 2009
Download Here
Title Decision support and Business Intelligence Systems
Authors Efraim Turban, Ramesh Sharda, Dursun Delen
Publisher Pearson
Edition 9th
Year 2011
Download Here
Title Fundamental of Business Intelligence
Authors Grossmann W, Rinderle-Ma
Publisher Springer
Edition 1st
Year 2015
Download Here