TDS-C01 Exploring and Analyzing Data

Exploring and Analyzing Data Detailed Explanation

In this section, we will go step-by-step through "Exploring and Analyzing Data" concepts in Tableau, starting with Building Basic Visualizations. Visualizations are Tableau's core feature, allowing you to turn data into meaningful insights through charts and graphs.

1. Building Basic Visualizations

1.1 Bar Chart

What is a Bar Chart?

A bar chart is one of the simplest and most commonly used visualizations. It allows you to compare values across categories, like showing Sales by Region or Profit by Product Category.

Use Cases:

• Comparing data across categories.
• Highlighting the largest or smallest values.
• Visualizing categorical data (e.g., regions, products, departments).

Steps to Create a Simple Bar Chart:

1. Connect to Your Data Source:

   • Load your dataset in Tableau (e.g., Sample Superstore).

2. Drag a Dimension to the Rows Shelf:

   • Example: Drag the Region field to the Rows shelf.
   • This creates a header for each Region (East, West, South, Central).

3. Drag a Measure to the Columns Shelf:

   • Example: Drag the Sales field to the Columns shelf.
   • Tableau automatically generates a horizontal bar chart showing total Sales for each Region.

4. Add Labels for Clarity:

   • Click on the Label shelf in the Marks card.
   • Drag the Sales field to Label to display values directly on the bars.

5. Sort the Bar Chart:

   • Click the Sort icon above the view to arrange bars in ascending or descending order.

Creating a Stacked Bar Chart

A Stacked Bar Chart allows you to compare values within categories by adding another Dimension. For example, comparing Sales by Region and splitting it by Product Category.

Steps:

1. Create a basic bar chart as described above.
2. Drag a second Dimension (e.g., Product Category) to the Color shelf.
3. Tableau divides the bars by the second Dimension, creating a stacked bar chart.
4. Adjust colors for better clarity if needed.

Example: Sales by Region split into different Product Categories (Furniture, Office Supplies, and Technology).

Visual Example:

Region	Sales	Category
East	100,000	Furniture
East	50,000	Office Supplies
West	200,000	Technology

In a stacked bar chart, each region's bar is divided into "Furniture," "Office Supplies," and "Technology," with each segment showing the Sales for that category.

1.2 Line Chart

What is a Line Chart?

A line chart is used to show trends or changes over time, such as monthly sales, stock prices, or daily website traffic.

Use Cases:

• Analyzing data over time (e.g., monthly or yearly trends).
• Showing patterns or fluctuations.
• Highlighting increases or decreases in values.

Steps to Create a Line Chart:

1. Drag a Date Field to the Columns Shelf:

   • Example: Drag Order Date to the Columns shelf.
   • Tableau will automatically aggregate it to Year.

2. Change Date Aggregation:

   • Click the dropdown arrow on the Order Date field in Columns.
   • Select a finer level of detail, such as Month or Day.

3. Drag a Measure to the Rows Shelf:

   • Example: Drag the Sales field to the Rows shelf.
   • Tableau creates a line chart showing Sales over time.

4. Customize the Chart:

   • Add labels: Drag the Sales field to Label.
   • Format the axes: Right-click the axis > Edit Axis.

5. Highlight Trends:

   • Use Color to differentiate trends by a Dimension (e.g., Region).
   • Drag the Region field to the Color shelf.

Continuous vs. Discrete Date Fields

• Continuous Dates: Display dates as a continuous range on an axis (e.g., Month-Year).
• Discrete Dates: Group dates into categories (e.g., 2023, Q1, January).

Key Tip: Use continuous dates for trend lines and discrete dates for grouped comparisons.

1.3 Scatter Plot

What is a Scatter Plot?

A scatter plot is used to show the relationship between two numerical measures. It helps identify patterns, correlations, and outliers.

Use Cases:

• Analyzing relationships between two numeric variables (e.g., Sales vs. Profit).
• Identifying clusters and outliers.
• Understanding how one variable impacts another.

Steps to Create a Scatter Plot:

1. Drag One Measure to the Columns Shelf:

   • Example: Drag Sales to the Columns shelf.

2. Drag Another Measure to the Rows Shelf:

   • Example: Drag Profit to the Rows shelf.
   • Tableau creates a scatter plot with Sales on the x-axis and Profit on the y-axis.

3. Add a Dimension to the "Detail" Shelf:

   • Example: Drag the Region field to the Detail shelf.
   • This creates one point for each Region, positioned based on Sales and Profit.

4. Enhance the Scatter Plot:

   • Add Color: Drag a Dimension (e.g., Product Category) to the Color shelf.
   • Add Size: Drag a Measure (e.g., Quantity) to the Size shelf.
   • Add Labels: Drag a Dimension (e.g., Region) to the Label shelf.

Interpreting the Scatter Plot

• Positive Correlation: Points trend upward from left to right (e.g., Sales increases with Profit).
• Negative Correlation: Points trend downward.
• No Correlation: Points are scattered randomly.

1.4 Maps

What is a Map?

A map is used to visualize geographic data. Tableau automatically recognizes fields with geographic roles, such as Country, State, or City, and plots them on a map.

Use Cases:

• Visualizing sales, population, or profit by location.
• Comparing data across regions (e.g., states or countries).
• Highlighting high-performing or underperforming areas.

Steps to Create a Map:

1. Drag a Geographic Field to the View:

   • Example: Drag the State or Country field to the canvas.
   • Tableau automatically generates a map.

2. Add a Measure to Color:

   • Example: Drag the Sales field to the Color shelf.
   • The map shows different states shaded based on total Sales.

3. Add Labels:

   • Drag a field (e.g., State name) to the Label shelf to display state names.

4. Customize the Map:

   • Change Color Gradients: Click on the Color shelf to adjust the color palette.
   • Add Tooltips: Ensure the map displays additional details when you hover over regions.

Map Types:

• Filled Maps: Uses shaded colors to represent data (e.g., Sales by State).
• Symbol Maps: Uses dots or symbols to represent locations and data points.

1.5 Dual-Axis Charts

What is a Dual-Axis Chart?

A dual-axis chart combines two measures on the same visualization, using two axes. This allows you to compare different measures with different scales on a single view.

Use Cases:

• Compare two measures, such as Sales and Profit.
• Show trends and actual values together (e.g., Sales as bars and Profit as a line).
• Analyze data with different units (e.g., Revenue in dollars vs. Units Sold).

Steps to Create a Dual-Axis Chart

1. Drag Two Measures to the View:

   • Example: Drag Sales to the Rows shelf.
   • Then drag Profit to the Rows shelf next to Sales.
   • Tableau creates two separate axes (one for Sales and one for Profit).

2. Create the Dual Axis:

   • Right-click on the second Measure (Profit).
   • Select Dual-Axis.
   • The two axes will now overlay on the same chart.

3. Synchronize the Axes (Optional):

   • Right-click on the second axis (Profit) and select Synchronize Axis.
   • This ensures both axes align correctly.

4. Change Mark Types for Clarity:

   • Click on the Marks card for each Measure:
     • For Sales: Select Bar Chart.
     • For Profit: Select Line Chart.
   • Tableau creates a Bar-Line Dual-Axis Chart.

5. Customize the Chart:

   • Add Labels: Drag the Sales and Profit fields to the Label shelf.
   • Add Colors: Use different colors for each axis to distinguish measures.

Visual Example:

• Left Axis (Sales in bars): Shows the total sales per month.
• Right Axis (Profit in line): Shows the trend of profit alongside sales.

This visualization is very effective for understanding how one measure (Sales) correlates with another measure (Profit).

1.6 Histogram

What is a Histogram?

A histogram shows the frequency distribution of a numerical field. It divides the data into equal-sized bins and counts the number of records that fall into each bin.

Use Cases:

• Analyzing data distribution (e.g., how many orders fall within specific sales ranges).
• Identifying patterns or outliers in numeric data.
• Understanding the spread or concentration of data.

Steps to Create a Histogram

1. Drag a Measure to the Columns Shelf:

   • Example: Drag Sales to the Columns shelf.

2. Create Bins for the Measure:

   • Right-click on the Sales field in the Data Pane.
   • Select Create > Bins.
   • Define the Bin Size (e.g., divide Sales into $100 intervals).
   • Click OK to create the bins.

3. Drag the Binned Field to the View:

   • Tableau automatically groups the Sales data into bins and creates a histogram.
   • Example: The x-axis shows Sales ranges (e.g., $0-$100, $100-$200), and the y-axis shows the number of orders in each range.

4. Customize the Histogram:

   • Add Labels: Drag the Count measure to the Label shelf.
   • Change the Colors: Use a single or gradient color to improve readability.

Example Interpretation:

• If the histogram shows that most orders fall between $100 and $300, you know that small to medium-sized orders dominate the dataset.

2. Organizing and Filtering Data

Once you build your visualizations, Tableau provides powerful tools to organize and refine the data displayed in your charts. Key tools include Groups, Sets, Hierarchies, and Filters.

2.1 Groups

What are Groups?

A Group combines similar values into a single category for easier analysis. It allows you to simplify and clean up messy data.

Use Cases:

• Grouping regions (e.g., Northeast and Southeast into East).
• Combining similar products into broader categories.
• Simplifying long lists of dimensions.

Steps to Create a Group

1. Right-click on a Dimension:
   • Example: Right-click the Region field in the Data Pane.
2. Create Group:
   • Select values you want to combine (e.g., Northeast and Southeast).
   • Click Group and give it a name.
3. Rename the Group:
   • Double-click on the group name to edit it.
4. Add the Group to the View:
   • Drag the group field to the view.

Example:

• Group "East" and "West" regions into a new category called "Coastal Regions."

Original Data	Grouped Data
East	Coastal Regions
West	Coastal Regions
South	South

2.2 Sets

What are Sets?

A Set is a subset of data based on specific conditions. Unlike Groups, Sets are dynamic and can update automatically when the data changes.

Use Cases:

• Analyzing the Top 10 Products based on Sales.
• Creating a subset of customers with Sales > $1,000.
• Comparing “In-Set” vs. “Out-of-Set” data.

Steps to Create a Set

1. Right-click on a Dimension:
   • Example: Right-click the Product Name field.
2. Create Set:
   • Define the condition (e.g., Top 10 by Sales).
3. Add the Set to the View:
   • Drag the Set to the Filter shelf or use it in calculations.

Example:

• Create a Set of the Top 10 Products by Sales.

Product	Sales	Set Membership
Product A	$5,000	In Set
Product B	$4,800	In Set
Product Z	$300	Out of Set

2.3 Hierarchies

What are Hierarchies?

A Hierarchy organizes Dimensions into parent-child relationships, allowing you to drill down into data.

Use Cases:

• Drill down from Region → State → City.
• Analyze Products by Category → Subcategory → Product Name.

Steps to Create a Hierarchy

1. Drag One Dimension onto Another:
   • Example: Drag State onto Region in the Data Pane.
2. Name the Hierarchy:
   • Rename the hierarchy (e.g., “Geography”).
3. Drill Down in the View:
   • Add the hierarchy to the view.
   • Use the + or - sign to drill up or down.

Example:

Region	State	City
East	New York	New York City
West	California	Los Angeles

2.4 Filters

Filters allow you to refine your data by including or excluding specific categories, numeric values, or time ranges. Tableau provides different types of filters based on the type of data.

Types of Filters in Tableau

1. Dimension Filters

   • Filter categorical data (e.g., Region, Product Category).
   • Useful when you want to include/exclude specific categories.

   Example: Show only the East and West regions.

   Steps:

   1. Drag a Dimension (e.g., Region) to the Filters shelf.
   2. In the filter dialog box, select the categories you want to include (e.g., East, West).
   3. Click OK.

2. Measure Filters

   • Filter numeric values (e.g., Sales, Profit).
   • Use this filter to set thresholds or ranges (e.g., Sales > $1,000).

   Example: Display orders where Sales are greater than $1,000.

   Steps:

   1. Drag a Measure (e.g., Sales) to the Filters shelf.
   2. In the filter dialog box, select the filter type:
      • Range of values
      • At least / At most
   3. Define the threshold (e.g., Sales > 1000).
   4. Click OK.

3. Date Filters

   • Filter date fields to focus on specific time periods (e.g., Year, Quarter, Month).
   • Tableau allows you to use both relative dates (e.g., last 30 days) and fixed dates (e.g., 2023 data only).

   Example: Show only data from 2023.

   Steps:

   1. Drag a Date Field (e.g., Order Date) to the Filters shelf.
   2. Choose the filter type:
      • Relative Date: Select options like last 30 days, last year, etc.
      • Range of Dates: Define a start and end date.
      • Individual Dates: Choose specific dates to include.
   3. Click OK.

2.5 Highlighting

Highlighting allows you to emphasize specific data points in your visualization while still displaying all the data.

How to Highlight Data

1. Use the Highlight Shelf:

   • Drag a Dimension or Measure to the Highlight shelf on the Marks card.
   • Tableau highlights related data points when you interact with the chart.

2. Manual Highlighting:

   • Hover over or select a mark in the view to highlight it.

3. Highlight Actions (for Dashboards):

   • Highlight related marks across multiple charts in a dashboard.
   • Go to Dashboard > Actions > Add Action > Highlight.

Use Cases for Highlighting

• Highlight a specific Region to analyze its performance relative to others.
• Emphasize Top N products or customers.
• Allow users to interactively explore data in a dashboard.

3. Applying Analytics to Visualizations

Once you have built and refined your visualizations, Tableau allows you to enhance them further by adding statistical lines, bands, and calculations. These tools help you provide deeper insights and context to your data.

3.1 Reference Lines and Reference Bands

What are Reference Lines and Bands?

• Reference Lines: Add a constant line, average, median, or custom value to a chart.
• Reference Bands: Highlight ranges between two values on a chart.

Use Cases

• Reference Lines: Show benchmarks or averages for comparison.
  • Example: Display the average sales line on a bar chart.
• Reference Bands: Highlight ranges for performance analysis.
  • Example: Show sales ranges between $1,000 and $3,000.

Steps to Add a Reference Line

1. Go to the Analytics Pane.
2. Drag Reference Line onto your visualization.
3. Choose where to place the line:
   • Table: Adds the line across the entire table.
   • Pane: Adds the line for each group of data.
   • Cell: Adds the line for individual cells.
4. Define the line:
   • Select Value: Constant, Average, Median, or Custom.
   • Add Label: Display the value on the line.
   • Customize Formatting: Change line style, color, and thickness.

Steps to Add a Reference Band

1. Go to the Analytics Pane.
2. Drag Reference Band onto your visualization.
3. Define the range:
   • Start Value: Minimum, Average, or a specific value.
   • End Value: Maximum, Median, or a specific value.
4. Customize formatting to add labels and adjust band colors.

3.2 Trend Lines

What are Trend Lines?

Trend lines help you visualize relationships in the data and analyze trends over time. Tableau provides options for linear, logarithmic, and polynomial trend lines.

Use Cases

• Show the trend of Sales over Time.
• Analyze the relationship between two measures, such as Sales and Profit.
• Predict future performance with existing data.

Steps to Add a Trend Line

1. Go to the Analytics Pane.
2. Drag Trend Line to your chart.
3. Select the type of trend line:
   • Linear
   • Logarithmic
   • Polynomial
   • Exponential
4. Tableau adds the trend line to the chart.
5. Customize the trend line:
   • Right-click the line > Edit.
   • Choose line style, color, and label options.

Interpreting a Trend Line

• Positive Trend: The line slopes upward (e.g., as Sales increases, Profit increases).
• Negative Trend: The line slopes downward.
• No Trend: The line is relatively flat, indicating no significant relationship.

3.3 Quick Table Calculations

What are Quick Table Calculations?

Quick Table Calculations allow you to perform common computations without writing formulas. Tableau provides prebuilt calculations that can be applied to your visualizations instantly.

Examples of Quick Table Calculations

1. Percent of Total: Calculate the contribution of each value to the total.
2. Running Total: Show cumulative values over time (e.g., cumulative Sales).
3. Difference: Calculate the change between values (e.g., year-over-year growth).
4. Rank: Rank data from highest to lowest.

Steps to Add a Quick Table Calculation

1. Right-click a Measure:
   • Example: Right-click the Sales field on the Rows shelf.
2. Select Quick Table Calculation.
3. Choose the desired calculation:
   • Percent of Total
   • Running Total
   • Difference
4. Tableau applies the calculation to your visualization.

Customizing Quick Table Calculations

• Right-click the calculated field > Edit Table Calculation.
• Choose the direction for the calculation:
  • Across (Rows)
  • Down (Columns)
  • Specific Dimensions

4. Creating Calculated Fields

4.1 What is a Calculated Field?

A Calculated Field is a custom field you create in Tableau by writing formulas. These formulas allow you to:

• Perform arithmetic calculations.
• Apply logical operations (e.g., IF-THEN statements).
• Work with string manipulations (e.g., splitting names).
• Use date calculations (e.g., finding the difference between dates).

4.2 Why Use Calculated Fields?

• Create new insights by building custom calculations.
• Clean and transform data directly in Tableau.
• Define KPIs (Key Performance Indicators) for business analysis.
• Categorize data dynamically (e.g., “High Sales” vs. “Low Sales”).

4.3 Steps to Create a Calculated Field

1. Open the Calculation Editor:
   • Go to the Data Pane.
   • Right-click anywhere > Create Calculated Field.
2. Name the Calculated Field:
   • Provide a clear, descriptive name.
3. Write the Formula:
   • Use Tableau's syntax to define the calculation.
   • The Calculation Editor provides autocomplete suggestions to help you.
4. Validate the Formula:
   • Tableau checks for errors in your formula.
   • If valid, click OK.
5. Use the Calculated Field:
   • The new field appears in the Data Pane.
   • Drag it into your visualization like any other field.

4.4 Examples of Calculated Fields

1. Basic Calculations

Perform simple arithmetic operations to create new measures.

Example: Calculate the Profit Ratio (Profit / Sales).

[Profit] / [Sales]  

Steps:

• Right-click > Create Calculated Field.
• Enter the formula: [Profit] / [Sales].
• Click OK.
• Drag the new field into your view.

2. Conditional Statements (IF-THEN)

Categorize data based on conditions.

Example: Create a new field to classify Sales as "High" or "Low."

IF [Sales] > 1000 THEN "High" ELSE "Low" END  

Steps:

• Right-click > Create Calculated Field.
• Write the formula above.
• Drag the calculated field to Color or Rows to see the classification.

Result:

• Sales > 1000 → High
• Sales ≤ 1000 → Low

3. String Functions

Manipulate text fields, such as splitting, combining, or extracting portions of strings.

Example: Extract the first 5 characters of a customer name.

LEFT([Customer Name], 5)  

Steps:

• Create a calculated field with the formula above.
• Add it to the view to display the first 5 characters.

4. Date Functions

Perform calculations with date fields, such as extracting parts of a date or calculating the difference between dates.

Example 1: Extract the year from the Order Date field.

YEAR([Order Date])  

Example 2: Calculate the difference in years between Order Date and today.

DATEDIFF('year', [Order Date], TODAY())  

Steps:

• Use the DATEDIFF function to calculate the number of years between two dates.
• Display the result as a Measure or a Label in your visualization.

4.5 Combining Calculations

You can combine different types of calculations to create more advanced insights.

Example: Create a Profit Ratio field that also categorizes performance.

IF ([Profit] / [Sales]) > 0.2 THEN "High Margin" ELSE "Low Margin" END  

This calculation creates a custom performance category based on the Profit Ratio.

5. Using Parameters

5.1 What is a Parameter?

A Parameter is a dynamic placeholder value that allows users to interactively change calculations, filters, or reference lines in a visualization.

5.2 Why Use Parameters?

• Allow users to choose between different measures (e.g., Sales vs. Profit).
• Create dynamic thresholds for filters or reference lines.
• Enable interactive analysis without editing the workbook.

5.3 Steps to Create a Parameter

1. Right-click in the Data Pane:

   • Select Create Parameter.

2. Define the Parameter:

   • Name: Give the parameter a descriptive name.
   • Data Type: Choose the appropriate type:
     • Integer (whole numbers)
     • Float (decimal numbers)
     • String (text)
     • Boolean (True/False)
     • Date
   • Allowable Values:
     • All: Users can enter any value.
     • List: Provide a list of allowable values.
     • Range: Define a minimum, maximum, and step size for numbers.

3. Use the Parameter in a Calculation:

   • Right-click the new parameter > Create Calculated Field.
   • Write a formula that references the parameter.

4. Add the Parameter Control to the View:

   • Right-click the parameter in the Data Pane > Show Parameter Control.
   • This allows users to interact with the parameter in the view.

5.4 Examples of Parameters

1. Switch Between Measures

Allow users to toggle between Sales and Profit dynamically.

Steps:

1. Create a Parameter:

   • Name: "Select Measure"
   • Data Type: String
   • Allowable Values: List
     • Add "Sales" and "Profit" as options.

2. Create a Calculated Field:

IF [Select Measure] = "Sales" THEN [Sales]  
ELSEIF [Select Measure] = "Profit" THEN [Profit]  
END  

3. Add the Calculated Field to the View.
4. Show the Parameter Control and let users choose Sales or Profit.

2. Dynamic Reference Line

Allow users to set a custom target value for comparison.

Steps:

1. Create a Parameter:

   • Name: "Target Sales"
   • Data Type: Float
   • Allowable Values: Range (e.g., 0 to 5000).

2. Add a Reference Line:

   • Go to Analytics Pane > Reference Line.
   • Select "Value" and choose the "Target Sales" parameter.

3. Show the Parameter Control to let users input a target value.

5.5 Best Practices for Parameters

• Use clear names for parameters to make their purpose obvious.
• Combine parameters with calculated fields to enable dynamic functionality.
• Test the parameter control to ensure it works correctly with your data.

Exploring and Analyzing Data (Additional Content)

1. The "Show Me" Panel – Smart Chart Recommendations

The Show Me panel is a built-in Tableau feature that provides automatic visualization suggestions based on selected fields.

What is Show Me?

• A sidebar that helps users quickly build charts without memorizing chart requirements.
• It activates once you select one or more Dimensions or Measures in the data pane.

How it works:

• Tableau analyzes the type and number of selected fields.
• It highlights appropriate visualization types (e.g., bar chart, map, scatter plot).
• The user clicks on the suggested chart type to generate it instantly.

Use Cases:

• Beginners can use Show Me to learn how different charts relate to data structures.
• Analysts can explore multiple chart types quickly before settling on one.
• Great for demonstrating the difference between using 1 dimension + 1 measure vs multiple dimensions.

Typical TDS-C01 Question:

Which Tableau feature recommends chart types based on selected fields?

Correct answer: Show Me

2. Sorting in Tableau – Methods and Usage

Sorting is essential for improving the clarity of your visualizations, especially with bar charts, text tables, and scatter plots.

Sorting Methods in Tableau:

Method	Description
Manual Sort	Drag items to a custom order directly in the view
Field Sort	Sort based on a specific field (e.g., Product Name)
Aggregation Sort	Sort using a measure like SUM(Sales), in ascending or descending order

Where to Apply Sorting:

• Click directly on the axis (e.g., sort bars by size).
• Use the Sort dialog: Right-click the field > Sort > Choose sort method and order.
• Apply via the data shelf: Sort on Rows/Columns.

Example:

Sort “Product Category” in descending order by “SUM(Sales)” to highlight top performers.

Why It Matters:

• Enhances comparability in visuals.
• Makes high/low values stand out.
• Often tested in practical Tableau tasks or dashboard refinement questions.

3. Context Filters – Managing Filter Priority

When using multiple filters, Tableau executes them in a specific order, and this can affect the final result. That’s where Context Filters come in.

What is a Context Filter?

• A primary filter that sets the filtering context for other filters.
• It is executed first, before any other filters.

When to Use Context Filters:

• When a Top N filter depends on another filter.
• To improve performance with large datasets by reducing the data volume first.
• When other filters need to be applied after a specific condition is met.

How to Set One:

1. Right-click the filter in the Filter shelf.
2. Select "Add to Context".
3. The filter turns gray in the Filter shelf, indicating it’s now a context filter.

Example Scenario:

You want to show the Top 10 Products only within the East Region.

• Step 1: Add a filter for “Region” = East → set it as Context.
• Step 2: Apply a Top N filter on Product Name by Sales → this will now respect the Region context.

Exam-Relevant Insight:

Expect questions like:

“Which filter must be applied first to limit a Top N result to a specific Region?”

Correct answer: Context Filter

4. Level of Detail (LOD) Expressions – Conceptual Understanding

Although writing LOD expressions may not be heavily tested, understanding their purpose and types is essential.

What are LOD Expressions?

LOD Expressions allow you to customize the level at which Tableau performs aggregations, independently of the visualization’s granularity.

Three Types:

LOD Type	Purpose	Example
FIXED	Ignores view’s dimensions, fixes the level	{ FIXED [Region] : SUM([Sales]) }
INCLUDE	Adds a lower level of detail to the view	{ INCLUDE [City] : AVG([Profit]) }
EXCLUDE	Removes a dimension from the view	{ EXCLUDE [State] : SUM([Sales]) }

Key Idea:

LOD = You define “At what level” Tableau should calculate a result, not Tableau.

Exam Tip:

TDS-C01 may ask:

“Which LOD type should you use to calculate Sales by Region, even if the view includes Product?”

Correct answer: FIXED

5. Workbook vs Worksheet – Tableau Terminology Clarification

Basic Tableau terminology is frequently tested in the exam, especially to check your understanding of file structure and components.

Definitions:

Term	Meaning
Workbook (.twb/.twbx)	The full Tableau file, can include multiple sheets, dashboards, stories
Worksheet	A single visualization or chart
Dashboard	A layout that combines multiple worksheets and interactive objects
Story	A sequence of visualizations (story points) designed to tell a data-driven narrative

File Types:

• .twb = Tableau Workbook (metadata only, no data included)
• .twbx = Tableau Packaged Workbook (includes data and all assets)

Example Question:

Which Tableau component allows you to combine multiple visualizations into a single interactive interface?

Correct answer: Dashboard

Common Exam Traps and Smart Tips

Exam Trap	Correction	Tip
Thinking Show Me is for formatting	It suggests chart types based on field selection	Remember: Show Me = Chart suggestion
Assuming filters are applied in the order shown	Context filter runs first, then others	Learn to use “Add to Context”
Confusing Workbook with Worksheet	Workbook is the full file, Worksheet is one chart	Know all four Tableau object types
Misunderstanding sort behavior	Sort by field, not just manually	Check axis headers and Sort options carefully