Business Analytics
and Data Mining
Section 2
True/False Questions:
1. BI tools only collect data but do not analyze it.
False
2. Data Warehouse is designed for analytical
processing rather than transaction processing.
True
3. ETL involves extracting data, transforming it, and
loading it into a warehouse.
True
4. OLTP focuses on analysis while OLAP focuses on
operations.
False
5. One of the key benefits of BI is improved customer
insights.
True
6. Decision Support Systems are used only in the
finance sector.
False
7. Big Data plays a significant role in real-life
business applications.
True
8. DSS and BI have no relation to each other.
False
9. BI helps organizations make decisions based on
real-time data.
True
10. Marketing and sales are not areas where BI can be
applied.
False
Multiple Choice Questions:
1. Business Intelligence (BI) mainly aims
to:
A. Increase transaction processing speed
B. Transform raw data into actionable insights
C. Replace human decision-making completely
D. Store operational data only
(B)
2. Which of the following is NOT a key
benefit of BI?
A. Informed decision-making
B. Increased organizational efficiency
C. Eliminating the need for data storage
D. Competitive advantage
(C)
3. The “T” in ETL stands for:
A. Translate
B. Transform
C. Transfer
D. Transmit
(B)
4. Data Warehouse (DWH) is mainly designed
for:
A. Transaction processing
B. Complex queries and analysis
C. Data entry and operational updates
D. Internet browsing
(B)
5. Which of the following best describes
OLAP?
A. Real-time transaction updates
B. Supports analytical processing and decision-
making
C. Focuses on daily operations
D. Used only in small businesses
(B)
6. A BI dashboard is used to:
A. Store raw data
B. Present analytical results visually
C. Replace human managers
D. Clean and transform data sources
(B)
7. Which of the following is an example of
BI insight?
A. Recording sales transactions
B. Identifying a sales pattern over time
C. Buying new cash registers
D. Reducing the number of employees
(B)
8. The Extract, Transform, Load (ETL)
process is part of:
A. Data Warehouse architecture
B. Transaction processing systems
C. Marketing campaigns
D. Email automation tools
(A)
9. Which of the following industries can
benefit from DSS?
A. Healthcare
B. Finance
C. Education
D. All of the above
(D)
10. Which statement describes Big Data
correctly?
A. It is small and easy to manage
B. It is unrelated to business decision-making
C. It involves massive, complex datasets for insights
D. It replaces BI systems completely
(C)
Essay questions:
1. Explain how Business Intelligence (BI)
supports decision-making in modern
organizations.
➢ Answer: Business Intelligence (BI) plays a critical role in supporting strategic
and operational decision-making by transforming raw data into actionable
insights. It collects and integrates data from multiple sources, analyzes it, and
presents it in the form of dashboards, reports, and visualizations.
For example, in retail, BI can identify sales patterns and help managers adjust
pricing, inventory, or promotional strategies accordingly. This leads to faster, more
accurate, and evidence-based decisions, minimizing risks and improving
organizational performance.
2. Discuss the key components of
Data Warehouse architecture
and explain the role of each.
➢ Answer: The architecture of a Data Warehouse typically consists
of four main layers:
1. Data Sources: The origin of data (operational databases, external
systems, sensors, etc.).
2. ETL Process (Extract, Transform, Load): Extracts data from
sources, transforms it into a unified format, and loads it into the
warehouse.
3. Storage: A centralized repository designed for analytical
processing.
4. Presentation Layer: Interfaces, dashboards, and reporting
tools that allow users to analyze and visualize data.
This layered structure ensures data accuracy, consistency, and
accessibility for decision support.
3. Compare between OLTP and OLAP.
➢ Answer:
Aspect OLTP OLAP
Analytical processing &
Purpose Transaction processing
decision support
Data Structure Real-time, detailed Historical, aggregated
Daily operations (e.g., Strategic analysis (e.g.,
Usage sales) trends)
Users Operational staff Managers, analysts
Example Point of sale system Sales trend analysis tool
➢ OLTP ensures efficiency in daily
transactions, while OLAP provides insights
for strategic decision-making.
4. Describe the ETL process and
explain its importance.
➢ Answer: ETL (Extract, Transform, Load) is a fundamental process
in data integration:
Extract: Collecting data from multiple heterogeneous sources.
Transform: Cleaning, standardizing, and reformatting data.
Load: Inserting the transformed data into the data warehouse.
➢ This process ensures data quality, consistency, and readiness for
analysis. It allows organizations to rely on a single, integrated
source of truth for BI activities.
5. DSS across various industries.
➢ Answer: Decision Support Systems (DSS) are applied in many
sectors:
1. Healthcare: Clinical DSS supports doctors by analyzing patient
data and suggesting diagnoses.
2. Finance: DSS helps in credit scoring and risk management.
3. Education: DSS supports decision-making regarding student
performance, resource allocation, and strategic planning.
➢ DSS improves accuracy, speeds up decision-making, and enhances
organizational efficiency.
6. Big Data and its importance in
decision-making.
➢ Answer: Big Data refers to large, complex datasets generated from
various sources such as transactions, social media, IoT, and sensors.
It allows organizations to uncover patterns, trends, and correlations
that are not visible in small datasets.
For example, e-commerce companies use Big Data to personalize
recommendations, optimize pricing, and forecast demand. Its value
lies in supporting data-driven strategies, innovation, and competitive
advantage.
7. BI as a source of competitive
advantage.
➢ Answer: BI provides organizations with real-time insights
into operations, markets, and customer behavior. These
insights help companies anticipate market trends, optimize
processes, and respond faster than competitors.
For instance, BI dashboards enable executives to make
informed strategic decisions, reduce operational costs, and
enhance customer satisfaction. As a result, BI becomes a
strategic asset, not just a technology.
8. BI and customer experience.
➢ Answer: BI enables companies to analyze customer
behaviors, preferences, and buying patterns. This allows
marketers to personalize campaigns, improve customer
service, and enhance the overall experience.
For example, a retail store can use BI to identify peak
shopping hours and adjust staff schedules and offers
accordingly. This leads to higher satisfaction, loyalty, and
revenue growth
THANK YOU