D. Y.
Patil International University
Programme Year of Study Semester Course Type
MCA 1st I Generic Course
Course Full Title Knowledge Discovery & Data Mining
Course Short Title DMBI
Course Code MCA_ 103
Course Objective ●To Study data warehouse architectures, OLAP
and the project planning aspects in building a
data warehouse.
●To introduce the concepts, techniques, design
and applications of data warehousing and data
mining.
●To enable students to understand and implement
classical algorithms in data mining.
●To understand how to analyze the data, identify
the problems, and choose the relevant
algorithms to apply.
●To understand business analysis and
methodologies
D. Y. Patil International University
Course Outcomes (CO) / Learning Outcomes
On successful completion of this course, the learner will be able to
CO1 To present a survey on different learning, classification and data mining
foundations.
CO2 Understand techniques of preprocessing various kinds of data.
CO3 Describe Data warehouse concepts and organize data in multidimensional
schema models.
CO4 Apply Association Mining, Classification and Cluster Techniques on a large
dataset.
CO5 Apply Business Intelligence technique on data and present a survey on
applications for Business Intelligence.
D. Y. Patil International University
Sr Subjec Subject Title Total Marks: 100.
. t
N Code
o.
1 MCA_10 Data mining and Business Intelligence
3
Sr Topic Details % No.
. Weighta of
N ge Sessio
o. ns
1 Data Warehousing: 15 6
1.1. Introduction to data and different types of
information
1.2. Introduction to Data warehousing Architecture
1.3. Data Mart Warehouse schemas
1.4. Dimensional data modelling- star, snowflake
schemas, fact constellation
1.5. Online analytical processing (OLAP)
1.6. Data cubes and Operations on cubes
1.7. ETL: Data preprocessing; the need for preprocessing,
data cleaning, data integration, transformation and
data reduction
2 Knowledge Base Systems & Expert Systems: 10 4
2.1. Basic concepts and elements of Expert System
2.2 Structure of Expert System
2.3 The functionality of Expert System
2.4 Expert System Applications
2.5 Comparison of Conventional & Expert Systems
2.6 Data mining as a part Knowledge Discovery process
2.7 Predictive & Descriptive Mining.
D. Y. Patil International University
3 Association, Classification, Clustering: 25 8
3.1. Association rules Market-basket Model, support &
confidence,
3.2. Apriori Algorithm, Sampling Algorithm, Frequent-
pattern Tree Algorithm, Partition Algorithm
3.3. Classification: Issues Regarding Classification and
Prediction, Classification by Decision Tree Induction
3.4. Bayesian Classification, Rule-Based Classification
3.5. Clustering: Types of Data in Cluster Analysis, A
Categorization of Major Clustering Methods, Partitioning
Methods, Hierarchical Methods, Density-Based Methods,
Outlier.
3.6. Analysis - Mining Streams. Introduction to machine
learning.
4 Different Approaches to resolving data mining 2 8
problems: 5
4.1. Discovery of sequential patterns and Discovery of
patterns in time series
4.2. Linear Regression for Prediction, Neural Networks,
Genetic Algorithms
4.3. Text mining, Web Mining and Data-visualization
4.4. Applications of Data Mining
4.5. Fraud Detection
4.6.Targeted Marketing, Customer Retention and Online
Advertising
4.7. WEKA tool
5 Business Intelligence: 25 8
5.1. Definition of Problem :(Corporate problems & Issues)
5.2. Designing a physical database
5.3. Deploying and supporting DW/BI system
5.4. BI Architecture – spreadsheets, the concept of the
dashboard, OLAP, decision engineering, LIS
D. Y. Patil International University
5.5. Business performance management, including Key
performance indicators and operational metrics, Balanced
scorecard, Six Sigma, Dashboards, Data visualization
5.6. BI Application in various domains
5.7. BI Analytics (discriminant analysis and logistic
regression, cluster analysis, principle component analysis )
Learning Resources:
1. Text books
1. 1. Han, J., Pei, J. and Kamber, M., 2011. Data mining: concepts and techniques.
Elsevier.
2. Tan, P.N., Steinbach, M. and Kumar, V., 2016. Introduction to data mining.
Pearson Education India.
2. Reference books
1. Witten, I.H. and Frank, E., 2002. Data mining: practical machine learning tools and
techniques with Java implementations. Acm Sigmod Record, 31(1), pp.76-77.
2. Golfarelli, M. and Rizzi, S., 2009. Data warehouse design: Modern principles and
methodologies. McGraw-Hill, Inc.
3. Dunham, M.H., 2006. Data mining: Introductory and advanced topics. Pearson
Education India.
3. Web References
1. www.ibm.com/in/en/
2. www.pentaho.com/
3. www.jaspersoft.com/
4. www.amazon.com/Data-Mining-Business-Intelligence-Applications
5. www.ibm.com/insights/in
6. www.sas.com
List of Practicals:
1. Demonstration of WEKA Explorer for preprocessing of data and study the attributes.
2. Perform Preprocessing, Classification techniques on the dataset given.
3. Perform clustering techniques on the dataset given.
4. Perform association techniques on the dataset given.
D. Y. Patil International University
5. Write a python program to open Comma Separated Value (CSV) and perform given statistical operations.
Operations to perform -
1. Mean
2. Median
3. Mode
4. Variance
5. Standard Deviation
6. Quartile Range
Examination Evaluation Scheme :
