BI - TEST

Business intelligence (BI) is a broad category of application programs which includes :

• Decision support
• Data mining
  
  
• OLAP
• All of the mentioned

Point out the correct statement :

• OLAP is an umbrella term that refers to an assortment of software applications for analyzing an organization’s raw data for intelligent decision making
• Business intelligence equips enterprises to gain business advantage from data
• BI makes an organization agile thereby giving it a lower edge in today’s evolving market condition.
• None of the mentioned 

BI can catalyze a business’s success in terms of :

• Distinguish the products and services that drive revenues.
• Rank customers and locations based on profitability.
• Ranks customers and locations based on probability.
• All of the mentioned 

Which of the following areas are affected by BI ?

• Revenue
• CRM 
•  Sales
• All of the mentioned

Point out the wrong statement 

• Data is factual information for analysis
• BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data 
• Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer
•  None of the mentioned

________ is a performance management tool that recapitulates an organization’s performance from several standpoints on a single page.
 

• Balanced Scorecard
• Data Cube
• Dashboard
• All of the mentioned

__________ is a system where operations like data extraction, transformation and loading operations are executed.

• Data staging 
• Data integration
• ETL
• None of the mentioned

_________ is a category of applications and technologies for presenting and analyzing corporate and external data

• Data warehouse
• MIS
• EIS
• All of the mentioned

Which of the following is process of basing an organization’s actions and decisions on actual measured results of performance ?

• Institutional performance management 
• Gap analysis
• Slice and Dice
• None of the mentioned 

Which of the following does not form part of BI Stack in SQL Server ?

• SSRS
• SSIS
• SSAS
• OBIEE