SPPU Computer Engineering (Semester 8)
Business Analytic and Intelligence
December 2016
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) Describe the role of Business Intelligence in making a business successfull.
5 M
1(b) Explain process of Decision making Business Intelligence System.
5 M

2(a) Explain various data visualization techniques in Decision Support System.
5 M
2(b) What are the obstacles to Business Intelligence in an Organization?
5 M

Solve any one question from Q.3(a,b) & Q.4(a,b)
3(a) Explain "Predictive Business Analytics" in detail.
5 M
3(b) What is concept hierarchy? Explain its importance in multidimensional cube.
5 M

4(a) Explain the distributed data warehouse architecture with suitable diagram.
5 M
4(b) Explain " Fact constellaton schema" with suitable example.
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 cleaning techniques.
5 M
5(b) Explain the methods of measuring central tendency of data with example.
6 M
5(c) What is data normalization in data pre-processing? Explain following data nomalization methods with example:
i) Min-Max normalization
ii) Z-score normalization
6 M

6(a) What are outliers? Explain various types of outliers with suitable example.
6 M
6(b) Explain clustering based methods of oulier detection with examples.
6 M
6(c) What is OLAP'? Explain Roll-up and Slice operations with example.
5 M

Solve any one question from Q.7(a,b,c) & Q.8(a,b,c)
7(a) Explain Business Intelligence Infrastructure with suitable diagram.
6 M
7(b) Explain the need of Scalability in Business Intelligence infrastructure.
6 M
7(c) What is business continuity? Explain various operations involved in it.
5 M

8(a) What is Business Intelligence System? Explain various steps of designing It.
6 M
8(b) Explain the concept and importance of maintaining Business Intelligence systems.
6 M
8(c) What are the challenges involved in implementing BI infrastructure?
5 M

Solve any one question from Q.9(a,b,c) & Q.10(a,b)
9(a) Explain the need and role of BI in improving various business functionalities.
6 M
9(b) Write a short note on
i) Business Analytic
ii) CRM
6 M
9(c) Explain the application of business intelligence for detection of intrusion in network system.
4 M

10(a) Explain the application of Business Intelligence in banking.
8 M
10(b) Consider the database of an online retail Shoppe like Big Bazar. Use suitable business intelligence techniques and derive discount s for various items in the shop, for a particular week, to increase the profitability. Explain the techniques used for the same.
8 M



More question papers from Business Analytic and Intelligence
SPONSORED ADVERTISEMENTS