Exercises

Exercise ID Lesson Title Description Primary Feature Focus Learning Objective Technical Focus Book Chapter Book Section Book Page Num
s1042 Donut Use the Dual Axis method to create a clean, minimalist KPI indicator. 1. Placeholder Generation: Create two identical rows using AVG(0) or MIN(1) on the Rows shelf.
2. Primary Mark: Set the first mark type to Pie and encode with Color and Angle.
3. Secondary Mark (The Hole): Set the second mark type to Circle, color it white, and reduce the size slightly.
4. Dual Axis Synchronize: Right-click the second pill and select Dual Axis to overlay the circle onto the pie.
5. KPI Labeling: Place the core metric (e.g., Total Sales) on the Label shelf of the second (circle) mark so it sits in the center.		 6 6.5 112
s1049 Sheet Selection Menu for Dashboard This exercise demonstrates how to create a dashboard with two worksheets stacked on top of each other, using a parameter control to switch between them. The implementation of Parameter Controls combined with Calculated Field Filters to create a dynamic "Sheet Swapping" effect on a dashboard. The implementation of Parameter Controls combined with Calculated Field Filters to create a dynamic "Sheet Swapping" effect on a dashboard. Parameter Creation: Defining a string-based list parameter (e.g., "pSelect a Sheet") that contains the exact names of the worksheets to be toggled.


Logical Filtering: Constructing a calculated field that passes the parameter value to the Filters shelf, allowing a worksheet to display only when its name is selected.


Custom Value Lists: Using the "Custom Value List" feature within the Filter dialog to manually input the specific sheet name for each toggle state.


Dashboard Real Estate Optimization: Using Floating objects to stack multiple worksheets in the same physical space, which allows the dashboard to seamlessly switch between views like "Sales" and "Profit" without requiring additional screen space.		 14 14.14.3, 14.21.2 343
s1057 Fixed LoD % of Total LOD Calculations: Slow & Steady implementation and conceptual understanding of Fixed Level of Detail (LOD) expressions in Tableau Master the syntax and conceptual logic of FIXED LODs to create view-independent aggregations. Level of Detail Calculations , Standard versus LOD Aggregations , Fans Per Zip Code FIXED logic , Nested Percent of Total Calculations , Statewide FIXED State Aggregations , and Abbreviated FIXED LOD Syntax. 11 11.13.5
s1065 Filtering 2 Dynamic Parameters & Top N Create a Top N filter combined with a dynamic range filter using two user-defined parameters to isolate high-performing cities within specific sales boundaries. Float parameters allow for manual entry of bottom and top sales values to dynamically update the view. A "By formula" filter on the City dimension applies a conditional range logic to the data. A Top 10 constraint isolates the highest-performing records that meet the specified range criteria. Configure float parameters for user input, apply logical operators within the Filter Condition tab to establish range boundaries, and utilize the Top N field limit to isolate high-performing records. Parameter-driven Range Filtering, Conditional Formulas, and Top N Field Constraints 8 8.5.2, 8.7.1
s1073 Top 3 Encode Marks Diamond Custom Color and Shape Legend (Diamod) A calculated field adjusts indicators to 95% of a bar's length. A RANK() function isolates the top three performers. A shape from a blank .png file hides shapes for all other records. Coordinate dual-axis overlays for precise visual alignment, implement rank-based logic for conditional visibility, and manage custom repository assets like transparent shapes and hex codes. Building the Initial View , Creating the Parameters , Applying the Condition Filter , and Adding the Top N Limit. 7, 13 7.2.7.8, 13.6.4 130, 298
s1074 Box & Whisker Draw a box and whisker plot from scratch to analyze data distribution and replicate the chart using Tableau's Show Me feature for rapid development. Sales data is plotted against segments using circle marks to establish a distribution foundation. The Analytics pane provides the box plot overlay with whiskers extending to 1.5 times the interquartile range. Custom formatting adjusts the fill, border, and whisker thickness, while the Show Me button provides a default automated alternative Construct box and whisker plots manually via the Analytics pane, utilize the Show Me tool for automated chart generation, and interpret statistical markers including the median, maximum, minimum, and quartiles. Establishing the Initial View, Adding the Box Plot from the Analytics Pane, Adjusting Plot Styles and Fill Colors, Configuring Mark Labels and Alignment, and Rapid Generation via Show Me. 7 7.2.3.4 124
s1096 Sheet Selector for Dynamic Zones Description Build a high-performance dashboard using a parameter control to switch between three different worksheets while simultaneously updating which filters (e.g., Supervisor or Manager) are displayed using Dynamic Zone Visibility. This feature, which was introduced in 2024, is located on the Layout pane of the Tableau dashboard. It is used to create highly interactive dashboards where entire "zones"—such as worksheets and their corresponding filters—are dynamically added to or removed from the layout based on user selection, rather than just being hidden. Master the use of Boolean logic to control dashboard layout, ensuring that worksheets and their associated filters only occupy space when active, resulting in a clean, professional user interface. • Parameter Controls: Creating String-based List parameters for navigation.


• Boolean Filter Logic: Writing specific calculations (e.g., [Select a View] = 'ee hours') to serve as "Show/Hide" triggers.


• Vertical Containers: Organizing worksheets and controls within nested containers to maintain layout integrity.


• Item Hierarchy: Using the Layout pane to rename zones and map Boolean fields to the "Control visibility using value" setting.		 14 14.15
s1109 Accidental Analyst Analyze a dataset containing product sales, profit, and distribution costs to derive business insights using multiple worksheets and comparison dashboards. A product count analysis identifies top-selling items through descending sorts on Tableau-generated count fields. Color-coded bars and sheet renaming conventions help differentiate between various metrics like sales volume and product count. The sheet name field is utilized to automatically update chart titles for streamlined organization. Perform exploratory data analysis using count and sales metrics, apply context-sensitive sorting to identify top-performing products, and organize multiple worksheets via color-coding and dynamic sheet naming. Analyzing Product Count, Sorting by Field, Formatting the View with Color Tiles, Renaming Worksheets for Dynamic Titles, and Analyzing Sales Volume. 5 5.6
s1110 Top 3 Conditional Sets Create a dynamic Conditional Set to automatically identify and visually distinguish top-performing data segments within a dashboard. A dynamic "In/Out" bucket evaluates every record to isolate the top three members based on sum of sales. Custom aliases rename Boolean headers into descriptive labels like "Top 3" for improved user-friendliness. The set is applied to the Color tile to highlight top performers automatically as data values shift without requiring manual updates. Construct dynamic sets using the Top tab criteria, manage set membership visibility through aliases and pill toggles, and implement set-driven color coding for automated highlighting. Building the Conditional Set, Visualizing In/Out Membership, Driving Visuals with Sets, and Automation. 3 3.6.3.2
s1111 Create a Set Define and implement Sets in Tableau to create dynamic, binary "In/Out" groupings for targeted data analysis. Sets are established as custom fields that separate data into two categories: members that meet a specific condition ("In") and those that do not ("Out"). They can be created statically from a selection of marks or dynamically based on conditions such as "Top 10" or "Sales > $5,000". Construct dynamic Sets to isolate specific data segments, differentiate between static and conditional Set logic, and utilize the "In/Out" functionality to drive visual encodings like color or size. Creating Dynamic and Static Sets, Implementing "In/Out" Logic, and Conditional Data Partitioning.
s1112 Filters Teamwork Makes the Dream Work Troubleshoot clashing filters by implementing Context Filters to ensure data adheres to the correct logical hierarchy when combining Top N and dimensional categories. Standard dimension filters are promoted to Context to force them to run earlier in the Tableau pipeline. A gray visual cue on the filter shelf indicates the promoted status of the field. Verification is performed by comparing "Before Context" and "After Context" views side-by-side to confirm the calculation logic. Identify filter clashes between Top N and independent dimension filters , recognize where filters sit within the Tableau Order of Operations , and implement Context Filters to solve intersection conflicts Identifying Filter Clashes, Understanding the Order of Operations, Implementing Context Filters, and Verification and Best Practices. 8 8.5.5.1 169
s1115 Replace Data Source Swap an existing data source for a new one while maintaining dashboard functionality through pre-replacement auditing and field metadata verification. A pre-replacement audit involves unhiding all worksheets to monitor for red error marks across broken fields or calculations. The metadata table compares local field names against remote source names to verify data type consistency for strings and numbers. The Replace Data Source feature facilitates the transition between two active connections within the workbook. Execute data source replacements without losing dashboard formatting, identify common errors in calculated fields and parameters, and reconcile field name discrepancies using the metadata tab. Pre-Replacement Audit and Calculation Review, Data Source Metadata Comparison, Remote versus Local Name Verification, and Executing the Data Source Replacement. 2 2.6
s1116 Minimalist Clean up a complex chart by using table calculations and Level of Detail (LOD) expressions to calculate a weighted percent of goal for employees. An EXCLUDE LOD expression calculates total employee hours by removing the task dimension from the aggregation. A running sum table calculation determines the weighted percent of goal, with the compute direction set to "Pane (Down)" to isolate calculations per employee. The LAST() function is implemented as a filter to hide intermediate rows and display only the final calculated value for each partition. Construct EXCLUDE LOD expressions to aggregate data at higher levels of detail, apply table calculations to create running totals across specific panes, and utilize index-based filtering to streamline "messy" visualizations into minimalist summaries. Productivity Per Hour Calculation, Percent of Goal Logic, Employee Total Hours LOD, Running Sum Weighted Percent of Goal, and Partition-Based Filtering with LAST. 10, 11 10, 11.4
s1117 Multiple Data Source Connect to multiple data sources Successfully relate multiple tables without creating data duplication or loss of granularity. 1. Logical Layer Mapping: Connect to the primary data source and drag the secondary table to the Canvas to create a Relationship (the "Noodle").
2. Cardinality Selection: Define the relationship as Many-to-Many or One-to-Many based on the primary key.
3. Referential Integrity: Set "Some Records Match" or "All Records Match" to optimize query performance.
4. Verification: Build a simple crosstab using fields from both sources to ensure the Aggregation remains correct across the relationship.		 4, 5 4.7, 5.5.3
s1118 Storytelling Turn a standard report into a compelling narrative by using specific structures and annotations to provide context for impactful decision-making Critical "Need to Know" information is placed at the very top of the view to capture audience attention. Annotations are added to the dashboard to highlight and explain the "Why" behind specific data spikes. Dynamic titles are used to change and guide how a user perceives a simple bar chart. Combine the five "heavy lifting" features of Tableau to solve a multi-dimensional business problem. 1. Parameter Creation: Define a "Metric Picker" parameter (e.g., Sales, Profit, Quantity).
2. Calculated Field Logic: Write a CASE statement to link the Parameter to the actual data fields.
3. LOD Implementation: Create a FIXED expression to calculate a baseline (e.g., Regional Average) that ignores local filters.
4. Action Configuration: Set up a Change Parameter Action on the dashboard to allow the user to toggle views by clicking a mark.
5. Context Filtering: Add a filter "To Context" to ensure it executes before the Fixed LOD.		 6
s1119 Apply Filters Button Configure dashboard filters to update multiple worksheets simultaneously, ensuring data consistency and an interactive user experience. The "Apply to Worksheets" menu allows a single filter selection to control multiple relevant views at once. Users can choose "Selected Worksheets" for targeted control or "All Using This Data Source" for a universal filter application. Cross-data source filtering is supported when worksheets share a common field, providing seamless interactivity across different datasets. Improve dashboard performance and user experience by controlling when filters execute. • Parameter Setup: Create a "Boolean" or "String" parameter to act as the toggle state for the filter.
• Filter Logic: Write a calculation that only evaluates to TRUE when the "Apply" button is triggered.
• Action Configuration: Set up a Parameter Action on the dashboard that passes the value from the button worksheet to the main dashboard.
• Reset Logic: Create a secondary "Reset" worksheet that clears the parameter values back to their default state.		 15.1.2
s1121 Dates Implement advanced date-driven logic using parameters, table calculations, and LOD expressions to provide granular control over time-series data. A string parameter paired with a DATETRUNC calculation allows users to toggle visualization granularity between Day, Week, Month, Quarter, and Year. DATEDIFF functions calculate event durations for Gantt and Waterfall charts, while Lookup Filters using the LAST() function hide historical data without removing it from Year-over-Year calculations. Fixed LOD expressions anchor views to the most recent data, ensuring dashboards update automatically as new records are added. Build interactive time-series dashboards that allow for flexible period-over-period analysis. • Relative Date Filters: Configure a filter that defaults to "Last 3 Months" or "Year to Date" automatically.
• Custom Date Formatting: Create a calculated field to display dates as "FY-26 Q1" to match corporate fiscal standards.
• Gantt Bar Implementation: Use a Start Date and a Duration (Size) to build a project timeline or process flow.
• DATEDIFF Logic: Calculate the lead time between two date timestamps (e.g., Order Date vs. Ship Date).		 13
s1123 Float Field Freedom Recreate complex Excel-style reporting by converting float values into string tokens and using placeholder axes for precise visual positioning. String manipulation functions like STR(), SPLIT(), and MID() isolate number segments to perform custom rounding and precision formatting. Placeholder calculations on the Columns shelf create a fixed axis used to manually "nudge" RAG (Red-Amber-Green) shapes next to text values. Transparent shapes are implemented for non-target records to maintain a clean, minimalist layout, while string concatenation adds custom suffixes like percentage symbols and commas. Parse float values into string tokens for disparate formatting, implement nested rounding logic using IF/THEN statements, and utilize placeholder fields to control the visual positioning of shapes and labels. Parsing Float Values into String Tokens, Implementing Nested Rounding Logic, Visual Positioning with Placeholder Fields, and Recreating Complex Excel Formats. 12
s1124 Calculate With Confidence-Testing Implement a structured testing framework using dedicated "Check" worksheets to validate the accuracy of complex nested string calculations and float conversions. Dedicated testing environments are created using a "Check" prefix to isolate and verify individual logic branches. Side-by-side text tables compare raw float values against calculated string fields to audit rendering accuracy for percentages and null states. Specific CASE and IFNULL statements are implemented to address the "Zero-to-Null" bug, ensuring that float values of zero do not vanish during string conversion. Build dedicated validation worksheets to audit calculation logic, identify and fix common float-to-string conversion errors, and implement robust null-handling strategies for professional dashboard reporting. Creating a Dedicated Testing Environment, Validating Float-to-String Conversions, Advanced Null and Zero-State Handling, and Verification of Logic Branches.
s1192 Reverse Engineer Tableau Charts Download and deconstruct professional workbooks from Tableau Public to master advanced visualization techniques like collapsible menus and multi-layered marks cards. Hidden worksheets are revealed using the "Unhide All Sheets" command to expose the underlying dimensions and measures driving dashboard objects. The "subtraction method"—dragging fields off shelves and undoing the action—identifies the exact purpose of specific pills. Mark layering is analyzed by clicking through individual continuous fields on the Columns shelf to see how shapes, lines, and labels are assigned. Reverse engineering extends to window functions and axis placeholders that anchor visual elements and control line lengths. Extract source workbooks from Tableau Public, uncover hidden worksheet logic to identify data structures, and deconstruct complex marks cards and table calculations using the subtraction method. Accessing and Extracting Public Workbooks, Uncovering Hidden Worksheet Logic, Deconstructing the Marks Card and Calculations, and Analyzing Custom Table Calculations and Parameters.
s1194 Flocking Flamingos
s1195 KPI Dashboards Create a Tableau KPI Dashboard with four different worksheets. We’ll build a logic-driven view that tracks your Current Month performance, calculates a rolling 3-Month Average, and provides a direct Month-over-Month (MoM) Comparison. Tableau Calculated Fields (Date & Logical functions).

Table Calculations (Moving Average & % Difference).

Dashboard Containers and Layout formatting.

Dynamic Worksheet Titles and Tooltips.		 Construct a four-worksheet KPI dashboard for executive tracking.

Calculate Current Month (CM) vs. Prior Month performance.

Establish a 3-month rolling average to identify trends.

Master Month-over-Month (MoM) comparison logic.		 Logic-driven time-series calculations.

Rolling window aggregations and offsets.

Period-over-period mathematical validation.

Dynamic date filtering and logic.		 14 14.23 347
s1196 Tableau Workspace Day 1 Navigate the Tableau workspace to orient new developers with the primary control zones and foundational drag-and-drop architecture. The Data Pane organizes dimensions and measures on the left, while the Rows and Columns shelves serve as structural anchors for data. The Marks Card acts as the engine room for defining visual encodings such as Color, Size, Label, and Detail. The Show Me tab in the top right provides a rapid prototyping menu for various chart types based on field selections. Achieve "Tool Fluency" by identifying and utilizing the primary functional zones of the interface. • Data Source Connection: Connect to a local file/server and distinguish between the Physical and Logical layers.
• Shelf Mapping: Correctly place fields on Rows, Columns, and Pages to generate a basic visualization.
• The Marks Card: Utilize Color, Size, and Detail to add depth and dimensionality to a mark.
• Analytics Pane: Drag and drop Trend Lines or Reference Lines onto an existing view to add statistical context.
s1197 Blue vs Green Day 2 Master the fundamental distinction between Discrete and Continuous fields to control how Tableau renders categorical headers versus quantitative axes. The Data Pane is divided into Dimensions (qualitative) and Measures (quantitative). Blue fields (Discrete) generate distinct headers for individual members, while Green fields (Continuous) create a quantitative range or axis. Custom fields like Groups, Sets, and Bins provide advanced categorization, and Parameters allow for global interactivity. Tooltips are customized to display metadata or embedded charts without cluttering the primary visualization. Master the mathematical and visual differences between Discrete and Continuous data. • Pill Identification: Identify how Blue (Discrete) pills create headers and Green (Continuous) pills create axes.
• Data Type Conversion: Manually switch a field from a Dimension to a Measure to observe the change in aggregation.
• Date Granularity: Toggle between Date Parts (Discrete) and Date Values (Continuous) to change how time is visualized.
• Visual Logic Test: Build a "Highlight Table" vs. a "Heat Map" to demonstrate the difference in pill placement.		 3
s1198 Fun Fab Five Day 3 Transition from raw data exploration to polished reporting by implementing advanced sorting, grouping, and Level of Detail (LOD) expressions. ulti-layered sorting options include computed sorts by specific measures and manual drag-and-drop for custom business sequences. The "Paperclip" tool allows for the creation of ad-hoc groups directly from marks in the view. Level of Detail (LOD) expressions use the FIXED syntax to calculate values at a specific grain, such as average sales per customer, independent of dashboard filters. Common aggregation errors are resolved by wrapping non-aggregates in ATTR() or MAX() functions. Organize cluttered visualizations using one-click and computed sorting, manage data relationships using the grouping tool, and construct FIXED LOD expressions to maintain calculation accuracy across various grains of detail. Refining the View (Sorting & Filtering), Data Grouping and Aggregation, and Level of Detail (LOD) Expressions. 8, 9, 10, 11, 15
s1199 Label Secrets, Titles (renumbered this) Master the use of labels and headings in Tableau to provide essential context and create professional, clear visualizations. termediate.
•  Primary Features: The Text tile on the Marks card allows for deep customization of labels, including color matching to data marks and the insertion of multiple fields like Price and Sales. Custom "friendly" column names are created by dragging calculated text fields to the Columns shelf and hiding original technical labels. Advanced layout settings move innermost headings to the top of the view, while annotations and fixed axis ranges ensure consistent scaling and clear insight call-outs.		 Edit and format labels using the Text tile to match mark colors, implement calculated fields to replace default technical headers with custom names, and configure advanced table layouts to reposition headings and align date tick marks. Editing Labels via the Text Tile, Formatting for Visual Elegance, Creating Custom Field Labels, Aligning and Centering Date Headings, and Advanced Layout and Annotations 13
s1201 Histograms In this two-part series, we walk through the hands-on process of building four distinct Tableau histograms. Once the technical work is done, we leverage AI to tell the story, using Google Gemini to help interpret the distributions and uncover the "why" behind the data. 1. Tableau Desktop: Bins & Measure Aggregation. 2. Google Gemini: AI Narrative Synthesis. 1. Understand the relationship between data bins and frequency distributions.  2. Apply generative AI to translate statistical charts into business narratives. 3. Differentiate between varying distribution types (Skewed vs. Normal). 1. Histogram Construction & Bin Logic 2.Prompt Engineering for Data Analysis 7 7.2.2.2 119
s1202 Explore Tableau Formatting Tableau Formatting Pane (Font, Alignment, Shading, Borders).

Custom Number Formats (Currency, Percentages, Decimals).

Workbook-level Theme Settings.

Axis and Header Customization Tools.		 Master the hierarchy of Tableau formatting from Workbook to Cell level.

Differentiate between headers, labels, and axes for visual clarity.

Use shading, banding, and borders to improve dashboard readability.

Apply custom number formatting to align with business standards.		 Global vs. Local formatting inheritance.

Gridline and border management for "clean" design.

Strategic use of color, text hierarchy, and whitespace.

Mechanics of the Tableau Formatting Pane.		 13
s1085 Drill Down with Set Actions 15 15.1.8
s1098 Data Update Date 9, 15 9.10, 15.4.2
Dual-Axes Charts 6 6.2 103
A Small Multiples View 6 6.4 105
Histogram Charts 7 7.2.2.2 119
Bullet Graph 7 7.2.6.1 127
Sparkline 7 7.2.3.1 121
Gantt Bar Charts 7 7.2.6 126
Dumbbell Chart 7 7.2.8.1 134
Halo 7 7.3.4.1 141
Call Attention to the Difference With Color 7 7.3.16 145
Bullet Graph With Reference Line & Distribution Band 7 7.8.3 153
Why Use a Context Filter 8 8.5.5.1 166
Add Date Parts to Titles 9 9.6.1 198
Avoid 'All' in a Date Title 9 9.11 208
Date Parameter in Axis Label 9 9.13 208
Click Data Points to Sort with a Set 8 8.13 175
Hover to Choose a Field for Sorting 8 8.14 181
Sorting Segments Within a Stacked Bar 8 8.15 187
Sort by Rank Alternative 8 8.16 188
Sort by Ranking Alternative 11 11.10.5.1 236
Worksheet for Date Title 9 9.6.2 199
Pareto Chart With Running Total Percent of Total Table Calc 10 10.2.1 210
Slope Chart Rank Table Calculation 10 10.4.3 215
A Heading for Text Tile Field 13 13.4.2 295
Validate and Test 11 11.7 230
Fixed LoD Example 11 11.13.2 241
s1047 Weighted Average with Fixed LoD 11 11.14 250
Borders, Default: Cell 12 12.6.1 266
Borders, Row Divider 12 12.6.2 266
Lines, Horizontal Grid Lines 12 12.7.3 270
Axis Rulers 12 12.7.4 271
Number Format: Percentage 12 12.11.5 277
Arrows Comparing Two Values 12 12.21 287
s1070 Highlight Table-Mark Labels 13 13.1.7.1 292
KPI Dashboard Template 14 14.4.5 307
s1071 Horizontal Radial Buttons to Change Filters 14 14.16 323
s1072 Horizontal Radial Buttons to Switch Sheets 14.17 328
s1045 A Floating Container for Filters 14 14.18 333
s1044 A Reset All Filters Button 14 14.19 339
s1049 A Floating Dashboard Container 14 14.2 343
s1001 Tree Map Chart 14 14.21 347
KPIs and BANs (Big Numbers) 14 14.23 347
Go to Sheet Action With a Tooltip 15 15.1.5 358
s1085 Drill Down with a Set Action 15 15.1.8 359
Open Other Worksheet from within a Tooltip 15 15.2.7 363
s1058 Switch between Measures with Parameters 15 15.5 369
s1059 Switch between Aggregation: Sum and % 15 15.6 371