Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Tableau Interface

Explore the Tableau user interface and understand its important components. Learn how to use the Data Pane, Analytics Pane, Rows, Columns, Marks Card, Filters, Pages, Worksheets, Dashboards, and Stories to build interactive visualizations.

1. Introduction to Tableau Interface

The Tableau interface is the working environment where users connect to data, explore information, create visualizations, and build interactive dashboards. It provides different panels, shelves, cards, menus, and toolbars to make data analysis easier.

When you open Tableau Desktop and create or open a workbook, you can access the worksheet environment. This is where you drag fields, configure visualizations, apply filters, and analyze your data.

Main Components of Tableau Interface

  • Menu Bar
  • Toolbar
  • Data Pane
  • Analytics Pane
  • Rows Shelf
  • Columns Shelf
  • Pages Shelf
  • Filters Shelf
  • Marks Card
  • View or Visualization Area
  • Sheet Tabs and Status Bar

2. Overview of Tableau Workspace

The Tableau workspace is divided into several functional areas. Each area has a specific responsibility in the visualization process. Understanding these areas makes it easier to create charts and dashboards.

Tableau File Data Worksheet Dashboard Story Analysis Toolbar: Save | Undo | Redo | Sort | Swap | Show Me Data Pane Tables Sales Customer Dimensions Region Category Measures Sales Profit Columns Shelf Drop fields here Rows Shelf Drop fields here Marks Card Color Size Label Detail / Tooltip Visualization Area Sheet 1 | Sheet 2 | Dashboard 1

Figure 1: Conceptual overview of the Tableau worksheet workspace.

3. Menu Bar

The Menu Bar is located at the top of the Tableau application. It provides access to commands and options for managing workbooks, data, worksheets, dashboards, analysis, and application settings.

Menu Purpose
File Create, open, save, export, and close workbooks.
Data Connect to data sources and manage data connections.
Worksheet Manage worksheet operations and visualization settings.
Dashboard Create and manage dashboards.
Story Create and organize story points.
Analysis Access analytical options such as totals, calculations, and aggregations.
Map Access geographic visualization options.
Format Control formatting of worksheets and visual elements.
Server Access publishing and server-related options where supported.
Window / Help Manage application windows and access help resources.
Tip: Menu availability can vary depending on the active worksheet, product, and Tableau version.

4. Toolbar

The Toolbar provides quick access to frequently used commands. Instead of navigating through multiple menus, users can use toolbar controls to perform common actions.

Common Toolbar Operations

  • Save: Save changes made to a workbook.
  • Undo: Reverse the previous supported action.
  • Redo: Restore an action that was undone.
  • Sort: Arrange data in ascending or descending order.
  • Swap Rows and Columns: Exchange the fields placed on the Rows and Columns shelves.
  • Fit View: Adjust how a visualization appears in the available workspace.
  • Show Me: Explore visualization types suitable for selected fields.

5. Data Pane

The Data Pane displays fields available from the connected data source. Users can drag these fields into the Rows, Columns, Filters, Pages, and Marks areas to build visualizations.

Tableau commonly organizes fields into two important categories: Dimensions and Measures.

Dimensions

Dimensions are fields used to categorize, group, or describe data. They often contain text, dates, geographical values, and other descriptive attributes.

Examples: Customer Name, Region, Category, Order Date.

Measures

Measures are fields that can generally be aggregated or calculated. They commonly contain numeric values used for analysis.

Examples: Sales, Profit, Quantity, Discount.

Dimensions Measures
Region Sales
Product Category Profit
Customer Name Quantity
Order Date Discount
Real-world example: Suppose a retail company wants to analyze sales by region. Region can be used as a Dimension, while Sales can be used as a Measure.

6. Analytics Pane

The Analytics Pane provides analytical objects that can be added to a visualization. It helps users perform deeper analysis without manually creating every analytical element.

Common Analytics Objects

  • Average Line: Displays an average reference line.
  • Median: Shows a median reference value.
  • Constant Line: Adds a fixed reference value.
  • Trend Line: Helps identify patterns or trends.
  • Reference Band: Highlights a range of values.
  • Distribution Band: Helps understand data distribution.
  • Forecast: Estimates future values when supported by the data and view.
Example: A sales manager can add an average line to a monthly sales chart to compare individual months against the overall average sales value.

7. Rows and Columns Shelves

Rows and Columns are important shelves in a Tableau worksheet. They determine how fields are arranged in the visualization. Dragging fields to these shelves helps create different chart structures.

Rows Shelf

The Rows Shelf determines how fields are placed along the vertical direction of a visualization.

Columns Shelf

The Columns Shelf determines how fields are placed along the horizontal direction of a visualization.

Columns Shelf Sales Rows Shelf Region Tableau uses these fields to construct the view

Figure 2: Example of placing Sales on Columns and Region on Rows.

Example

If you place Region on the Rows Shelf and Sales on the Columns Shelf, Tableau can create a sales comparison visualization across different regions.

8. Marks Card

The Marks Card controls how data marks appear in a visualization. It allows users to change the visual representation of data through color, size, label, detail, and tooltip settings.

Marks Option Purpose Example
Color Changes the color of marks based on selected fields. Different colors for product categories.
Size Controls the size of marks. Large circles for higher sales.
Label Displays text labels on marks. Show sales values on bars.
Detail Adds more data granularity to the view. Break down sales by customer.
Tooltip Controls information shown when users hover over marks. Display sales and profit on hover.
Shape Changes the shape of marks when supported by the mark type. Different symbols for categories.
Marks Card Color Size Label Detail Tooltip Configure Customize

Figure 3: Important controls available in the Marks Card.

9. Filters Shelf

The Filters Shelf is used to limit the data displayed in a visualization. It allows users to focus on specific categories, regions, dates, or numeric ranges.

Types of Filtering Examples

  • Region Filter: Display only selected regions.
  • Category Filter: Display only selected product categories.
  • Date Filter: Display records from a selected time period.
  • Sales Filter: Focus on records within a numeric range.

Practical Example

Imagine a retail business with sales records from four regions: North, South, East, and West. If a manager wants to analyze only the North region, they can add Region to the Filters Shelf and select North.

Tip: Filters help simplify complex datasets and make visualizations more relevant to the user's analysis requirements.

10. Pages Shelf

The Pages Shelf allows users to break a visualization into separate pages based on a selected field. It can be used to examine how data changes across categories or time periods.

For example, placing Year on the Pages Shelf can allow users to view the visualization one year at a time.

Example: Year-wise Sales Analysis

  1. Connect a sales dataset.
  2. Create a sales visualization.
  3. Drag the Year field to the Pages Shelf.
  4. Use the page controls to move between available years.
  5. Compare the visualization across different years.

11. Worksheets, Dashboards, and Stories

Tableau provides three important workbook structures: Worksheets, Dashboards, and Stories. Each serves a different purpose in the data visualization process.

Worksheet

A Worksheet is where an individual visualization is created. Users can drag fields, choose chart types, apply filters, and format the view.

Example: Monthly Sales Bar Chart.

Dashboard

A Dashboard combines multiple worksheets and other supported objects into a single interactive view. It helps users monitor multiple business metrics together.

Example: Sales Dashboard with revenue, profit, and regional performance.

Story

A Story is a sequence of story points used to communicate findings in a logical order. Each story point can contain a worksheet or dashboard view.

Example: A presentation explaining sales trends, regional performance, and business recommendations.

Worksheets Individual charts Dashboard Combined views Story Sequential insights Build individual views, combine them, and communicate findings.

Figure 4: Relationship between Worksheets, Dashboards, and Stories.

12. Sheet Tabs and Status Bar

Sheet Tabs appear at the bottom of the Tableau workbook. They help users navigate between worksheets, dashboards, and stories.

Sheet Tabs

  • Switch between different worksheets.
  • Open dashboards within the workbook.
  • Navigate to story points and stories.
  • Create additional sheets using the available controls.

Status Bar

The Status Bar provides contextual information about the active view, selected marks, or other workbook details. The information displayed depends on the current selection and worksheet.

13. Show Me Panel

Show Me helps users explore visualization types that can be created from the fields selected in the Data Pane. It provides chart suggestions based on the selected fields and their data types.

Common Visualization Types

  • Bar Chart
  • Line Chart
  • Area Chart
  • Scatter Plot
  • Pie Chart
  • Treemap
  • Map
  • Histogram
  • Box Plot
  • Heat Map
Example: Select Region and Sales fields in the Data Pane, then explore Show Me to find suitable visualizations for comparing sales across regions.

14. How Tableau Interface Components Work Together

Tableau interface components work together to convert raw data into meaningful visualizations. A typical workflow begins with selecting fields from the Data Pane and ends with creating a worksheet or dashboard.

Example: Create a Regional Sales Chart

  1. Connect Tableau to a sales dataset.
  2. Find Region and Sales fields in the Data Pane.
  3. Drag Region to the Rows Shelf.
  4. Drag Sales to the Columns Shelf.
  5. Use the Marks Card to configure color and labels.
  6. Use Filters to select a particular region or category.
  7. Use Show Me to explore chart types.
  8. Save the worksheet.
  9. Add the worksheet to a dashboard if required.
Best Practice: Start with a clear business question before selecting a chart. The visualization should make the answer easy to understand.

15. Practice Questions

Basic Questions

  1. What is the Tableau interface?
  2. What is the purpose of the Data Pane?
  3. What is the difference between Dimensions and Measures?
  4. What are the Rows and Columns shelves used for?
  5. What is the purpose of the Marks Card?
  6. What is the use of the Filters Shelf?
  7. What is the purpose of the Analytics Pane?

Practical Questions

  1. Locate the Data Pane in Tableau Desktop.
  2. Identify the Rows and Columns shelves.
  3. Find the Color and Label options in the Marks Card.
  4. Locate the Show Me panel.
  5. Create a simple chart using Region and Sales.
  6. Create a filter for a product category.
  7. Identify the worksheet and dashboard tabs.

Interview Questions

  1. Explain the major components of Tableau interface.
  2. What is the difference between Data Pane and Analytics Pane?
  3. Explain the purpose of the Marks Card.
  4. What is the difference between a Worksheet and Dashboard?
  5. How does the Pages Shelf work?
  6. What is the purpose of Show Me?
  7. How do Filters help in data analysis?

16. Summary

In this lesson, we explored the Tableau user interface and understood the purpose of its major components. We learned how the Menu Bar and Toolbar provide access to application operations, while the Data Pane displays available fields for analysis.

We also explored the Analytics Pane, Rows and Columns shelves, Marks Card, Filters Shelf, Pages Shelf, and Show Me panel. These components work together to create meaningful visualizations from connected datasets.

Finally, we understood the differences between Worksheets, Dashboards, and Stories. With this knowledge, you are ready to start connecting data and building your first Tableau visualization in the upcoming lessons.