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.