STWD Questions

Q1. Define context in data storytelling. [Remember] [Easy]

Context in data storytelling is the background information, situation, or framework that

helps the audience understand why the data matters. It includes details like the time
period, location, business problem, or audience needs that give meaning to the numbers
and visuals.

Q2. Explain the importance of context in storytelling. [Understand] [Easy]

Context is important because it:

• Helps the audience understand why the data is relevant

• Prevents misinterpretation by explaining background conditions

• Makes insights actionable by linking data to real-world situations

• Builds credibility by showing the full picture, not just isolated numbers

Q3. Define Exploratory Data Analysis. [Remember] [Easy]

Exploratory Data Analysis (EDA) is the process of analyzing datasets to summarize their
main characteristics, often using visual methods. It helps discover patterns, spot
anomalies, test hypotheses, and check assumptions without a predefined hypothesis.

Q4. Define Explanatory Analysis. [Remember] [Easy]

Explanatory Analysis is the process of using data and visuals to communicate specific
insights or answers to known questions. It focuses on telling a clear story to persuade or
inform an audience about a particular finding.

Q5. List different types of charts used in data visualisation. [Remember] [Easy]

Common chart types include:

• Bar chart

• Line chart
 • Pie chart

• Scatter plot

• Heat map

• Area chart

• Histogram

• Box plot

• Bubble chart

• Geographic/map chart

Q6. What is a bar chart and where is it used? [Understand] [Easy]

A bar chart uses rectangular bars to compare quantities across different categories. It is
used when:

• Comparing values between groups (e.g., sales by region)

• Showing discrete categorical data

• Highlighting differences in magnitude

Q7. What is a line chart and where is it used? [Understand] [Easy]

A line chart displays data points connected by straight lines, showing trends over
continuous intervals. It is used when:

• Showing changes over time (e.g., monthly sales trends)

• Tracking continuous data

• Identifying patterns, increases, or decreases across time periods

Q8. What is a filter in Tableau? [Understand] [Easy]

A filter in Tableau is a tool that limits the data shown in a visualization based on specific
criteria. It allows users to focus on subsets of data (e.g., showing only sales from 2024 or
only a specific region) [fn4].
Q9. Differentiate between Exploratory and Explanatory Analysis. [Analyse] [Medium]

Aspect Exploratory Analysis Explanatory Analysis

Discover patterns, generate Communicate specific insights, test

Purpose hypotheses hypotheses

Audience Data analyst/researcher Business stakeholders/general audience

Structure Open-ended, flexible Structured, narrative-driven

Outcome Questions and hypotheses Clear conclusions and recommendations

Visuals Many rough charts for investigation Polished charts for storytelling

Q10. Explain how audience influences data storytelling. [Analyse] [Medium]

The audience influences data storytelling in several ways:

• Technical level: Technical audiences need detailed graphs; general audiences need
simpler visuals

• Knowledge background: Experts need less context; non-experts need more

explanation

• Decision needs: Executives need high-level insights; analysts need granular data

• Visual preferences: Different audiences respond to different chart types and colors

• Time pressure: Busy audiences need quick, clear takeaways

Q11. Explain the importance of structuring stories and plots. [Analyse] [Medium]

Structuring stories and plots is important because it:

• Guides the audience through a logical flow from problem to insight to action
 • Reduces confusion by presenting information in a clear sequence

• Highlights key points through emphasis and ordering

• Improves retention by creating a narrative arc that's easier to remember

• Makes data actionable by connecting insights to recommendations

Q12. Describe the use of scatter plots with an example. [Apply] [Medium]

A scatter plot displays relationships between two continuous variables using dots on a
coordinate plane.

Example: Plotting "Advertising Spend" (x-axis) vs. "Sales Revenue" (y-axis) for different
months. Each dot represents one month. If dots show an upward trend, it indicates that
higher advertising spend correlates with higher sales, helping identify the relationship
strength.

Uses:

• Identifying correlations

• Detecting outliers

• Showing clusters or patterns

Q13. Explain heat maps and their advantages. [Analyse] [Medium]

A heat map uses color intensity to represent values in a matrix, where colors indicate
magnitude (e.g., blue = low, red = high).

Advantages:

• Quickly shows patterns across large datasets

• Easy to spot high/low values visually

• Effective for comparing multiple variables simultaneously

• Works well for time-based data (e.g., hours vs. days)

• Handles complex data more clearly than tables

Example: Sales performance by region (rows) and product category (columns).

Q14. Explain parameters in Tableau with a suitable use case. [Apply] [Medium]

Parameters in Tableau are dynamic variables that users can change to control what data is
shown or how it's calculated.

Use case: A retail dashboard where managers can select a profit threshold (e.g., $10,000).
The parameter filters products to show only those above the selected profit level. This
allows different users to explore data with their own criteria without creating multiple
worksheets [fn4].

Benefits:

• Interactive dashboards

• User-driven analysis

• Reduces need for multiple sheets

Q15. Analyse how incorrect chart selection can mislead interpretation. [Analyse]
[Medium]

Incorrect chart selection can mislead because:

Problem Example Consequence

Wrong chart type Using pie chart for time trends Hidden patterns, unclear progression

Truncated axes Starting y-axis at 50 instead of 0 Exaggerated differences

3D effects 3D pie chart Distorted proportions

Too many categories Pie chart with 15 slices Impossible to compare

Inappropriate scale Log scale without labeling Misleading magnitude

This leads to wrong conclusions, poor decisions, and loss of credibility.

Q16. Design a complete data storytelling approach using context for a real-world
scenario. [Create] [Difficult]

Scenario: A retail company experiencing declining quarterly sales.

Data Storytelling Approach:

1. Context Setup

• Background: Sales dropped 15% in Q4 2025 vs. Q3 2025

• Audience: Senior management needing quick decisions

• Goal: Identify cause and recommend action

2. Problem (Opening Visual)

• Line chart showing monthly sales for 2025

• Highlight Q4 decline with annotation

3. Evidence (Middle Visuals)

• Bar chart: Sales by region (shows Northeast region dropped 30%)

• Heat map: Sales by product category and month (electronics declining)

• Scatter plot: Price vs. Sales volume (price increase correlates with drop)

4. Insight

• Northeast region's electronics sales dropped after 10% price increase

• Competitors lowered prices in same period

5. Action (Closing Visual)

• Dashboard with recommendations: Adjust pricing, run promotion in

Northeast, monitor competitors

• Parameter: Allow managers to simulate different price scenarios

6. Conclusion

• Clear call-to-action with timeline and expected impact

This structure moves audience from problem → evidence → solution.

Q17. Analyse and justify the selection of appropriate chart types for different
datasets. [Analyse] [Difficult]

Dataset Type Best Chart Justification

Shows trends and patterns over

Time series (monthly sales) Line chart continuous time

Categorical comparison (sales by Easy to compare discrete

region) Bar chart categories

Pie/Donut chart (max 5

Part-to-whole (market share) slices) Shows proportions clearly

Two continuous variables (price vs.

销量) Scatter plot Reveals correlation and outliers

Multiple variables (sales by region Compares many combinations

& category) Heat map efficiently

Distribution (age of customers) Histogram Shows frequency distribution

Geographic data (sales by country) Map chart Visualizes location-based patterns

Change over time + comparison Combined line & bar Shows trend + category comparison

Justification principles:

• Match chart to data type (categorical vs. continuous)

• Consider audience's familiarity

• Ensure clarity over complexity

• Highlight the key message

Q18. Evaluate the role of filters and parameters in improving dashboard interactivity.
[Evaluate] [Difficult]

Filters improve interactivity by:

• Allowing users to focus on specific data subsets (e.g., by region, date, product)

• Reducing visual clutter

• Enabling self-service exploration

• Making dashboards adaptable to different user needs [fn4]

Parameters improve interactivity by:

• Enabling dynamic calculations (e.g., "what-if" scenarios)

• Allowing user-controlled thresholds

• Reducing need for multiple worksheets

• Creating personalized experiences [fn4]

Combined impact:

• Users can explore data without analyst help

• Dashboards serve multiple use cases

• Faster decision-making through immediate insights

• Increased user engagement and satisfaction

Evaluation: Both are essential for modern dashboards. Filters handle data selection;
parameters handle logic/calculation changes. Together they transform static reports into
interactive analytical tools [fn4].

Q19. Create a Bar Chart in Tableau using a given dataset and explain each step. [Apply]

Steps to create a Bar Chart in Tableau:

1. Connect to data: Open Tableau → Select data source (e.g., Excel/CSV) [fn4]

2. Drag sheet: Drag the worksheet tab to the canvas

3. Add dimension: Drag "Region" (dimension) to Columns shelf

4. Add measure: Drag "Sales" (measure) to Rows shelf

 5. Choose chart type: Tableau automatically creates bar chart (or click Bar icon)

6. Sort data: Click Sort button to arrange bars by sales (descending)

7. Add labels: Drag "Sales" to Label on Marks card

8. Format: Change colors, add title via Format menu

9. Add filter (optional): Drag "Year" to Filters shelf

10. Save: Save workbook

Result: Horizontal/vertical bars showing sales by region, sorted by magnitude [fn4].

Q20. Create a Line Chart to show trends over time and interpret the result. [Apply]

Steps:

1. Connect to dataset with date field (e.g., "Order Date") and measure (e.g., "Sales")

2. Drag "Order Date" to Columns shelf (automatically becomes continuous)

3. Drag "Sales" to Rows shelf

4. Tableau creates line chart automatically

5. Change date hierarchy to "Month" or "Quarter" as needed

6. Add trend line: Analytics pane → drag Trend Line

7. Format: Add title, color, labels

Interpretation:

• Upward slope: Sales increasing over time

• Downward slope: Sales decreasing

• Flat line: Stable sales

• Seasonal pattern: Repeating peaks/troughs indicate seasonality

• Outliers: Sudden spikes/drops need investigation

Example: If line shows steady increase from Jan to Dec 2025, business is growing.

Q21. Create a Scatter Plot and analyse the relationship between two variables. [Apply]
Steps:

1. Connect to dataset with two continuous measures (e.g., "Advertising Spend" and
"Sales")

2. Drag "Advertising Spend" to Columns shelf

3. Drag "Sales" to Rows shelf

4. Change mark type to "Circle" (scatter plot)

5. Add "Region" to Color on Marks card to differentiate groups

6. Add trend line: Analytics pane → Trend Line

7. Add labels if needed

Analysis:

• Positive correlation: Points slope upward (more spend → more sales)

• Negative correlation: Points slope downward

• No correlation: Random scatter

• Strong relationship: Points close to trend line

• Weak relationship: Points widely scattered

• Outliers: Points far from cluster

Example: If r² = 0.85, advertising spend explains 85% of sales variation.

Q22. Apply filters to a dataset and explain how the output changes. [Apply]

Example: Filtering sales data by region and year.

Steps:

1. Drag "Region" to Filters shelf → Select "North" and "South"

2. Drag "Order Date" to Filters shelf → Select "2025"

3. Drag "Sales" to Rows, "Category" to Columns

4. Observe bar chart updates

How output changes:

 Without Filter With Filter

Shows all 4 regions Shows only North & South

Total sales: $500,000 Total sales: $300,000

All years included Only 2025 data

12 categories visible Same 12 categories but smaller values

Broader trends More focused, specific insights

Impact: Filters reduce data volume, highlight specific segments, enable targeted analysis,
and make patterns in subsets clearer [fn4].

Q23. Create and use a parameter to dynamically control a visualisation. [Create]

Steps to create a parameter:

1. Create parameter:

• Right-click in Data pane → Create Parameter

• Name: "Profit Threshold"

• Data type: Float

• Current value: 10000

• Allowable values: Range (0 to 50000, step 1000)

2. Use parameter:

• Create calculated field: IF [Profit] > [Profit Threshold] THEN "High" ELSE
"Low" END

• Drag this field to Color on Marks card

• Or drag parameter to Filters shelf

3. Show parameter control:

 • Right-click parameter → Show Parameter

• Slider/dropdown appears on dashboard

4. Test: Adjust slider → visualization updates instantly

Use case: Managers set profit threshold to see only high-performing products. Changing
threshold dynamically shows different product sets without creating new worksheets [fn4].

Q24. Build a dashboard using at least two different charts and apply filters for
interactivity. [Create]

Dashboard: Sales Performance Overview

Steps:

1. Create Worksheet 1: Bar chart

• Sales by Region (Columns: Region, Rows: Sales)

2. Create Worksheet 2: Line chart

• Monthly Sales Trend (Columns: Order Date, Rows: Sales)

3. Create Worksheet 3: Pie chart

• Sales by Category (Category to Color, Sales to Label)

4. Create Dashboard:

• Dashboard → New Dashboard

• Drag all 3 worksheets onto canvas

• Arrange layout (bar chart top, line + pie side-by-side)

5. Add interactivity:

• Drag "Region" to Filters on any sheet

• Right-click filter → Apply to Dashboard → All Sheets

• Enable "Use as Filter" on bar chart (clicking region filters others)

6. Add parameter (optional): Profit Threshold parameter

7. Add title: "2025 Sales Performance Dashboard"

8. Test: Click region in bar chart → other charts filter to show only that region
Result: Interactive dashboard where users explore data by clicking, filtering, and adjusting
parameters [fn4].

Q25. Given a dataset, choose the most appropriate chart type and justify your
selection. [Analyse]

Dataset: Sales data with fields: Date, Region, Product Category, Sales, Profit, Quantity

Chart Selection & Justification:

Analysis Goal Chart Type Justification

Date is continuous; line shows progression

Sales trend over time Line chart clearly

Region is categorical; bar enables easy

Sales by Region Bar chart comparison

Sales vs. Profit relationship Scatter plot Both continuous; shows correlation/outliers

Two categorical dimensions; color shows

Profit by Category & Region Heat map magnitude

Sales distribution Histogram Shows frequency of sales ranges

Pie chart (4 Part-to-whole; few categories make it

Market share by Category slices) readable

Sales by geographic location Map chart Region has geographic meaning

Monthly Sales + Category

comparison Stacked bar Shows total + breakdown simultaneously

Best overall choice for executive summary: Dashboard with line chart (trends) + bar
chart (regional comparison) because:
 • Covers time and category dimensions

• Executives need both trend and comparison

• Clear, quick to interpret

• Industry standard for sales reporting

All answers are based on data visualization best practices, Tableau functionality, and data
storytelling principles [fn4].

Unit 4: Questions 1. What is a story in Tableau, and how does it differ from a dashboard? 2.
Define story points in Tableau. How are they used in storytelling? 3. Explain the significance
of captions in Tableau stories. 4. Why is planning important before building a Tableau
story? 5. Provide an example where using a Tableau story would be more effective than a
standalone dashboard. 6. How can interactive filters enhance the effectiveness of Tableau
stories? 7. Describe the key steps involved in planning a Tableau story. 8. What factors
should be considered when sequencing story points? 9. Given a dataset on employee
performance, outline a story that highlights top performers, average performers, and areas
of improvement. 10. What are timelines, and how are they useful in storytelling? 11.
Suggest three scenarios where timelines are the most appropriate visualisation. 12. Explain
the purpose of a bar-in-bar chart. How does it help in comparative analysis? 13. Describe
how bar-in-bar charts can be used to compare forecasted and actual sales performance.
14. What is a word cloud, and what type of data is best suited for this visualisation? 15.
Suggest how word clouds can be used for analysing customer feedback in a retail
business. 16. Define a dashboard in Tableau and explain its key components. 17. What are
the differences between a worksheet, a dashboard, and a story in Tableau? 18. How can
you add interactivity to a Tableau dashboard? 19. What are the benefits of designing
interactive dashboards? 20. Explain the role of filter actions, highlight actions, and URL
actions in enhancing dashboard interactivity. 21. Suggest a use case where interactive
dashboards would be critical for decision-making. 22. How can parameters be used to
allow users to customise their view of the data in Tableau? 23. How can stories in Tableau
enhance stakeholder presentations? 24. What are the common mistakes to avoid when
building a Tableau story?

Completed 3 steps

Here are the answers to all 24 Unit 4 questions with each question followed by its answer:
Q1. What is a story in Tableau, and how does it differ from a dashboard?

A story in Tableau is a sequence of visualizations (views, dashboards, or text) that work

together to convey information, tell a data narrative, provide context, or make a compelling
case.

Differences between Story and Dashboard:

Aspect Story Dashboard

Purpose Tells a narrative with sequential flow Displays multiple views for exploration

Structure Sequence of story points (like slides) Single canvas with multiple sheets

Flow Guided, step-by-step presentation Interactive, user-driven exploration

Best for Presentations, explanations, cases Monitoring, analysis, self-service

Navigation Previous/Next arrows Click filters, actions for interactivity

Q2. Define story points in Tableau. How are they used in storytelling?

Story points are individual sheets within a Tableau story, each containing a view,
dashboard, or text.

How they're used in storytelling:

• Each point represents one step in the narrative

• Points can show the same visualization with different filters/annotations

• Points build upon each other to create a logical flow

• Viewers navigate through points using arrows to follow the story arc

• Example: Point 1 = Problem, Point 2 = Evidence, Point 3 = Solution

Q3. Explain the significance of captions in Tableau stories.

Captions in Tableau stories summarize each story point and highlight key takeaways.

Significance:

• Provide context for what viewers are seeing

• Explain the main insight of each point

• Guide viewers through the narrative

• Make the story self-explanatory without verbal presentation

• Appear in the navigator box for easy navigation

• Can be resized for better readability

Q4. Why is planning important before building a Tableau story?

Planning is important because:

• Defines purpose: Clarifies whether it's a call to action, simple narrative, or case
presentation

• Determines flow: Helps decide if you'll build to a conclusion or start with

conclusion then show evidence

• Identifies problems: Sketching on paper/whiteboard reveals sequence issues early

• Saves time: Prevents rework from poor structure

• Ensures clarity: Every element serves a purpose

• Considers audience: Tailors the journey to viewer needs

Q5. Provide an example where using a Tableau story would be more effective than a
standalone dashboard.

Example: Presenting quarterly sales decline to executive leadership.

Why story is better:

1. Point 1: Line chart showing sales decline over 6 months with caption "Sales
dropped 20% in Q4"
 2. Point 2: Bar chart by region showing Northeast dropped 35% with caption
"Northeast region driving decline"

3. Point 3: Scatter plot showing price increase correlation with caption "10% price
increase correlates with drop"

4. Point 4: Dashboard with recommendations and action plan

A standalone dashboard would overwhelm executives with all data at once. The story
guides them through problem → evidence → cause → solution in a logical, compelling
narrative.

Q6. How can interactive filters enhance the effectiveness of Tableau stories?

Interactive filters enhance stories by:

• Allowing viewers to explore data beyond the guided narrative

• Enabling users to focus on their areas of interest

• Making stories more engaging and personalized

• Letting users ask "what if" questions during/after the story

• Supporting both guided presentation and self-service exploration

• Example: After showing regional decline, filter lets viewers explore specific products
or time periods

Q7. Describe the key steps involved in planning a Tableau story.

Key planning steps:

1. Define purpose: Call to action, narrative, or case presentation

2. Identify audience: Technical vs. non-technical, decision-makers vs. analysts

3. Determine structure: Build to conclusion or start with conclusion

4. Sketch story: Draw on paper/whiteboard to identify sequence problems

5. Select data stories type: Change Over Time, Drill Down, Contrast, etc.

6. Choose visuals: Bar charts, line charts, dashboards for each point
 7. Write captions: Plan key takeaways for each story point

8. Consider performance: Ensure fast load times, use extracts

9. Remove clutter: Eliminate unnecessary legends, grid lines, titles

Q8. What factors should be considered when sequencing story points?

Factors for sequencing:

Factor Consideration

Logical flow Problem → Evidence → Conclusion OR Conclusion → Supporting data

Audience needs Busy audiences prefer conclusion first

Complexity Start simple, build to complex insights

Emotional arc Build tension, then resolve with solution

Causality Show cause before effect

Time sequence Chronological order for trends

Cognitive load Don't overwhelm with too many points

Key message Ensure main insight is clear at climax

Q9. Given a dataset on employee performance, outline a story that highlights top
performers, average performers, and areas of improvement.

Employee Performance Story Outline:

Point 1: Overview
 • Visual: Dashboard showing overall performance metrics

• Caption: "Company-wide performance analysis: 150 employees evaluated"

Point 2: Top Performers

• Visual: Bar chart ranking top 10 employees by performance score

• Filter: Performance score > 90

• Caption: "Top 10 performers average 95% score, contributing 25% of total output"

Point 3: Performance Distribution

• Visual: Histogram showing performance score distribution

• Caption: "60% average performers (70-85%), 20% top performers (>90%), 20% need
improvement (<70%)"

Point 4: Areas of Improvement

• Visual: Bar chart by department showing lowest-performing teams

• Filter: Performance score < 70

• Caption: "Customer Service department has lowest average (68%), needs targeted
training"

Point 5: Skill Gaps

• Visual: Heat map of skills vs. performance

• Caption: "Technical skills and communication are primary gaps for low performers"

Point 6: Action Plan

• Visual: Text + simple table with recommendations

• Caption: "Recommendation: Training program for Customer Service, mentorship for

top performers"

Q10. What are timelines, and how are they useful in storytelling?

Timelines are visualizations showing events or data points in chronological order, often
with dates and descriptions.

Usefulness in storytelling:
 • Remind decision-makers when and why decisions were made

• Add rich background information to interpret numbers

• Separate coincidence from causality in complex situations

• Challenge assumptions and reframe narratives

• Show sequence of events leading to current situation

• Make stories more relatable and interesting

• Especially helpful in "next steps" section of stories

Q11. Suggest three scenarios where timelines are the most appropriate visualisation.

Scenario Why Timeline is Best

Shows when features were released, helping explain current sales

1. Product launch history patterns and customer adoption

2. Company Connects organizational changes (mergers, layoffs, leadership changes)

restructuring events to performance metric shifts

3. Marketing campaign Shows when campaigns ran, budgets spent, and correlates with sales
timeline spikes/drops to measure effectiveness

Q12. Explain the purpose of a bar-in-bar chart. How does it help in comparative
analysis?

Purpose: A bar-in-bar chart displays one bar inside another, comparing two measures for
the same categories.

How it helps in comparative analysis:

• Compares two measures directly in one compact visualization

• Visualizes difference between target vs. actual values

• Requires less space than separate charts

 • Provides instant insights about gaps

• Easy to see which categories met/missed targets

• Better alternative to divergent bar charts for instant insights

Example: Actual sales (inner bar) vs. Target sales (outer bar) by region

Q13. Describe how bar-in-bar charts can be used to compare forecasted and actual
sales performance.

How to use bar-in-bar for forecasted vs. actual:

1. Outer bar: Forecasted/target sales (e.g., $100,000)

2. Inner bar: Actual sales (e.g., $85,000)

3. Color coding:绿色 for met/exceeded, red for missed

4. Categories: By region, product, or month

Interpretation:

• If inner bar reaches outer bar edge = target met

• If inner bar shorter = missed forecast

• Gap size shows variance magnitude

• Instantly identifies which products/regions underperformed

Example: Medical device company compares actual vs. target sales by product (sterilizers,
infusion pumps, catheters) across regions

Q14. What is a word cloud, and what type of data is best suited for this visualisation?

Word cloud (tag cloud) displays words from text data in varying sizes based on frequency
or significance.

Best suited data types:

• Customer feedback comments and reviews

• Survey responses with open-ended questions

• Social media mentions and hashtags

 • Support tickets with issue descriptions

• Interview transcripts with recurring themes

• Email content analysis

Why it works: Larger words = more frequent, making prominent themes instantly visible

Q15. Suggest how word clouds can be used for analysing customer feedback in a retail
business.

Word cloud application for retail customer feedback:

1. Data collection: Gather product reviews, survey responses, support tickets

2. Create word cloud: Dimension = feedback words, Measure = word frequency

3. Analysis insights:

• Large "price" = pricing is major concern

• Large "quality" = product quality frequently mentioned

• Large "delivery" = shipping issues prominent

• Large "friendly" = positive service feedback

4. Actionable outcomes:

• If "expensive" is large → review pricing strategy

• If "slow delivery" is large → improve logistics

• If "great quality" is large → emphasize in marketing

• If "rude staff" appears → training needed

5. Comparison: Create separate word clouds for positive vs. negative reviews to
identify patterns

Q16. Define a dashboard in Tableau and explain its key components.

Dashboard in Tableau: A single canvas that combines multiple worksheets, dashboards,

and objects (text, images, web pages) to display data views together for analysis and
monitoring.
Key components:

Component Purpose

Worksheets Individual charts/graphs showing data

Dashboards Nested dashboards for complex layouts

Text objects Titles, explanations, instructions

Images logos, icons, reference images

Web objects Embed web pages or URLs

Blank objects Spacing and layout control

Filters Interactive controls for data filtering

Parameters Dynamic user-controlled variables

Legend Explains colors, sizes, shapes

Titles/Captions Context and labels

Q17. What are the differences between a worksheet, a dashboard, and a story in
Tableau?

Aspect Worksheet Dashboard Story

Multiple views on one Sequence of points telling

Definition Single view/chart canvas narrative
 Aspect Worksheet Dashboard Story

Multiple worksheets + Views, dashboards, or text

Content One visualization objects per point

Explore/create single Monitor/analyze multiple

Purpose chart metrics Tell data story with flow

High (actions, filters,

Interactivity Basic filters parameters) Filters + navigation arrows

Sequential points with

Layout Single view Drag-and-drop layout navigator

Best for Analysis, creation Monitoring, self-service Presentations, explanations

Q18. How can you add interactivity to a Tableau dashboard?

Ways to add interactivity:

1. Filters: Add filter controls for dimensions/measures [fn4]

2. Dashboard Actions:

• Filter actions: Click sheet to filter others

• Highlight actions: Click to highlight related data

• URL actions: Click to open web pages [fn4]

3. Parameters: Create user-controlled variables for dynamic views [fn4]

4. Tooltip customization: Show extra info on hover

5. Sheet swapping: Use parameters to change displayed charts

6. Zone visibility: Show/hide sections based on selections

7. Quick table calculations: Allow users to compute % change, running total

 8. Layout containers: Organize for better user experience

[fn4]

Q19. What are the benefits of designing interactive dashboards?

Benefits:

Benefit Impact

Self-service analysis Users explore without analyst help

Faster decisions Immediate insights from filtering

Personalization Users focus on their data

Deeper insights Drill-down reveals hidden patterns

Engagement Interactive elements保持用户参与

Reduced workload Fewer ad-hoc requests to analysts

Real-time exploration Ask "what if" questions instantly

Better understanding Users discover relationships themselves

[fn4]

Q20. Explain the role of filter actions, highlight actions, and URL actions in enhancing
dashboard interactivity.
 Action Type Role Example

Click one sheet to filter data in Click "North" region bar → other charts show
Filter Actions others only North data [fn4]

Highlight Click to highlight related data Click "Product A" → other charts highlight
Actions without filtering Product A, dim others [fn4]

Click to open external web Click "View Details" → opens product page on
URL Actions pages website [fn4]

Enhancement impact:

• Filter actions enable drill-down exploration

• Highlight actions show relationships without losing context

• URL actions connect dashboard to external resources

• Together create immersive, navigable experience [fn4]

Q21. Suggest a use case where interactive dashboards would be critical for decision-
making.

Use Case: Hospital Operations Dashboard

Critical for:

• Real-time monitoring: Bed occupancy, patient wait times, staff availability

• Filter actions: Click department → see specific metrics (ER, ICU, Surgery)

• Parameters: Select date range, shift, or doctor to analyze

• Quick decisions:

• If ER wait time > 30 min → redirect staff

• If bed occupancy > 90% → activate overflow protocol

• If staff shortage → call in replacements

Why interactive: Administrators need to drill into specific departments, time periods, and
metrics instantly during emergencies without waiting for reports [fn4]

Q22. How can parameters be used to allow users to customise their view of the data in
Tableau?

Parameter customization methods:

1. Dynamic filtering: Parameter controls threshold (e.g., show products with profit >
$10,000) [fn4]

2. Measure switching: Parameter lets users select which metric to display (Sales,
Profit, Quantity) [fn4]

3. Top N selection: Parameter chooses top 5, 10, 20 performers [fn4]

4. Date range: Parameter controls time period shown

5. What-if analysis: Parameter changes assumptions (e.g., price increase 5%, 10%,
15%) [fn4]

6. Chart type selection: Parameter swaps between bar, line, scatter plots

7. Calculated field input: Parameter used in formulas for dynamic calculations [fn4]

Example: Profit Threshold parameter (0-50,000) filters products dynamically [fn4]

Q23. How can stories in Tableau enhance stakeholder presentations?

Stories enhance presentations by:

1. Guiding narrative: Lead stakeholders through problem → evidence → solution

2. Providing context: Captions explain each point without verbal explanation

3. Building case: Show how facts connect and decisions relate to outcomes

4. Controlling flow: Ensure key points are seen in optimal sequence

5. Making compelling: Data comes to life through structured narrative

6. Supporting Q&A: Viewers can navigate back to specific points during questions

7. Publishing shareable: Present live or publish to Tableau Server/Cloud for access

 8. Accommodating audiences: Conclusion-first approach works for busy executives

Q24. What are the common mistakes to avoid when building a Tableau story?

Common mistakes:

Mistake Consequence Solution

Viewers overwhelmed, lose

Too many points focus Keep it simple, 5-7 points max

Unclear captions Confusion about key insights Write concise, meaningful captions

Remove legends, grid lines if not

Unnecessary elements Cluttered, distracting views needed

Poor sequencing Story doesn't flow logically Sketch on paper first

Frustrated viewers,
Slow load times disengagement Use extracts, optimize filters

No clear purpose Story lacks direction Define purpose before building

Ignoring audience Wrong complexity level Consider audience knowledge

Same view without Use different filters, annotations per

variation Boring, repetitive point

No conclusion No clear takeaway End with actionable insight

Q1. Define context in data storytelling. [Remember] [Easy]

Context in data storytelling is the background information, situation, or framework

that helps the audience understand why the data matters. It includes details like the
time period, location, business problem, or audience needs that give meaning to the
numbers and visuals.[1][2]

Q2. Explain the importance of context in storytelling. [Understand] [Easy]

Context is important because it:

• Helps the audience understand why the data is relevant

• Prevents misinterpretation by explaining background conditions

• Makes insights actionable by linking data to real-world situations

• Builds credibility by showing the full picture, not just isolated numbers[3][1]

Q3. Define Exploratory Data Analysis. [Remember] [Easy]

Exploratory Data Analysis (EDA) is the process of analyzing datasets to summarize

their main characteristics, often using visual methods. It helps discover patterns, spot
anomalies, test hypotheses, and check assumptions without a predefined hypothesis.[1]

Q4. Define Explanatory Analysis. [Remember] [Easy]

Explanatory Analysis is the process of using data and visuals to communicate

specific insights or answers to known questions. It focuses on telling a clear story to
persuade or inform an audience about a particular finding.[1]
Q5. List different types of charts used in data visualisation. [Remember]
[Easy]

Common chart types include:

• Bar chart

• Line chart

• Pie chart

• Scatter plot

• Heat map

• Area chart

• Histogram

• Box plot

• Bubble chart

• Geographic/map chart[2][1]

Q6. What is a bar chart and where is it used? [Understand] [Easy]

A bar chart uses rectangular bars to compare quantities across different categories. It
is used when:

• Comparing values between groups (e.g., sales by region)

• Showing discrete categorical data

• Highlighting differences in magnitude[1]

Q7. What is a line chart and where is it used? [Understand] [Easy]

A line chart displays data points connected by straight lines, showing trends over
continuous intervals. It is used when:
 • Showing changes over time (e.g., monthly sales trends)

• Tracking continuous data

• Identifying patterns, increases, or decreases across time periods[1]

Q8. What is a filter in Tableau? [Understand] [Easy]

A filter in Tableau is a tool that limits the data shown in a visualization based on
specific criteria. It allows users to focus on subsets of data (e.g., showing only sales from
2024 or only a specific region) [fn4].[1]

Q9. Differentiate between Exploratory and Explanatory Analysis. [Analyse]

[Medium]

Aspect Exploratory Analysis Explanatory Analysis

Purpose Discover patterns, generate hypotheses Communicate specific insights, test hypotheses

Audience Data analyst/researcher Business stakeholders/general audience

Structure Open-ended, flexible Structured, narrative-driven

Outcome Questions and hypotheses Clear conclusions and recommendations

Visuals Many rough charts for investigation Polished charts for storytelling

Q10. Explain how audience influences data storytelling. [Analyse] [Medium]

The audience influences data storytelling in several ways:

• Technical level: Technical audiences need detailed graphs; general audiences need simpler
visuals[1]

• Knowledge background: Experts need less context; non-experts need more explanation

• Decision needs: Executives need high-level insights; analysts need granular data
 • Visual preferences: Different audiences respond to different chart types and colors

• Time pressure: Busy audiences need quick, clear takeaways[1]

Q11. Explain the importance of structuring stories and plots. [Analyse]

[Medium]

Structuring stories and plots is important because it:

• Guides the audience through a logical flow from problem to insight to action

• Reduces confusion by presenting information in a clear sequence

• Highlights key points through emphasis and ordering

• Improves retention by creating a narrative arc that's easier to remember

• Makes data actionable by connecting insights to recommendations[4][5]

Q12. Describe the use of scatter plots with an example. [Apply] [Medium]

A scatter plot displays relationships between two continuous variables using dots on a
coordinate plane.

Example: Plotting "Advertising Spend" (x-axis) vs. "Sales Revenue" (y-axis) for
different months. Each dot represents one month. If dots show an upward trend, it
indicates that higher advertising spend correlates with higher sales, helping identify the
relationship strength.[1]

Uses:

• Identifying correlations

• Detecting outliers

• Showing clusters or patterns

Q13. Explain heat maps and their advantages. [Analyse] [Medium]

A heat map uses color intensity to represent values in a matrix, where colors indicate
magnitude (e.g., blue = low, red = high).

Advantages:

• Quickly shows patterns across large datasets

• Easy to spot high/low values visually

• Effective for comparing multiple variables simultaneously

• Works well for time-based data (e.g., hours vs. days)

• Handles complex data more clearly than tables[1]

Example: Sales performance by region (rows) and product category (columns).

Q14. Explain parameters in Tableau with a suitable use case. [Apply]

[Medium]

Parameters in Tableau are dynamic variables that users can change to control what
data is shown or how it's calculated.

Use case: A retail dashboard where managers can select a profit threshold (e.g.,
$10,000). The parameter filters products to show only those above the selected profit
level. This allows different users to explore data with their own criteria without creating
multiple worksheets [fn4].

Benefits:

• Interactive dashboards

• User-driven analysis

• Reduces need for multiple sheets

Q15. Analyse how incorrect chart selection can mislead interpretation.
[Analyse] [Medium]

Incorrect chart selection can mislead because:

Problem Example Consequence

Wrong chart type Using pie chart for time trends Hidden patterns, unclear progression

Truncated axes Starting y-axis at 50 instead of 0 Exaggerated differences

3D effects 3D pie chart Distorted proportions

Too many categories Pie chart with 15 slices Impossible to compare

Inappropriate scale Log scale without labeling Misleading magnitude

This leads to wrong conclusions, poor decisions, and loss of credibility.[1]

Q16. Design a complete data storytelling approach using context for a real-
world scenario. [Create] [Difficult]

Scenario: A retail company experiencing declining quarterly sales.

Data Storytelling Approach:

1. Context Setup

o Background: Sales dropped 15% in Q4 2025 vs. Q3 2025

o Audience: Senior management needing quick decisions
o Goal: Identify cause and recommend action

2. Problem (Opening Visual)

o Line chart showing monthly sales for 2025

o Highlight Q4 decline with annotation

3. Evidence (Middle Visuals)

o Bar chart: Sales by region (shows Northeast region dropped 30%)

 o Heat map: Sales by product category and month (electronics declining)
o Scatter plot: Price vs. Sales volume (price increase correlates with drop)

4. Insight

o Northeast region's electronics sales dropped after 10% price increase

o Competitors lowered prices in same period

5. Action (Closing Visual)

o Dashboard with recommendations: Adjust pricing, run promotion in Northeast, monitor

competitors

o Parameter: Allow managers to simulate different price scenarios

6. Conclusion

o Clear call-to-action with timeline and expected impact

This structure moves audience from problem → evidence → solution.[5][4]

Q17. Analyse and justify the selection of appropriate chart types for
different datasets. [Analyse] [Difficult]

Dataset Type Best Chart Justification

Time series (monthly sales) Line chart Shows trends and patterns over
continuous time

Categorical comparison (sales by Bar chart Easy to compare discrete categories

region)

Part-to-whole (market share) Pie/Donut chart (max 5 Shows proportions clearly

slices)

Two continuous variables (price vs.销 Scatter plot Reveals correlation and outliers

量)

Multiple variables (sales by region & Heat map Compares many combinations efficiently
category)

Distribution (age of customers) Histogram Shows frequency distribution

 Geographic data (sales by country) Map chart Visualizes location-based patterns

Change over time + comparison Combined line & bar Shows trend + category comparison

Justification principles:

• Match chart to data type (categorical vs. continuous)

• Consider audience's familiarity

• Ensure clarity over complexity

• Highlight the key message[2][1]

Q18. Evaluate the role of filters and parameters in improving dashboard

interactivity. [Evaluate] [Difficult]

Filters improve interactivity by:

• Allowing users to focus on specific data subsets (e.g., by region, date, product)

• Reducing visual clutter

• Enabling self-service exploration

• Making dashboards adaptable to different user needs [fn4]

Parameters improve interactivity by:

• Enabling dynamic calculations (e.g., "what-if" scenarios)

• Allowing user-controlled thresholds

• Reducing need for multiple worksheets

• Creating personalized experiences [fn4]

Combined impact:

• Users can explore data without analyst help

• Dashboards serve multiple use cases

 • Faster decision-making through immediate insights

• Increased user engagement and satisfaction

Evaluation: Both are essential for modern dashboards. Filters handle data selection;
parameters handle logic/calculation changes. Together they transform static reports
into interactive analytical tools [fn4].

Q19. Create a Bar Chart in Tableau using a given dataset and explain each
step. [Apply]

Steps to create a Bar Chart in Tableau:

1. Connect to data: Open Tableau → Select data source (e.g., Excel/CSV) [fn4]

2. Drag sheet: Drag the worksheet tab to the canvas

3. Add dimension: Drag "Region" (dimension) to Columns shelf

4. Add measure: Drag "Sales" (measure) to Rows shelf

5. Choose chart type: Tableau automatically creates bar chart (or click Bar icon)

6. Sort data: Click Sort button to arrange bars by sales (descending)

7. Add labels: Drag "Sales" to Label on Marks card

8. Format: Change colors, add title via Format menu

9. Add filter (optional): Drag "Year" to Filters shelf

10. Save: Save workbook

Result: Horizontal/vertical bars showing sales by region, sorted by magnitude [fn4].

Q20. Create a Line Chart to show trends over time and interpret the result.
[Apply]

Steps:

1. Connect to dataset with date field (e.g., "Order Date") and measure (e.g., "Sales")
 2. Drag "Order Date" to Columns shelf (automatically becomes continuous)

3. Drag "Sales" to Rows shelf

4. Tableau creates line chart automatically

5. Change date hierarchy to "Month" or "Quarter" as needed

6. Add trend line: Analytics pane → drag Trend Line

7. Format: Add title, color, labels

Interpretation:

• Upward slope: Sales increasing over time

• Downward slope: Sales decreasing

• Flat line: Stable sales

• Seasonal pattern: Repeating peaks/troughs indicate seasonality

• Outliers: Sudden spikes/drops need investigation

Example: If line shows steady increase from Jan to Dec 2025, business is growing.[1]

Q21. Create a Scatter Plot and analyse the relationship between two
variables. [Apply]

Steps:

1. Connect to dataset with two continuous measures (e.g., "Advertising Spend" and "Sales")

2. Drag "Advertising Spend" to Columns shelf

3. Drag "Sales" to Rows shelf

4. Change mark type to "Circle" (scatter plot)

5. Add "Region" to Color on Marks card to differentiate groups

6. Add trend line: Analytics pane → Trend Line

7. Add labels if needed

Analysis:
 • Positive correlation: Points slope upward (more spend → more sales)

• Negative correlation: Points slope downward

• No correlation: Random scatter

• Strong relationship: Points close to trend line

• Weak relationship: Points widely scattered

• Outliers: Points far from cluster

Example: If r² = 0.85, advertising spend explains 85% of sales variation.[1]

Q22. Apply filters to a dataset and explain how the output changes. [Apply]

Example: Filtering sales data by region and year.

Steps:

1. Drag "Region" to Filters shelf → Select "North" and "South"

2. Drag "Order Date" to Filters shelf → Select "2025"

3. Drag "Sales" to Rows, "Category" to Columns

4. Observe bar chart updates

How output changes:

Without Filter With Filter

Shows all 4 regions Shows only North & South

Total sales: $500,000 Total sales: $300,000

All years included Only 2025 data

12 categories visible Same 12 categories but smaller values

Broader trends More focused, specific insights

Impact: Filters reduce data volume, highlight specific segments, enable targeted
analysis, and make patterns in subsets clearer [fn4].
Q23. Create and use a parameter to dynamically control a visualisation.
[Create]

Steps to create a parameter:

1. Create parameter:

o Right-click in Data pane → Create Parameter

o Name: "Profit Threshold"
o Data type: Float
o Current value: 10000
o Allowable values: Range (0 to 50000, step 1000)

2. Use parameter:

o Create calculated field: IF [Profit] > [Profit Threshold] THEN "High" ELSE "Low" END
o Drag this field to Color on Marks card
o Or drag parameter to Filters shelf

3. Show parameter control:

o Right-click parameter → Show Parameter

o Slider/dropdown appears on dashboard

4. Test: Adjust slider → visualization updates instantly

Use case: Managers set profit threshold to see only high-performing products.
Changing threshold dynamically shows different product sets without creating new
worksheets [fn4].

Q24. Build a dashboard using at least two different charts and apply filters
for interactivity. [Create]

Dashboard: Sales Performance Overview

Steps:

1. Create Worksheet 1: Bar chart

o Sales by Region (Columns: Region, Rows: Sales)

2. Create Worksheet 2: Line chart

o Monthly Sales Trend (Columns: Order Date, Rows: Sales)

3. Create Worksheet 3: Pie chart

o Sales by Category (Category to Color, Sales to Label)

4. Create Dashboard:

o Dashboard → New Dashboard

o Drag all 3 worksheets onto canvas
o Arrange layout (bar chart top, line + pie side-by-side)

5. Add interactivity:

o Drag "Region" to Filters on any sheet

o Right-click filter → Apply to Dashboard → All Sheets
o Enable "Use as Filter" on bar chart (clicking region filters others)

6. Add parameter (optional): Profit Threshold parameter

7. Add title: "2025 Sales Performance Dashboard"

8. Test: Click region in bar chart → other charts filter to show only that region

Result: Interactive dashboard where users explore data by clicking, filtering, and
adjusting parameters [fn4].

Q25. Given a dataset, choose the most appropriate chart type and justify
your selection. [Analyse]

Dataset: Sales data with fields: Date, Region, Product Category, Sales, Profit, Quantity
Chart Selection & Justification:

Analysis Goal Chart Type Justification

Sales trend over time Line chart Date is continuous; line shows progression clearly
[1]

Sales by Region Bar chart Region is categorical; bar enables easy

comparison [1]

[1]
Sales vs. Profit relationship Scatter plot Both continuous; shows correlation/outliers

Profit by Category & Region Heat map Two categorical dimensions; color shows
magnitude

Sales distribution Histogram Shows frequency of sales ranges

Market share by Category Pie chart (4 Part-to-whole; few categories make it readable
slices)

Sales by geographic location Map chart Region has geographic meaning

Monthly Sales + Category Stacked bar Shows total + breakdown simultaneously

comparison

Best overall choice for executive summary: Dashboard with line chart
(trends) + bar chart (regional comparison) because:

• Covers time and category dimensions

• Executives need both trend and comparison

• Clear, quick to interpret

• Industry standard for sales reporting[2][1]

Here are the detailed, step-by-step solutions for all the questions found in the document,
structured for a comprehensive evaluation.

Page 1: Dataset 1 (Weekly Sales Data)

Question 1
You are given weekly sales data, with sales recorded in thousands. Use Tableau basic
chart type to create/show the trend in sales over time (weeks). Also, show the graph.
Also add a trend line.

Answer:

• Suitable Chart Type: A Line Chart is the standard and most effective basic chart
type in Tableau to visualize trends over time.

• Step-by-Step Implementation in Tableau:

1. Connect to Data: Import your dataset containing Week ($x_i$) and Sales in
Thousands ($y_j$) into Tableau.

2. Configure Axis: Drag the Week field to the Columns shelf. Ensure it is treated as a
continuous dimension or numeric value so it plots sequentially from 1 to 5.

3. Add Measure: Drag Sales in Thousands to the Rows shelf. Tableau will
automatically generate a line chart tracking the data points.

4. Adding a Trend Line: * Navigate to the Analytics pane on the left side of the screen
(next to the Data pane).

▪ Drag Trend Line from the model section and drop it onto the Linear model box that
appears over the canvas.

• Data Table Visualization Represented:

Week (xi) Sales in Thousands (yj)

1 1.2

2 1.8

3 2.6

4 3.2

5 3.8
 • Graph Trend Analysis: The line graph shows a steady, continuous upward trend.
The trend line matches a linear equation closely, as sales increase by roughly $0.6$
to $0.8$ units each week.

Question 2

Calculate the percentage growth in sales from one week to the next. Create a table in
Tableau that displays both the original sales data and the calculated growth rate.
(Assume the percentage growth to be 10%)

Answer:

• Mathematical Formula for Growth Rate:

$$\text{Percentage Growth} = \frac{\text{Sales}_{\text{Current Week}} -
\text{Sales}_{\text{Previous Week}}}{\text{Sales}_{\text{Previous Week}}} \times
100$$

• Step-by-Step Table Setup in Tableau:

1. Drag Week to the Rows shelf (set as a discrete dimension).

2. Drag Sales in Thousands directly onto the Text card on the Marks card.

3. Right-click on the Sales in Thousands pill inside the Rows/Text shelf, hover over
Quick Table Calculation, and select Percent Difference.

4. To display both simultaneously, drag a fresh copy of Sales in Thousands from the
Data pane back onto the Text card.

• Calculated Output Table:

Week Sales (Original) Calculated Percentage Growth

1 1.2 Null (No previous data)

2 1.8 $\frac{1.8 - 1.2}{1.2} \times 100 =$ 50.0%

3 2.6 $\frac{2.6 - 1.8}{1.8} \times 100 =$ 44.4%

4 3.2 $\frac{3.2 - 2.6}{2.6} \times 100 =$ 23.1%

 5 3.8 $\frac{3.8 - 3.2}{3.2} \times 100 =$ 18.8%

Question 3

Using the sales data provided, which basic chart in Tableau is suitable to compare
sales across each week using graph.

Answer:

• Suitable Chart Type: A Bar Chart (specifically a Vertical Bar Chart/Column Chart).

• Why it is suitable: While a line chart is best for showing continuous trends, a bar
chart is ideal for discretely comparing the precise volume of sales between
individual weeks. The height of each bar provides a clean, immediate visual baseline
comparison of performance.

Pages 1 & 2: Dataset 2 (Age vs Weight)

Question 1

Using the data provided, create a scatter plot in Tableau to visualize the relationship
between Age (X) and Weight (Y). Write steps to create a scatter plot. Also show a
sample graph for customizing the grid lines, zero lines, and drop lines for better clarity
in the plot.

Answer:

• Steps to Create a Scatter Plot:

1. Drag the Age (X) measure to the Columns shelf.

2. Drag the Weight (Y) measure to the Rows shelf.

3. Crucial Step: By default, Tableau will aggregate these measures into a single point.
Go to the top menu bar, click on Analysis, and uncheck Aggregate Measures. This
plots each individual sample point $(X, Y)$ on the coordinate plane.

• Customization Steps:

o Grid lines & Zero lines: Right-click anywhere on the chart background, select
Format, switch to the Lines tab in the formatting side-pane, and toggle or adjust
lines under the "Grid Lines" and "Zero Lines" options.
 o Drop Lines: Right-click an empty area in the view canvas, navigate to Drop Lines,
and select Show Drop Lines. This drops perpendicular dotted markers from the
data dot down to both axes when a user hovers over a data point.

• Data Coordinate Points Visualized:

o Point 1: $(9, 14)$

o Point 2: $(6, 10)$

o Point 3: $(5, 9)$

o Point 4: $(8, 13)$

o Point 5: $(6, 11)$

o Point 6: $(7, 12)$

Question 2

Calculate the average weight for each age group and draw graph. Write the steps to
apply a colour gradient based on weight.

Answer:

• Calculated Aggregations (Age Group Averages):

o Age 5: $9$

o Age 6: $\frac{10 + 11}{2} =$ 10.5

o Age 7: $12$

o Age 8: $13$

o Age 9: $14$

• Steps to Apply a Color Gradient Based on Weight:

1. Set your view to show Age (X) on Columns (set as Discrete/Dimension) and Weight
(Y) on Rows (set to metric expression AVG).

2. Locate Weight (Y) from your measures shelf and drag it directly onto the Color
property box on the Marks Card.

3. Click on the Color card, select Edit Colors, and choose a continuous gradient color
palette (e.g., Blue or Green-Gold).
 4. Higher values will automatically receive dark, intense color tones, while lower
weights transition into lighter shades.

Page 3: Dataset 3 (Product Sales Distribution)

Question 1

Using the provided sales data, draw a suitable graph/chart in Tableau to visualize the
distribution of sales by product category. Apply different colour effects to the slices
for enhanced distinction. Write a sample graph to suit the question.

Answer:

• Suitable Chart Type: A Pie Chart or Donut Chart is standard for showing part-to-
whole categorical distribution when the category count is small. Alternatively, a
Treemap works exceptionally well.

• Steps for Slices and Color Effects:

1. Change the Mark type dropdown selection from "Automatic" to Pie.

2. Drag Product into the Color marks property box.

3. Drag Sales (in thousands) into the Angle marks property box.

4. Click Color $\rightarrow$ Edit Colors to manually apply unique, distinct color tones
to each categorical slice.

Question 2

Show the sales of each product category as a percentage of total sales (create
calculated field).

Answer:

• Calculated Field Code Expression:

Create a new calculated field called % of Total Sales using the following expression:
Code snippet
SUM([Sales (in thousands)]) / TOTAL(SUM([Sales (in thousands)]))

• Data Verification Calculations:

o Total Sales Sum $= 45 + 30 + 56 + 80 + 100 = 311$

o Electronics: $\frac{45}{311} \times 100 =$ 14.47%

 o Clothing: $\frac{30}{311} \times 100 =$ 9.65%

o Home & Kitchen: $\frac{56}{311} \times 100 =$ 18.01%

o Sports & Fitness: $\frac{80}{311} \times 100 =$ 25.72%

o Beauty & Health: $\frac{100}{311} \times 100 =$ 32.15%

Question 3

How do you add labels to the chart?

Answer:

1. Drag the Product dimension catalog item onto the Label tile inside the Marks card
to display the names.

2. Drag the newly created % of Total Sales calculated field onto the Label tile as well.

3. Right-click on the metric field pill inside the label block, go to Format, choose
Percentage, and set decimal resolution to get formatted readable outputs on the
chart slices.

Page 4: Visualization Interpretation (Sales by Country)

Question 1 Breakdown:

• a. What field is placed on the Rows shelf in this visualization?

o Answer: The measure Amount (or Amount ₹) is placed on the Rows shelf, creating
the vertical numerical Y-axis scale ranging from $0\text{K}$ to $70\text{K}$.

• b. What does each bar in the chart represent?

o Answer: Each bar represents the aggregated total volume of sales generation
amount for a specific Country (e.g., India, Australia, Canada, USA, New Zealand,
UK).

• c. Which field is used to differentiate the bars by color?

o Answer: The Country dimension field is dropped on the Color marks property card,
giving every individual country its own distinct color identity.

• d. Why do you think the bars are aligned vertically rather than horizontally?

o Answer: Vertical alignment emphasizes direct magnitude height comparisons. It is

also selected because the categorical labels (Country names) are short, clean, and
fit perfectly underneath the columns without causing truncation.
 • e. Would adding trend lines or reference lines make the chart more insightful? If
yes, how?

o Answer: Yes. A Trend Line is not useful here because the X-axis is categorical rather
than chronological, but an Average Reference Line across the chart pane would
instantly show which countries performed above average (India, Australia, Canada,
USA) vs below average (New Zealand, UK).

• f. How does the color scheme of this chart enhance or detract from the overall
visualization?

o Answer: It detracts slightly from optimal clarity. Using distinct rainbow colors for
independent countries makes them look visually separate, but it can create
unnecessary visual noise. Since the bars are already labeled by country along the X-
axis, a single monochromatic color gradient based on performance amount would
tell a cleaner story.

Page 5: Visualization Interpretation (Top Salesperson Analysis)

Question 2 Breakdown:

• a. What does each pair of bars represent in the chart?

o Answer: Each pair shows a performance comparison of a specific Salesperson

within a country, displaying two distinct operational performance metrics side-by-
side.

• b. Which field is used to differentiate the bars by color?

o Answer: The Measure Names descriptor field is assigned to the Color mark card to
split the metrics cleanly.

• c. What are the two measures shown in this chart?

o Answer: The two active measures shown are Amount (represented by the tall blue
columns) and Shipment Count (represented by the short orange columns).

• d. Are there any filters applied in this visualization? If yes, what field is being
filtered?

o Answer: Yes. There is a filter applied to the Country dimension field, which is
explicitly constrained to show data only for "Canada", as shown in the subtitle
header.
• e. Why do you think both shipment count and amount are shown for each
salesperson?

o Answer: It helps evaluate sales efficiency. For example, a salesperson could have a
very high total sales dollar value balance (Amount) despite processing a low volume
of orders (Shipment Count), indicating they are dealing in premium, high-value
contracts.

• f. Is there any line depiction in the visualization? If so, name the line.

o Answer: No, there are no active visual trend line traces or trend lines generated
directly inside the bar space of this visualization canvas.

• g. How does the title color contrast with the rest of the chart, and does this help
or detract from the overall presentation?

o Answer: The bold solid blue background block behind the title banner creates a
strong visual contrast. It helps draw immediate structural attention to the main goal
of the view ("Top Salesperson"), but it could be styled more subtly to better match
the minimalist white theme of the primary chart workspace.