Midterm Exam Reviewer PDF

**BUSINESS INTELLIGENCE REVIEWER** 1. What is the primary goal of Business Intelligence (BI)? - **Enhancing decision-making with data-driven insights** 2. What does the "S" in DSS stand for? - **Support** 3. Which of the following is a characteristic of Model-Driven DSS? - **Uses comp...

**BUSINESS INTELLIGENCE REVIEWER** 1. What is the primary goal of Business Intelligence (BI)? - **Enhancing decision-making with data-driven insights** 2. What does the "S" in DSS stand for? - **Support** 3. Which of the following is a characteristic of Model-Driven DSS? - **Uses complex algorithms to simulate scenarios** 4. Which system allows managers to simulate the impact of decisions before implementing them? - **Decision Support System (DSS)** 5. Which component of BI architecture provides data visualization capabilities? - **Performance dashboard** 6. How does BI differ from traditional reporting tools? - **BI offers both descriptive and predictive insights, whereas reports summarize past data.** 7. What role does a DSS play in tactical decision-making? - **Provides information to support mid-level decisions** 8. What is one benefit of data-driven decision-making? - **Allows decisions based on real-time data insights** 9. Which scenario exemplifies the use of Model-Driven DSS? - **A business simulates various pricing strategies to maximize profit** 10. How can a company apply DSS to improve supply chain management? - **By analyzing logistics and inventory levels** 11. In what way can BI tools enhance a marketing campaign's effectiveness? - **By segmenting customer data for targeted advertising** 12. A company's DSS indicates that increasing marketing expenditures have not resulted in higher sales. What might be the first step in analyzing this data? - **Review customer demographics and preferences** 13. When analyzing data from a DSS, what is a potential risk managers must consider? - **The accuracy and relevance of the data** 14. If a company decides to implement a new DSS, what should they analyze to ensure its success? - **User requirements and system compatibility** 15. What factor might a company analyze to determine the effectiveness of its DSS? - **User satisfaction and decision accuracy** 16. What is a data warehouse primarily used for? - **Storing and managing historical data for analysis** 17. Which component is essential for data warehousing? - **Data Integration tools** 18. What does ETL stand for in data warehousing? - **Extract, Transform, Load** 19. Why is data integration important in a data warehouse? - **It allows for a unified view of data from different sources** 20. How does a data warehouse differ from a traditional database? - **Data warehouse support complex queries and analytics over historical data** 21. What is a staging area in the context of data warehousing? - **A temporary storage for data during the ETL process** 22. A company is implementing a new data warehouse. What should they consider during the ETL process? - **The quality and source of incoming data** 23. How might a business use its data warehouse for sales analysis? - **By analyzing trends in historical sales data to forecast future sales** 24. In evaluating a data warehouse, which aspect should be prioritize? - **Data accuracy and retrieval speed** 25. If a data warehouse is not yielding useful insights, what should analysts investigate first? - **The quality and relevance of the data being input** 26. What is the purpose of data visualization - **To communicate complex data clearly and effectively** 27. Which of the following is a common data visualization tool? - **Microsoft Excel** 28. What is a dashboard in the context of data visualization? - **A visual display of key metrics and performance indicators** 29. Which visualization technique is best for showing trends over time? - **Line graph** 30. What type of chart is ideal for comparing parts of a whole? - **Pie chart** 31. Which of the following best describes visual analytics? - **The use of visual methods to understand and analyze data** 32. What is a key benefit of using color in data visualization? - **To highlight important information and differentiate data points** 33. In the context of business performance management, what does a balanced scorecard typically include? - **Metrics across financial, customer, internal processes, and learning/growth perspectives.** 34. Which data visualization method would best illustrate the relationship between two quantitative variables? - **Scatter plot** 35. How does data visualization improve decision-making? - **By making data more accessible and understandable** 36. Why is it important to consider the audience when creating a data visualization? - **Different audiences may prefer different data formats** 37. What is the main challenge when using visualizations to present data? - **Ensuring that visualizations do not mislead the audience** 38. In which scenario would a heat map be most useful? - **Showing the distribution of data points over geographic regions** 39. What is a potential drawback of using 3D visualizations? - **They can make it harder to accurately interpret the data** 40. What role does storytelling play in data visualization? - **It enhances the understanding and engagement of the audience** 41. Which principle should guide the design of effective data visualization? - **Prioritize simplicity and clarity** 42. When should you choose a bar chart over a pie chart? - **When comparing multiple categories or groups** 43. What is the purpose of using annotations in data visualizations? - **To provide additional context and insights to the audience** 44. If you need to present sales data for different regions, which visualization would best help identify the highest-performing region? - **Bar chart** 45. How might an organization use data visualization to improve customer satisfaction? - **By analyzing customer feedback data to identify trends and areas for improvement** 46. When preparing a presentation with multiple data visualizations, what should you ensure? - **Each visualization has a clear purpose and supports to your main message** 47. Which data visualization technique would best illustrate the growth of company's revenue over the last five years? - **Line graph** 48. If data visualizations consistently show an unexpected drop in sales, what should the business do first? - **Investigate possible causes for the drop by analyzing underlying data** 49. When evaluating the effectiveness of a dashboard, what is the critical factor? - **User feedback on ease of use and clarity of information** 50. If a visualization leads to a misinterpretation of data, what should be assessed? - **The clarity and design of the visualization**