BUSINESS INTELLIGENCE TEST PAPER 2025/2026
QUESTIONS WITH SOLUTIONS RATED A+
✔✔the term BI was coined by the? - ✔✔Gartner Group 1990s
✔✔MIS Reporting - static periodic reports - ✔✔1970s
✔✔EIS (executive information system) - ✔✔1980s
✔✔OLAP, Dynamic, multidimensional, ad-hoc reporting -> coining of the term "BI" -
✔✔1990s
✔✔inclusion of AI and Data/Text Mining capabilities; web-based portals/dashboards -
✔✔2005+
✔✔yet to be seen - ✔✔2010s
✔✔4 major components of BI system - ✔✔- data warehouse
- business analytics
- business performance management
- a user interface
✔✔its source data - ✔✔data warehouse
✔✔a collection of tools for manipulating, mining, and analyzing the data in the data
warehouse - ✔✔business analytics
✔✔bpm - ✔✔business performance management
✔✔for monitoring and analyzing performance - ✔✔business performance management
✔✔dashboard - ✔✔user interface
✔✔this built the data warehouse - ✔✔technical staff
✔✔technical stuff : - ✔✔- organizing
- summarizing
- standardizing
✔✔business users : - ✔✔access
manipulation, results
,✔✔user interface : - ✔✔- browser
- portal
- dashboard
✔✔is the cornerstrone of any medium-to-large BI system - ✔✔data warehouse
✔✔are the tools that help users transform data into knowledge - ✔✔business analytics
✔✔is an analytics based BI system that specializes in predicting success of movies
based on a detailed analysis of movie scripts - ✔✔epagogix
✔✔this uses data mining to aid its marketing initiatives - ✔✔national australia bank
✔✔a marketing intelligence firm, assists health care providers with growing their
businesses - ✔✔hoyt highland partners
✔✔cpm - ✔✔corporate performance management
✔✔which is also referred to as cpm - ✔✔bpm
✔✔is an emerging portfolio of applications within the bi framework - ✔✔bpm
✔✔provides a comprehensive graphical/pictorial view - ✔✔user interface
✔✔five styles of bi - ✔✔-report delivery and alerting
-enterprise reporting
-cube analysis
-ad hoc queries
-statistics and data mining
✔✔cube analysis is also known as - ✔✔slice-and-dice analysis
✔✔using dashboardds and scorecards - ✔✔enterprise reporting
✔✔a relatively new approach to supporting decision making - ✔✔automated decision
making
✔✔applies to high structured decisions - ✔✔ads
✔✔ads - ✔✔automated decision systems
✔✔ads or? - ✔✔automation automation systems
, ✔✔is a rule based system that provides a solution to a repetitive managerial problem -
✔✔ads
✔✔foundation and sources - ✔✔technology
dss theories
ai
business processes
✔✔types - ✔✔customized
standard
✔✔initially appeared in the airline industry called _______ - ✔✔revenue or yield
✔✔are driven by business rules - ✔✔ADS
✔✔identification and prioritization of BI projects - ✔✔bi governance
✔✔the way that modern companies ethically and legally organize themselves -
✔✔intelligence
✔✔involved in handling updates to what we might call operational databases -
✔✔transaction processing systems
✔✔oltp - ✔✔online analytic processing
✔✔handles routine on-going business - ✔✔oltp
✔✔these systems generate and store data in oltp systems - ✔✔erp, scm,crm
✔✔olap - ✔✔online analytic processing
✔✔systems are involved in extracting information from data stored by oltp system -
✔✔olap
✔✔bicc - ✔✔BI Competency Center
✔✔major bi tools and techniques (tool categories) - ✔✔- data management
- reporting, status tracking
- visualization
- strategy and performance management
- business analytics
✔✔may be the only independent large bi vendor - ✔✔microstrategy
QUESTIONS WITH SOLUTIONS RATED A+
✔✔the term BI was coined by the? - ✔✔Gartner Group 1990s
✔✔MIS Reporting - static periodic reports - ✔✔1970s
✔✔EIS (executive information system) - ✔✔1980s
✔✔OLAP, Dynamic, multidimensional, ad-hoc reporting -> coining of the term "BI" -
✔✔1990s
✔✔inclusion of AI and Data/Text Mining capabilities; web-based portals/dashboards -
✔✔2005+
✔✔yet to be seen - ✔✔2010s
✔✔4 major components of BI system - ✔✔- data warehouse
- business analytics
- business performance management
- a user interface
✔✔its source data - ✔✔data warehouse
✔✔a collection of tools for manipulating, mining, and analyzing the data in the data
warehouse - ✔✔business analytics
✔✔bpm - ✔✔business performance management
✔✔for monitoring and analyzing performance - ✔✔business performance management
✔✔dashboard - ✔✔user interface
✔✔this built the data warehouse - ✔✔technical staff
✔✔technical stuff : - ✔✔- organizing
- summarizing
- standardizing
✔✔business users : - ✔✔access
manipulation, results
,✔✔user interface : - ✔✔- browser
- portal
- dashboard
✔✔is the cornerstrone of any medium-to-large BI system - ✔✔data warehouse
✔✔are the tools that help users transform data into knowledge - ✔✔business analytics
✔✔is an analytics based BI system that specializes in predicting success of movies
based on a detailed analysis of movie scripts - ✔✔epagogix
✔✔this uses data mining to aid its marketing initiatives - ✔✔national australia bank
✔✔a marketing intelligence firm, assists health care providers with growing their
businesses - ✔✔hoyt highland partners
✔✔cpm - ✔✔corporate performance management
✔✔which is also referred to as cpm - ✔✔bpm
✔✔is an emerging portfolio of applications within the bi framework - ✔✔bpm
✔✔provides a comprehensive graphical/pictorial view - ✔✔user interface
✔✔five styles of bi - ✔✔-report delivery and alerting
-enterprise reporting
-cube analysis
-ad hoc queries
-statistics and data mining
✔✔cube analysis is also known as - ✔✔slice-and-dice analysis
✔✔using dashboardds and scorecards - ✔✔enterprise reporting
✔✔a relatively new approach to supporting decision making - ✔✔automated decision
making
✔✔applies to high structured decisions - ✔✔ads
✔✔ads - ✔✔automated decision systems
✔✔ads or? - ✔✔automation automation systems
, ✔✔is a rule based system that provides a solution to a repetitive managerial problem -
✔✔ads
✔✔foundation and sources - ✔✔technology
dss theories
ai
business processes
✔✔types - ✔✔customized
standard
✔✔initially appeared in the airline industry called _______ - ✔✔revenue or yield
✔✔are driven by business rules - ✔✔ADS
✔✔identification and prioritization of BI projects - ✔✔bi governance
✔✔the way that modern companies ethically and legally organize themselves -
✔✔intelligence
✔✔involved in handling updates to what we might call operational databases -
✔✔transaction processing systems
✔✔oltp - ✔✔online analytic processing
✔✔handles routine on-going business - ✔✔oltp
✔✔these systems generate and store data in oltp systems - ✔✔erp, scm,crm
✔✔olap - ✔✔online analytic processing
✔✔systems are involved in extracting information from data stored by oltp system -
✔✔olap
✔✔bicc - ✔✔BI Competency Center
✔✔major bi tools and techniques (tool categories) - ✔✔- data management
- reporting, status tracking
- visualization
- strategy and performance management
- business analytics
✔✔may be the only independent large bi vendor - ✔✔microstrategy
