SPPU Computer Engineering (Semester 8)
Business Analytic and Intelligence
May 2017
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


Solve any one question from Q.1(a,b) &Q.2(a,b)
1(a) Explain Business Intelligence Cycle with suitable diagram.
5 M
1(b) What are the factors responsible for successful Business Intelligence project.
5 M

2(a) Explain Decision Support System with its limitations.
5 M
2(b) Explain any one applications of Decision Support System in detail.
5 M

Solve any one question from Q.3(a,b) &Q.4(a,b)
3(a) Explain the data warehouse architecture with its components.
5 M
3(b) Differentiate between Snowflake schema and Fact Constellation (Galaxy) Schema with suitable example.
5 M

4(a) Describe top down approach for designing Data warehouse.
5 M
4(b) Explain the Extract-Transform-Load (ETL) process.
5 M

Solve any one question from Q.5(a,b,c) &Q.6(a,b,c)
5(a) What is the need of data pre-processing? Explain various data transformation techniques.
6 M
5(b) Explain concept hierarchy generation for categorical data.
5 M
5(c) Explain HOLAP and DOLAP in detail.
6 M

6(a) Explain clustering -based outlier analysis.
6 M
6(b) Suppose that the data for analysis includes the attribute age. The age values for the data tuples ar (in increasing order) 13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35, 35, 35, 35, 36, 40, 45, 46, 52, 70.
i) What is the mean of the data?
ii) What is the mode of the data? Comment on the data's modality (i,e., bimodal, trimodal, etc.)
iii) Give the five-number summary of the data.
6 M
6(c) Discuss different methods for handling noisy data in the data cleaning process.
5 M

Solve any one question from Q.7(a,b,c) &Q.8(a,b,c)
7(a) Explain the important factors to consider while planning for availability of Business Intelligence system.
8 M
7(b) Write short note on business continuity.
5 M
7(c) Explain the term "Resilience" in the context of business continuity.
4 M

8(a) Explain Security Management in terms of Business Inetelligence infrastructure.
6 M
8(b) Explain the usage of Business Intelligence tools to handle Business Intelligence Infrastructure.
6 M
8(c) Explain steps in designing business Intelligence system.
5 M

Solve any one question from Q.9(a,b,c) &Q.10(a,b,c)
9(a) Explain Business Analytics with suitable example.
6 M
9(b) Assume a suitable banking database and use appropriate Business Intelligence technique to classify whether the customer is eligible to get the loan or not.
6 M
9(c) How Business Intelligence is applied in CRM?
4 M

10(a) Explain the applications of Business Intelligence in: Fraud Detection.
5 M
10(b) Telecommunications.
5 M
10(c) Market Basket Analysis.
6 M



More question papers from Business Analytic and Intelligence
SPONSORED ADVERTISEMENTS