Introduction to Tableau Dashboards

Topic: Introduction to Tableau Dashboards

Course: Tableau Training

Learning Objective: Understand Tableau dashboards, their components, creation process, layout options, interactivity, formatting, and practical business applications.

1. Introduction to Tableau Dashboards

A Tableau dashboard is a visual workspace that combines multiple worksheets, charts, tables, maps, KPI cards, filters, legends, and other objects into a single view. It enables users to monitor key performance indicators, compare different data perspectives, identify trends, and make informed business decisions.

Instead of opening several worksheets separately, users can view related visualizations together and interact with the data through filters, selections, and dashboard actions.

For example, a sales dashboard may display total sales, total profit, monthly sales trends, sales by category, regional performance, and a map of customer locations on one screen.

Example of a Sales Dashboard

+--------------------------------------------------+
|             SALES PERFORMANCE DASHBOARD         |
+--------------------------------------------------+
| Total Sales | Total Profit | Orders | Profit %   |
+--------------------------------------------------+
| Monthly Sales Trend     | Sales by Category      |
|                         |                        |
+--------------------------------------------------+
| Regional Sales Map      | Top Products           |
|                         |                        |
+--------------------------------------------------+
| Filters: Year | Region | Category | Segment      |
+--------------------------------------------------+

This is a conceptual layout. The actual arrangement depends on the dashboard size, business requirements, and selected worksheets.

2. Learning Objectives

• Understand the meaning and purpose of a Tableau dashboard.
• Differentiate between worksheets, dashboards, and stories.
• Identify the major components of the Tableau Dashboard workspace.
• Create a dashboard using existing worksheets.
• Arrange visualizations using tiled and floating layouts.
• Configure dashboard size, titles, legends, and filters.
• Add interactivity using filter actions and selections.
• Apply dashboard design and usability best practices.
• Build a basic business dashboard using sample sales data.

3. Why Are Tableau Dashboards Important?

Businesses collect large amounts of data from sales, finance, marketing, operations, customer service, and other departments. Dashboards transform this data into an understandable visual summary.

• Centralized reporting: Combines related charts and metrics in one place.
• Faster decision-making: Helps users identify important changes quickly.
• Performance monitoring: Displays KPIs such as revenue, profit, growth, and order count.
• Interactive analysis: Lets users explore data without creating a separate report for every question.
• Trend identification: Highlights patterns, seasonal changes, and unusual results.
• Business communication: Presents complex information in a visual format that is easier to understand.
• Consistent reporting: Provides a shared view of important business metrics.

4. Worksheet vs Dashboard vs Story

5. Main Components of a Tableau Dashboard

5.1 Worksheets

Worksheets contain individual visualizations created from a data source. A dashboard can include bar charts, line charts, maps, tables, scatter plots, and other views.

Example: A worksheet named Monthly Sales displays sales by month, while another worksheet named Profit by Category displays profit for each product category.

5.2 Dashboard Title

A title communicates the dashboard's purpose. A useful title might be "Sales Performance Overview – 2026" rather than simply "Dashboard 1".

5.3 Filters

Filters allow users to limit the displayed data according to selected criteria.

Common examples include Year, Region, Category, Customer Segment, and Order Date.

5.4 Legends

Legends explain visual encodings such as colors, shapes, and sizes. For example, a profit legend may show which colors represent positive and negative profit.

5.5 Text Objects

Text objects display explanations, subtitles, instructions, data definitions, or important observations.

5.6 Image Objects

Image objects can display company logos, icons, or supporting graphics.

5.7 Blank Objects

Blank objects create spacing between dashboard elements and help improve visual organization.

5.8 Layout Containers

Horizontal and vertical containers group objects and help manage their arrangement and resizing behavior.

5.9 Navigation Objects

Navigation buttons allow viewers to move between dashboards or sheets in a published workbook.

6. Understanding the Tableau Dashboard Workspace

When you open a new dashboard, the workspace provides controls for choosing the dashboard size, arranging sheets, adding objects, and adjusting layouts.

• Sheets pane: Lists available worksheets and dashboards that can be added to the current dashboard.
• Objects pane: Provides objects such as Text, Image, Blank, Web Page, Navigation, and layout containers.
• Dashboard canvas: The main area where visualizations and objects are placed.
• Size settings: Control the dashboard's dimensions or sizing behavior.
• Layout pane: Helps adjust selected objects' placement, padding, borders, and other layout properties.
• Device Preview: Helps inspect how a dashboard appears on different device types.

7. How to Create a Dashboard in Tableau

Step 1: Connect to a Data Source

Open Tableau Desktop or another supported Tableau authoring environment. Connect to a dataset such as Sample - Superstore, an Excel file, a text file, or a database.

Step 2: Create Worksheets

Build the individual charts that will be used in the dashboard.

• Worksheet 1: Sales by Month.
• Worksheet 2: Sales by Category.
• Worksheet 3: Profit by Region.
• Worksheet 4: Orders by Segment.

Give each worksheet a clear, descriptive name.

Step 3: Create a New Dashboard

1. Locate the New Dashboard icon near the sheet tabs at the bottom of the workbook, or use the Dashboard menu.
2. Select the new dashboard.
3. Rename it to something meaningful, such as Sales Overview.

Step 4: Choose the Dashboard Size

In the Dashboard pane, select an appropriate size option. Depending on the Tableau version, options may include Automatic, a preset size, or a custom size.

Choose a size based on where the dashboard will be viewed. A desktop report may need more horizontal space, while a phone layout requires a more compact arrangement.

Step 5: Add Worksheets

1. Find the required worksheets in the Sheets pane.
2. Drag a worksheet onto the dashboard canvas.
3. Repeat the process for other worksheets.
4. Arrange the views to establish a clear visual hierarchy.

Step 6: Add Filters

1. Select a worksheet on the dashboard.
2. Open its drop-down menu.
3. Choose a field filter to display, where available, or configure the filter on the worksheet first.
4. Position the filter where users can find it easily.
5. Configure which relevant worksheets should respond to the filter.

Step 7: Add Titles and Supporting Objects

Add a clear title and optional text, logo, legends, and spacing objects. Remove objects that do not contribute to the dashboard's purpose.

Step 8: Format and Arrange the Dashboard

Adjust chart sizes, fonts, colors, padding, borders, and alignment. Check that titles, legends, and labels remain readable.

Step 9: Add Interactivity

Enable Use as Filter for a suitable worksheet or configure dashboard actions. For example, clicking a region in a bar chart can filter a sales trend chart to that region.

Step 10: Test and Save

Test all filters, selections, tooltips, and navigation. Check the dashboard for clipped labels, excessive scrolling, and inconsistent formatting. Save the workbook when the dashboard works as expected.

Tableau's official dashboard documentation describes the process of creating a dashboard, adding sheets, configuring objects, and enabling interactivity: Create a Dashboard – Tableau Help.

8. Understanding Tiled and Floating Layouts

8.1 Tiled Layout

In a tiled layout, dashboard items are arranged within a structured layout. Objects share available space and generally adjust according to the surrounding objects and containers.

Advantages:

• Helps maintain an organized layout.
• Makes alignment easier.
• Works well for dashboards with multiple charts.
• Supports structured resizing through layout containers.

Example: KPI cards appear across the top, with a line chart and a bar chart arranged underneath.

8.2 Floating Layout

Floating objects can be positioned and sized independently, allowing them to overlap other objects or occupy specific locations on the dashboard.

Advantages:

• Provides precise positioning.
• Supports overlays and custom visual arrangements.
• Can be useful for buttons, labels, and carefully positioned filters.

Limitations: Floating objects may overlap or become difficult to use when the dashboard is resized. They require careful testing.

8.3 Comparison

9. Understanding Dashboard Size

Dashboard sizing affects how charts, text, and filters fit on a screen.

• Automatic: Allows the dashboard to adapt to the available display area, depending on the viewing environment.
• Fixed size: Uses defined dimensions to create a consistent canvas.
• Range: Allows the dashboard to resize within specified minimum and maximum dimensions where supported.

Best practice: Choose the size based on the intended display environment. Preview the dashboard at realistic screen sizes before publishing.

10. Adding and Managing Filters

Filters help users focus on specific parts of a dataset. For example, a Sales dashboard may provide a Year filter and a Region filter.

Common Filter Types

Applying a Filter Across Multiple Worksheets

1. Add the relevant filter to a worksheet.
2. Display the filter on the dashboard.
3. Open the filter menu.
4. Choose the option to apply the filter to the appropriate worksheets, such as selected worksheets or all worksheets using the related data source, depending on the available choices.
5. Test the filter to ensure all intended views update correctly.

Not every worksheet must use every filter. Check data-source relationships, field compatibility, and the selected filter scope when results do not match expectations.

11. Dashboard Interactivity

Interactive dashboards allow users to explore data by selecting marks, changing filters, viewing tooltips, or navigating to related content.

11.1 Use as Filter

The Use as Filter option turns a worksheet into a control for filtering other dashboard views.

Example: Selecting the Furniture bar filters the sales trend chart and product table to show Furniture-related data.

11.2 Filter Actions

A filter action passes a selection from a source view to one or more target views.

Example: Selecting Maharashtra on a map filters the sales and profit charts to the selected state, provided the required geographic data and action configuration are available.

11.3 Highlight Actions

Highlight actions emphasize related marks while leaving other marks visible for comparison.

Example: Highlight a product category across a bar chart and a line chart to compare its performance.

11.4 URL Actions

URL actions can open a relevant web address based on a user interaction, subject to the workbook configuration and security settings.

11.5 Navigation Actions and Buttons

Navigation objects help users move between dashboards or worksheets. They are useful when a workbook contains an overview dashboard and several detailed analysis dashboards.

11.6 Tooltips

Tooltips show additional details when a user hovers over a mark. Useful tooltip fields may include sales, profit, order count, customer name, and date.

For more details about dashboard actions, see Tableau Actions and Dashboards.

12. Dashboard Objects and Their Uses

13. Formatting and Designing a Professional Dashboard

13.1 Use a Clear Visual Hierarchy

Place the most important information where users can find it quickly. Commonly, a dashboard starts with its title and KPI cards, followed by trend charts and more detailed breakdowns.

13.2 Use Consistent Colors

Use a consistent color scheme across related charts. For example, keep the same color for the same product category whenever possible. Use color intentionally to distinguish categories or highlight meaningful conditions.

13.3 Choose Readable Fonts

Use readable titles, labels, and tooltips. Avoid excessive font styles or very small text.

13.4 Avoid Clutter

Remove unnecessary gridlines, redundant legends, excessive labels, decorative objects, and unrelated charts.

13.5 Align Objects

Use containers, padding, and consistent spacing to make the dashboard look organized.

13.6 Provide Context

Use meaningful titles, units, date ranges, and explanatory notes. A KPI showing 25,000 is less informative if users cannot tell whether it represents revenue, orders, or customers.

13.7 Design for the Audience

Executives may need a concise summary of KPIs and trends. Analysts may need detailed breakdowns, more filters, and interactive exploration.

14. Practical Example: Sales Performance Dashboard

Scenario: A retail company wants to monitor sales, profit, orders, product categories, and regional performance.

Sample Dataset

Note: This is a small illustrative dataset for learning. It is not a complete business dataset, and the figures are examples rather than real company results.

14.1 Create KPI Worksheets

Create separate worksheets for Total Sales, Total Profit, and Total Quantity or Order Count. Use the appropriate aggregation for each metric.

For example, if each row represents an individual order line, use COUNTD(Order ID) for distinct orders rather than assuming the number of rows equals the number of orders.

14.2 Create a Monthly Sales Trend

1. Open a new worksheet and name it Monthly Sales Trend.
2. Place Order Date on Columns and choose a suitable month-level date representation.
3. Place Sales on Rows and use SUM aggregation.
4. Choose a line chart.
5. Format the title, date axis, and sales values.

14.3 Create Sales by Category

1. Open another worksheet.
2. Place Category on Rows.
3. Place Sales on Columns.
4. Use a bar chart.
5. Sort categories by sales if useful.

14.4 Create Profit by Region

1. Create a worksheet named Profit by Region.
2. Place Region on Rows.
3. Place Profit on Columns.
4. Use a bar chart and apply a meaningful color encoding.
5. Check negative profit values carefully so they are not mistaken for positive results.

14.5 Assemble the Dashboard

1. Create a new dashboard and name it Sales Performance Dashboard.
2. Choose an appropriate dashboard size.
3. Place KPI worksheets at the top.
4. Arrange Monthly Sales Trend and Sales by Category in the middle.
5. Place Profit by Region in a lower section or side panel.
6. Add Year, Region, and Category filters if needed.
7. Enable Use as Filter on an appropriate chart to connect the views.
8. Test every interaction and save the workbook.

15. Basic Tableau Calculations for Dashboard KPIs

Calculated fields can provide reusable metrics for dashboard cards, charts, and tooltips.

15.1 Total Sales

SUM([Sales])

Returns the sum of sales in the current view and filter context.

15.2 Total Profit

SUM([Profit])

15.3 Profit Ratio

IF SUM([Sales]) != 0 THEN
    SUM([Profit]) / SUM([Sales])
END

Format this calculated field as a percentage. The calculation returns a ratio based on aggregated profit and sales.

15.4 Average Sales per Order

SUM([Sales]) / COUNTD([Order ID])

Use this only when Order ID is available and the metric is intended to represent sales per distinct order. Confirm that the dataset's order structure supports the calculation.

15.5 Sales Target Status

If the dataset contains a numeric field named Sales Target, a basic comparison can be created using an appropriate aggregation:

IF SUM([Sales]) >= SUM([Sales Target]) THEN
    "Target Achieved"
ELSE
    "Below Target"
END

Ensure that the target is not duplicated across multiple transaction rows; otherwise, summing it may inflate the target. Depending on the data model, a separate target table or an appropriate level-of-detail calculation may be required.

16. Common Dashboard Problems and Solutions

17. Dashboard Performance Optimization

• Use only the visualizations needed to answer the intended business questions.
• Reduce unnecessary high-cardinality detail and excessive marks.
• Review complex calculations and repeated logic.
• Use efficient data-source designs and appropriate extracts where suitable.
• Limit the number of filters and actions when they do not add analytical value.
• Test performance with realistic data volumes.
• Check dashboard load time after adding each major component.
• Ensure that tooltips and actions do not trigger unnecessary complex processing.

18. Publishing and Sharing Dashboards

After building and testing a dashboard, you can share it with other users through supported Tableau publishing environments.

1. Save the workbook.
2. Check that the required data sources and permissions are configured.
3. Publish the workbook to a supported environment, such as Tableau Cloud or Tableau Server, when available to you.
4. Set suitable permissions for intended viewers.
5. Verify that filters, actions, and data connections work after publishing.
6. Check any required device layouts and export options.

Publishing options, licensing, permissions, and available features depend on the Tableau product and environment being used.

19. Best Practices for Tableau Dashboards

• Start with a clear business question and intended audience.
• Choose KPIs that support the main objective.
• Place the most important information prominently.
• Use appropriate chart types for the data and analytical question.
• Keep colors, fonts, number formats, and labels consistent.
• Use descriptive titles and meaningful units.
• Make filters easy to discover and understand.
• Use dashboard actions only when they improve analysis.
• Avoid overcrowding the canvas with too many visualizations.
• Check accessibility, readability, and color contrast.
• Test the dashboard with representative users and realistic data.
• Validate that totals and calculations are correct before sharing.

20. Real-World Applications of Tableau Dashboards

21. Mini Project: Retail Sales Dashboard

Project Goal: Build an interactive dashboard that helps a retail manager monitor business performance.

Project Requirements

• Display total sales, total profit, and distinct order count.
• Show monthly sales trends.
• Compare sales across product categories.
• Compare profit across regions.
• Include filters for date, region, and category.
• Enable at least one useful chart-to-chart filter action.
• Use consistent formatting and a clear dashboard title.

Expected Outcome

The manager should be able to identify sales trends, compare category performance, locate underperforming regions, and explore the data interactively.

Project Evaluation Checklist

• All charts use the correct measures and dimensions.
• KPI calculations have been validated.
• Filters work on the intended worksheets.
• Titles and labels are clear.
• Dashboard objects are aligned.
• Interactivity works as expected.
• Dashboard performance is acceptable.

22. Interview Questions and Answers

Q1. What is a Tableau dashboard?

Answer: A Tableau dashboard combines multiple worksheets and other objects into one interactive view so users can analyze related data together.

Q2. What is the difference between a worksheet and a dashboard?

Answer: A worksheet is used to build an individual visualization, while a dashboard combines multiple views and supporting objects into a single workspace.

Q3. How do you create a dashboard in Tableau?

Answer: Create the required worksheets, open a new dashboard, select a size, drag the worksheets onto the canvas, arrange the objects, configure filters and actions, and test the result.

Q4. What is the difference between tiled and floating objects?

Answer: Tiled objects follow a structured layout, whereas floating objects can be positioned and sized independently.

Q5. What is the purpose of a dashboard filter?

Answer: A dashboard filter allows users to restrict the displayed data to selected values or conditions.

Q6. What does Use as Filter do?

Answer: It lets users select marks in one worksheet to filter other views in the dashboard.

Q7. What is a dashboard action?

Answer: A dashboard action responds to a user interaction, for example by filtering or highlighting other views, opening a URL, or navigating to another view.

Q8. Why are layout containers useful?

Answer: They group related objects and help manage their arrangement, spacing, and resizing behavior.

Q9. How can you improve dashboard performance?

Answer: Simplify the dashboard, optimize data sources and calculations, reduce unnecessary marks and filters, and test performance using realistic data volumes.

Q10. Why should a dashboard be tested on different devices?

Answer: Different screen sizes can affect readability, chart sizing, scrolling, and filter usability. Device previews and appropriate layouts help improve the viewing experience.

Q11. What should you consider when choosing a dashboard size?

Answer: Consider the target audience, screen dimensions, viewing environment, number of visualizations, and readability requirements.

Q12. What is the difference between a filter action and a highlight action?

Answer: A filter action restricts the target view to related data, while a highlight action emphasizes related marks and leaves other data visible for context.

23. Practice Exercises

1. Create a dashboard containing a bar chart and a line chart.
2. Add a Year filter and configure its scope across the intended worksheets.
3. Create three KPI cards for sales, profit, and orders.
4. Arrange the KPI cards in a horizontal container.
5. Enable Use as Filter on a category chart.
6. Compare tiled and floating layouts by building two versions of the same dashboard.
7. Format sales as currency and profit ratio as a percentage.
8. Test the dashboard at different sizes and correct any layout issues.
9. Create a second dashboard and add a navigation button between the two dashboards.
10. Write a short business summary describing three insights discovered from the dashboard.

24. Quick Revision Notes

• A dashboard combines multiple worksheets and objects into one view.
• Worksheets contain individual visualizations.
• Stories present a sequence of analytical points.
• Tiled layouts provide structured arrangement; floating layouts allow independent placement.
• Filters restrict the data shown in views.
• Use as Filter connects selections from one view to other views.
• Filter and highlight actions support interactive exploration.
• Text, image, blank, navigation, and layout containers support dashboard design.
• Dashboard sizing should suit the intended viewing environment.
• Good dashboards are readable, accurate, focused, interactive, and performant.
• Always validate calculations and test filters before publishing.

25. Conclusion

Tableau dashboards bring multiple visualizations together to provide a clear and interactive overview of business performance. By combining worksheets, KPI cards, filters, actions, and well-organized layouts, users can explore information efficiently and communicate insights effectively.

To build effective dashboards, start with a business objective, select appropriate visualizations, arrange the most important information clearly, add meaningful interactivity, validate calculations, and test the final dashboard before sharing it.

26. Additional Learning Resources

Official Tableau documentation: Create a Dashboard

Tableau dashboard actions: Actions and Dashboards

JustAcademy Tableau Training: Explore Tableau Training

Register for a Tableau Course Demo: Register for a Course Demo