Data Mining and Business Intelligence — Summer 2023

Define: Data Mart, Enterprise Warehouse & Virtual Warehouse

Adata warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data – Justify.

What are different sources of information? Explain the term data, information and knowledge with suitable example.

Differentiate Fact table vs. Dimension table.

Define noise. Explain binning methods for data smoothing.

Explain different OLAP operation with example.

What is Data Mining? Explain Data mining as one step of Knowledge Discovery Process.

List and describe the methods for handling the missing values in data cleaning.

What is market basket analysis? Explain the two measures of rule interestingness: support and confidence.

State the Apriori Property. Generate large itemsets and association rules using Apriori algorithm on the following data set with minimum support value and minimum confidence value set as 50% and 75% respectively.

Discuss click-stream analysis using data mining.

Explain the Min-max data normalization method with suitable example.

Explain three-tier Data Warehouse Architecture.

Discuss following terms. 1) Supervised learning 2) Correlation analysis 3) Tree pruning

Differentiate Association vs. Classification.

Explain Baye’s Theorm and calculate Naïve Bayesian Classification for given example:1

Draw the topology of a multilayer, feed-forward Neural Network.

Explain data mining application for fraud detection.

Define linear and nonlinear regression using figures. Calculate the value of Yfor X=100 based on Linear regression prediction method. X Y4390

Describe web mining using example.

What is Big Data? What is big data analytic?

Define the term “Information Gain”. Explain the steps of the ID3 Algorithm for generating Decision Tree.

Define: 1) Data Node 2) Name Node 3) Text mining

Explain partitioning and hierarchical methods of clustering.

What is distributed file system? Explain HDFS architecture in detail.