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

Building Dashboards in Tableau

Learn how to create interactive Tableau dashboards by combining worksheets, arranging dashboard objects, managing layouts, and presenting meaningful business insights in a single view.

1. What is a Tableau Dashboard?

A Tableau Dashboard is a collection of multiple worksheets and visualizations displayed together on a single screen. It helps users analyze different aspects of data without switching between individual worksheets.

Dashboards combine charts, tables, maps, filters, legends, text, images, and other objects to create a complete analytical experience.

Important: A worksheet generally focuses on one visualization, whereas a dashboard combines multiple worksheets to provide a broader view of business information.

Why are Dashboards Important?

  • Display multiple visualizations in one place.
  • Help users understand business performance quickly.
  • Allow users to interact with filters and other controls.
  • Support data-driven business decisions.
  • Present complex information in an organized format.
  • Make reports easier to understand and share.

2. Worksheet vs Dashboard vs Story

Tableau provides different working areas for creating and presenting visualizations. Understanding their differences helps determine where each component should be used.

Feature Worksheet Dashboard Story
Purpose Create an individual visualization. Combine multiple visualizations. Present a sequence of analytical insights.
Content Usually one chart or table. Multiple worksheets and objects. Worksheets and dashboards in story points.
Interaction Chart-level interaction. Filters and dashboard actions. Navigation between story points.
Use Case Analyze sales by category. Display complete sales performance. Explain sales performance trends.

3. Understanding the Tableau Dashboard Interface

Tableau provides a dedicated Dashboard workspace where users can add worksheets, objects, filters, legends, and containers.

Main Dashboard Interface Components

  • Dashboard Canvas: The main working area where dashboard content is arranged.
  • Sheets Panel: Displays available worksheets and dashboards.
  • Objects Panel: Provides objects such as text, images, web pages, and containers.
  • Size Section: Controls dashboard dimensions.
  • Layout Section: Controls positioning, spacing, and sizing of dashboard elements.
  • Device Preview: Helps review dashboard layouts for different devices.
Example: A sales dashboard can contain a sales KPI worksheet, monthly sales chart, regional map, category chart, and a date filter. These components are arranged together in the Dashboard Canvas.

4. Creating a New Dashboard

A dashboard can be created after preparing the worksheets that will be included in the final report.

Steps to Create a Dashboard

  1. Open your Tableau workbook.
  2. Create the required worksheets and visualizations.
  3. Locate the New Dashboard icon near the sheet tabs.
  4. Click the New Dashboard icon.
  5. Alternatively, select Dashboard → New Dashboard from the menu.
  6. Tableau opens a new Dashboard workspace.
  7. Drag worksheets from the Sheets panel onto the dashboard canvas.
  8. Arrange and resize the worksheets according to your requirements.
Best Practice: Prepare and name your worksheets before building the dashboard. Descriptive worksheet names make it easier to identify and manage dashboard components.

5. Understanding Dashboard Size Settings

Dashboard size determines the available space for displaying worksheets and other dashboard objects. Tableau provides different sizing options depending on the reporting requirements.

Types of Dashboard Sizing

Size Option Description When to Use
Automatic Adjusts the dashboard size according to the available viewing area. When dashboards must adapt to different screen sizes.
Fixed Size Uses a specified dashboard width and height. When a consistent layout is required.
Range Allows a minimum and maximum dashboard size. When controlled resizing is required.

How to Change Dashboard Size

  1. Open the dashboard.
  2. Locate the Size section in the Dashboard pane.
  3. Select Automatic, Fixed Size, or Range.
  4. For Fixed Size, specify the required width and height.
  5. For Range, specify minimum and maximum dimensions.
  6. Review the dashboard after changing its size.
Note: A fixed-size dashboard may require scrolling or resizing on smaller screens. Always review the dashboard on the devices where it will be used.

6. Adding Worksheets to a Dashboard

Worksheets are the primary building blocks of most Tableau dashboards. Each worksheet contains a visualization that communicates a particular aspect of the underlying data.

Steps to Add a Worksheet

  1. Open the Dashboard workspace.
  2. Locate the Sheets panel on the left side.
  3. Identify the worksheet you want to include.
  4. Drag the worksheet onto the dashboard canvas.
  5. Position the worksheet where it should appear.
  6. Repeat the process for other worksheets.
  7. Resize and arrange the visualizations.

Example Dashboard Worksheets

Worksheet Visualization Business Purpose
Total Sales KPI Text Display overall sales performance.
Monthly Sales Line Chart Analyze monthly sales trends.
Sales by Category Bar Chart Compare product categories.
Regional Sales Map Analyze geographic performance.
Top Products Text Table Identify high-performing products.

7. Tiled and Floating Layouts

Tableau provides two primary layout approaches for positioning dashboard elements: Tiled and Floating.

7.1 Tiled Layout

In a tiled layout, dashboard objects are arranged within a structured grid. Objects fit together without overlapping, and their positions influence the available space for neighboring objects.

  • Objects are arranged in a structured layout.
  • Elements share the available dashboard space.
  • Objects can be organized using containers.
  • Suitable for clean and consistent dashboard designs.

7.2 Floating Layout

Floating objects can be positioned independently on the dashboard. Their placement and dimensions can be controlled without following the same tiled arrangement.

  • Objects can overlap other dashboard elements.
  • Position and size can be controlled independently.
  • Useful for labels, images, and overlay elements.
  • Requires careful positioning to avoid visual clutter.
Tiled Layout Floating Layout Header Chart 1 Chart 2 Data Table Dashboard Canvas Main Chart Floating KPI Structured arrangement vs independently positioned objects
Figure 1: Comparison of tiled and floating dashboard layouts.
Recommendation: Use tiled layouts for the main dashboard structure and floating layouts only when independent positioning or overlapping elements are needed.

8. Working with Layout Containers

Containers help organize multiple dashboard objects into structured horizontal or vertical arrangements. They make it easier to manage spacing, alignment, and resizing.

Types of Containers

8.1 Horizontal Container

A horizontal container arranges objects from left to right. It is useful when multiple charts or KPI cards need to appear side by side.

8.2 Vertical Container

A vertical container arranges objects from top to bottom. It is useful for creating dashboard sections such as headers, charts, and tables.

Benefits of Containers

  • Maintain consistent alignment between objects.
  • Make dashboard resizing easier.
  • Help organize related visualizations.
  • Improve spacing and layout consistency.
  • Reduce manual positioning work.

Steps to Add a Container

  1. Open the Dashboard workspace.
  2. Locate the Objects section.
  3. Drag a Horizontal or Vertical container onto the canvas.
  4. Drag worksheets or other objects inside the container.
  5. Adjust the container size and spacing.
  6. Review the layout to ensure proper alignment.

9. Understanding Dashboard Objects

Dashboard objects provide additional functionality beyond worksheets. They help improve presentation, navigation, organization, and usability.

Object Purpose Example
Horizontal Container Arranges objects horizontally. Display three KPI cards in one row.
Vertical Container Arranges objects vertically. Place a title above a chart.
Text Adds headings and descriptions. Sales Performance Overview.
Image Adds images to a dashboard. Company logo.
Web Page Displays web content. Embed an appropriate web page.
Navigation Helps users navigate between views. Move to another dashboard.
Blank Adds empty space. Create spacing between charts.
Note: The availability and behavior of certain objects can depend on the Tableau version and workbook environment.

10. Adding Text and Images

Text and image objects help make dashboards easier to understand and visually consistent with business reporting standards.

Adding a Text Object

  1. Open the Dashboard workspace.
  2. Drag the Text object onto the dashboard.
  3. Enter the required heading or description.
  4. Adjust font size, font style, and alignment.
  5. Click OK to apply the changes.

Adding an Image Object

  1. Drag the Image object onto the dashboard.
  2. Select the image file from your system.
  3. Configure the image fitting options.
  4. Adjust the image dimensions and placement.
  5. Review the dashboard appearance.
Example: A company sales dashboard may include a company logo at the top, a dashboard title, a reporting period, and a short description of the displayed metrics.

11. Adding Filters and Legends

Filters allow dashboard users to focus on selected portions of the data. Legends explain the meaning of colors, sizes, and other visual encodings used in charts.

Adding a Filter

  1. Add a worksheet to the dashboard.
  2. Open the worksheet's drop-down menu.
  3. Select Filters.
  4. Choose the field that should be displayed as a filter.
  5. Position the filter on the dashboard.
  6. Configure the filter display style as required.

Types of Filter Controls

  • Single Value Dropdown
  • Single Value List
  • Multiple Values Dropdown
  • Multiple Values List
  • Slider controls for suitable numeric or date fields

Adding a Legend

  1. Add a worksheet containing color or size encoding.
  2. Open the worksheet menu on the dashboard.
  3. Enable the relevant color or size legend.
  4. Place the legend near the corresponding visualization.
Important: A filter and a legend serve different purposes. A filter changes which data is displayed, while a legend explains how visual elements represent data.

12. Applying Consistent Formatting

Dashboard formatting improves readability and helps users understand information without unnecessary visual distractions.

Important Formatting Options

  • Fonts: Use readable font styles and consistent sizes.
  • Colors: Use a consistent color palette across charts.
  • Titles: Give every visualization a meaningful title.
  • Spacing: Maintain consistent gaps between objects.
  • Borders: Use borders only when they improve separation.
  • Backgrounds: Avoid excessive background colors.
  • Alignment: Align related elements consistently.

Formatting Best Practices

Area Recommended Practice
Dashboard Title Use a clear and descriptive title.
Colors Use a limited and meaningful color palette.
Charts Choose visualizations appropriate for the data.
Spacing Keep consistent padding and spacing.
Labels Display useful labels without overcrowding.
Filters Place commonly used filters in an accessible location.

13. Creating a Sales Dashboard Layout

Consider a company that wants to monitor its sales performance using Tableau. The dashboard should display overall sales, profit, monthly performance, category performance, and regional information.

Required Dashboard Components

  • Total Sales KPI
  • Total Profit KPI
  • Monthly Sales Trend
  • Sales by Category
  • Regional Sales Map
  • Product Performance Table
  • Year and Region Filters
SALES PERFORMANCE DASHBOARD Total Sales $125K Total Profit $32K Orders 2,450 Growth +18% Monthly Sales Trend Sales by Category A B C Regional Sales Map Geographic Sales Visualization Filters Year | Region | Category
Figure 2: Example layout of a business sales performance dashboard.

Dashboard Creation Workflow

  1. Connect to the sales dataset.
  2. Create individual worksheets for KPIs and charts.
  3. Create a new dashboard.
  4. Choose an appropriate dashboard size.
  5. Add KPI worksheets to the top section.
  6. Add sales trend and category charts.
  7. Add the regional map and product table.
  8. Add filters for Year, Region, and Category.
  9. Apply consistent formatting.
  10. Review and test the final dashboard.

14. Device Layouts and Responsive Dashboards

Tableau dashboards may be viewed on desktop computers, tablets, and mobile devices. Device layouts help customize how dashboard content appears on different screen sizes.

Device Layout Types

  • Default Layout: The primary dashboard layout.
  • Desktop Layout: Optimized for larger screens.
  • Tablet Layout: Adjusted for medium-sized screens.
  • Phone Layout: Designed for smaller mobile screens.

How to Configure Device Layouts

  1. Open the dashboard.
  2. Locate the Device Preview option.
  3. Select the required device type.
  4. Review how the dashboard appears on that device.
  5. Adjust the layout and worksheet arrangement where required.
  6. Preview the dashboard again before publishing.
Best Practice: Do not assume that a desktop dashboard will automatically provide the best experience on mobile devices. Review each required device layout separately.

15. Dashboard Interactivity Overview

Dashboards can provide interactive experiences through filters, highlighting, and actions. These features allow users to explore information rather than simply viewing static charts.

Common Dashboard Interactions

  • Filter data based on selected values.
  • Highlight related marks across worksheets.
  • Use one worksheet to filter another worksheet.
  • Navigate between dashboards.
  • Explore additional information using dashboard actions.

For example, selecting a region in a regional sales visualization can help users investigate related sales information in other charts.

Example: A manager selects the West region from a dashboard filter. The related sales charts update to show information for the selected region, making regional analysis easier.

Dashboard Actions are covered in detail in the next lesson.

16. Testing and Reviewing a Dashboard

Before publishing a dashboard, review its layout, data, filters, and overall user experience. Testing helps identify presentation problems and unexpected behavior.

Dashboard Review Checklist

  • Verify that all worksheets display the correct data.
  • Check that chart titles and labels are meaningful.
  • Test all dashboard filters.
  • Review the positioning of dashboard objects.
  • Check for overlapping or hidden content.
  • Verify that legends are understandable.
  • Review desktop and mobile layouts where applicable.
  • Check dashboard performance with realistic data volumes.
Testing Tip: Ask another user to interact with the dashboard. Their feedback can reveal confusing labels, unnecessary filters, and layout problems.

17. Common Dashboard Building Problems

Problem Possible Cause Suggested Solution
Worksheet is not visible Worksheet was not added to the dashboard. Drag the required worksheet onto the dashboard canvas.
Objects overlap Floating objects are positioned incorrectly. Adjust object positions or use tiled containers.
Dashboard looks crowded Too many visualizations or objects are included. Remove unnecessary elements and simplify the layout.
Content is cut off Dashboard size does not match the viewing area. Review dashboard sizing and device layouts.
Filters do not affect expected sheets Filter scope is not configured as required. Review the filter's Apply to Worksheets settings.
Dashboard loads slowly Complex visualizations or large data volumes. Review workbook design and data performance.
Text is difficult to read Font sizes or colors are unsuitable. Improve typography, contrast, and spacing.

18. Dashboard Design Best Practices

A professional dashboard should communicate important information clearly while avoiding unnecessary complexity.

  • Start with the business questions the dashboard should answer.
  • Place important KPIs near the top of the dashboard.
  • Use suitable charts for the information being presented.
  • Keep colors consistent throughout the dashboard.
  • Group related visualizations together.
  • Use containers to maintain consistent alignment.
  • Avoid adding too many filters.
  • Use meaningful titles and descriptions.
  • Provide enough space for labels and legends.
  • Test dashboard usability and performance.
  • Review layouts for the intended devices.

19. Practical Exercise: Build a Sales Dashboard

Practice building a Tableau dashboard using a sample sales dataset. The goal is to combine multiple worksheets into one organized business reporting view.

Exercise Requirements

  1. Connect Tableau to a sales dataset.
  2. Create a worksheet for Total Sales.
  3. Create a worksheet for Total Profit.
  4. Create a monthly sales trend chart.
  5. Create a category-wise sales chart.
  6. Create a regional sales map.
  7. Create a new dashboard.
  8. Add the worksheets to the dashboard.
  9. Use containers to organize the layout.
  10. Add Year and Region filters.
  11. Apply consistent formatting.
  12. Review the final dashboard on different screen sizes.
Expected Result: A sales dashboard that displays important performance indicators, sales trends, category comparisons, regional information, and interactive filters in one place.

20. Dashboard Building Workflow

The following diagram summarizes the main stages involved in creating a Tableau dashboard, from preparing worksheets to reviewing the final dashboard.

Prepare Worksheets Create Dashboard Add Worksheets and Objects Arrange and Format Layout Test and Review Dashboard
Figure 3: End-to-end workflow for building a Tableau dashboard.

Summary

Tableau dashboards combine multiple worksheets, charts, tables, filters, legends, and other objects into a single interactive reporting interface. In this lesson, we explored dashboard creation, dashboard sizing, tiled and floating layouts, horizontal and vertical containers, dashboard objects, text and image components, filters, legends, formatting, device layouts, and dashboard testing. We also learned how to organize a sales performance dashboard using meaningful visualizations and consistent design practices. A well-designed dashboard helps users understand business performance, explore data efficiently, and make informed decisions. In the next lesson, we will learn how to make dashboards more interactive using Tableau Dashboard Actions.