DMBA117 DATA VISUALIZATION

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

Its Half solved only

Buy Complete from our online store

 

https://smuassignment.in/online-store/

 

MUJ Fully solved assignment available for session Jul-Aug 2025.

 

Lowest price guarantee with quality.

Charges INR 198 only per assignment. For more information you can get via mail or Whats app also

Mail id is aapkieducation@gmail.com

 

Our website www.smuassignment.in

After mail, we will reply you instant or maximum

1 hour.

Otherwise you can also contact on our

whatsapp no 8791490301.

 

 

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 include integers, decimals, percentages, and currency values. Excel automatically recognizes numeric data for operations

 

 

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 columns. For example, consider a dataset containing columns like “Product,” “Region,” “Sales,” and “Profit.”

Step 2: Select the Data

 

 

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

 

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

 

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 analysis and dynamic data exploration.

Calculated Fields in Tableau

Calculated fields are user-defined formulas created to generate new data from existing fields. They allow users