DMBA117: Data Visualization

MASTER OF BUSINESS ADMINISTRATION

SEMESTER 1

DMBA117
DATA VISUALIZATION
Unit: 7 - Building Basic Visualizations in Tableau 1
DMBA117: Data Visualization

Unit – 7
Building Basic Visualizations in Tableau

Unit: 7 - Building Basic Visualizations in Tableau 2

DMBA117: Data Visualization

TABLE OF CONTENTS

SL Fig No / Table / SAQ / Page

Topic
No Graph Activity No
1 Introduction - -
4
1.1 Objectives - -
2 Creating Basic Charts - -

2.1 Guide to Bar Charts 1, 2, 3, 4, 5 -

5 - 20
2.2 Guide to Line Charts 6, 7, 8, 9, 10 -

2.3 Guide to Pie Charts 11, 12. 13, 14, 15 -

3 Customizing Visual Elements - -
3.1 Labels in Tableau 16 -
21 - 31
3.2 Colors in Tableau 17 -
3.3 Tooltips in Tableau 18 -
4 Filters, Sets, and Groups - -
4.1 Filters in Tableau - -
32 - 40
4.2 Sets in Tableau - -
4.3 Groups in Tableau - -
5 Summary - - 41
6 Glossary - - 42 - 43
7 Self-Assessment Questions - 1 44
8 Terminal Questions - - 45
9 Answers - - 46 - 47
10 Suggested Books and References - - 48

Unit: 7 - Building Basic Visualizations in Tableau 3

DMBA117: Data Visualization

1. INTRODUCTION
In modern information analysis, data visualization is essential, offering a graphical avenue for
conveying complex data and insights. Through the expert utilization of visual elements such as charts,
graphs, and maps, data visualization tools become the channel that transforms raw data into a visually
clear narrative. This approach offers a potent means of rendering trends, outliers, and patterns
observable, thus empowering users to easily grasp the details of data.

In conclusion, data visualization is not merely a secondary component of data analysis; it's a
transformative approach that complements information and perception. It empowers individuals
across a spectrum of technical expertise to derive meaning from complex datasets, accelerating
decision-making processes and fostering a more comprehensive understanding of data-driven
narratives. In the era of Big Data, where information overload is a pressing concern, data visualization
emerges as a vital navigational tool, guiding us through the intricacies of data and transforming them
into insights that fuel progress and innovation.

1.1. Objectives
After studying this unit, you should be able to:
• Recall fundamental concepts of data
visualization, including terminology, data types
and common graphical representations.
• Explain the relationship between data
visualization and effective communication.
Compare and contrast different visualization
techniques, discussing their strengths and
weaknesses in conveying specific types of information.
• Demonstrate the ability to choose appropriate visualization types based on the characteristics
of the data and the communication goals.
• Justify the choice of visualization methods by explaining how they enhance understanding of
specific insights.
• Critique existing data visualizations regarding their accuracy, clarity, and potential biases.

Unit: 7 - Building Basic Visualizations in Tableau 4

DMBA117: Data Visualization

2. CREATING BASIC CHARTS

Tableau’s intuitive drag-and-drop interface makes creating basic charts straightforward, allowing
users to transform raw data into meaningful visualizations. Basic charts like bar, line, and pie charts
are fundamental tools for analyzing data and uncovering insights. Bar charts are ideal for comparing
values across discrete categories, such as sales by product or region. They can be further customized
as stacked or side-by-side bars for multi-dimensional analysis. Line charts excel at showing trends
over time, making them invaluable for tracking growth, identifying seasonal patterns, or forecasting
future performance. Pie charts, while best used sparingly, represent proportions within a dataset,
such as market share by category or revenue contribution by region.

Creating these charts in Tableau begins with selecting dimensions and measurements from the data
pane and placing them on the appropriate shelves—Columns and Rows. Tableau automatically
generates the best-suited chart type, which users can refine using the Marks card to adjust colours,
labels, and tooltips. For example, adding dimensions to the Color mark can reveal deeper insights,
such as segmenting a line chart by product categories to track individual trends. These charts simplify
complex data and empower users to explore, interact with, and present insights visually engagingly,
forming the foundation of impactful data storytelling in Tableau.

2.1. Guide to Bar Charts

Bar charts are among Tableau's most versatile and widely used visualization types, offering a clear
way to compare data across discrete categories. Whether you are analyzing sales by product category,
revenue by region, or expenses by department, bar charts provide an intuitive and visually
straightforward method for data comparison. Tableau’s drag-and-drop functionality makes creating
and customizing bar charts simple, allowing users to focus on analyzing insights rather than grappling
with design complexities.

Unit: 7 - Building Basic Visualizations in Tableau 5

DMBA117: Data Visualization

Fig 7.1. A standard example of a Bar chart in Tableau

Steps to Create a Bar Chart:

1. Drag a Dimension to the Columns Shelf:

Dimensions, such as Category, define the labels or categories for your bar chart. When you drag a
dimension to the Columns shelf, Tableau places each unique value of that dimension as a label on
the X-axis. For example, if your dataset contains product categories like "Furniture," "Office
Supplies," and "Technology," these will appear as labels across the horizontal axis.

2. Drag a Measure to the Rows Shelf:

Measures, such as Sales or Profit, determine the height of the bars. Dragging a measure to the
Rows shelf tells Tableau to plot the numerical values for each corresponding category on the Y-
axis. For example, dragging SUM to the Rows shelf will create bars representing the total sales for
each product category.

Fig 7.2. Column and Row selection

Unit: 7 - Building Basic Visualizations in Tableau 6

DMBA117: Data Visualization

3. Automatic Bar Chart Generation:

Tableau automatically detects that you are combining a dimension and a measure, generating a
bar chart by default. The result is a simple vertical bar chart where each bar's length corresponds
to the measure's value.

Select “Bar” under the Marks tab if automatic generation does not occur.

Fig 7.3. Marks tab

4. Sorting the Bars:

Use the Sort button in the toolbar to improve readability and highlight trends. You can sort the
bars in ascending or descending order based on the measure, making it easier to identify top-
performing categories or trends at a glance.

Enhancing the Bar Chart

Stacked Bar Charts:

Use a stacked bar chart to show the contribution of subcategories within a category. For example,
drag a secondary dimension, like Sub-Category, to the Color mark on the Marks card. This breaks
down each bar into segments, where each segment's length represents a subcategory's contribution
to the total value.

Unit: 7 - Building Basic Visualizations in Tableau 7

DMBA117: Data Visualization

Fig 7.4. Average Bar Chart

Side-by-Side Bars:
Drag a second dimension (e.g., Year) to the Columns shelf to compare categories across multiple
dimensions. This displays individual bars for each combination of dimensions, such as sales by
category over multiple years.

Fig 7.5. A standard example of a Side-by-Side Bar

Unit: 7 - Building Basic Visualizations in Tableau 8

DMBA117: Data Visualization

Adding Labels:
Drag the measure (e.g., Sales) to the Label mark on the Marks card to display numerical values on
each bar, improving the chart's interpretability.

Example: Analyzing Sales by Product Category

Scenario:
A retail company wants to analyze its total sales across three main product categories—furniture,
Office Supplies, and Technology—and further break down sales by sub-categories.

Steps:
• Connect to the dataset, ensuring fields like Category, Sub-Category, and Sales are available.
• Drag Category to the Columns shelf. Tableau displays the categories—Furniture, Office
Supplies, and Technology—on the X-axis.
• Drag Sales to the Rows shelf. Tableau creates bars for each category, with the bar height
corresponding to the total sales for that category.
• Drag Sub-Category to the Color mark on the Marks card. The bars are now stacked, with each
segment representing the contribution of individual sub-categories (e.g., "Chairs" and "Tables"
under Furniture).
• Add Sales to the Label mark to display sales figures directly on the bars for each sub-category.

Result:
The resulting stacked bar chart visually communicates total sales by category and the contribution of
each sub-category, making it easier to identify top-performing and underperforming segments within
the business.

By following these steps and tips, you can effectively leverage bar charts to communicate data insights
in Tableau, customizing them to fit specific analysis needs.

2.2. Guide to Line Charts

Line charts are one of the most effective visualization tools for analyzing trends over time or
sequential data. Plotting data points along a continuous line makes it easy to observe patterns,
identify fluctuations, and forecast future outcomes. Line charts are useful for showing growth trends,
seasonal patterns, and time-series analysis.

Unit: 7 - Building Basic Visualizations in Tableau 9

DMBA117: Data Visualization

Fig 7.6. A standard line graph in Tableau

Steps to create a Line Chart:

Creating a line chart in Tableau is a simple process. The following steps will guide you through it:

1. Connect to Data:
Open Tableau and connect to your dataset, ensuring it contains a time-related field (e.g., Order
Date) and at least one measure (e.g., Sales or Profit).

2. Drag the Date Field to the Columns Shelf:

Dates are usually placed on the column's shelf to create the chart's X-axis. Tableau automatically
defaults to a continuous date hierarchy (e.g., Year, Quarter, Month).
If your dataset does not have a date field, you can create a similar effect using any sequential
dimension or custom aggregation.

3. Drag a Measure to the Rows Shelf:

Drag a measure like Sales or Profit to the row's shelf. Tableau will plot the measure along the Y-
axis, and a line chart will begin to take shape.

Fig 7.7. Dragging rows and columns

4. Refine the Time Granularity:

Tableau defaults to aggregating dates at the Year level. If you want to display data by a smaller
unit, such as months or days:

Unit: 7 - Building Basic Visualizations in Tableau 10

DMBA117: Data Visualization

• Right-click the date field on the Columns shelf.

• Select a lower level of granularity, such as Month or Week.

5. Customize the Visualization

• To show multiple trends on the same chart, drag another dimension (e.g., Category) to the
Color mark on the Marks card. This creates separate lines for each category.
• Add labels by dragging the measure (e.g., Sales) to the Label mark to display values at each
data point.
• Enhance tooltips by dragging fields to the Tooltip mark to provide additional context when
users hover over the chart.

Add Filters
Drag a field (e.g., Region or Product) to the Filters shelf to allow focus on specific subsets of the data.
Interactive filters can also be added to dashboards for user-driven exploration.

Customizing Line Charts:

Dual-Axis Line Chart

To compare two measures (e.g., Sales and Profit) on the same timeline, drag a second measure to the
Rows shelf. Right-click the second axis and select "Dual-Axis." Then, synchronize the axes to ensure
accurate comparison.

Fig 7.8. Dual Axis Line Chart

Unit: 7 - Building Basic Visualizations in Tableau 11

DMBA117: Data Visualization

Trend Lines
Tableau allows you to add trend lines to emphasize patterns or predictions. Go to the Analytics pane
and drag Trend Line to the chart to display linear or exponential trends.

Fig 7.9. Trend Lines are depicted in dashed lines across the line graphs

Shading and Reference Lines

Right-click the Y-axis and select Add Reference Line to add reference bands or lines for thresholds,
such as sales targets.

Fig 7.10. Example of Shading and Reference lines

Example: Tracking Monthly Sales Over Two Years

Unit: 7 - Building Basic Visualizations in Tableau 12

DMBA117: Data Visualization

Scenario:
A retail company wants to analyse its monthly sales trends over two years to identify peak sales
periods and compare performance across product categories.

Steps:
1. Connect to the Data
2. Load a dataset that includes fields like Order Date, Sales, and Category.
3. Create the Base Line Chart
4. Drag the Order Date to the Columns shelf. Tableau automatically sets the date granularity to
Year.
5. Right-click the Order Date field on the Columns shelf and select Month. This changes the X-axis
to display data points for each month.
6. Drag the measure Sales to the Rows shelf. Tableau plots the total sales for each month as a line.
7. Add Product Category Trends
8. Drag Category to the Color mark on the Marks card. This creates a distinct line for each product
category (e.g., Furniture, Office Supplies, Technology).

Enhance the Chart

• Drag Sales to the Label mark to display monthly sales values at each data point.
• Drag Category to the Filters shelf and enable multi-select filtering to let users toggle categories.

Add a Trend Line:

Go to the Analytics pane and drag Trend Line to the chart. Select a linear trend to visualize overall
growth patterns for each category.

Result:
The resulting line chart displays monthly sales trends for each product category over two years. Users
can easily observe peak sales periods, seasonal patterns, and category-specific performance trends.
The interactive filters allow further exploration, such as isolating a single category for detailed
analysis.
Line charts in Tableau provide a clean, dynamic way to convey trends, making them a cornerstone for
time-series analysis and performance monitoring.

2.3. Guide to Pie Charts

Pie charts are a popular visualization for displaying proportions within a dataset. They represent data
as slices of a circle, where each slice corresponds to a specific category’s contribution to the total.

Unit: 7 - Building Basic Visualizations in Tableau 13

DMBA117: Data Visualization

While pie charts are visually appealing and easy to interpret, they should be used sparingly to avoid
clutter and maintain clarity. They are most effective when showing proportions for a limited number
of categories with distinct value differences.

Fig 7.11. Pie Chart in Tableau

Steps to Create a Pie Chart:

1. Drag a Dimension to the Rows or Columns Shelf:
Dimensions define the categories that will appear as slices in the pie chart. For instance, dragging
Region to the Rows shelf ensures that slices represent distinct regions (e.g., East, West, North,
South). This step creates the foundation for dividing the data into categories.

2. Drag a Measure to the Size Mark on the Marks Card:

Measures, such as Profit or Sales, determine the size of each slice. Dragging a measure (e.g., Profit)
to the Size mark adjusts the proportional size of the slices based on the measure's values. Larger
values result in bigger slices, while smaller values create smaller slices.

3. Change the Marks Type to Pie:

By default, Tableau may display the data as a bar chart or another visualization. To convert it into
a pie chart:
• Go to the Marks card.

Unit: 7 - Building Basic Visualizations in Tableau 14

DMBA117: Data Visualization

• Change the Marks type from Automatic to Pie. This transforms the data representation into a
pie chart format.

Fig 7.12 Marks tab options

4. Drag the Dimension to the Color Mark:

Drag the same dimension (e.g., Region) to the Color mark on the Marks card to distinguish the
slices by category. Tableau will assign a unique color to each slice, making it easier to identify the
categories visually.

Tips for Effective Pie Charts

1. Minimize the Number of Slices:

Pie charts work best when there are 5-7 slices or fewer. Too many slices can make the chart
difficult to read and interpret. Consider grouping smaller values into an "Other" category for
datasets with more categories or using an alternative visualization like a bar chart.

2. Avoid Small Numerical Differences:

When the values of the slices are too close in size, it becomes challenging to differentiate between
them. In such cases, consider using a stacked bar chart or a sorted bar chart instead.

3. Add Labels and Tooltips:

Drag the measure to the Label mark to enhance readability to display the exact values or
percentages on each slice. Tooltips can provide additional context when users hover over a slice.

Types of Pie Charts in Tableau:

In Tableau, there are several variations and customizations of pie charts that you can create to
represent data better. While the standard pie chart is the most commonly used, Tableau's flexibility
allows users to design customizations to suit specific analytical needs. Below are the types of pie
charts in Tableau:

1. Donut Chart:
A donut chart is a variation of the pie chart that includes a hollow center. This format can be

Unit: 7 - Building Basic Visualizations in Tableau 15

DMBA117: Data Visualization

achieved in Tableau by overlaying a white circle on the center of a pie chart. While not a built-in
chart type, it can be created with minor adjustments.

How to create:
• Create a standard pie chart.
• Use a dual-axis chart by adding an empty field or constant to the Rows shelf and synchronizing
the axes.
• Adjust the size of the inner circle to create the hollow effect.

Best for:
Adding emphasis to a central label, such as total values or percentages.

Example:
Showing product category contributions while placing the total sales figure in the center.

Fig 7.13 Example of a Donut Chart

2. Pie Chart with Multiple Measures

This type of pie chart displays proportions for multiple measures by using calculated fields to
normalize the values.

How to create:
• Use calculated fields to aggregate multiple measures into one field.
• Assign these fields to the Size and Angle marks.

Unit: 7 - Building Basic Visualizations in Tableau 16

DMBA117: Data Visualization

Best for:
Comparing relative proportions of multiple measures across a dataset.

Example:
Showing the proportion of Sales, Profit, and Discount across regions.

3. Filtered Pie Chart

A filtered pie chart allows users to dynamically explore different data slices by applying filters or
parameters to adjust what is displayed.

How to create:
• Add dimensions or measures to the Filters shelf.
• Enable interactive filtering in the dashboard or worksheet.

Best for:
Letting users drill down into specific categories or time frames.

Example:
A pie chart where users can filter by year or region to see corresponding proportions.

4. Nested (Hierarchical) Pie Chart

Although Tableau does not natively support nested pie charts, they can be simulated using dual-
axis techniques. Nested pie charts show multiple levels of categorical data in a concentric layout.

How to create:
• Overlay two pie charts using dual axes, each representing different categorical levels (e.g.,
Category and Sub-Category).
• Adjust the sizes of the two charts to create a nested effect.

Best for:
Visualizing hierarchical data within proportions.

Example:
Showing product categories in the outer layer and sub-categories in the inner layer.

Unit: 7 - Building Basic Visualizations in Tableau 17

DMBA117: Data Visualization

Fig 7.14 Example of a Nested Pie chart

5. Pie Chart with Percentages

This variation explicitly shows the percentage contribution of each slice to the total rather than
raw values.

How to create:
• Add a Quick Table Calculation to the measure and select "Percent of Total."
• Drag this calculation to the Label mark to display percentages.

Best for:
Displaying proportions in an easy-to-interpret manner.

Example:
Showing the percentage of region contribution to total sales.

Unit: 7 - Building Basic Visualizations in Tableau 18

DMBA117: Data Visualization

Fig 7.15. Pie Chart with percentages

Example: Visualizing Regional Profit Distribution

Scenario:
A retail company wants to understand the contribution of each region (East, West, South, North) to
overall profit.

Steps:
1. Connect to the Dataset:
Load a dataset that includes fields such as Region and Profit.

2. Set Up the Pie Chart:

• Drag Region to the Rows shelf. This defines the categories for the slices.
• Drag Profit to the Size mark on the Marks card. The size of each slice is now proportional to
the profit for that region.
• Change the Marks type to Pie using the dropdown on the Marks card.

3. Color and Label the Slices:

• Drag Region to the Color mark to assign a unique color to each slice.
• Drag Profit to the Label mark to display profit values directly on the chart.

4. Enhance the Visualization:

• Adjust the size of the pie chart using the Size slider on the Marks card for better visibility.
• Use the Sort option to order the slices by profit, ensuring the largest slices are displayed first.

Unit: 7 - Building Basic Visualizations in Tableau 19

DMBA117: Data Visualization

5. Add Context:
When hovering over a slice, drag Region to the Tooltip mark to display additional details (e.g.,
region name and percentage contribution).

Result:
The pie chart visually communicates the profit distribution across regions. For example, the West
region might have the largest slice, indicating it contributes the most to overall profit. In contrast, the
North region might have a smaller slice, showing its lower contribution.

When to Use Pie Charts:

Pie charts are ideal for summarising proportions when the goal is to highlight a few key categories
and their relative contributions. However, bar charts or other visualisations are more effective for
datasets with numerous small categories or when precise comparison is required.

This careful application ensures pie charts remain an impactful part of your Tableau toolkit.

Unit: 7 - Building Basic Visualizations in Tableau 20

DMBA117: Data Visualization

3. CUSTOMIZING VISUAL ELEMENTS

Customizing visual elements in Tableau is essential for creating clear, engaging, and impactful
visualizations. Tableau provides users with numerous options to enhance the appearance of charts,
dashboards, and reports. Customization begins with modifying colors, fonts, and sizes to align with
organizational branding or to make data distinctions more apparent. For instance, you can use a
colour palette to differentiate product categories, highlight specific data points, or represent
performance metrics (e.g., green for growth and red for decline). Adjusting fonts and text sizes for
titles, labels, and legends ensures readability and draws attention to critical information.

Beyond basic formatting, Tableau offers tools to customize tooltips, which provide additional context
when users hover over data points. Tooltips can include a combination of dimensions, measures, and
even dynamic calculations, allowing users to explore data without overwhelming the visualization
itself. Additionally, marks like shapes and sizes can be tailored to enhance interpretability. For
example, using larger dots for higher sales values in a scatter plot or specific shapes to represent
unique data categories makes the visualization intuitive. You can also control mark transparency and
borders to avoid clutter, especially in dense datasets.

Another powerful feature is adding reference lines, bands, and annotations to provide context or
emphasize thresholds, trends, or outliers. For example, reference lines can indicate sales targets,
while annotations highlight specific points of interest in the data. Tableau dashboards allow for
further customization with interactivity, such as filters, parameters, and actions that enable users to
focus on specific data subsets. Combined, these visual enhancements ensure that Tableau
visualizations look professional and effectively communicate the story behind the data.

3.1. Labels in Tableau

Labels in Tableau are text elements that provide additional context to visualizations by displaying
specific information directly on the chart. They can include numerical values, percentages,
dimensions, or even calculated fields. Labels enhance the interpretability of charts and dashboards,
ensuring users can grasp key insights without hovering or exploring additional details.

Unit: 7 - Building Basic Visualizations in Tableau 21

DMBA117: Data Visualization

Fig 7.16 Example of Labels in Tableau

Key Features:

1. Adding Labels to Visualizations

• Labels can be added to a chart by dragging a field (dimension or measure) to the Label mark
on the Marks card.
• For example, dragging Sales to the Label mark in a bar chart will display the exact sales values
on each bar.

2. Customizing Labels
Tableau provides extensive options to format and customize labels, including:
• Font: Change font type, size, color, and style (bold, italic, etc.).
• Alignment: Adjust the position of labels relative to marks (e.g., top, middle, or bottom).
• Automatic Placement: Tableau automatically adjusts label positions to prevent overlapping,
ensuring clarity.
• Prefix/Suffix: Add text elements such as currency symbols, percentage signs, or units to labels.

Unit: 7 - Building Basic Visualizations in Tableau 22

DMBA117: Data Visualization

3. Dynamic Labels
• Tableau allows users to combine multiple fields in a single label.
• Use the Edit Label option (accessible via the Label mark) to concatenate fields or include text.
• For example, you can display "Region: East | Sales: $10,000" by combining the Region and Sales
fields in the label editor.

4. Conditional Labels
• Labels can be dynamically displayed based on conditions.
• For example, create a calculated field that only shows a label when Profit > 0 to highlight
profitable data points while hiding others.

5. Tooltips vs. Labels

• Labels display information directly on the visualization, whereas tooltips provide details only
when hovering over marks.
• Use labels for critical, high-level information and tooltips for supplementary details.

Steps to Add and Customize Labels:

1. Start with a Chart:

Create a chart in Tableau, such as a bar chart, line chart, or scatter plot.

2. Add a Field to the Label Mark:

• Drag a measure (e.g., Sales) or a dimension (e.g., Category) to the Label mark on the Marks
card.
• Tableau will display the values for the selected field as text labels on each mark.

3. Edit the Label

• Click the Label mark on the Marks card and select Edit Label to open the label editor.
• Combine fields or add static text (e.g., "Sales: " before the value).

4. Format the Label

• Click Font in the Label editor to customize font size, color, and alignment.
• Use the Advanced button to configure label placement for clarity.

5. Use Quick Table Calculations for Dynamic Labels

• Drag the same measure to the Label mark and apply a Quick Table Calculation (e.g., Percent of
Total).

Unit: 7 - Building Basic Visualizations in Tableau 23

DMBA117: Data Visualization

• The label will dynamically update to show the calculated value (e.g., percentages instead of
raw numbers).

6. Control Label Visibility

• To limit labels to specific marks, use a calculated field or filter.
• Example: Only display labels for values greater than a specific threshold (e.g., SUM(Sales) >
5000).

Example: Labeling a Sales Bar Chart

Scenario:
A retail company wants to create a bar chart showing sales by region, with labels displaying both the
sales amount and the percentage contribution to total sales.

Steps:
1. Build the Bar Chart: Drag Region to the Columns shelf and Sales to the Rows shelf. Tableau creates
a bar chart.

2. Add Sales Labels:

• Drag Sales to the Label mark on the Marks card.
• The sales values will now appear on top of each bar.

3. Add Percentage Labels”

• Drag Sales to the Label mark again.
• Right-click on the field in the Label and select Quick Table Calculation > Percent of Total.
• Edit the label text to show both the sales value and percentage (e.g., "Sales: $10,000 (25%)").

4. Customize the Labels

• Click the Label mark to open the editor. Adjust the font size, color, and alignment for clarity.
• Use automatic placement to avoid overlapping.

Result:
The bar chart now displays sales values and percentages for each region, clearly communicating both
absolute and relative performance.

Labels in Tableau are a powerful feature that makes visualizations more informative and user-
friendly. By customizing and strategically applying labels, you can create charts that effectively
convey key insights at a glance.

Unit: 7 - Building Basic Visualizations in Tableau 24

DMBA117: Data Visualization

3.2. Colors in Tableau

Colors in Tableau play a critical role in enhancing data visualizations by improving clarity,
highlighting trends, and guiding users' attention to key insights. Tableau provides extensive tools for
customizing colors, enabling users to align visuals with branding guidelines, emphasize critical data
points, or distinguish categories. Whether it’s a bar chart, scatter plot, or heat map, colors help to
make complex data easier to interpret and visually appealing.

Fig 7.17 Colors in Tableau

Ways to Use Colors in Tableau:

1. Assigning Colors to Dimensions and Measures

• For categorical dimensions, Tableau automatically assigns distinct colors to each category. For
example, in a sales dataset with regions like East, West, North, and South, Tableau may assign
a unique color to each region to help users visually distinguish between them.
• For quantitative measures, colors are applied as gradients based on values. For instance, a heat
map of sales figures may range from light blue (low sales) to dark blue (high sales).

2. Customizing Color Palettes

• Tableau offers several built-in color palettes, including categorical palettes (e.g., "Tableau 10")
and sequential palettes (e.g., "Orange-Blue Diverging"). Users can customize these palettes in
the Edit Colors dialog to align with branding or specific visual preferences.

Unit: 7 - Building Basic Visualizations in Tableau 25

DMBA117: Data Visualization

• You can also upload custom color palettes by modifying Tableau's preferences file (JSON
format) to include specific HEX or RGB codes.

3. Color Marks in the Marks Card

• Dragging a dimension or measure to the Color mark in the Marks card allows Tableau to
automatically apply colors. For dimensions, colors distinguish categories, while gradients
represent intensity or magnitude for measures.
• Additional fields, such as calculated fields or parameters, can be dragged to the Color mark for
more dynamic visualizations.

4. Dual-Axis Charts with Color

Tableau enables the use of two different color schemes on dual-axis charts. For instance, a line
chart showing sales might use blue for sales trends, while a secondary axis for profit might use
red, creating a clear distinction.

5. Diverging Color Scales

Diverging color scales are helpful when highlighting positive and negative values in the same
dataset. For example, a profit chart may use green for positive values and red for losses.

6. Customizing Legends and Tooltips

• Legends in Tableau dynamically update as you assign colors, giving users a clear
understanding of the color scheme. You can also modify legend placement and titles for clarity.
• Additionally, tooltips can include colour values to add context when users hover over marks.

Best Practices for Using Colors:

• Avoid Overusing Colors: Use a limited color palette to prevent overwhelming users or creating
confusion. For instance, a chart with more than seven colors can become difficult to interpret.
• Use Meaningful Color Choices: Align colours with intuitive or culturally recognized meanings, such
as green for growth and red for decline.
• Account for Accessibility: Ensure visualizations are accessible to users with colour blindness by
using colour palettes designed for colour vision deficiencies, such as Tableau's Color-Blind palette.
• Use Contrasts for Emphasis: Apply high-contrast colors to draw attention to critical data points or
thresholds.

Unit: 7 - Building Basic Visualizations in Tableau 26

DMBA117: Data Visualization

Example: Visualizing Sales by Region Using Colors

Scenario:
A retail company wants to create a bar chart showing sales by region and highlight the regions with
the highest and lowest sales using colors.
Steps:
1. Build the Chart:
Drag the Region field to the Columns shelf and Sales to the Rows shelf. Tableau will generate a bar
chart.

2. Apply Colors:
Drag the Sales measure to the Color mark on the Marks card. Tableau automatically applies a
gradient, with darker colors representing higher sales values.

3. Customize the Gradient:

Click the Color mark, select Edit Colors, and choose a diverging palette like "Red-Blue Diverging."
To distinguish visually, assign red to low and blue to high sales.

4. Add Context:
Include a color legend for user reference. When hovering over bars, add tooltips to display sales
values and regions.

5. Highlight Specific Regions:

Create a calculated field to flag the highest and lowest sales regions (e.g., IF [Sales] =
WINDOW_MAX([Sales]) THEN "Highest" ELSEIF [Sales] = WINDOW_MIN([Sales]) THEN "Lowest"
ELSE "Other" END). Use this calculated field as a dimension and assign specific colours (e.g., gold
for "Highest," grey for "Other," and red for "Lowest").

Result:
The bar chart displays sales by region, with the highest and lowest sales distinctly colored. Users can
quickly identify performance patterns and focus their analysis on outliers. Colors in Tableau not only
improve aesthetics but also significantly enhance the storytelling capability of your visualizations. By
thoughtfully applying color techniques, you can make your Tableau dashboards more insightful and
impactful.

3.3. Tooltips in Tableau

Tooltips in Tableau are dynamic information boxes that appear when users hover over a data point

Unit: 7 - Building Basic Visualizations in Tableau 27

DMBA117: Data Visualization

or mark in a visualization. They provide additional details about the selected data, offering more
context without cluttering the visualization. Tooltips are a powerful feature for improving
interactivity and depth in Tableau dashboards, enabling users to explore data insights effectively
without overloading the main visual.

Fig 7.18 Example of a Tooltip

Features of Tooltips:

1. Default Tooltips:
Tableau automatically generates tooltips based on the fields included in the visualization. For
example, hovering over a bar in a bar chart might display the bar’s dimension (e.g., Region) and
measure (e.g., Sales).

2. Customizing Tooltips
Users can fully customize the content and format of tooltips to enhance their utility and
appearance:
• Adding Fields: Drag dimensions, measures, or calculated fields to the Tooltip mark in the
Marks card to include them in the tooltip.
• Formatting: Customize font styles, sizes, colors, and alignments for better readability.
• Static Text and Dynamic Values: Combine static text with dynamic data fields to create
informative and visually appealing tooltips. For instance, "Region: East | Sales: $10,000 | Profit:
$2,000".

3. Dynamic Tooltips
Tooltips can display dynamic content such as percentages, ranks, or calculated field results. This

Unit: 7 - Building Basic Visualizations in Tableau 28

DMBA117: Data Visualization

allows users to see tailored information for each data point based on context.

4. Using Multiple Fields in Tooltips

Tableau allows users to combine multiple fields into a single tooltip. For example, in a scatter plot,
tooltips might display the Customer Name, Region, Sales, and Profit for each mark.

5. Conditional Tooltips
Tooltips can display specific content based on conditions by leveraging calculated fields or filters.
For instance, they can show only profit-related details if a product’s profit margin is below a
certain threshold.

6. Interactive Features in Tooltips

Tableau supports Viz in Tooltip, a feature that embeds another visualization directly inside the
tooltip. When hovering over a mark, users can see an interactive mini-chart that provides deeper
insights.

7. Global and Sheet-Level Tooltips

Tooltips can be customized for individual sheets or applied globally across dashboards to ensure
consistency in multi-chart views.

Steps to Customize Tooltips:

1. Access Tooltip Settings

• In a worksheet, click the Tooltip mark on the Marks card.

2. This opens the Tooltip Editor, where you can format and customize the content.
Add Fields to Tooltip:Drag any dimension or measure to the Tooltip mark. These fields will
automatically appear in the tooltip text.

3. Format the Tooltip:

In the Tooltip Editor, edit the text to include dynamic and static fields. For example:
Region: <Region>
Sales: $<SUM(Sales)>
Profit: $<SUM(Profit)>

4. Style the Tooltip:

You can use the formatting toolbar to change font size, style, and alignment. You can also apply
background colors for better visibility.

5. Add Interactive Visuals (Viz in Tooltip):

Unit: 7 - Building Basic Visualizations in Tableau 29

DMBA117: Data Visualization

Drag a secondary worksheet to the Tooltip field. Configure it to display related data when
hovering over a mark in the primary visualization.

6. Test the Tooltip:

Hover over marks in your visualization to ensure the tooltip displays as expected.

Example: Customizing Tooltips in a Sales Dashboard

Scenario:
A retail manager wants a tooltip on a scatter plot showing sales and profit for each product, with
additional details such as the product category, sub-category, and profit margin.

Steps:
1. Build the Scatter Plot
• Drag Sales to the Columns shelf and Profit to the Rows shelf.
• Drag the Product Name to the Detail mark on the Marks card to ensure tooltips appear for each
product.

2. Customize the Tooltip

Click the Tooltip mark. In the Tooltip Editor, format the text to include:
• Dynamic fields: <Product Name>, <Category>, <Sub-Category>, <Sales>, <Profit>, and a
calculated field for profit margin.
• Static text: Add context to the dynamic fields (e.g., "Product Name: ").
• Final text example:
Product Name: <Product Name>
Category: <Category> | Sub-Category: <Sub-Category>
Sales: $<SUM(Sales)> | Profit: $<SUM(Profit)>
Profit Margin: <Calculated Profit Margin>%

3. Style the Tooltip:

Apply bold text for the product name and adjust the alignment for clarity.

4. Test the Tooltip:

Hover over points in the scatter plot to see the tooltip displaying detailed product information.

Result:
The scatter plot now includes a tooltip for each product, providing rich contextual details like
category, sub-category, sales, profit, and profit margin. This enhances the visualization's interactivity

Unit: 7 - Building Basic Visualizations in Tableau 30

DMBA117: Data Visualization

and usefulness, enabling the retail manager to make informed decisions quickly.

Tooltips are a simple yet powerful feature in Tableau. They allow users to explore data in detail
without overcrowding the visualization. Thoughtfully customized tooltips can significantly improve
the usability and interactivity of dashboards.

Unit: 7 - Building Basic Visualizations in Tableau 31

DMBA117: Data Visualization

4. FILTERS, SETS, AND GROUPS

Filters, sets, and groups are fundamental tools in Tableau that enable users to refine, segment, and
organize data for better analysis and visualization. They empower users to handle large datasets
effectively by focusing on specific data points, creating meaningful segments, or consolidating similar
values. These tools are essential for developing dynamic dashboards and reports that can adapt to
user inputs and provide targeted insights. By understanding and combining these features, analysts
can create efficient and insightful visualisations.

Filters narrow the dataset by including or excluding specific data points based on user-defined
criteria. They can be applied to dimensions (e.g., categories, regions) or measures (e.g., sales, profit),
enabling users to analyze data subsets relevant to their goals. Filters also enhance interactivity in
dashboards, allowing end users to explore data dynamically through dropdowns, sliders, or other
controls. Whether filtering data by periods, geographic regions, or numerical ranges, Tableau
provides various filtering options to accommodate different analytical needs.

Sets and groups, however, are powerful tools for segmenting and categorizing data. Sets allow users
to define subsets of data based on specific conditions or selections, which can be dynamic (updating
automatically as data changes) or fixed (static subsets). Groups, meanwhile, are used to combine
related items into a single category, such as grouping similar products or regions. These tools help
simplify data, enable comparisons, and highlight trends. Filters, sets, and groups offer a
comprehensive approach to organizing and exploring data in Tableau, making it easier to uncover
actionable insights.

4.1. Filters in Tableau

Filters in Tableau are essential for narrowing down data, enhancing interactivity, and providing users
with control over the data they want to explore. Filters allow you to display only specific subsets of
data based on criteria like dimensions, measures, dates, or calculated fields. By applying filters, you
can create focused and insightful visualizations tailored to your audience's needs.

Types of Filters in Tableau:

1. Dimension Filters:
• Dimension filters allow you to include or exclude specific categories or groups within a dataset.
• Example: Filtering a "Region" field to display only "North" and "South" regions in a chart.

Unit: 7 - Building Basic Visualizations in Tableau 32

DMBA117: Data Visualization

2. Measure Filters
• Measure filters work on numerical data, allowing you to set conditions or ranges.
• Example: Displaying only sales greater than $10,000 or profit margins above 20%.

3. Date Filters
• These filters allow users to focus on data from specific periods.
• Options include relative dates (e.g., "last 30 days"), ranges (e.g., "January to March"), or specific
dates (e.g., "January 1, 2023").

4. Wildcard Filters
• Wildcard filters are applied to text fields, allowing partial matches.
• Example: Filtering product names that contain "Pro" or "Elite."

5. Context Filters
• Context filters are applied before all other filters as a pre-filtering mechanism to improve
performance or apply hierarchical logic.
• Example: Using a context filter to restrict data to a specific region before applying other filters
like product or sales.

6. Top N Filters
• These filters allow users to display the top or bottom N values based on a measure.
• Example: Showing the top 10 products by sales.

Features of Filters:

1. Interactive Filters
Filters can be added to dashboards as filter controls, allowing users to interact with visualizations
dynamically. For example, users can select a region from a dropdown list to update all associated
charts.

2. Filter Options
• Keep Only: Retains selected data points in the visualization.
• Exclude: Removes selected data points from the visualization.

3. Customizing Filter Display

• Filters can appear as dropdowns, checkboxes, sliders, or as a search bar.
• Customize filter options to allow single or multiple selections.

Unit: 7 - Building Basic Visualizations in Tableau 33

DMBA117: Data Visualization

4. Cascading Filters
Tableau supports cascading filters, where one filter's selection dynamically updates the available
options in another filter. For instance, selecting a region filter might narrow the choices for
product categories in another filter.

5. Filter Actions in Dashboards

• Filters can be configured to work across multiple sheets in a dashboard, ensuring consistent
data views.
• Example: Clicking on a bar in one chart filters the data in a related chart.

Steps to Create Filters

1. Add a Filter:
Drag a field (dimension or measure) to the Filters shelf.

2. Define Filter Criteria

• For dimensions, select the categories to include or exclude.
• For measures, specify a range or condition (e.g., SUM(Sales) > 10,000).
• For dates, choose relative, range, or specific date options.

3. Customize the Filter

Right-click on the filter in the Filters shelf to adjust settings, such as making it a context filter or
adding a condition.

4. Show Filter Controls

• To make the filter interactive, right-click on the filter and select Show Filter.
• Customize the filter display type (e.g., dropdown, slider, etc.).

5. Test the Filter

Interact with the filter to ensure it works as expected and dynamically updates your visualization.

Example: Applying Filters to a Sales Dashboard

Scenario:
A retail company wants to create a dashboard to analyze sales data for specific regions, products, and
time periods.

Steps:
• Build the Dashboard:
Create visualizations for sales by region (bar chart), product (tree map), and time (line chart).

Unit: 7 - Building Basic Visualizations in Tableau 34

DMBA117: Data Visualization

• Add Region Filter:

Drag the Region field to the Filters shelf. Select regions (e.g., North, South, East, West) and apply
the filter.

• Add Date Filter:

Drag the Order Date field to the Filters shelf. Select Relative Dates and configure it to show data
from the last 12 months.

• Add Product Category Filter:

Drag the Category field to the Filters shelf. Show the filter as a dropdown menu in the dashboard.

• Test Interactivity
Add the filters to the dashboard by selecting Show Filter. Test the filters by selecting regions,
categories, and time periods to see how all charts update dynamically.

Result:
The dashboard is now interactive, allowing users to analyze sales for specific regions, product
categories, and timeframes. For example, selecting "Furniture" in the category filter and "East" in the
region filter updates all charts to display relevant data.

Filters in Tableau are versatile tools that enable users to interact with data dynamically, focus on
relevant subsets, and discover actionable insights. By combining filters with interactivity, you can
create dashboards that are both powerful and user-friendly.

4.2. Sets in Tableau

Sets in Tableau are custom subsets of data that you can create based on specific conditions or
selections. They are dynamic and versatile tools for analyzing data by isolating certain categories,
ranges, or values. Sets can help focus on specific data points while allowing comparisons between the
selected subset and the rest of the data. Tableau supports two types of sets: fixed sets and dynamic
sets, each serving different analytical purposes.

Types of Sets:

1. Fixed Sets
• Fixed sets are created manually by selecting data points. Once created, they remain static and
do not update automatically when the underlying data changes.
• Use Case: If you want to analyze sales performance for a specific group of products, such as
"Furniture" and "Office Supplies," you can manually create a fixed set containing these

Unit: 7 - Building Basic Visualizations in Tableau 35

DMBA117: Data Visualization

products.

2. Dynamic Sets
• Dynamic sets are based on conditions or rules, and they update automatically as the data
changes.
• Use Case: A dynamic set could include customers whose total sales exceed $10,000. If a new
customer meets the condition in the future, they will be included in the set automatically.

Creating and Using Sets:

1. Manual Selection
Select data points directly in the visualization or data pane, right-click, and choose Create Set. This
creates a fixed set based on the selected points.

2. Condition-Based Sets
Right-click on a field in the data pane, select Create, and then choose Set. Define conditions based
on dimensions or measures. For example, "Include customers where total sales > $10,000."

3. Combining Sets
• Tableau allows you to combine multiple sets using operations like AND, OR, and EXCEPT. This
is useful for comparing subsets or analyzing overlaps.
• Example: Create one set for customers in the "East" region and another for customers with
high sales. Combine these sets to analyze customers who meet both conditions.

4. Using Sets in Visualizations

• Drag the set to the Rows, Columns, or Filters shelf to visualize or filter data based on the set.
• You can also use sets as part of calculations or in dashboards to create interactivity.

5. Set Actions
Sets can be dynamically controlled through Set Actions in dashboards. For instance, clicking on a
region in one chart could update another chart to display only the data for that region.

Example: Analyzing High-Performing Customers

Scenario:
A retail company wants to analyze customers who have made purchases exceeding $15,000 in total
sales.

Steps:
1. Create a Dynamic Set

Unit: 7 - Building Basic Visualizations in Tableau 36

DMBA117: Data Visualization

• Right-click on the Customer Name field in the data pane and select Create > Set.
• In the Set dialog box, go to the Condition tab.
• Set the condition as: SUM(Sales) > 15,000.
• Name the set "High-Performing Customers."

2. Use the Set in a Visualization

• Drag Customer Name to the Rows shelf and Sales to the Columns shelf.
• Drag the "High-Performing Customers" set to the Filters shelf. This filters the view to display
only customers with total sales above $15,000.

3. Create a Comparison
• Add another bar chart to compare the sales of "High-Performing Customers" versus all
customers.
• Drag the set to the Color mark on the second chart. Tableau will automatically divide the data
into "In" (customers in the set) and "Out" (customers not in the set).

Result:
The visualization highlights high-performing customers, enabling the company to focus its strategies,
such as loyalty programs or personalized offers, on these valuable clients. Dynamic updating ensures
that new high-performing customers are automatically included in the analysis.

Benefits of Using Sets

• Flexibility: Sets allow for highly customized data segmentation, whether static or dynamic.
• Comparison: Analyze subsets of data against the rest of the dataset effortlessly.
• Interactivity: Set Actions make dashboards more interactive, enabling user-driven
exploration.
• Reusability: Sets can be reused across multiple visualizations, saving time and maintaining
consistency.

Sets are a cornerstone of advanced analysis in Tableau, making them an indispensable tool for
analysts aiming to gain deeper insights into their data.

4.3. Groups in Tableau

Groups in Tableau
Groups in Tableau are used to consolidate multiple data points into a single category for simplified
analysis. This feature is particularly helpful when you have several distinct values in a dimension but

Unit: 7 - Building Basic Visualizations in Tableau 37

DMBA117: Data Visualization

want to analyze or visualize them as broader categories. By grouping data, you can clean up
visualizations, focus on specific aspects of the data, and make charts more understandable.

For example, if a dataset contains individual product names, you can group them into broader
categories like "Office Supplies," "Furniture," and "Technology." Groups are static, meaning they don’t
update automatically when new data is added unless you manually edit the group.

How to Create Groups

Manual Grouping
• In the data pane or visualization, right-click on a dimension field, then choose Create > Group.
• A dialog box opens where you can select multiple values and group them into a single category.
• Example: Select multiple regions (e.g., "Northwest" and "Southwest") and group them as "Western
Region."

Using the Group Icon

• In a visualization, select marks directly on the chart, then click on the Group icon in the tooltip.
Tableau will automatically group the selected items.

Ungrouping
• You can remove items from a group at any time. Open the group, deselect the items you want to
ungroup, and click OK.

Editing Groups
• To modify a group, right-click on the group field in the data pane and select Edit Group. You can
add new items, rename categories, or adjust groupings as needed.

Use Cases for Groups

Simplifying Data for Analysis

• Grouping helps condense data with numerous distinct values into manageable categories.
• Example: Grouping individual cities into broader regions like "East," "West," "North," and "South."

Enhancing Visualizations
• Groups reduce visual clutter, making charts easier to interpret. Instead of displaying individual
product names, a bar chart can show sales by product category.

Customizing Hierarchies
• Groups can be combined with hierarchies for drill-down analysis. For example, you can group
countries into continents and then create a hierarchy to analyze global sales.

Unit: 7 - Building Basic Visualizations in Tableau 38

DMBA117: Data Visualization

Comparing Segments
• Grouping data allows you to compare different segments more effectively. For example,
comparing grouped regions or customer types.

Steps to Use Groups in a Visualization

Drag the Group Field

• Once a group is created, Tableau treats it as a new dimension. Drag this grouped field to the Rows,
Columns, or Filters shelf to incorporate it into your visualization.

Customize Visuals
• Use the grouped field on the Color, Size, or Label mark to highlight categories. For instance, display
sales by grouped regions in a bar chart.

Example: Grouping Product Sub-Categories

Scenario: A retail company wants to analyze sales by broader product categories instead of
individual sub-categories.

Steps:

1. Create Groups
In the data pane, right-click on the Sub-Category field and select Create > Group.
In the Group dialog box:
• Group "Chairs," "Tables," and "Bookcases" as "Furniture."
• Group "Copiers," "Machines," and "Phones" as "Technology."
• Leave other sub-categories ungrouped or group them as "Other."

2. Build a Bar Chart

Drag the Group field to the Rows shelf and Sales to the Columns shelf. Tableau automatically
displays a bar chart of sales by the new grouped categories.

3. Format and Analyze

Add labels or colors to highlight the grouped categories.
Analyze how "Furniture" and "Technology" perform compared to "Other."

Result:
The bar chart now aggregates sales data into broader categories, making it easier for stakeholders to
focus on the bigger picture rather than getting lost in granular details.

Unit: 7 - Building Basic Visualizations in Tableau 39

DMBA117: Data Visualization

Benefits of Using Groups in Tableau

• Simplified Visuals: Consolidates data for cleaner and more readable charts.
• Enhanced Analysis: Allows comparisons at a broader level, which can uncover trends that may
not be evident in detailed data.
• Flexibility: Easy to edit and adapt to changing analytical needs.
• Focus on Insights: By grouping irrelevant or minor categories, you can emphasize the most
important aspects of the data.

Groups are an invaluable feature for anyone working with complex datasets, enabling streamlined
visualizations and improved data storytelling in Tableau.

By mastering these fundamental techniques, you can create visually appealing and insightful Tableau
dashboards. These skills will form the foundation for building more advanced visualizations and
analyses in Tableau.

Unit: 7 - Building Basic Visualizations in Tableau 40

DMBA117: Data Visualization

5. SUMMARY
The chapter on data visualization explores the significance, applications, and types of this powerful
technique for representing information visually. Data visualization plays a pivotal role in
transforming complex data sets into comprehensible visuals, aiding in quicker insights and informed
decision-making.

The applications of data visualization are diverse and far-reaching. In healthcare, it helps doctors
comprehend patient histories rapidly, leading to improved emergency care. In business intelligence,
cloud-connected analytics facilitate data-driven decision-making. Military applications involve rapid
delivery of accurate information for informed action, while finance industries benefit from visualizing
customer behavior and investment strategies.

The chapter delves into the different types of data visualizations. Comparison visualizations, such as
bar charts and population pyramids, excel at showcasing variations between values. Pattern
visualizations, like line graphs and scatter plots, reveal trends and relationships in data. Changes
visualizations, like candlestick charts, focus on displaying changes over time, particularly in financial
analysis.

Lastly, the chapter discusses conceptual visualizations like flowcharts and mind maps that represent
abstract concepts and processes. It explores planning and calendar visualizations, including calendars
and timelines, which provide insights into scheduling and temporal relationships.

In summary, the chapter underscores the pivotal role of data visualization in transforming complex
data into actionable insights across various domains. It highlights its applications and showcases the
diversity of visualization types that contribute to better understanding, informed decision-making,
and effective communication of data-driven information.

Unit: 7 - Building Basic Visualizations in Tableau 41

DMBA117: Data Visualization

6. GLOSSARY
Financial Management is concerned with the procurement of the least cost funds, and its effective

The graphical representation of information and data using visual elements

Data
- such as charts, graphs, and maps to simplify the interpretation of complex
Visualization
datasets.

A visualization technique that uses rectangular bars to represent and

Bar Chart -
compare categorical data, such as sales figures or product performance.

A circular chart divided into sectors, each representing a proportion of the

Pie Chart -
whole, often used to show percentage distributions.

A graphical tool used to visualize relationships or correlations between two

Scatter Plot -
numerical variables, often revealing trends or patterns.

A visual interface that consolidates multiple data visualizations, providing

Dashboard -
a comprehensive overview of key metrics for decision-making.

Anomaly The process of identifying unusual patterns or outliers in data, often used
-
Detection in fraud detection or quality control.

Predictive The ability to forecast future trends or behaviors based on historical data,
-
Capabilities often visualized through time series or trend graphs.

KPI (Key
A measurable value that indicates how effectively an individual or
Performance -
organization is achieving key objectives, often visualized on dashboards.
Indicator)
A graphical representation of data where values are depicted by color
Heatmap - intensity, commonly used for analyzing geographic or categorical data
distributions.

Storytelling with The practice of using data visualizations to communicate insights

-
Data effectively, often in a narrative format that resonates with the audience.

Supply Chain The management of resources, logistics, and workflows in production and
-
Management delivery, often optimized using data visualization tools.

The process of identifying fraudulent activities in financial or transactional

Fraud Detection -
data, frequently supported by visual tools to highlight anomalies.

Unit: 7 - Building Basic Visualizations in Tableau 42

DMBA117: Data Visualization

Data-Driven A process of making decisions based on data analysis and visualization

-
Decision Making rather than intuition or observation alone.

Data that represents distinct categories or groups, such as regions,

Categorical Data -
products, or departments, often visualized with bar or pie charts.

Data expressed in numbers, such as sales figures or revenue, typically

Numerical Data -
analyzed using scatter plots, line graphs, or histograms.

The process of working together across teams, facilitated by data

Collaboration - visualization tools that make data insights accessible to both technical and
non-technical stakeholders.

Actionable Data-driven conclusions that can be implemented directly to improve

-
Insights processes or strategies, often derived from dashboards or visual analyses.

Resource The process of distributing resources effectively, such as funds, manpower,

-
Allocation or materials, often optimized using visual data representations.

Strategic The process of defining an organization's direction and making decisions

-
Planning on resource allocation, supported by data visualizations for clarity.

Dynamic Fast-changing operational or market conditions where data visualization

-
Environments helps organizations adapt and make timely decisions.

Unit: 7 - Building Basic Visualizations in Tableau 43

DMBA117: Data Visualization

7. SELF-ASSESSMENT QUESTIONS
Answer the Following:
1 What is the purpose of data visualization?
2 What does data visualization do for different expertise levels?
3 What does data visualization combine with technical analysis?
4 What does data visualization turn raw data into in business intelligence?
5 What does data visualization assist with in data science?
6 What does a Candlestick Chart display?
7 What is the primary purpose of a Mind Map?
8 What does data visualization aid in identifying in emergencies?
Multiple Choice Questions:
9 What does data visualization help military commanders understand quickly?
a) Financial data
b) Troop movements
c) Consumer behaviour
d) Political trends
10 How does data visualization impact real estate professionals?
a) Managing food delivery
b) Showcasing property information
c) Analysing customer reviews
d) Monitoring financial markets

Unit: 7 - Building Basic Visualizations in Tableau 44

DMBA117: Data Visualization

8. TERMINAL QUESTIONS
Short Answer Questions

1. Discuss the role of data visualization in shaping professional skills and career opportunities.
2. Explain the concept of the "citizen data scientist" and the role of data visualization in this
context.
3. Discuss the crucial role of data visualization in military applications.
4. Explain how data visualization enhances data science processes
5. Explain how data visualization impacts the field of Business Intelligence.
6. Explain the concept and utility of a Bubble Map in data visualization.

Long Answer Questions

1. Define data visualization and explain its role in simplifying complex data for effective
communication.
2. Discuss the significance of data visualization in decision-making processes across different
industries. Provide examples to support your answer.
3. Identify and describe at least three practical applications of data visualization in real-world
scenarios. How does it impact business strategies?
4. Compare and contrast various types of data visualization techniques (e.g., bar charts, pie charts,
scatter plots). Discuss their suitability for different data types.
5. Evaluate how data visualization bridges the gap between technical data analysis and non-
technical stakeholders. Why is this essential for modern organizations?

Unit: 7 - Building Basic Visualizations in Tableau 45

DMBA117: Data Visualization

9. ANSWERS
Self-Assessment Questions
1. Understanding
2. Bridge
3. Storytelling
4. Insights
5. Exploration
6. Movements
7. Representing Interconnected ideas
8. Conditions
9. B) Troop Movements
10. B) Showcasing Property Information

Terminal Questions Answers

Short Question Answers
1. Refer section 1.4
2. Refer section 1.4
3. Refer section 1.5
4. Refer section 1.5
5. Refer section 1.6
6. Refer section 1.6

Long Question Answers

1. Data visualization is the graphical representation of data through charts, graphs, maps, and other
visual formats, making it easier to interpret large datasets. It plays a crucial role in simplifying
complex information by highlighting trends, patterns, and outliers, allowing for faster decision-
making and enhanced communication between technical and non-technical stakeholders.
Visualization aids in storytelling and helps uncover insights that are not readily apparent in raw
data, making it indispensable for data-driven organizations.

2. Data visualization is essential for informed decision-making as it transforms raw data into
actionable insights. For example, in healthcare, patient flow diagrams optimize resource
management, while in finance, stock trends are visualized to aid investment decisions. Marketing

Unit: 7 - Building Basic Visualizations in Tableau 46

DMBA117: Data Visualization

teams use dashboards to monitor campaign performance. Across industries, visualization

facilitates quick comprehension of complex data, improves strategic planning, and enhances
predictive capabilities, enabling organizations to adapt swiftly to changing conditions.

3. Data visualization has wide-ranging applications, such as tracking website traffic and conversion
rates in marketing, optimizing delivery routes and stock levels in supply chain management, and
identifying fraudulent activities in financial transactions through anomaly detection. These visual
tools enable businesses to refine strategies, reduce costs, and improve efficiency by presenting
data in a clear, actionable manner, ensuring better resource allocation and faster decision-making.

4. Bar charts are ideal for comparing categorical data, such as sales performance by region, while pie
charts effectively display proportions, such as market share distribution. Scatter plots are suited
for exploring relationships between variables, such as sales versus advertising spend. While bar
and pie charts are simple and effective for non-technical audiences, scatter plots cater to deeper
analytical needs, highlighting correlations and patterns in numerical datasets.

5. Data visualization acts as a bridge by converting complex datasets into visually intuitive formats
that are easily understood by non-technical stakeholders. This is essential for modern
organizations as it fosters collaboration, ensuring all team members can engage with data insights.
By enhancing clarity and accessibility, visualization supports informed decision-making, drives
alignment on strategic goals, and helps organizations remain agile and competitive in dynamic
environments.

Unit: 7 - Building Basic Visualizations in Tableau 47

DMBA117: Data Visualization

10. SUGGESTED BOOKS AND REFERENCES

• A. Kirk, Data Visualization: A Handbook for Data Driven Design, 2nd ed. London, U.K.: SAGE
Publications, 2019.

• P. McFedries, Excel Data Analysis for Dummies, 2nd ed. Hoboken, NJ, USA: Wiley, 2022.

• B. Jones, Communicating Data with Tableau: Designing, Developing, and Delivering Data
Visualizations. Sebastopol, CA, USA: O’Reilly Media, 2014.

• S. Few, Show Me the Numbers: Designing Tables and Graphs to Enlighten, 2nd ed. Burlingame, CA,
USA: Analytics Press, 2012.

• D. G. Murray, Tableau Your Data!: Fast and Easy Visual Analysis with Tableau Software, 2nd ed.
Hoboken, NJ, USA: Wiley, 2016.

Unit: 7 - Building Basic Visualizations in Tableau 48