Unit VI Business Intelligence

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

I 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