How to Create a Tracking Dashboard in Tableau

Building a custom dashboard is the best way to see all your most important business metrics in one organized view. Instead of jumping between a dozen different reports, you can build a single source of truth to track performance, spot trends, and make smarter decisions. This guide will walk you through, step by step, how to build your own tracking dashboard in Tableau.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, What Is a Tracking Dashboard?

A tracking dashboard is a visual interface that organizes and displays your key performance indicators (KPIs) in a way that's easy to understand at a glance. Think of it as the cockpit for your business, department, or individual campaigns. Instead of digging through dense spreadsheets, you get charts, graphs, and summary numbers that tell you what’s happening in real time.

These dashboards are incredibly valuable because they:

• Centralize Your Data: Pull metrics from different sources into one place.
• Provide Clarity: Turn raw numbers into clear, simple visualizations.
• Enable Quick Decisions: Spot a sudden drop in sales or a surge in website traffic and react immediately, not next month.
• Identify Trends: See how performance changes over time to understand what's working and what isn't.

You can build a dashboard to track almost anything, from marketing campaign results and sales team performance to financial health or website analytics.

Before You Build: Planning for Success

Jumping straight into Tableau without a plan is a recipe for a cluttered, confusing dashboard. The most effective dashboards are built with a clear purpose in mind. Before you connect any data, take a few minutes to answer these questions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Who is the Audience and What Are Their Goals?

A dashboard for a CEO will look very different from one for a social media manager. Think about who will be using this dashboard and what they need to know.

• For a CEO: Focus on high-level, business-critical KPIs like overall revenue, profit margins, and customer acquisition cost (CAC).
• For a Sales Manager: Focus on team performance metrics like deals closed, conversion rates by rep, and sales pipeline velocity.
• For a Digital Marketer: Focus on campaign-specific metrics like click-through rates, cost per lead, and return on ad spend (ROAS).

The key here is to build a dashboard that helps a specific person do their job better. What question do they need answered in 30 seconds or less? Design the dashboard to provide that answer.

2. What Are Your Key Performance Indicators (KPIs)?

Once you know your audience, define the specific metrics that matter most. Avoid the temptation to include every piece of data you have. A great dashboard has focus. Select between 5-10 core KPIs that give a complete picture without being overwhelming.

Some examples include:

• Total Revenue
• Conversion Rate (Lead to Deal)
• Average Deal Size
• Sales Cycle Length
• New Leads Generated This Month

A website tracking dashboard might use:

• Total Sessions
• Unique Visitors
• Bounce Rate
• Average Session Duration
• Goal Completions (e.g., form submissions)

3. Where Does Your Data Live?

Finally, figure out where you'll be pulling this data from. Is it in an Excel file, a Google Sheet, a SQL database, or a SaaS platform like Salesforce or Google Analytics? Ensure your data is clean and structured properly. This means consistent date formats, no missing values where they are needed, and clear column headers. Spending time cleaning your data source now will save you a massive headache later.

How to Build Your Tracking Dashboard in Tableau, Step-by-Step

With your plan in place, it's time to build. We'll walk through the process of creating a simple sales tracking dashboard.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Connect to Your Data Source

Open Tableau Desktop. On the left side of the screen, you’ll see the Connect pane, which lists all the different data sources Tableau can connect to. For this example, let's assume our sales data is in an Excel file.

1. Underneath a "To a File" heading, click on Microsoft Excel.
2. Navigate to your file and select it. Tableau will now open the Data Source page.
3. Here, you can see all the sheets inside your Excel file. Drag the sheet containing your data (e.g., "Sales_Data") onto the canvas on the right.

Tableau will display a preview of your data at the bottom of the screen. You can check that your columns are recognized with the correct data types (e.g., "Order Date" is a date, "Sales" is a number).

Step 2: Create Your First Worksheet (Chart)

In Tableau, you build individual charts on worksheets and then combine them into a dashboard. Let's create a line chart showing sales trends over time.

1. Click the "New Worksheet" tab at the bottom of the screen (it has an icon of a bar chart with a plus sign).
2. On the left, you'll see your data fields split into two categories: Dimensions (qualitative data, like dates, categories, or names) and Measures (quantitative data, like sales, profit, or quantity).
3. Drag the Order Date dimension onto the Columns shelf at the top of the canvas.
4. Drag the Sales measure onto the Rows shelf.

That's it! Tableau automatically generates a line chart showing your total sales over time. You can customize this further by clicking the dropdown on the "Order Date" pill in Columns and changing it from YEAR to MONTH for a more detailed view.

Now, repeat this process to create a few more charts on separate worksheets. For example:

• Sales by Region (Bar Chart): Drag the Region dimension to Columns and Sales measure to Rows.
• Sales by Product Category (Horizontal Bar Chart): Drag Sales to Columns and Product Category to Rows.

Step 3: Build Your KPI Cards

Tracking dashboards often feature big numbers at the top highlighting the most important totals. These are easy to make.

1. Create a new worksheet.
2. Drag the Sales measure directly onto the Text mark in the Marks card (located in the middle of the screen).
3. You'll see a number appear. Click on the Text button to format it. You can make the font bigger, bolder, and change the color.
4. Rename the worksheet to something clear like "Total Sales".

Create another KPI card for "Total Profit" or "Total Customers" by repeating these same steps on a new sheet.

Step 4: Combine Everything into a Dashboard

Now it's time to assemble your components into a coherent dashboard.

1. Click the "New Dashboard" icon at the bottom, next to the New Worksheet button.
2. On the left pane, you'll see a list of all the worksheets you've built.
3. Simply drag and drop your worksheets onto the blank dashboard canvas. Start with your KPI cards at the top, then add your charts below them. Tableau will automatically tile them to fit the space.
4. Under Size in the left pane, you can set the dimensions. "Fixed size" is great for precise layouts, while "Automatic" will make the dashboard resize to fit any screen.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 5: Add Interactivity with Filters

A static dashboard is useful, but an interactive one is even better. Let’s add a filter so you can slice your data by region.

1. Select the "Sales by Region" sheet on your dashboard.
2. Click the small downward arrow on the top right corner of that sheet’s container and go to Filters > Region.
3. A filter box for "Region" will appear on the dashboard. Now, select that new filter box, click its own downward arrow, and select Apply to Worksheets > All Using This Data Source.

Now, when you check or uncheck a region in the filter, all the charts and KPI cards on your dashboard will update to show data only for the selected regions. This allows you to dig into performance without needing to build separate views.

Step 6: Polish and Publish Your Dashboard

The final step is to make sure your dashboard is clean, clear, and easy to read.

• Add Titles: Give each chart a descriptive title. You can also add an overall title for the dashboard by dragging a Text object from the left pane to the top.
• Format with Purpose: Use color to draw attention, not to decorate. For example, you can color your "Profit" measure so that positive numbers are green and negative numbers are red.
• Clean Up Clutter: Hide unnecessary axes, remove gridlines, and ensure a logical layout that guides the viewer’s eye (typically from top-left to bottom-right).

Once you’re happy with it, you can publish your dashboard to Tableau Server or Tableau Cloud to share it with your team.

Final Thoughts

Creating a tracking dashboard in Tableau is a powerful way to turn your raw data into actionable insights. By carefully planning your audience and KPIs, building individual visual components on worksheets, and then composing them into an interactive dashboard, you can build a single source of truth that helps drive your business forward.

To get these insights without the steep learning curve of a complex BI tool, we built Graphed. Our platform allows you to connect all your data sources from places like Shopify, Google Analytics, or Salesforce, and then build dashboards in seconds using plain English. Simply ask, “Show me a dashboard of new Shopify customers vs. ad spend from Facebook for the last quarter,” and Graphed builds the interactive, real-time dashboard for you instantly. No training courses or manual chart-building required.