Total No. of Questions: 8] SEAT No.
[Total No. of Pages: 2]
[PEC-521C-COM]
F.Y.M.E. (Computer Engg.)
BUSINESS INTELLIGENCE
(2025 Pattern) (Semester - I)
[Time: 3 Hours] [Max. Marks: 50]
Instructions to the candidates:
1) Answer Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8.
2) Neat diagrams must be drawn wherever necessary.
3) Figures to the right side indicate full marks.
4) Use of Calculator is allowed.
5) Assume suitable data if necessary.
Q1) a) Draw and explain the architecture of a Business Intelligence System
Infrastructure. [6]
b) Differentiate between Data Warehouse and Data Mart with examples.
[6]
OR
Q2) a) Define Business Intelligence (BI) and explain its importance in
modern organizations. [6]
b) What is Metadata management? Explain how metadata management
improves consistency and accuracy in Business Intelligence systems.
[6]
Q3) a) Define the following terms with suitable examples: [6]
i) Business Rule
ii) Data Profiling
iii) Information Compliance
b) What is Business Rule–Based Information Compliance? Explain how
business rules can be applied to enforce data accuracy, completeness,
and regulatory compliance with real-world examples. [6]
OR
Q4) a) List the Types of Data Errors and Analyze how each type affects
organizational processes. Evaluate why organizations must invest in
data cleansing to prevent these errors. [6]
P.T.O
b) Explain Data Profiling Activities and Discuss how Attribute Analysis,
Data Model Inference, and Relationship Analysis help in identifying
hidden patterns and improving data quality. [6]
Q5) a) What is ETL? Explain how Enterprise Application Integration (EAI) and
Web Services support business operations. [6]
b) What are the trends in using psychographic, demographic, geographic,
and web behavior data? Discuss their social and ethical impacts. [6]
OR
Q6) a) What is parallelism in Business Intelligence? How do parallel processing
systems improve data handling? [6]
c) What are the main challenges in implementing ETL and parallel
processing in a company? Explain how these challenges can be
overcome through reports or presentations. [6]
Q7) a) List the Types of Data Errors and Analyze how each type affects
organizational processes. Evaluate why organizations must invest in
data cleansing to prevent these errors. [7]
b) Explain the business case of Knowledge Discovery and Data Mining.
Analyze how directed and undirected data mining techniques support
decision making and discuss their management issues. [7]
OR
Q8) a) What is Data Enhancement? Explain the business case for data
enhancement and analyze the management issues associated with
incremental and batch data enhancements. [7]
b) Explain different public data resources used in business intelligence.
How can insights derived from such data be effectively presented
through reports or dashboards? [7]
✩✩✩
[PEC-521C]