www.exammain.com VALLIAMMAI ENGINEERING COLLEGE SRM Nagar, Kattankulathur – 603 203
DEPARTMENT OF INFORMATION TECHNOLOGY
QUESTION BANK
VIII SEMESTER IT6010-Business Intelligence Regulation – 2013 Academic Year 2017 – 18
Prepared by Mr. E.Prabhakarraj, Assistant Professor (O.G)/IT
Visit : www.exammain.com
www.exammain.com VALLIAMMAI ENGINEERING COLLEGE SRM Nagar, Kattankulathur – 603 203.
DEPARTMENT OF INFORMATION TECHNOLOGY QUESTION BANK Academic Year 2017-2018
SUBJECT
: IT6010-BUSINESS INTELLIGENCE
SEM / YEAR: VIIISEM / IVYEAR UNIT-1
BUSINESS INTELLIGENCE
Effective and timely decisions Data, information and knowledge, Role of mathematical models, Business intelligence architectures: Cycle of a business intelligence analysis Enabling factors in business intelligence projects Development of a business intelligence system Ethics and business intelligence. PART - A Q.No.
Question
BT Level
Competence
1
Define Business intelligence
BTL-1
ing
2
What are the benefits of BI?
BTL-1
ing
3 4 5 6
BTL-1 BTL-1 BTL-1 BTL-1 BTL-2
ing ing ing ing Understanding
9
What is the role of mathematical models in BI Write short notes on effective and timely decisions. Define data and information. Define data mining. Differentiate data, information and knowledge with suitable example. sketch and summarize the main components in BI architecture Discuss about enabling factors in business intelligence projects.
BTL-2 BTL-2
Understanding Understanding
10
Discuss the development of BI system.
BTL-2
Understanding
11 12 13 14 15
Illustrate the role of mathematical models with an example Illustrate the importance of ethics in BI Show the importance of business intelligence system. Explain the cycle of BI analysis Point out the enabling factors in BI projects
BTL-3 BTL-3 BTL-3 BTL-4 BTL-4
Applying
7 8
Visit : www.exammain.com
Applying Applying
Analyzing Analyzing
www.exammain.com 16 17
Point out the components architectures.
in
business
intelligence BTL-4
Analyzing
18
Compare data, information and knowledge. Summarize the importance of business intelligence system.
BTL-5 BTL-5
Evaluating Evaluating
19
Generalize the benefits of business intelligence system.
BTL-6
Creating
BTL-6
Creating
20
Write a steps involved in developing a business intelligence system.
PART – B Q.No . 1 2
3 4 5 6 7 8 9 10 11. 12. 13.
Question
BT Level
Competence
Describe in detail about business intelligence and emphasis on making effective and timely decisions.
BTL-1
ing
Describe in detail about data, information and knowledge in detail with an example.
BTL-1
ing
Describe about the business intelligence architecture with a neat sketch.
BTL-1
ing
List the components of business intelligence systems and also BTL-1 explain in detail about the working of various components in detail. Discuss the role of mathematical models in business BTL-2 intelligence
ing
Summarize the cycles involved in BI analysis. BTL-2 Discuss about the enabling factors in business intelligence BTL-2 projects. Demonstrate the development of business intelligent system in BTL-3 detail
Understanding Understanding
Demonstrate with an example the ethics followed in business intelligence Explain the architecture of business intelligence.
BTL-3
Applying
BTL-4
Analyzing
i.Explan in detail about cycle in a BI analysis.(8) BTL-4 ii.explain in detail about effective and timely decisions.(8) Analyze and explain about the development of business BTL-4 intelligence system. Compare data, information and knowledge and synthesize the BTL-5 valid point from that.
Analyzing
Visit : www.exammain.com
Understanding
Applying
Analyzing Evaluating
www.exammain.com 14.
Propose the importance of ethics in BI system
BTL-6
Creating
UNIT 2- KNOWLEDGE DELIVERY The business intelligence types, Standard reports, Interactive Analysis and Ad Hoc Querying, Parameterized Reports and Self-Service Reporting, dimensional analysis, Alerts/Notifications, Visualization: Charts, Graphs, Widgets, Scorecards and Dashboards, Geographic Visualization, Integrated Analytics, Considerations: Optimizing the Presentation for the Right Message. PART – A Q.No.
Question
BT Level
1
List the types of BI s
Competence ing
8
BTL-1 What are standard reports? Give example. BTL-1 What is dimensional analysis? BTL-1 Define visualization and list out the techniques used BTL-1 What is interactive analysis and adhoc query? BTL-1 What is parameterized and self-service reporting? BTL-1 Discuss some of the caveats when allowing s to formulate BTL-2 and execute adhoc queries. Discuss about the purpose of DEA? BTL-2
9
Differentiate between scorecards and dashboards
BTL-2
Understanding
10 11
Give the various types of BI s Illustrate the working of a standard reports. Demonstrate the working of dimensional analysis with an example. Classify the different types of charts. Point out the considerations in optimizing the presentation for the right message.
BTL-2 BTL-3 BTL-3
Understanding Applying Applying
BTL-3 BTL-4
Applying Analyzing
Compare charts and graphs. Point out some applications of geographic visualization
BTL-4 BTL-4
Analyzing Analyzing
Compare the working of scoreboards and dashboards. Explain about data analytics.
BTL-5 BTL-5
Evaluating Evaluating
Propose the importance/use of alerts and notifications Prepare a things that are to be considered for optimizing the
BTL-6 BTL-6
Creating Creating
2 3 4 5 6 7
12 13 14 15 16 17 18 19 20
presentations for the right message.
Visit : www.exammain.com
ing ing ing ing ing Understanding Understanding
www.exammain.com PART-B Q.No.
Question
1 2
Describe about the various BI types with an example Describe in detail about geographical visualization with an example.
BTL-1 BTL-1
ing ing
3
Illustrate the use of dimensional analysis with example
BTL-1
ing
4
Analyze parameterized and self-service reporting
BTL-1
ing
5
Discuss about interactive analysis and adhoc querying in detail BTL-2 Summarize the considerations in optimizing the presentation BTL-2 for the right message
Understanding Understanding
BTL-2
Understanding
8
Describe about the parameterized reports and self-service reporting Illustrate with an example alerts/noitifications.
BTL-3
Applying
9
Demonstrate visualization techniques with suitable examples
BTL-3
Applying
10
Compare the working of various visualization tools.
BTL-4
Analyzing
11
Explain the working of widgets Point out and explain in detail about the importance of scoreboards and dashboards.
BTL-4 BTL-4
Analyzing Analyzing
i.summarize about integrated analytics.(8) ii.summarize the benefits of geographical visualization(8) Generalize the working of geographical information system.
BTL-5
Evaluating
BTL-6
Creating
6 7
12 13. 14.
BT Level
Competence
UNIT 3-EFFICIENCY Efficiency measures, The CCR model: Definition of target objectives- Peer groups, Identification of good operating practices; cross efficiency analysis, virtual inputs and outputs, Other models. Pattern matching ,cluster analysis, outlier analysis VPART – A Q.No.
Question
1
Define virtual inputs and virtual outputs
2 3
What do you mean by constant returns to scale? What do you mean by outliers?
BT Level BTL-1 BTL-1 BTL-1
Visit : www.exammain.com
Competence ing ing ing
www.exammain.com 4
What do you mean by clustering? What are the methods used for clustering?
BTL-1
ing
5
Write notes on data envelopment analysis.
BTL-1
ing
6 7
Define a peer group with an example Discuss the different methods used to detect the efficient units
BTL-1 BTL-2
ing Understanding
8
Summarize cross-efficiency analysis
BTL-2
Understanding
9
Differentiate virtual inputs and virtual outputs.
BTL-2
Understanding
10
Summarize the working of clustering methods.
BTL-2
Understanding
11
Illustrate outlier analysis with a suitable example
BTL-3
Applying
12 13 14
Illustrate Banker–Charnes–Cooper model Illustrate CCR model Explain the taxonomy of clustering methods.
BTL-3 BTL-3 BTL-4
Applying Applying Analyzing
15 16 17
Point out the advantages of good operating practices. Analyze and list out the applications of outliers. Summarize about the efficiency measures
BTL-4 BTL-4 BTL-5
Analyzing Analyzing Evaluating
18 19
Summarize in detail about distance based outliers. Write notes on developing a CCR model. Develop a formula for calculating a target value for input and output.
BTL-5 BTL-6 BTL-6
Evaluating Evaluating Evaluating
20
PART-B
Q.No.
Question
BT Level
Competence
1
Describe in detail about the virtual input and virtual output.
BTL-1
ing
2 3
Describe outlier analysis Describe about the various clustering methods in detail
BTL-1 BTL-1
ing ing
BTL-1
ing
4
Describe in detail about K-means algorithm and K-mediods algorithm
5
Summarize the working of various hierarchical clustering methods.
BTL-2
Understanding
Discuss in detail about the cluster analysis
BTL-2
Understanding
6
Visit : www.exammain.com
www.exammain.com
12
Summarize the identification of good operating practices with an example. Illustrate the working of various Agglomerative hierarchical clustering methods with an example. Illustrate a working of outlier analysis with a neat example. Explain CCR Model Analyze peer groups in detail Analyze and write in detail about the various efficiency measures
13
Explain and evaluate the various pattern matching cluster BTL-5 methods.
Evaluating
Propose the ideas behind the efficiency measures
Creating
7 8 9 10 11
BTL-2
Understanding
BTL-3
Applying
BTL-3 BTL-4 BTL-4 BTL-4
Applying Analyzing Analyzing Analyzing
BTL-6
14
Ununi4- UNIT 4- BUSINESS INTELLIGENCE APPLICATIONS Marketing models, Logistic and Production models, Case studies. VPART – A
Q.No. 1 2 3
Question
BT Level
Competence
What is the goal of relational marketing? What is relational marketing? What are the Components of a relational marketing strategy? What are the Network of relationships involved in a relational marketing strategy
BTL-1 BTL-1 BTL-1 BTL-1
ing ing ing ing
7
What is Revenue management? Sketch and describe the Cycle of relational marketing analysis Summarize the need for lifetime value of a customer.
BTL-1 BTL-1 BTL-2
ing ing Understanding
8
Summarize the working of ERP
BTL-2
Understanding
9
Discuss in detail about Sales force management
BTL-2
Understanding
10
Give the various problems connected with managing a mobile sales force management
BTL-2
Understanding
11
Demonstrate and explain the categories of decision-making processes relative to sales force management.
BTL-3
Applying
12
Illustrate with example the working of supply chain.
BTL-3
Applying
4 5 6
Visit : www.exammain.com
www.exammain.com 13 14 15 16 17 18 19 20
Illustrate in detail about various Optimization models used for logistics planning Compare cross-selling & up-selling Point out the need for backlogging. Explain about the bill of materials. Summarize the working of supply chain optimization
BTL-3
Applying
BTL-4 BTL-4 BTL-4 BTL-5
Analyzing Analyzing Analyzing Evaluating
Summarize the need for relational marketing analysis BTL-5 Develop and Sketch the Components of an environment for BTL-6 relational marketing analysis. Develop and Sketch the decision processes in revenue BTL-6 management
Evaluating Creating Creating
PART-B
Q.No.
Question
BT Level
Competence
Describe the retention in telecommunications with respect to marketing Describe and Elaborate on the acquisition in the automotive industry Describe and Explain the various marketing models with suitable case study Write a short note on revenue management systems
BTL-1
ing
BTL-1
ing
BTL-1
ing
BTL-1
ing
BTL-2
Understanding
6
Summarize the logistics planning in the packaging industry Discuss sales force management in detail Discuss in detail about logistic and production models.
BTL-2
Understanding
7
Discuss the optimization models for logistics planning
BTL-2
Understanding
8
Demonstrate the logistics planning in the food industry
BTL-3
Applying
Demonstrate relational marketing in detail Discuss the components of relational marketing strategy explain in detail about the environment in relational marketing analysis Explain the lifetime value of the customer with a clear example. Explain in detail about the decision process in revenue management Predict and explain a appropriate Case study for logistic and production models Develop a Case study for logistic production in food industry.
BTL-3
Applying
BTL-4
Analyzing
BTL-4
Analyzing
BTL-4
Analyzing
BTL-5
Evaluating
BTL-6
Creating
1 2 3 4 5
9 10 11 12 13 14
Visit : www.exammain.com
www.exammain.com UNIT 5- FUTURE OF BUSINESS INTELLIGENCE Future of business intelligence, Emerging Technologies, Machine Learning, Predicting the Future, BI Search & Text Analytics, Advanced Visualization, Rich Report, Future beyond Technology. VPART – A
Q.No.
Question
1
What are the Top 5 Emerging Trends in BI?
2
What is machine learning? What are the categories under machine learning?
3 4
BT Level BTL-1 BTL-1 BTL-1
Competence ing ing ing
5
What is meant by analytics? What are the techniques that can be adopted under machine learning?
BTL-1 BTL-1
ing ing
6
What is clustering?
BTL-1
ing
7
Summarize the working of regression
BTL-2
Understanding
8
Differentiate clustering and classification. Give examples
BTL-2
Understanding
9 10
BTL-2 BTL-2 BTL-3
Understanding Understanding Applying
12
Differentiate supervised and unsupervised learning. Discuss about text analytics with an example. Demonstrate the applications in which the text analytics can be employed. Illustrate the typical steps in text analytics
BTL-3
Applying
13
Demonstrate the need for machine learning.
BTL-3
Applying
14 15
Point out the need of advanced visualization. Give examples. Explain in precise about rich reports with a simple example.
BTL-4 BTL-4
Analyzing Analyzing
16
Compare predictive and descriptive analytics.
BTL-4
Analyzing
Justify the need of sophisticated business intelligence tools
BTL-5
Evaluating
18
Explain in precise about advance visualization.
BTL-5
Evaluating
19
Develop an example for BI search.
BTL-6
Creating
20
Develop an example for rich report preparation.
BTL-6
Creating
11
17
Visit : www.exammain.com
www.exammain.com PART-B
Q.No.
Question
BT Level
Competence
1
Describe machine learning with suitable examples
BTL-1
ing
2
Write short notes on advanced visualization
BTL-1
ing
3
Write short notes on future beyond technology
BTL-1
ing
4
Give an on the emerging technologies
BTL-1
ing
5
Interpret predicting the future using Business Intelligence
BTL-2
Understanding
6 7
Summarize the emerging technologies in business intelligence BTL-2 Summarize in detail about machine learning BTL-2
Understanding Understanding Applying
8
Illustrate the working of advanced visualization concepts with BTL-3 an example.
9
Demonstrate the rich report with a clear cut example.
BTL-3
Applying
10
Analyze rich report Explain about the working of BI search in detail.
BTL-4 BTL-4
Analyzing Analyzing
Explain about the predictive analytics and descriptive analytics BTL-4 in detail. Speculate BI search & text analytics BTL-5 Develop an example case study for rich report generation. BTL-6
Analyzing
11 12 13 14
Visit : www.exammain.com
Evaluating Creating