Business Performance Management Data Analytics and Business Intelligence 1 — Questions and Answers
Question 1: What is the primary purpose of business intelligence (BI) in performance management?
- To automate all business processes
- To transform raw data into actionable insights for decision-making (Correct answer)
- To replace human decision-making entirely
- To manage employee performance reviews
Correct answer: To transform raw data into actionable insights for decision-making
Business intelligence transforms raw data into meaningful insights that support strategic and operational decision-making.
Question 2: Which type of analytics focuses on understanding what happened in the past?
- Predictive analytics
- Prescriptive analytics
- Descriptive analytics (Correct answer)
- Cognitive analytics
Correct answer: Descriptive analytics
Descriptive analytics examines historical data to summarize and report on what happened in the past.
Question 3: A data warehouse differs from a transactional database primarily because it is optimized for:
- Real-time transaction processing
- Storing unstructured data only
- Reporting and analytical queries (Correct answer)
- Managing user authentication
Correct answer: Reporting and analytical queries
Data warehouses are designed for read-heavy analytical queries and reporting, unlike transactional databases built for CRUD operations.
Question 4: What does ETL stand for in data management?
- Evaluate, Test, Launch
- Extract, Transfer, Load
- Enable, Track, Log
- Extract, Transform, Load (Correct answer)
Correct answer: Extract, Transform, Load
ETL (Extract, Transform, Load) describes the process of extracting data from sources, transforming it into the required format, and loading it into a destination system.
Question 5: Which visualization type is most appropriate for showing the proportion of parts to a whole?
- Line chart
- Scatter plot
- Pie chart (Correct answer)
- Histogram
Correct answer: Pie chart
Pie charts display how parts contribute to a whole, making proportional relationships immediately visible.
Question 6: KPIs displayed in a BI dashboard should primarily be:
- As numerous as possible for comprehensive coverage
- Aligned with strategic business objectives (Correct answer)
- Focused solely on financial metrics
- Updated manually on a monthly basis
Correct answer: Aligned with strategic business objectives
Effective KPIs must align with strategic objectives to ensure performance tracking drives meaningful business outcomes.
Question 7: What is a 'data silo' in the context of business intelligence?
- A specialized storage unit for sensitive information
- A backup copy of the primary database
- A method for securing data against unauthorized access
- A system where data is isolated in separate departments and not shared across the organization (Correct answer)
Correct answer: A system where data is isolated in separate departments and not shared across the organization
Data silos occur when departments store data independently without sharing it, preventing organization-wide analysis and creating inconsistencies.
Business Performance Management Data Analytics and Business Intelligence 1
What is the primary purpose of business intelligence (BI) in performance management?