How to Create a Simple Dashboard in Tableau

Creating your first dashboard in Tableau can feel intimidating, but it's much more straightforward than you might think. A good dashboard turns raw data into clear, actionable insights, and this guide will walk you through building a simple one from start to finish. We'll cover everything from connecting your data to creating charts and combining them into an interactive view.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly is a Tableau Dashboard?

Think of a Tableau dashboard as a visual command center. It’s a single screen where you can display multiple data visualizations - or "worksheets," in Tableau lingo - at once. Unlike a static report, a well-built dashboard is often interactive, allowing you to filter, drill down, and explore your data to find answers to your questions. Your goal is to arrange these different charts and graphs in a way that tells a coherent story and makes complex information easy to understand at a glance.

Before You Build: A Quick Data Prep Checklist

The quality of your dashboard depends entirely on the quality of your data. Before you even open Tableau, take a few minutes to get your data in order. This small step upfront can save you hours of frustration later. A messy dataset leads to a confusing dashboard.

Here’s a simple checklist to run through:

• Define Your Goal: What question are you trying to answer with this dashboard? Are you tracking monthly sales, analyzing marketing campaign performance, or monitoring website traffic? A clear goal will guide your decisions. For this tutorial, our goal is to understand our sales performance across different regions and product categories over time.
• Choose Your Data: For our walkthrough, we'll use a simple sales dataset. Imagine an Excel file or Google Sheet with columns like Order Date, Product Category, Region, and Sales Amount.
• Clean & Structure Your Data: Ensure your data is "tidy." This generally means each row is a single observation, each column is a variable, and there are no merged cells or unnecessary headers. Check for typos, inconsistent naming (e.g., "NY" vs. "New York"), and make sure your date and number columns are formatted correctly.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Connecting to Your Data Source

First things first, you need to bring your data into Tableau. Tableau can connect to a huge variety of data sources, from simple Excel files to complex cloud databases. We'll start with a basic spreadsheet.

1. Open the Tableau Desktop application.
2. On the welcome screen, look at the Connect pane on the left. You'll see options like "Microsoft Excel," "Text file," "JSON File," and more.
3. Click on Microsoft Excel (or whichever file type you're using).
4. Navigate to your saved data file and click Open.

Once you've connected, Tableau will take you to the Data Source screen. Here, you can see all the sheets in your workbook. Drag the sheet containing your data onto the canvas. Tableau will display a preview of your data, showing the column headers and the first few rows. This is a good place to double-check that Tableau is interpreting your data types correctly (e.g., recognizing your 'Sales Amount' as a number and 'Order Date' as a date).

If everything looks good, click on the orange tab at the bottom left labeled "Sheet 1" to move into the worksheet view, where the real magic happens.

Step 2: Building Your Charts (Worksheets)

A dashboard is made of individual charts, called "worksheets" in Tableau. Let's create three simple visualizations that, together, will tell a story about our sales performance.

When you enter the worksheet view, you'll see your data fields organized in the Data pane on the left. Tableau automatically categorizes them into Dimensions (categorical data like 'Region' or 'Product Category') and Measures (numerical data like 'Sales Amount').

Chart 1: Sales Over Time (Line Chart)

A line chart is perfect for showing trends over time. Let’s see how our sales have performed month by month.

1. From the Data pane, find your 'Order Date' field and drag it onto the Columns shelf at the top of the workspace.
2. Next, drag your 'Sales Amount' field onto the Rows shelf.

That's it! Tableau instantly generates a line chart. By default, it might show the data by year. To get a more detailed view, you can right-click the "YEAR(Order Date)" pill in the Columns shelf and select a different date format, like "Month."

Go ahead and rename your worksheet to something descriptive. Double-click the "Sheet 1" tab at the bottom and type "Sales Over Time".

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Chart 2: Sales by Product Category (Bar Chart)

Bar charts are great for comparing values across different categories. Let's see which of our product categories are the top performers.

1. Click the small "New Worksheet" icon at the bottom of the screen (it looks like a small bar chart with a plus sign).
2. From the Data pane, drag 'Product Category' to the Columns shelf.
3. Drag 'Sales Amount' to the Rows shelf.

Tableau will create a vertical bar chart. To make it even more insightful, you can sort the bars from highest to lowest sales by clicking the small sort icon that appears when you hover over the "Sales Amount" axis. You can also drag the 'Sales Amount' measure onto the Color target in the Marks card to create a color gradient, making high-performing categories stand out even more.

Don't forget to rename this worksheet to "Sales by Category."

Chart 3: Sales by Region (Map)

Maps are one of Tableau's most powerful features for visualizing geographic data. Let's plot our sales on a map to see a regional breakdown.

1. Create another new worksheet.
2. Find your 'Region' field. If it has a small globe icon next to it, Tableau has already recognized it as geographic data. Double-click it.
3. Tableau will automatically create a map and place a dot on each region in your data. It's a bit boring right now, so let's add some data to it.
4. Drag the 'Sales Amount' measure and drop it onto the Color target on the Marks card.

Now your map will color-code the regions based on sales, with darker shades representing higher sales. You've just created a choropleth map that makes it instantly clear which regions are your biggest markets.

Rename this sheet to "Sales by Region" and you're ready to assemble your dashboard.

Step 3: Assembling Your First Dashboard

Now it's time to bring all your hard work together into a single, cohesive view.

1. Click the "New Dashboard" icon at the bottom of the screen (it looks like a grid of four squares).
2. This opens the Dashboard canvas. On the left, you'll see a list of all the worksheets you just created.
3. Under Size, you can set the dimensions for your dashboard. "Fixed size" is great for presentations, while "Automatic" will adjust to fit the viewer's screen. Let's stick with the default fixed size for now.
4. Now, simply drag and drop your worksheets from the Sheets list onto the canvas. Start by dragging "Sales Over Time" to the top.
5. Next, drag "Sales by Category" and hover over the bottom half of the canvas. You'll see a grey box appear, showing you where the chart will be placed. Release it.
6. Finally, drag "Sales by Region" and place it next to the bar chart. You'll also notice that the color legends for your charts automatically appear on the right.

You can adjust the size of each chart by hovering your cursor over the borders between them and dragging.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 4: Adding Interactivity

Here’s where your dashboard comes to life. Let’s make it so that clicking on a part of one chart filters the others. This allows you and your audience to explore the data dynamically.

Let's use our map as the main filter.

1. Select the "Sales by Region" map view within your dashboard (you'll see a grey border around it).
2. In the upper right corner of this view, a few small icons will appear. Click the funnel icon that says "Use as Filter."

That's it! Now, go back to your dashboard and click on any region on the map. Watch how the "Sales Over Time" and "Sales by Category" charts automatically update to show data for only the selected region. You can click another region, or Ctrl-click (Cmd-click on a Mac) to select multiple regions. To deselect, just click the same region again or click on any white space in the map view.

This simple interactive feature transforms your static report into a powerful analytical tool.

Step 5: Final Touches for a Professional Look

Lastly, let's clean up the appearance to make it look professional and easy to read.

• Add a Title: On the left pane under Objects, drag a Text object to the very top of your dashboard. Type in a clear, descriptive title, like "Quarterly Sales Performance Dashboard." You can also format the font and size to make it stand out.
• Clean Up Tooltips: A tooltip is the box of information that appears when you hover over a data point. Tableau creates them automatically, but you can clean them up by going back to each worksheet, clicking on the Tooltip target in the Marks card, and editing the text to be more readable.
• Adjust Spacing: You can add Blank objects from the left pane to create more white space between elements, making your dashboard feel less cluttered and easier on the eye.

Final Thoughts

You've successfully built your first simple dashboard in Tableau! By connecting your data, creating individual charts on worksheets, arranging them on a dashboard canvas, and adding a simple filter, you've transformed a raw spreadsheet into a dynamic and insightful analytical tool. This foundational process is the launching point for creating much more complex and powerful visualizations.

As you can see, the process involves several distinct steps, from cleaning data and learning the interface to building each chart individually. When you’re buried in client work or marketing campaigns, finding the hours to build dashboards like this from scratch can be tough. We created Graphed to solve exactly this problem. You can connect your data sources in a few clicks, and then simply ask for what you want in plain English - like "Show me a dashboard of sales by region and product category last quarter." We build the interactive, real-time dashboard for you in seconds, so you get the insights without the steep learning curve.