PRACTICE QUESTIONS WITH CORRECT
ANSWERS
◉ Business intelligence definition Answer: umbrella term- combines
architectures, tools, databases, analytical tools, applications, and
methodologies
*different things to different people
*major objective: enable easy access to data (and models) to provide
business managers with the ability to conduct analysis
*Bi helps transform data to information (and knowledge) to
decisions and finally to action
IS.. a discipline that encompasses: tech, work processes,
human/organizational factors, evolutionary
IS NOT.. a product/tool, product, collection of dashboards/reports
◉ My definition: bi means (4 things) Answer: Timely
Accurate
High-value
Actionable
,"soundbite def"^
Insights
-via organization (and sometimes external) data
◉ 5 "flavors" BI capabilities should include Answer: -Tell me what
happened... and why
-Tell me what is happening.. RIGHT NOW!
-Tell me what is likely to happen
-Tell me what might have happened
-Tell me something interesting and important (without me asking
specific questions)
◉ Tell me what happened.. and why? Answer: -easiest
-theme: after the fact historical reporting
-can be discrete or comparative
Tabular
Dashboard:panels!
Visualization: "look and feel"
,◉ Discrete Answer: Last year's/months/quarters profitability
report
◉ Comparative Answer: This quarter vs last quarter or this quarter
vs same quarter last years
◉ Business Environmental Factors Answer: globalization
customer demand
govt regulations
market conditions
competition
◉ Organization's responses Answer: strategy
partners collaboration
real time response
agility
increased productivity
new vendors
new business models
◉ Decision and support Answer: analyses
predictions
, decisions
-integrated computerized decision support
-business intelligence
◉ Single department, single function Answer: county department of
human services
"tell me what happened and why"
"tell me what is likely to happen and why"
◉ state level, agency wide Answer: state department of
transportation (DOT)
-enterprise vs departmental
-mostly "tell me what happened
not a lot of "and why"
part of a larger enterprise
◉ multi enterprise, mission critical "life or death" Answer: state
department of health (DOH)
required consolidation, reporting of disease information to CDC
-expanded into mission-critical
◉ County department of human services Answer: mission: reduce
recidivism among those receiving county provided assistance for: