MIS Business Intelligence and Analytics 1 — Questions and Answers
Question 1: What is the primary purpose of Business Intelligence (BI) systems?
- To automate routine transaction processing
- To transform raw data into actionable insights for business decisions (Correct answer)
- To manage human resource records
- To process customer orders automatically
Correct answer: To transform raw data into actionable insights for business decisions
Business Intelligence systems collect, integrate, and analyze data to provide actionable insights that support strategic and operational decision-making.
Question 2: A data warehouse differs from an operational database in that it is:
- Smaller and updated in real time
- Subject-oriented, integrated, time-variant, and non-volatile (Correct answer)
- Used only for payroll processing
- Accessible only to IT staff
Correct answer: Subject-oriented, integrated, time-variant, and non-volatile
Bill Inmon's definition of a data warehouse describes it as subject-oriented, integrated, time-variant, and non-volatile — optimized for analysis rather than transactions.
Question 3: What is OLAP (Online Analytical Processing)?
- A real-time transaction processing system
- A technology for fast multi-dimensional analysis of large data sets (Correct answer)
- An online ordering platform
- A network monitoring protocol
Correct answer: A technology for fast multi-dimensional analysis of large data sets
OLAP enables users to perform fast, flexible, multi-dimensional analysis on large datasets to support business reporting and analysis.
Question 4: In BI, 'drill down' refers to:
- Importing data from external sources
- Navigating from summary data to increasingly detailed levels (Correct answer)
- Removing redundant data from the warehouse
- Exporting reports to external systems
Correct answer: Navigating from summary data to increasingly detailed levels
Drill down allows users to navigate from high-level summary data into progressively more detailed data levels, such as from annual to quarterly to monthly figures.
Question 5: Which of the following is an example of a BI dashboard KPI?
- A raw SQL database query
- Monthly revenue growth rate displayed as a gauge chart (Correct answer)
- A server uptime log file
- An employee email thread
Correct answer: Monthly revenue growth rate displayed as a gauge chart
KPIs on BI dashboards are quantifiable metrics like monthly revenue growth, displayed visually to give executives quick performance overviews.
Question 6: What is ETL in the context of data warehousing?
- Enterprise Technology Licensing
- Extract, Transform, Load — moving data from sources to the warehouse (Correct answer)
- Encrypted Transaction Language
- External Transfer Link
Correct answer: Extract, Transform, Load — moving data from sources to the warehouse
ETL (Extract, Transform, Load) is the process of extracting data from source systems, transforming it to meet warehouse standards, and loading it into the data warehouse.
MIS Business Intelligence and Analytics 1
What is the primary purpose of Business Intelligence (BI) systems?