Data Visualisation — DU B.Com. (Hons.) Previous Year Question Papers

a) "Data visualisation is not just about making charts; it is about telling a story with data that drives better decision-making." Discuss role of data visualisation in modern business and financial analysis. (6 Marks) b) You are asked to present a ‘role of a data analyst’ to a group of university students. How do you explain the transition from mere data entry to creating data-driven stories? OR c) Compare the utility of Comparison-based charts like Bar and Column against distribution-based charts (like Histograms). Under what specific data conditions should an analyst choose one over the other for gaining hands-on experience with financial data? (6 Marks) d) Describe the specific utility of Stock Charts and Histogram Charts in financial analysis. How does a histogram provide a different perspective on risk and return compared to a standard line chart? (6 Marks) a) Elaborate on advance feature of spreadsheet like conditional for matting, and Sparklines. Also explain how these tools make data interpretation easy and understandable? (6 Marks) b) “The right chart can reveal patterns that tables often hide.” Explain in detail this statement with reference to spreadsheet-based visualisation. (6 Marks) OR c) Suppose you are tracking daily stock prices and need to show both price and volume simultaneously. Which specialised chart would you choose, and why? Write a short note on any two of following: I. Hierarchical charts II. waterfall charts III. Funnel charts a) Discuss the role of slicers and timelines in making dashboards interactive and useful. (6 Marks) b) “An effective dashboard turns data into action.” Explain this statement with reference to spreadsheet dashboards. (6 Marks) Explain the use of power view and power map with suitable example. (6 Marks) What do you mean by Power Query? Explain its importance in preparing data for visualisation. (6 Marks) c) d) Explain the steps involved in cleaning, transforming, and loading data in Power Explain how merging and appending data help in building a complete financial report. (6 Marks) Discuss possible data sources used in Power BI for financial reporting. (6 Marks) " A dashboard is a summary of the past, but an interactive Power BI report is a tool for the future." In light of this statement, analyse the role of Visualization Controls in Power BI. (6 Marks) a) " Tableau does not just create charts; it creates a dialogue between the user and the data through its 'Show Me architecture”. In light of this statement explain the significance of the 'Show Me pane in Tableau Public. (6 Marks) b) Describe the steps involved in creating a Tableau dashboard and adding a brand filter. (6 Marks) c) Discuss how Tableau suggests specific visualization types based on the combination of dimensions and measures selected. Also explain how does this feature assist an analyst in adhering to best practices in data storytelling? d) How bar charts, line charts, and combination charts are created and used in