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.
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.
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
- Open your Tableau workbook.
- Create the required worksheets and visualizations.
- Locate the New Dashboard icon near the sheet tabs.
- Click the New Dashboard icon.
- Alternatively, select Dashboard → New Dashboard from the menu.
- Tableau opens a new Dashboard workspace.
- Drag worksheets from the Sheets panel onto the dashboard canvas.
- Arrange and resize the worksheets according to your requirements.
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
- Open the dashboard.
- Locate the Size section in the Dashboard pane.
- Select Automatic, Fixed Size, or Range.
- For Fixed Size, specify the required width and height.
- For Range, specify minimum and maximum dimensions.
- Review the dashboard after changing its size.
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
- Open the Dashboard workspace.
- Locate the Sheets panel on the left side.
- Identify the worksheet you want to include.
- Drag the worksheet onto the dashboard canvas.
- Position the worksheet where it should appear.
- Repeat the process for other worksheets.
- 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.
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
- Open the Dashboard workspace.
- Locate the Objects section.
- Drag a Horizontal or Vertical container onto the canvas.
- Drag worksheets or other objects inside the container.
- Adjust the container size and spacing.
- 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. |
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
- Open the Dashboard workspace.
- Drag the Text object onto the dashboard.
- Enter the required heading or description.
- Adjust font size, font style, and alignment.
- Click OK to apply the changes.
Adding an Image Object
- Drag the Image object onto the dashboard.
- Select the image file from your system.
- Configure the image fitting options.
- Adjust the image dimensions and placement.
- Review the dashboard appearance.
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
- Add a worksheet to the dashboard.
- Open the worksheet's drop-down menu.
- Select Filters.
- Choose the field that should be displayed as a filter.
- Position the filter on the dashboard.
- 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
- Add a worksheet containing color or size encoding.
- Open the worksheet menu on the dashboard.
- Enable the relevant color or size legend.
- Place the legend near the corresponding visualization.
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
Dashboard Creation Workflow
- Connect to the sales dataset.
- Create individual worksheets for KPIs and charts.
- Create a new dashboard.
- Choose an appropriate dashboard size.
- Add KPI worksheets to the top section.
- Add sales trend and category charts.
- Add the regional map and product table.
- Add filters for Year, Region, and Category.
- Apply consistent formatting.
- 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
- Open the dashboard.
- Locate the Device Preview option.
- Select the required device type.
- Review how the dashboard appears on that device.
- Adjust the layout and worksheet arrangement where required.
- Preview the dashboard again before publishing.
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.
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.
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
- Connect Tableau to a sales dataset.
- Create a worksheet for Total Sales.
- Create a worksheet for Total Profit.
- Create a monthly sales trend chart.
- Create a category-wise sales chart.
- Create a regional sales map.
- Create a new dashboard.
- Add the worksheets to the dashboard.
- Use containers to organize the layout.
- Add Year and Region filters.
- Apply consistent formatting.
- Review the final dashboard on different screen sizes.
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.
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.