ASSIGNMENT

SESSION JULY-AUGUST 2025

PROGRAM MASTER OF BUSINESS

ADMINISTRATION (MBA)

SEMESTER 01
NAME SATHWIK S KUMAR
ROLL NO. 251450520441
COURSE CODE & NAME DMBA117 DATA VISUALIZATION

Page 1 of 12
 Assignment Set – 01
Question 01.

Answer:

Introduction
Data visualization is more than just showing charts, graphs, or numbers. Its main purpose is to
communicate information clearly so that people can understand it easily. Storytelling in data
visualization adds meaning and direction to the visuals. It helps the audience connect with the
data and understand the message behind it. Without a story, even a good chart may look
confusing or fail to highlight the key insight. Because of this, storytelling is an important part
of creating effective and impactful visualizations.
Importance of Storytelling in Data Visualization :

1. Helps the Audience Understand Better:

A story gives context to the data. When we guide the viewer with a narrative, it becomes
much easier for them to understand what the numbers mean and why they are important.
Without a story, people may misinterpret or miss the main point.

2. Makes the Data More Interesting :

Stories make visuals more engaging. When charts are linked to real situations or business
problems, people feel more connected to the information. This keeps their attention and
makes the visualization more meaningful.

3. Supports Better Decision-Making :

Organizations rely on data to make decisions. Storytelling highlights the key trends, patterns,
and comparisons so that decision-makers know where to focus. A clear storyline helps them
take the right actions based on the insights shown.

4. Reduces Complexity :
Large amounts of data can look complicated. Storytelling breaks the information into simple
and logical steps. Using elements like colors, labels, and annotations helps viewers follow the
flow easily and understand even complex topics.

5. Improves Recall and Memory :

People tend to remember stories more than plain numbers or isolated facts. When a
visualization has a strong narrative, the audience can recall the insights later. This makes the
message more powerful and long-lasting.

Conclusion
Storytelling plays a vital role in data visualization because it gives clarity, purpose, and
meaning to the data. It turns ordinary charts into informative and engaging messages that help
people understand and remember the insights clearly. By combining visual elements with a
good story, data becomes easier to interpret and more impactful for decision-making.

Page 2 of 12
Question 2.

Answer:

Introduction
Microsoft Excel is a powerful tool used for organizing data, doing calculations, and creating
charts. Excel works with different types of data, and the most common ones are numbers, text,
and dates. Each data type behaves differently, and this affects how charts are created and how
information is formatted. Knowing the difference between these data types helps in making
clear, correct, and meaningful charts.

1. Numbers
Definition:
Numbers include whole numbers, decimals, percentages, and currency values. They are mainly
used for calculations.

Characteristics:

 Can be used in formulas and mathematical operations.

 Can be formatted into currency, percentage, or general number styles.

Influence on Chart Creation:

 Numbers usually appear as values on the vertical (Y) axis of a chart.

 Excel automatically adjusts the scale of numbers to make comparisons easy.
 If numbers are typed as text by mistake, Excel will not plot them correctly.

Influence on Formatting:

 Numbers can be shown with decimals, currency symbols, or percentage signs.

 Proper formatting makes charts easier to read and understand.

2. Text

Definition:
Text refers to words, letters, or any entry that Excel does not treat as a number or date.

Characteristics:

 Cannot be used for mathematical calculations.

 Mostly used to name or identify data.

Influence on Chart Creation:

Page 3 of 12
  Text usually appears on the horizontal (X) axis as category labels.
 These labels help explain what each bar, line, or point in the chart represents.
 If numerical data is stored as text by mistake, Excel may show incorrect chart results.

Influence on Formatting:

 Text can be formatted by changing font size, color, style, or alignment.

 Clear text labels help users understand charts better.

3. Dates

Definition:
Excel stores dates as numbers that represent the number of days from a starting reference date
(usually 1 January 1900).

Characteristics:

 Dates can be shown in many formats like DD/MM/YYYY or Month-Year.

 Can be used in time-based calculations such as counting days or months.

Influence on Chart Creation:

 Dates are commonly used in time-based charts (time series).

 Excel automatically arranges dates in order.
 Using dates helps show trends over time, such as monthly sales or yearly growth.

Influence on Formatting:

 Selecting the correct date format avoids confusion, especially when data is shared
across regions.

Conclusion
Understanding the difference between numbers, text, and dates in Excel is important for
creating correct and meaningful charts. Numbers provide the actual values, text helps label the
data, and dates help show how things change over time. Using the right data type and proper
formatting leads to clear, accurate, and professional-looking charts.

Question 3.

Answer:

Page 4 of 12
Introduction
PivotTables and PivotCharts in Excel are useful tools that help summarize and understand large
amounts of data. A PivotTable allows you to quickly organize and analyze data, while a
PivotChart shows the same summary in a visual format. These tools are helpful for finding
patterns, comparing values, and presenting information clearly.

Here is a small sample dataset to explain the steps:

Product Region Sales

A North 1200
A South 900
B North 1500
B East 1000
C West 1800

This table shows the sales of different products in different regions.

Steps to Create a PivotTable
Step 1: Select the Data

 Highlight the full data table, including the column headings (Product, Region, Sales).

Step 2: Insert PivotTable

 Go to the Insert tab on the Excel ribbon.

 Click on PivotTable.
 A dialog box will appear:
o Make sure the selected range is correct.
o Choose where you want the PivotTable:
 New Worksheet (recommended)
 or Existing Worksheet
 Click OK.

Step 3: Add Fields to the PivotTable

After clicking OK, you will see the PivotTable Field List on the right side.

You can drag fields into these four areas:

 Rows → Product
 Columns → Region (optional)
 Values → Sales (Sum of Sales)
 Filters → Region or Product (optional)

Example PivotTable Output

Page 5 of 12
 Product Total Sales
A 2100
B 2500
C 1800

This summary helps you quickly compare product sales.

Steps to Create a PivotChart

Step 1: Select the PivotTable

 Click anywhere inside your PivotTable.

Step 2: Insert a PivotChart

 Go to Insert → PivotChart.
 Choose a chart type (Column, Bar, Line, etc.).
 Click OK.

Step 3: Format the PivotChart

 Add a chart title.

 Adjust colors or labels if needed.
 Make the chart easy to read and understand.

Example PivotChart Output

A simple column chart would show Product A, B, and C on the X-axis and their total sales on
the Y-axis. This makes the comparison clear.

Conclusion
PivotTables and PivotCharts are very helpful tools in Excel for analyzing and presenting data.
PivotTables let you summarize information quickly without changing the original data, and
PivotCharts turn those summaries into clear visual charts. Using both together helps in better
decision-making and makes it easier to explain insights to others.

Assignment Set – 02

Question 4.

Answer:

Introduction

Excel has many tools that help make data analysis easier and more interactive. Two very useful
tools among them are Slicers and Timelines. These tools are mostly used with PivotTables and

Page 6 of 12
PivotCharts to filter information quickly. They help users explore data in a simple, visual way
instead of using normal drop-down filters.

Slicers
Definition

A slicer is a visual filter in Excel. It shows filter options as clickable buttons. When you click
a button, the data in the PivotTable or PivotChart updates instantly. Slicers are usually linked
to fields like Category, Product, Region, etc.

Characteristics

 Appears as a box with buttons for different filter options.

 More than one slicer can be used at the same time.
 The selected option is clearly highlighted so you can see your filter easily.

Example

Imagine we have a PivotTable showing Monthly Sales by Employee.

Employee Total Sales

Arjun 45,000

Riya 52,300

Kabir 38,900

Now you add a slicer for Department with the options:

[Sales] [Marketing] [Finance] [Support]

If you click Sales, the PivotTable will only show employees who belong to the Sales
department. The PivotChart connected to it also updates instantly.
This makes it very simple to compare data between departments.

Advantages of Slicers

 Easy to use and understand

 Makes filtering more visual
 Helps create clean, interactive dashboards

Page 7 of 12
Timelines
Definition

A Timeline is a special type of slicer used only for filtering by dates. It allows you to filter your
PivotTable using time periods like Year, Quarter, Month, or Day.

Characteristics

 Works only if your PivotTable has a date field

 Shows a horizontal date bar
 You can drag the slider to pick a date range

Example

Suppose we have a dataset that records Daily Website Visitors for the whole year.
After creating a PivotTable that summarizes the total visitors per month, you insert a Timeline
for the Date field.

The timeline might show:

| Jan | Feb | Mar | Apr | May | Jun | ... | Dec |

If we drag the slider from July to September, the PivotTable will only show visitor data for
those three months.
This helps us easily spot seasonal patterns—like increases during holidays or drops in off-
season months.

Advantages of Timelines

 Very fast and interactive for date filtering

 Perfect for time-series data
 Allows switching between Month, Quarter, and Year view easily

Conclusion

Slicers and Timelines make working with PivotTables and PivotCharts much easier. Slicers
help filter category-based information with one click, making dashboards look more interactive
and clear. Timelines help filter data by date ranges, which is useful for analyzing trends over
time. Both tools improve understanding and make data analysis more user-friendly.

Question 5.

Answer:

Introduction

Page 8 of 12
Data visualization helps people understand information more clearly by turning raw numbers
into visuals. Two commonly used tools for creating visualizations are Microsoft Excel and
Tableau. Both help present data in charts, graphs, and dashboards, but they work differently
and are used for different purposes.

Excel

Microsoft Excel is mainly a spreadsheet tool used for entering data, performing calculations,
and creating basic charts. Because it is easy to use and available almost everywhere, it is widely
used in offices, schools, and daily tasks.

Strengths of Excel

1. Simple to Learn: Most people are already familiar with Excel, so it is easy to start
working with.
2. Common Visualizations: It supports basic charts like bar, line, pie charts, and even
PivotCharts.
3. Strong Calculation Features: Excel has many formulas and functions that help with fast
data analysis.
4. Easily Accessible: It comes with Microsoft Office, so almost every organization
already uses it.

Limitations of Excel

 It slows down when working with very large datasets.

 Visualizations are less interactive.
 Customizing dashboards is limited compared to advanced tools.

Tableau

Tableau is a powerful software designed mainly for data visualization and analytics. It helps
create dynamic and interactive dashboards, especially when dealing with big data.

Strengths of Tableau

1. Handles Big Data Easily: It can connect to multiple data sources and process large
datasets smoothly.
2. Interactive Dashboards: Tableau allows users to add filters, slicers, and drill-down
options in dashboards.
3. Advanced Charts: It provides many visualization options like heatmaps, maps, tree
maps, scatter charts, and more.
4. Drag-and-Drop System: You can build visuals by simply dragging fields, without
writing formulas or code.

Limitations of Tableau

 Requires training and practice to use effectively.

 It is more costly than Excel.

Page 9 of 12
  Not suitable for data entry or heavy calculations.

Key Differences Between Excel and Tableau

Feature Excel Tableau

Primary Use Data entry, formulas, basic charts Advanced visuals and dashboards

Data Handling Slower with large datasets Works well with big datasets

Customization Limited Highly flexible

Skill Requirement Easy to learn Needs practice/training

Conclusion

Excel and Tableau both are useful, but they serve different purposes. Excel is best for everyday
data work, calculations, and simple charts. Tableau, on the other hand, is ideal for creating
interactive and detailed dashboards, especially when the data is large or complex. The choice
depends on what kind of analysis you need and your comfort with the tool.

Question 6.
Answer:
Introduction

Tableau is widely used for data analysis and visualization because it allows users to explore
and interpret data in flexible and interactive ways. While the tool provides many default fields,
users often need additional calculations or interactive controls to gain deeper insights. This is
where calculated fields and parameters become essential features.

Calculated Fields in Tableau

Definition
A calculated field is a custom field created by applying formulas to existing data. It enables
users to perform mathematical, logical, or text-based operations that are not directly available
in the raw dataset.
Purpose and Uses

 Creating New Metrics:

Organizations can derive additional measures such as Profit = Sales – Cost to support
decision-making.

Page 10 of 12
  Conditional Analysis:
Calculated fields allow the use of expressions such as IF statements to categorize data
(e.g., marking regions as “High Sales” or “Low Sales”).
 Standardizing Data:
These fields can be used for converting units, cleaning text, or extracting specific
portions of a string.
 Enhancing Visuals:
They can be applied in filters, color schemes, tooltips, and labels, adding more
meaning and context to a visualization.

Example

To compute profit margin in Tableau, the following formula can be used:

Profit Margin = (SUM(Sales) - SUM(Cost)) / SUM(Sales)

This calculated field helps compare profitability across regions, products, or time periods.

Parameters in Tableau
Definition

A parameter is a dynamic input control created by the user. It can hold a single value—such
as a number, text, or date—that replaces a constant in calculations, filters, or reference lines.
Unlike filters, parameters do not filter data on their own; they work in combination with
calculated fields.

Purpose and Uses

 profit margin in Tableau:

Parameters allow viewers to change values and see results instantly, improving user
engagement.
 Switching Measures or Dimensions:
A parameter can enable users to toggle between metrics such as Sales, Profit, or
Quantity.
 Adjusting Thresholds:
Users can set their own benchmark values (e.g., minimum profit), making analyses
more flexible.
 What-If or Scenario Analysis:
Parameters help modify inputs such as discount rates to understand their impact on
overall revenue.

Example

A parameter can be created to allow users to select the metric they want to compare. A linked
calculated field then displays the chosen measure based on the parameter value, making the
visualization dynamic.

Page 11 of 12
Conclusion :

Calculated fields and parameters significantly enhance the analytical power of Tableau.
Calculated fields help create custom metrics and perform deeper analysis, while parameters
introduce flexibility by allowing users to interact with the data. Together, they make Tableau
dashboards more insightful and user-friendly.

Page 12 of 12