TDS-C01 Sharing Insights

Sharing Insights Detailed Explanation

This part focuses on the presentation, formatting, and sharing of visualizations in Tableau.

1. Formatting Visualizations

Formatting is crucial because it improves the aesthetics and readability of your charts, ensuring that the audience understands and engages with your insights effectively.

1.1 Titles and Captions

What are Titles and Captions?

• Titles describe the main idea of a chart or worksheet.
• Captions provide additional explanations or context for your visualizations.

Steps to Add or Edit Titles

1. Adding or Editing a Title:

   • Right-click on the Title of the worksheet at the top of the view.
   • Select Edit Title from the menu.
   • In the Edit Title dialog box:
     • Add a meaningful title (e.g., "Sales by Region - 2023").
     • Use the formatting options to customize the font, size, alignment, and color.
   • Click OK.

2. Adding Captions:

   • Go to the Worksheet menu at the top.
   • Select Show Caption.
   • Tableau automatically displays a caption at the bottom of the worksheet.
   • Edit the caption text to explain what the chart is showing.

Tips for Titles and Captions

• Be Clear and Concise: Titles should immediately convey the purpose of the chart.
• Use Consistent Style: Use the same font and size for all titles to ensure consistency.
• Explain Key Insights: Add captions to highlight important findings (e.g., “East region had the highest sales in 2023”).

1.2 Colors

Why Use Colors?
Colors are powerful visual cues that can highlight trends, differences, and patterns in data. However, using too many colors can overwhelm your audience.

Steps to Add and Adjust Colors

1. Drag a Field to the Color Shelf:

   • Select a Dimension (e.g., Region) or a Measure (e.g., Sales).
   • Drag it to the Color shelf in the Marks Card.

2. Adjust the Color Palette:

   • Click on the Color legend in the visualization.
   • Select Edit Colors.
   • Choose an appropriate color palette:
     • Categorical Palette: For Dimensions (e.g., regions, categories).
     • Sequential or Diverging Palette: For Measures (e.g., Sales or Profit ranges).

3. Customize Color Intensity:

   • Use the Opacity slider to adjust color transparency.
   • Set Borders or Shading to make the visualization cleaner.

Best Practices for Using Colors

1. Limit the Number of Colors: Avoid using more than 5-6 colors in one chart.
2. Use Consistent Colors: For the same categories across multiple charts, use the same colors (e.g., East is always blue, West is always green).
3. Highlight Important Data: Use bold or bright colors to emphasize key insights (e.g., Top N regions).
4. Test Accessibility: Ensure the color palette is readable for colorblind users by using high contrast.

Example

If you are showing Sales by Region, dragging the Region field to Color will automatically assign different colors to each region. You can then:

• Adjust the palette to a distinctive categorical palette for better visibility.
• Highlight the top-performing region with a brighter color.

1.3 Labels

What are Labels?
Labels display values directly on the visualization, making it easier to interpret the data without relying on tooltips or axes.

Steps to Add Labels

1. Drag a Measure to the Label Shelf:

   • Select a Measure (e.g., Sales) and drag it to the Label shelf on the Marks Card.

2. Enable Automatic Mark Labels:

   • Alternatively, click on the Show Mark Labels icon in the toolbar (it looks like a label).

3. Customize Labels:

   • Click on the Label shelf in the Marks Card.
   • Adjust the label formatting:
     • Font: Change the type, size, and color of the text.
     • Alignment: Position the labels (top, bottom, middle).
     • Number Format: Display numbers in currency, percentages, or rounded formats.

Best Practices for Labels

1. Avoid Clutter: Only label key data points in dense charts to prevent overcrowding.
2. Use Font Size Wisely: Ensure labels are readable but not overwhelming.
3. Position Strategically: Place labels inside or outside the bars depending on the chart type (e.g., bar chart vs. scatter plot).

Example

For a Bar Chart showing Sales by Region:

• Drag Sales to the Label shelf.
• Format the labels to display as currency (e.g., $150,000).
• Align labels at the center of each bar for clear visibility.

1.4 Tooltips

What are Tooltips?
Tooltips display additional information when you hover over a data point in the chart. They are useful for providing extra details without cluttering the visualization.

Steps to Customize Tooltips

1. Open the Tooltip Shelf:

   • Click on the Tooltip shelf in the Marks Card.

2. Edit the Tooltip:

   • In the Tooltip editor, you can customize the text:
     • Add or remove fields.
     • Format text (bold, italics, colors).
     • Include additional dynamic values using the Insert menu.

3. Add Context:

   • Use descriptive text to explain what the user is seeing.
   • Example: "Sales for is <SUM(Sales)>."

4. Preview the Tooltip:

   • Hover over a mark in the view to see the customized tooltip.

Example of a Customized Tooltip

For a Sales by Region chart, your tooltip could display:

Region: <Region>  
Total Sales: <SUM(Sales)>  
Average Profit: <AVG(Profit)>  

1.5 Gridlines and Borders

What are Gridlines and Borders?

• Gridlines help align and compare data points in the chart.
• Borders provide clear separation between marks and chart elements.

Steps to Format Gridlines and Borders

1. Go to the Format Menu:

   • Select Format > Lines.

2. Customize Gridlines:

   • In the Lines pane, choose the type of gridlines to customize (e.g., Rows, Columns).
   • Adjust options like line color, style (solid/dotted), and thickness.

3. Add Borders:

   • Go to Format > Borders.
   • Add borders to panes, cells, or headers to enhance visibility.

Best Practices for Gridlines and Borders

• Use subtle gridlines to improve readability without overwhelming the chart.
• Avoid using thick or bright lines unless highlighting something specific.

1.6 Fonts and Sizes

Why are Fonts Important?
Consistent fonts and sizes ensure that your dashboard looks polished and professional.

Steps to Adjust Fonts

1. Go to the Format Menu:

   • Select Format > Font.

2. Customize Fonts for Different Elements:

   • Titles: Set the font type, size, and color.
   • Headers: Format column and row headers.
   • Tooltips: Adjust text appearance for tooltips.

3. Adjust Font Sizes:

   • Ensure that titles are larger than other text.
   • Use smaller fonts for details like labels or captions.

Best Practices for Fonts

1. Use a maximum of 2 font types across the entire dashboard.
2. Ensure font size hierarchy:
   • Titles > Axis Labels > Legends > Tooltips.
3. Use bold or color to emphasize key insights.

Summary of Formatting

By carefully applying titles, colors, labels, tooltips, gridlines, and fonts, you can make your visualizations clear, professional, and easy to understand.

2. Creating Dashboards

2.1 What is a Dashboard?

A dashboard in Tableau is a collection of worksheets, filters, legends, and other objects combined into a single view. Dashboards enable you to:

• Combine multiple visualizations to tell a story.
• Compare related data from different worksheets.
• Allow users to interactively explore data using filters and actions.

2.2 Steps to Create a Dashboard

Follow these steps to create a professional and user-friendly dashboard:

Step 1: Start a New Dashboard

1. At the bottom of the Tableau workspace, click the New Dashboard icon (next to the New Worksheet icon).
2. Tableau opens a blank dashboard canvas with the Sheets pane on the left.

Step 2: Add Worksheets to the Dashboard

1. Drag existing worksheets from the Sheets pane into the dashboard canvas.
2. Tableau automatically arranges the worksheets based on the available space.

Step 3: Choose a Layout Option

Tableau provides two layout options for positioning and resizing components in a dashboard:

1. Tiled Layout:

   • Default setting in Tableau.
   • Worksheets and objects are placed in a grid-like, fixed structure.
   • Suitable for simpler dashboards where components do not need to overlap.

2. Floating Layout:

   • Allows you to freely position and resize components.
   • Worksheets and objects can overlap or float on top of each other.
   • Useful for creating highly customized dashboards.

How to Switch Between Layouts:

• Select the object in the dashboard.
• In the Layout Pane, check or uncheck the Floating option.

Step 4: Add Objects to the Dashboard

You can enhance dashboards by adding additional components like text, images, and filters.

Object Type	Description
Text	Add a text box for titles, descriptions, or instructions.
Image	Insert images like logos or icons.
Web Page	Embed a web page (e.g., reports, Google search links).
Blank	Create space between components for cleaner design.

Steps to Add an Object:

1. In the Objects Pane (bottom left), select the desired object.
2. Drag it to the dashboard canvas.
3. Adjust its position and size as needed.

Step 5: Arrange and Resize Views

1. Click on any worksheet or object to activate it.
2. Use the Resize Handles (blue border around the object) to adjust the size.
3. Drag components to rearrange their positions.
4. Align objects neatly using Tableau’s automatic snap-to-grid feature.

Step 6: Optimize Device Layouts

Tableau allows you to customize dashboards for different devices, including Desktop, Tablet, and Phone.

Steps to Optimize Device Layouts:

1. Click the Device Preview dropdown at the top of the dashboard.
2. Choose the device type: Desktop, Tablet, or Phone.
3. Resize and rearrange the dashboard components to fit the selected device layout.
4. Save and test the dashboard on each device preview.

Tip: Device layouts ensure that dashboards look great across all screen sizes.

2.3 Adding Interactivity to Dashboards

Interactivity makes dashboards more engaging and allows users to explore data on their own. Tableau provides several ways to add interactivity:

1. Filters

What is a Filter?
A Filter allows users to control what data is displayed in the dashboard by selecting specific values or ranges.

Steps to Add Filters in a Dashboard:

1. In the dashboard, click on a worksheet to activate it.
2. Click the dropdown menu in the top-right corner of the worksheet.
3. Select Filters and choose the field you want to filter.
4. Tableau adds the filter control to the dashboard.

Example: Allow users to filter Sales by Region or Product Category.

2. Highlighting

What is Highlighting?
Highlighting emphasizes specific data points across all charts on a dashboard, helping users focus on relevant details.

Steps to Add Highlighting:

1. In the dashboard, go to Dashboard > Actions.
2. Click Add Action > Highlight.
3. Select the source worksheet and target sheets where highlighting should occur.
4. Define the highlighting behavior (e.g., hover or click).

Example: Highlight all data points related to the "East" region when a user selects it in one chart.

3. Dashboard Actions

What are Dashboard Actions?
Dashboard Actions allow users to interact with one chart to dynamically update or trigger actions in other charts. Tableau supports three types of actions:

1. Filter Actions: Filter other charts based on selections in the source chart.
2. Highlight Actions: Highlight related data points across charts.
3. URL Actions: Open external links or web pages when users click a specific mark.

Steps to Add a Dashboard Action:

1. Go to the Dashboard menu > Actions.
2. Click Add Action and choose the action type:
   • Filter: Filter other charts dynamically.
   • Highlight: Highlight related data points.
   • URL: Open external web pages.
3. Define the action:
   • Source Sheet: The chart where the action originates.
   • Target Sheets: The charts or views to update.
   • Action Trigger: Choose Hover, Select, or Menu.

Example: Filter Action

1. Create a dashboard with two worksheets:
   • Sales by Region (bar chart)
   • Sales by State (map).
2. Add a Filter Action:
   • Select "Sales by Region" as the source.
   • Select "Sales by State" as the target.
   • Trigger: Select.
3. Result: Clicking a region in the bar chart filters the map to show only states in that region.

2.4 Adding Legends and Controls

To make dashboards more informative, include legends and controls for colors, sizes, and filters.

Steps to Show Legends:

1. Click the Legends menu in the Dashboard Pane.
2. Select which legends to display (Color, Size, or Shape).
3. Drag the legends into the dashboard for better placement.

Steps to Add Parameter Controls:

1. If a parameter is used in the dashboard, right-click it in the Data Pane.
2. Select Show Parameter Control.
3. The parameter control appears on the dashboard, allowing users to change values dynamically.

Best Practices for Creating Dashboards

1. Keep It Simple: Avoid cluttering the dashboard with too many components. Focus on 2-4 key visualizations.
2. Make It Interactive: Use filters, actions, and parameters to let users explore the data.
3. Prioritize Layout: Align charts, legends, and objects neatly. Use consistent spacing.
4. Optimize Performance:
   • Use extracts instead of live connections for large datasets.
   • Minimize the number of marks in each visualization.
5. Design for the Audience: Customize the design and layout for the intended audience (e.g., executives, analysts, or stakeholders).

3. Building Stories

3.1 What is a Story?

A Story in Tableau is a sequence of visualizations, called Story Points, that helps narrate a data-driven story. Stories guide the audience through an analysis or highlight key insights step-by-step.

3.2 When to Use Stories

• To present a step-by-step analysis of data insights.
• To explain findings in a logical sequence.
• To guide decision-makers through a complex analysis.
• To compare different scenarios or highlight changes over time.

3.3 Steps to Create a Story

Step 1: Start a New Story

1. At the bottom of the Tableau workspace, click the New Story icon.
2. Tableau opens a blank Story canvas.

Step 2: Add Worksheets or Dashboards to the Story

1. In the Story Pane (on the left), you will see a list of all available worksheets and dashboards.
2. Drag a worksheet or dashboard onto the Story canvas.
   • This becomes your first Story Point.

Step 3: Add Story Points

• A Story Point represents a single step or slide in your story.
• Each Story Point can display:
  • A worksheet or dashboard.
  • A text annotation to explain what’s happening.

How to Add a Story Point:

1. Click Add a New Story Point at the top of the Story canvas.
2. Drag a worksheet or dashboard into the new Story Point.

Example:

• Story Point 1: Show "Sales by Region" with a bar chart.
• Story Point 2: Show "Sales by Product Category" with a pie chart.
• Story Point 3: Highlight insights with annotations (e.g., "East region has the highest sales").

Step 4: Add Annotations

Annotations help explain each Story Point by providing context or insights.

Steps to Add Annotations:

1. Select the Story Point where you want to add text.
2. Click on the Text Box in the Story Pane.
3. Type your description or key findings.
4. Format the text (font size, color, alignment) for readability.

Example: Add a description like:

"Sales increased significantly in the East region, driven by Technology products."

Step 5: Navigate Between Story Points

• Use the navigation arrows at the top to move between Story Points.
• Tableau allows users to interact with worksheets within each Story Point, enabling deeper exploration.

3.4 Customizing Your Story

1. Change the Story Layout:

   • At the top of the Story canvas, choose between:
     • Caption Layout: Titles and captions at the top of the Story Point.
     • Navigator Layout: Thumbnails of all Story Points for easy navigation.

2. Format the Story:

   • Go to the Format menu to change:
     • Background color of the Story canvas.
     • Fonts for captions and annotations.
     • Borders or shading.

3. Resize the Story Canvas:

   • Adjust the size of the Story to fit different devices or screens.
   • Options include Default, Desktop Browser, Tablet, or Custom.

3.5 Best Practices for Building Stories

1. Start with a Clear Objective:

   • Define the purpose of your story (e.g., highlight performance trends, explain outliers, or guide decision-making).

2. Use a Logical Flow:

   • Present insights in a step-by-step manner that builds on previous points.

3. Keep it Simple:

   • Avoid overloading the audience with too many charts or excessive text.

4. Add Annotations:

   • Clearly explain what the user is seeing and why it matters.

5. Use Consistent Formatting:

   • Maintain uniform colors, fonts, and chart styles across all Story Points.

6. End with a Key Insight:

   • Conclude the story with a summary or a recommendation based on the analysis.

4. Sharing Your Insights

Once you have created visualizations, dashboards, or stories in Tableau, you can share your work with others. Tableau provides multiple ways to export, publish, or collaborate on your insights.

4.1 Export Options

1. Export to PDF

Export your visualizations or dashboards as a PDF document for reporting purposes.

Steps:

1. Go to the top menu > File > Export as PDF.
2. In the Export PDF dialog:
   • Choose the worksheets or dashboards to include.
   • Select the Paper Size (A4, Letter, etc.).
   • Set the layout (Portrait or Landscape).
3. Click OK to save the file.

2. Export to PowerPoint

Export your dashboards as PowerPoint slides for presentations.

Steps:

1. Go to the top menu > File > Export as PowerPoint.
2. Tableau exports the selected dashboards as static images in PowerPoint slides.

3. Export Images

Save individual worksheets or dashboards as image files (PNG, JPEG, etc.).

Steps:

1. Go to the top menu > Worksheet > Export > Image.
2. Choose the file format and save the image.

4. Copy and Paste Visualizations

You can directly copy visualizations and paste them into external documents, like Word or PowerPoint.

Steps:

1. Right-click on the worksheet or visualization.
2. Select Copy.
3. Paste the visualization into another application (Ctrl+V).

4.2 Publishing Workbooks

Publishing allows you to share your Tableau work online through Tableau Server or Tableau Online for collaboration and interaction.

Steps to Publish a Workbook:

1. Go to the top menu > Server > Publish Workbook.
2. Enter your Tableau Server or Tableau Online credentials.
3. Choose the project or folder to publish the workbook.
4. Configure settings:
   • Permissions: Define who can view or edit the workbook.
   • Data Refresh: Schedule data refresh for extracts.
5. Click Publish.

4.3 Saving Workbooks

Tableau offers two file formats for saving workbooks:

Format	Description
Tableau Workbook (.twb)	Saves the workbook and metadata (does NOT include data).
Tableau Packaged Workbook (.twbx)	Includes the workbook and data for offline sharing.

4.4 Collaboration Best Practices

1. Provide Clear Instructions: Add captions, tooltips, and annotations for clarity.
2. Maintain Consistency: Use consistent colors, fonts, and chart styles.
3. Optimize for Performance:
   • Use extracts instead of live connections for large datasets.
   • Minimize the number of marks and filters in each view.
4. Test Interactivity: Ensure filters, actions, and parameters work as expected.

Sharing Insights (Additional Content)

1. Dashboard Performance Recording – Analyzing and Optimizing Speed

Why It Matters:

While not a core exam focus, performance issues often appear in scenario-based questions such as:

“A dashboard loads slowly. What’s the best way to identify the cause?”

How to Use Performance Recording:

1. Go to the Top Menu in Tableau Desktop.
2. Select:
   Help > Settings and Performance > Start Performance Recording
3. Interact with your dashboard as usual.
4. Stop the recording: Help > Settings and Performance > Stop Performance Recording
5. Tableau generates a performance workbook, showing:

• Query time for each view
• Rendering time
• Filter responsiveness
• Layout performance

Use Case:

Helps you detect which worksheet or filter causes lag and optimize:

• Replace high-cardinality filters
• Reduce number of quick filters or marks
• Switch from Live to Extract

Exam Tip:

Look for keywords like “optimize” or “identify slow performance”.

Correct feature: Performance Recording

2. Dashboard vs Story – Purpose and Use Case

Why It Matters:

TDS-C01 often asks:

“Which Tableau component is best for interactive exploration?”
“Which is best for presenting a narrative?”

Dashboard:

• Designed for interactive exploration and analysis
• Users can click, filter, drill down, and use actions
• Suitable for executives, analysts, or dashboards with KPIs

Story:

• A linear sequence of visualizations called Story Points
• Meant to walk users through a data narrative
• Suitable for reports, presentations, and stakeholder storytelling

Quick Comparison:

Feature	Dashboard	Story
Purpose	Exploration, Analysis	Presentation, Explanation
Interactivity	High	Low to Medium
Layout	Multiple views in one screen	One view per point
Best For	Analysts, executives	Reports, business users

Exam Clue:

If the scenario says: “You want to explain key trends step-by-step,” the answer is likely Story.

3. Parameters vs Filters – Understanding the Difference

Why It Matters:

Candidates are often confused by this distinction.

Filters:

• Directly control what data appears
• Can be used without any calculated field
• Bound to a specific field (e.g., Category, Region)

Parameters:

• Are placeholder values (user-input)
• Do not filter data by themselves
• Must be used in a calculated field, reference line, or dynamic title

Use Case Example:

Goal: Let the user switch between Sales and Profit in a chart.

Solution:

• Create a String parameter: "Sales", "Profit"

• Create a calculated field:

  IF [Select Metric] = "Sales" THEN [Sales]
  ELSE [Profit]
  END
  

• Use this calculated field in your view

Exam Trap:

“You created a parameter for ‘Region’. Why doesn’t it filter your data?”

Correct answer: Parameters alone do not filter. You must create a calculated field using the parameter.

4. Embedded Sharing & Permission Control (Tableau Server/Online)

Why It Matters:

Though more advanced, questions may appear under topics like:

“How do you control who sees a shared dashboard?”

Two Sharing Options:

Method	Description
Link Sharing	Share a direct URL to the workbook on Tableau Server/Online
Embedded (iframe)	Embed the workbook in a webpage or intranet using HTML iframe

Permission Levels:

• Set when publishing or editing a project/workbook on Tableau Server/Online
• Common roles:
  • Viewer: Can only view published content
  • Editor: Can edit dashboards
  • Project Leader: Can manage project-level settings

Use Case Example:

To embed a filtered view of a dashboard in your company portal, you:

1. Publish to Tableau Server
2. Use "Embed Code" to generate the iframe
3. Set permissions so only authorized users can view

5. Dashboard Sizing and Responsive Design

Why It Matters:

Poor dashboard sizing leads to misaligned views and a bad user experience, especially on client screens or tablets.

Recommended Sizes:

Device	Suggested Fixed Size
Desktop	1200 × 800
Tablet	768 × 1024
Phone	375 × 667

Sizing Options in Tableau:

1. Fixed Size:

• Use a specific width/height
• Ensures consistent layout on all screens

2. Automatic:

• Adjusts based on user’s screen
• May break alignment or cause scroll bars

3. Device Layouts:

• Create custom layouts for Desktop, Tablet, and Phone
• Found in the Device Preview toolbar

Tips for Responsive Design:

• Avoid floating elements when using automatic resizing
• Use container layouts for better alignment
• Always test with Device Preview

Exam Insight:

“Which option ensures your dashboard is consistently aligned across screen sizes?”

Correct answer: Use Fixed Size or Device-Specific Layout

Summary of High-Yield Additions for “Sharing Insights”

Topic	Exam Angle	Key Learning
Performance Recording	Optimization scenario	Use Help > Performance Recording
Dashboard vs Story	Use-case questions	Dashboard = interactive, Story = narrative
Parameters vs Filters	Conceptual trap	Parameters ≠ Filters unless used in calculation
Embedding & Permissions	Server-based sharing	Use iframes + set user roles (Viewer/Editor)
Dashboard Layout	Design scenario	Use fixed sizes or Device layouts for consistency