Business Performance Management Data Analytics and Business Intelligence 2 — Questions and Answers
Question 1: Predictive analytics in business performance management is primarily used to:
- Forecast future outcomes based on historical data and statistical models (Correct answer)
- Document historical performance records
- Visualize current performance in real time
- Automate routine data entry tasks
Correct answer: Forecast future outcomes based on historical data and statistical models
Predictive analytics uses historical data patterns and statistical models to forecast future trends and performance outcomes.
Question 2: What is the role of a 'drill-down' feature in a BI dashboard?
- To delete unnecessary data from the database
- To merge multiple data sources into a single view
- To schedule automated report generation
- To navigate from summary-level data to more detailed underlying information (Correct answer)
Correct answer: To navigate from summary-level data to more detailed underlying information
Drill-down allows users to explore progressively more detailed data levels, moving from high-level summaries to granular details.
Question 3: In data analytics, the purpose of data normalization is to:
- Increase the overall volume of data stored
- Organize data to reduce redundancy and improve data integrity (Correct answer)
- Convert qualitative data into quantitative metrics
- Encrypt sensitive business data
Correct answer: Organize data to reduce redundancy and improve data integrity
Data normalization organizes database tables to minimize redundancy and dependency, improving data integrity and consistency.
Question 4: A company notices declining customer satisfaction scores. Which analytics approach best identifies the root cause?
- Prescriptive analytics
- Predictive analytics
- Descriptive analytics
- Diagnostic analytics (Correct answer)
Correct answer: Diagnostic analytics
Diagnostic analytics investigates why something happened by examining data relationships and patterns to pinpoint root causes.
Question 5: What distinguishes structured data from unstructured data?
- Structured data is always larger in volume
- Structured data is always more valuable than unstructured data
- Structured data is organized in a predefined format with rows and columns (Correct answer)
- Structured data can only be processed by specialized software
Correct answer: Structured data is organized in a predefined format with rows and columns
Structured data follows a predefined schema organized in rows and columns, like relational databases, making it easily searchable and analyzable.
Question 6: Which type of analytics recommends optimal actions to achieve desired business outcomes?
- Prescriptive analytics (Correct answer)
- Predictive analytics
- Descriptive analytics
- Diagnostic analytics
Correct answer: Prescriptive analytics
Prescriptive analytics goes beyond forecasting to recommend specific actions that will achieve optimal outcomes.
Question 7: Which metric is most commonly used to measure the effectiveness of a business intelligence implementation?
- The number of data sources connected to the BI system
- Return on investment (ROI) from improved decision-making (Correct answer)
- The total storage capacity of the data warehouse
- The number of reports generated per month
Correct answer: Return on investment (ROI) from improved decision-making
ROI from improved decision-making ties the BI investment to actual business outcomes, making it the most meaningful measure of effectiveness.
Business Performance Management Data Analytics and Business Intelligence 2
Predictive analytics in business performance management is primarily used to: