Business Intelligence Final Exam 2025
Questions and Answers
Definition of Business Intelligence and Analytics - --Answer --Business
Intelligence & Analytics are the techniques, technologies, systems, practices,
methodologies and applications that analyze critical business data to help an
enterprise better
understand its business and market and make timely business decisions.
1. Data Management
2. Descriptive Analytics
3. Predictive Analytics
4. Prescriptive Analytics
5. Business Performance Management - --Answer --5 aspects/components
of BI&A
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
,the technical staff that takes the data sources and builds the data warehouse by
organizing, summarizing, and standardizing - --Answer --explain the data
warehouse environment of BI&A:
the business users that access the date warehouse; manipulation via user interface
(browser, portal, dashboard) and produce results which lead to performance and
strategy from managers and executives - --Answer --explain the business
analytics environment of BI&A
Importance of BI&A - --Answer --#1 priority for CEO's
- evidence based businesses generally outperform their competition, in terms of
growth
There are several business environmental factors: globalization, customer demand,
government regulations, market conditions, competition, etc. These factors can be
both pressures and opportunities, depending on how an organization responds to
them: strategy, partners collaboration, real-time response, agility, increased
productivity, new vendors, new business model, etc. These organization responses
drive decisions and support: Analyses, Predictions, & Decisions, which makes up
Business Intelligence - --Answer --Describe the Business-Pressures-
Reponses-Support model:
1. Structured
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
, 2. Semistructured
3. Unstructured - --Answer --3 types of decisions:
1. Operational control
2. Managerial control
3. Strategic planning - --Answer --3 types of control:
Raw facts; has no meaning without its context
- Example: Blue; Blue what? Car? Shirt? Eyes? - --Answer --What is data?
Processed data; conclusion
- Example: the total sales of the week (mathematical equation) - --Answer --
What is information?
Information in action; you can learn from the information and produce actionable
insight
- Example: The average salary for IT professionals is $60,000. - --Answer --
What is knowledge?
structured decisions - --Answer --routine/repetitive decisions
unstructured decisions - --Answer --also called "ill" decisions
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 3
Questions and Answers
Definition of Business Intelligence and Analytics - --Answer --Business
Intelligence & Analytics are the techniques, technologies, systems, practices,
methodologies and applications that analyze critical business data to help an
enterprise better
understand its business and market and make timely business decisions.
1. Data Management
2. Descriptive Analytics
3. Predictive Analytics
4. Prescriptive Analytics
5. Business Performance Management - --Answer --5 aspects/components
of BI&A
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
,the technical staff that takes the data sources and builds the data warehouse by
organizing, summarizing, and standardizing - --Answer --explain the data
warehouse environment of BI&A:
the business users that access the date warehouse; manipulation via user interface
(browser, portal, dashboard) and produce results which lead to performance and
strategy from managers and executives - --Answer --explain the business
analytics environment of BI&A
Importance of BI&A - --Answer --#1 priority for CEO's
- evidence based businesses generally outperform their competition, in terms of
growth
There are several business environmental factors: globalization, customer demand,
government regulations, market conditions, competition, etc. These factors can be
both pressures and opportunities, depending on how an organization responds to
them: strategy, partners collaboration, real-time response, agility, increased
productivity, new vendors, new business model, etc. These organization responses
drive decisions and support: Analyses, Predictions, & Decisions, which makes up
Business Intelligence - --Answer --Describe the Business-Pressures-
Reponses-Support model:
1. Structured
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
, 2. Semistructured
3. Unstructured - --Answer --3 types of decisions:
1. Operational control
2. Managerial control
3. Strategic planning - --Answer --3 types of control:
Raw facts; has no meaning without its context
- Example: Blue; Blue what? Car? Shirt? Eyes? - --Answer --What is data?
Processed data; conclusion
- Example: the total sales of the week (mathematical equation) - --Answer --
What is information?
Information in action; you can learn from the information and produce actionable
insight
- Example: The average salary for IT professionals is $60,000. - --Answer --
What is knowledge?
structured decisions - --Answer --routine/repetitive decisions
unstructured decisions - --Answer --also called "ill" decisions
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 3