Creating a dashboard in Tableau - Mechanics & Internals

Overview - Creating a dashboard

What is it?

Creating a dashboard means putting together different charts, tables, and visuals on one screen so you can see important information all at once. It helps you understand data quickly by showing many views side by side. Dashboards are interactive, letting you click or filter to explore details. They are like control panels for your data.

Why it matters

Without dashboards, you would have to look at many separate reports or charts to understand your data, which takes a lot of time and can cause mistakes. Dashboards save time and help people make better decisions by showing the right information clearly and quickly. They turn complex data into simple stories anyone can understand.

Where it fits

Before creating dashboards, you should know how to connect to data and build basic charts in Tableau. After learning dashboards, you can explore advanced topics like dashboard actions, performance optimization, and storytelling with data.

Mental Model

Core Idea

A dashboard is a single screen that combines multiple visuals to tell a clear story from data at a glance.

Think of it like...

A dashboard is like the dashboard in a car, where you see your speed, fuel, and engine lights all in one place to understand how the car is doing quickly.

┌─────────────────────────────┐
│        Dashboard Screen      │
├──────────────┬──────────────┤
│ Chart 1      │ Chart 2      │
│ (Sales)      │ (Profit)     │
├──────────────┼──────────────┤
│ Table 1      │ Filter Panel │
│ (Details)    │ (Date, Region)│
└──────────────┴──────────────┘

Build-Up - 7 Steps

1

Foundation

Understanding dashboard basics

Concept: Learn what a dashboard is and its main parts in Tableau.

A dashboard in Tableau is a workspace where you place multiple views like charts and tables. You can add filters and images. It helps you see many data points together. To start, open Tableau and click the 'New Dashboard' button. You will see a blank canvas where you can drag sheets from your workbook.

Result

You get a blank dashboard ready to add visuals.

Knowing the dashboard workspace is key to building any combined view of your data.

2

Foundation

Adding and arranging visuals

Concept: Learn how to add charts and tables to the dashboard and arrange them.

Drag sheets from the left panel onto the dashboard canvas. You can place them side by side or stacked. Use containers to group items and control layout. Resize visuals by dragging edges. This lets you organize information clearly.

Result

A dashboard with multiple visuals arranged neatly.

Understanding layout controls helps make dashboards easy to read and use.

3

Intermediate

Using filters for interactivity

🤔Before reading on: do you think filters on a dashboard affect all visuals or just one? Commit to your answer.

Concept: Learn how to add filters that let users control what data they see.

Add filter controls by clicking on a chart's filter icon and choosing 'Show Filter'. You can set filters to apply to all or selected visuals. Filters let users pick dates, categories, or regions to focus on specific data.

Result

Dashboard users can interactively change data views using filters.

Knowing how filters work lets you create dashboards that adapt to user needs.

4

Intermediate

Adding dashboard actions

🤔Before reading on: do you think dashboard actions can only filter data, or can they do more? Commit to your answer.

Concept: Learn to add actions like filter, highlight, and URL to make dashboards interactive.

Dashboard actions let one visual control others. For example, clicking a bar can filter other charts. To add actions, go to Dashboard > Actions, then choose the type. Actions improve exploration and storytelling.

Result

Dashboards respond dynamically to user clicks and selections.

Understanding actions unlocks powerful interactive experiences beyond static views.

5

Intermediate

Optimizing dashboard layout for clarity

Concept: Learn best practices to make dashboards clear and easy to use.

Use consistent colors and fonts. Group related visuals. Avoid clutter by limiting the number of charts. Use titles and labels clearly. Test on different screen sizes. This helps users find insights quickly.

Result

A clean, user-friendly dashboard that communicates well.

Good design choices make dashboards effective communication tools.

6

Advanced

Using device designer for responsiveness

🤔Before reading on: do you think dashboards automatically adjust to phones and tablets, or do you need to design separately? Commit to your answer.

Concept: Learn to create dashboard layouts optimized for different devices.

Tableau’s Device Designer lets you create separate layouts for desktop, tablet, and phone. You can hide or rearrange visuals for smaller screens. This ensures your dashboard works well everywhere.

Result

Dashboards that look good and work well on any device.

Knowing device-specific design prevents poor user experience on mobile.

7

Expert

Performance tuning and best practices

🤔Before reading on: do you think adding more visuals always slows dashboards, or can design choices keep them fast? Commit to your answer.

Concept: Learn how to keep dashboards fast and responsive with large data.

Limit quick filters and complex calculations. Use extracts instead of live connections when possible. Minimize the number of visuals and use efficient chart types. Monitor performance with Tableau’s Performance Recorder. These steps keep dashboards smooth.

Result

Fast-loading dashboards even with big data sets.

Understanding performance helps avoid slow dashboards that frustrate users.

Under the Hood

Tableau dashboards are built by layering multiple worksheets on a canvas. Each worksheet queries the data source independently but can be linked through filters and actions. When a user interacts, Tableau sends queries to the data source to update visuals dynamically. The layout engine arranges visuals based on containers and sizing rules.

Why designed this way?

Tableau separates worksheets and dashboards to keep visuals modular and reusable. This design allows flexibility in combining views and adding interactivity without rebuilding charts. The query-driven model ensures dashboards reflect live or extracted data accurately.

┌───────────────┐       ┌───────────────┐
│   Worksheet   │       │   Worksheet   │
│  (Chart 1)   │       │  (Chart 2)   │
└──────┬────────┘       └──────┬────────┘
       │                       │
       │ Queries data source    │
       ▼                       ▼
┌─────────────────────────────────────┐
│           Data Source                │
└─────────────────────────────────────┘
       ▲                       ▲
       │                       │
┌──────┴────────┐       ┌──────┴────────┐
│ Dashboard     │       │ Layout Engine │
│ Canvas       │       │ (arranges     │
│ (combines    │       │ visuals)      │
│ worksheets)  │       └───────────────┘
└──────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Does adding more charts always make a dashboard better? Commit yes or no.

Common Belief: More charts on a dashboard always give better insights.

Reality: Too many charts clutter the dashboard and confuse users, making it harder to find key information.

Why it matters: Overloading dashboards reduces clarity and slows user decisions.

Quick: Do filters on one chart always affect all charts by default? Commit yes or no.

Common Belief: Filters applied on one chart automatically filter all other charts on the dashboard.

Reality: Filters only affect other charts if you set them to apply to all relevant worksheets; otherwise, they affect just one.

Why it matters: Assuming filters affect all visuals can cause unexpected dashboard behavior and user confusion.

Quick: Are dashboards always fast regardless of data size? Commit yes or no.

Common Belief: Dashboards load quickly no matter how much data they use.

Reality: Large data sets and complex calculations can slow dashboards unless optimized.

Why it matters: Ignoring performance leads to slow dashboards that frustrate users and reduce adoption.

Quick: Does Tableau automatically make dashboards look good on phones? Commit yes or no.

Common Belief: Tableau dashboards automatically adjust perfectly to any device without extra work.

Reality: You must design separate layouts for different devices using Device Designer for best results.

Why it matters: Without device-specific design, dashboards may be unusable on small screens.

Expert Zone

1

Dashboard actions can be chained to create complex interactive flows, but this requires careful planning to avoid confusing users.

2

Using floating containers allows precise placement but can cause layout issues on different screen sizes if not managed properly.

3

Performance tuning often involves balancing data freshness with speed, choosing between live connections and extracts based on use case.

When NOT to use

Dashboards are not ideal for deep data exploration or ad-hoc analysis where users need to build custom views. In those cases, use Tableau worksheets or data exploration tools instead.

Production Patterns

Professionals build dashboards with a clear story in mind, often starting with key metrics at the top and detailed views below. They use consistent color palettes and fonts aligned with company branding. They also implement user filters and actions to let stakeholders explore data without overwhelming them.

Connections

User Interface Design

Dashboard design builds on UI principles like layout, color, and interaction.

Understanding UI design helps create dashboards that are not only functional but also intuitive and pleasant to use.

Data Storytelling

Dashboards are a tool for telling stories with data by combining visuals and interactivity.

Knowing storytelling techniques improves how you arrange and highlight data to guide user understanding.

Control Panels in Engineering

Dashboards function like control panels that monitor system status and alert users.

Recognizing dashboards as control panels helps appreciate the importance of clarity, real-time updates, and alerting in design.

Common Pitfalls

#1 Adding too many visuals causing clutter.

Wrong approach:

Drag 10+ charts onto one dashboard without grouping or layout planning.

Correct approach:

Limit to 4-6 key visuals, use containers to group related charts, and leave white space for clarity.

Root cause:

Misunderstanding that more visuals always mean better insight.

#2 Filters not applying to all relevant charts.

Wrong approach:

Add a filter on one chart but do not set it to apply to other worksheets.

Correct approach:

Set filter to apply to all relevant worksheets in the dashboard filter settings.

Root cause:

Assuming filters automatically affect all visuals.

#3 Ignoring mobile layout design.

Wrong approach:

Create one dashboard layout and expect it to work on phones without changes.

Correct approach:

Use Device Designer to create separate layouts optimized for phone and tablet screens.

Root cause:

Not realizing dashboards need device-specific design.

Key Takeaways

Dashboards combine multiple visuals on one screen to give a clear, interactive view of data.

Good dashboard design balances clarity, interactivity, and performance to help users make decisions quickly.

Filters and actions make dashboards dynamic, but must be set up carefully to work as expected.

Designing for different devices ensures dashboards are usable everywhere, not just on desktops.

Performance tuning is essential for smooth dashboards, especially with large or complex data.

Practice

1. What is the main purpose of creating a dashboard in Tableau?

easy

A. To write complex SQL queries

B. To export data to Excel

C. To create raw data tables

D. To combine multiple charts for easy data viewing

Solution

1. Step 1: Understand dashboard purpose

   A dashboard is designed to show multiple visualizations together for quick insights.

2. Step 2: Compare options to purpose

   Only combining charts for easy viewing matches the dashboard's goal.

3. Final Answer:

   To combine multiple charts for easy data viewing -> Option D

4. Quick Check:

   Dashboard = Combine charts [OK]

Hint: Dashboards show many charts together for quick insight [OK]

Common Mistakes:

• Confusing dashboards with data export
• Thinking dashboards are for raw data only
• Mixing dashboards with query writing

2. Which of the following is the correct way to add a sheet to a Tableau dashboard?

easy

A. Drag the sheet from the Sheets pane onto the dashboard area

B. Right-click the sheet and select 'Export to Dashboard'

C. Double-click the sheet to automatically add it to the dashboard

D. Use the Data menu to import the sheet into the dashboard

Solution

1. Step 1: Identify how to add sheets

   In Tableau, sheets are added by dragging them onto the dashboard workspace.

2. Step 2: Evaluate options

   Only dragging from the Sheets pane is the correct method; others are incorrect or do not exist.

3. Final Answer:

   Drag the sheet from the Sheets pane onto the dashboard area -> Option A

4. Quick Check:

   Drag sheet to dashboard [OK]

Hint: Drag sheets from pane to dashboard to add [OK]

Common Mistakes:

• Trying to export sheets instead of dragging
• Double-clicking sheets expecting auto-add
• Using Data menu incorrectly

3. Consider a dashboard with three sheets: Sales, Profit, and Region Map. If you add a filter on Region in the dashboard, what happens when you select a region in the filter?

medium

A. Only the Sales sheet updates to show data for the selected region

B. All sheets update to show data for the selected region

C. The filter does not affect any sheet unless applied individually

D. Only the Region Map updates, others stay the same

Solution

1. Step 1: Understand dashboard filters

   Dashboard filters can be set to apply to all relevant sheets, syncing their data views.

2. Step 2: Apply filter effect

   Selecting a region filter updates all sheets connected to that filter to show data for that region.

3. Final Answer:

   All sheets update to show data for the selected region -> Option B

4. Quick Check:

   Dashboard filter affects all sheets [OK]

Hint: Dashboard filters update all connected sheets [OK]

Common Mistakes:

• Thinking filters affect only one sheet by default
• Assuming filters need manual application per sheet
• Believing filters do not update visualizations

4. You created a dashboard but the filter you added does not update any sheets. What is the most likely reason?

medium

A. The filter is not set to apply to all relevant sheets

B. The dashboard has too many sheets

C. The data source is disconnected

D. The sheets are not visible on the dashboard

Solution

1. Step 1: Check filter application settings

   Filters must be configured to apply to all or specific sheets to update them.

2. Step 2: Identify why sheets don't update

   If the filter is not set to apply to sheets, they won't respond to filter changes.

3. Final Answer:

   The filter is not set to apply to all relevant sheets -> Option A

4. Quick Check:

   Filter scope controls sheet updates [OK]

Hint: Set filter to apply to all sheets to update [OK]

Common Mistakes:

• Blaming number of sheets for filter failure
• Ignoring filter application scope
• Assuming disconnected data source without checking

5. You want to create a dashboard that shows sales trends and allows users to filter by year and product category. Which steps should you follow to build this interactive dashboard?

hard

A. Create sheets for sales trends, add filters on sheets but do not add filters to dashboard

B. Create one sheet with all data, add it to dashboard, then add filters only for year

C. Create sheets for sales trends, add them to dashboard, then add filters for year and category applying to all sheets

D. Create sheets, add to dashboard, export data, then add filters in Excel

Solution

1. Step 1: Build individual sheets for sales trends

   Create separate sheets showing sales trends by year and category for clarity.

2. Step 2: Add sheets to dashboard and add filters

   Drag sheets onto dashboard, then add filters for year and product category, setting them to apply to all sheets for interactivity.

3. Final Answer:

   Create sheets for sales trends, add them to dashboard, then add filters for year and category applying to all sheets -> Option C

4. Quick Check:

   Sheets + dashboard + filters for all sheets = interactive dashboard [OK]

Hint: Add filters on dashboard applying to all sheets for interactivity [OK]

Common Mistakes:

• Adding filters only on sheets, not dashboard
• Using one sheet for all data losing clarity
• Exporting data instead of using dashboard filters