Business Analytics — DU B.Com. (Hons.) Previous Year Question Papers

1. State whether the following statements are True or False. Justify your answer with reasons: (a) A business dashboard with more charts and visuals always improves managerial decision-making. (b) Structured data is generally easier to analyse than unstructured text data. A regression model with a high R? value is always reliable for business prediction. (d) Text mining converts unstructured textual information into meaningful business insights. (e) Correlation between two variables guarantees a cause-and-effect relationship. 2. (a) An e-commerce company wants to improve customer retention and increase profitability using analytics. 1 . Explain how Business Analytics can suppo¥ strategic decision-making in such a situation. 2. Differentiate between : (i) Descriptive Analytics (ii) Predictive Analytics (iii) Prescriptive Analytics 3 . Using suitable examples, explain how each category of analytics can help the company improve performance. (b) (c) What is the differenc; between business analytics and qata analysis? What are the maj.or levels or scales of measuring data? (a) A retail chain uses dashboards to monitor monthly sales, customer complaints, and inventory levels across different regions. 1. Explain the role of dashboards in business reporting and decision-making. 2. Discuss the importance of data cleaning and data validation before creating dashboards. 3 . Explain any four characteristics of ail effective dashboard. 4. Suggest suitable visualization tools/charts for: (i) Regional sales comparison (ii) complaint analysis (iii) Product category. contribution (b) A Pivot Table is a powerful aggregate tool in a spreadsheet. 'Elaborate. Also, discuss the benefits of using a pivot Table for aggre.gation. (10) (c) Briefly explain,the various, assumptions of linear regression.. (5) 1f fae mahe le flolig all HE e be te me fe bank sobe (4) (s)