DMBA117 DATA VISUALIZATION JULY AUG 2025

Description

SESSION	JULY-AUGUST 2025
PROGRAM	MASTER OF BUSINESS ADMINISTRATION (MBA)
SEMESTER	I
COURSE CODE & NAME	DMBA117 DATA VISUALIZATION

 

 

Assignment Set – 1

 

 

Q1. Explain the importance of storytelling in data visualization. (Principles of Visualization). Use graphics. 10           

Ans 1.

In the modern business world, data visualization goes beyond creating charts and graphs—it tells a story. Storytelling in data visualization combines analytical insights with visual design to make information meaningful and actionable. It bridges the gap between complex data and decision-making, helping audiences quickly understand trends, patterns, and relationships.

Importance of Storytelling in Data Visualization

1. Simplifies Complex Data

Data storytelling transforms raw data into an easy-to-understand narrative. Large datasets can

MUJ

Its Half solved only

Buy Complete assignment from us

Price – 190/  assignment

MUJ Manipal University Complete SolvedAssignments  JULY-AUGUST  2025

buy cheap assignment help online from us easily

we are here to help you with the best and cheap help

Contact No – 8791514139 (WhatsApp)

OR

Mail us-  [email protected]

Our website – https://muj.assignmentsupport.in/

 

Q2. Differentiate between data types in Excel (numbers, text, dates) and explain how they influence chart creation and formatting. 10

Ans 2.

Excel is one of the most powerful tools for data visualization and analysis. It supports various data types—numbers, text, and dates—that influence chart design, data organization, and formatting. Understanding these data types ensures accuracy, enhances presentation, and avoids visualization errors during analysis.

1. Numbers

Numbers represent quantitative data used in calculations and visual representation. They can

 

Q3. Describe the process of creating a PivotTable and PivotChart in Excel. You may insert screenshots of steps with a dummy data set.  10

Ans 3.

Excel users have access to advanced tools such as PivotTables and PivotCharts, which enable them to efficiently summarize, analyze, and visualize big datasets.  Considering that they assist in the transformation of raw data into useful insights, they are a vital component of decision-making in corporate analytics and reporting.

Process of Creating a PivotTable

Step 1: Prepare the Dataset

Ensure that the data is organized in a tabular format with clear headings and no blank rows or

 

 

Assignment Set – 2

 

 

Q4. What are slicers and timelines in Excel? Explain with suitable examples. 10          

Ans 4.

Slicers and timelines in Excel are powerful interactive tools used for filtering data in PivotTables and PivotCharts. They make it easier for users to visualize and analyze large datasets by allowing them to filter information dynamically without using traditional drop-down menus. These tools transform static reports into interactive dashboards, enhancing user experience and data interpretation.

Slicers in Excel

Slicers are visual filtering tools that provide buttons for filtering data in PivotTables or

 

 

Q5. Compare Excel and Tableau as visualization tools. 10          

Ans 5.

Excel and Tableau are two widely used data visualization tools, each offering unique capabilities for data analysis and reporting. While Excel is a traditional spreadsheet application known for its analytical functions, Tableau is a specialized data visualization and business intelligence (BI) platform designed for interactive dashboards and advanced analytics. Both tools serve the same goal—transforming data into meaningful insights—but they differ in functionality, performance, and scalability.

Data Handling and Performance

Excel is best suited for handling small to moderately large datasets, typically within a few

 

Q6. Explain the use of calculated fields and parameters are used in Tableau. 10         

Ans 6.

Tableau is a leading data visualization and business intelligence tool that allows users to transform raw data into meaningful insights through interactive dashboards. Among its many features, calculated fields and parameters are essential for creating advanced analytics and enhancing user interactivity. These features make Tableau a flexible platform for customized