Graphed LogoGraphed
Login

How to Create a Visual Report in Tableau

Cody Schneider•

Building a visual report in Tableau can feel like being handed the keys to a spaceship without a flight manual. You know it’s powerful, but the sheer number of buttons, panels, and options can be overwhelming. This guide is your co-pilot. We'll walk you through the essential steps to turn your raw data into a clear, interactive visual report without the complex jargon.

Before You Begin: A Quick Tableau Vocabulary Lesson

Tableau has its own language. Getting familiar with a few key terms will make the whole process much smoother. Think of this as learning the basic layout of the kitchen before you start cooking.

Data Source

This is simply where your data comes from. It could be an Excel or Google Sheets file, a CSV, a connection to a database like SQL Server, or even data from a CRM like Salesforce.

Dimensions vs. Measures

This is the most important concept to grasp in Tableau. Once you get this, everything else starts to click.

  • Dimensions: These are your categorical, descriptive data fields. They are the "what," "who," "where," and "when" in your data. Examples include things like Product Category, Country, Customer Name, or a specific date like Order Date. Tableau usually color-codes these blue.

  • Measures: These are your numerical, quantitative data fields. They are the numbers you want to add up, average, or count. Examples include Sales, Profit, Quantity, and Website Clicks. Tableau color-codes these green.

In short: you use Measures (like Sales) broken down by Dimensions (like Region) to answer business questions.

Worksheet, Dashboard, Story

Tableau organizes your work into three main components, accessible via tabs at the bottom of your screen:

  • A Worksheet is the canvas where you build a single chart or a table (e.g., one bar chart, one line graph).

  • A Dashboard is where you combine multiple worksheets into a single, cohesive view. This is where you assemble your "visual report."

  • A Story allows you to walk viewers through a sequence of worksheets and dashboards to tell a narrative with your data. We'll focus on dashboards for today.

Shelves and Cards

When you're in a worksheet, the main building area contains several "shelves" and "cards." For now, just focus on these key ones:

  • Columns Shelf: Dragging a field here creates columns in your view.

  • Rows Shelf: Dragging a field here creates rows.

  • Marks Card: This powerful card controls the visual properties of your data points (the "marks"). You can change the color, size, shape, and level of detail here.

  • Filters Shelf: Drag fields here to filter the data shown in your view.

Your First Visual Report: A Step-by-Step Guide

Theory is great, but the best way to learn is by doing. We'll use a hypothetical e-commerce sales dataset. Imagine you have a simple spreadsheet with columns like Order Date, Region, Product Category, Sales, and Profit.

Step 1: Connecting Your Data

When you first open Tableau Desktop, you're greeted with a Connect pane. This is where you tell Tableau where your data lives.

  1. On the left side, under "Connect," find the file type you're using. For a spreadsheet, you’ll likely select Microsoft Excel or Text File (for a CSV). If your data is in Google Sheets, choose the Google Sheets connector.

  2. A file explorer window will open. Navigate to your file and click "Open."

  3. Tableau will now show you the "Data Source" screen. Here, you can see your spreadsheet's tabs (if any) and a preview of your data columns. If it looks correct, click on the orange "Sheet 1" tab at the bottom-left to go to your first worksheet.

You’ll now see a blank worksheet. On the left, in the "Data" pane, Tableau has automatically sorted your columns into Dimensions (blue pills) and Measures (green pills). The magic is about to happen.

Step 2: Building Your First Chart (A Sales Bar Chart)

Let's answer a simple question: "What are our total sales by Product Category?" This is perfect for a bar chart.

  1. Find your Product Category dimension in the Data pane on the left.

  2. Click and drag Product Category and drop it onto the Columns Shelf. You'll now see your category names appear as column headers.

  3. Next, find your Sales measure.

  4. Click and drag Sales and drop it onto the Rows Shelf.

Just like that, Tableau creates a vertical bar chart. Each bar represents a product category, and its height corresponds to the total sales for that category. It automatically aggregates the sales data for you.

Bonus Tip: To make this more insightful, let's color-code these bars by how much profit each category generates. Find your Profit measure and drag it directly onto the Color tile within the Marks Card. Tableau will apply a color gradient - you can now instantly see which high-selling categories are also highly profitable.

Step 3: Creating a Second Chart (A Profit Trend Line)

Now, let's answer another question: "How has our profit trended over time?" A line chart is ideal for this.

  1. At the bottom of the screen, click the "New Worksheet" icon (it looks like a small bar chart with a plus sign).

  2. In this new sheet, find your Order Date dimension and drag it to the Columns Shelf. Tableau will default to showing the YEAR of the date.

  3. Find your Profit measure and drag it to the Rows Shelf.

A line chart appears, showing your total profit by year. But what if you want more detail?

Drilling Down: Notice the little "+" on the "YEAR(Order Date)" pill in your Columns Shelf. Click it. Tableau will "drill down" to the next level: Quarter. Click it again to see Months. This is a quick way to change the granularity of your time-series analysis without rebuilding an entirely new chart.

Step 4: Assembling Your Dashboard

You have two compelling worksheets. Now it's time to combine them into a single report - our dashboard.

  1. At the bottom of the screen, click the "New Dashboard" icon (it looks like a grid).

  2. You'll be presented with a blank canvas. On the left side, under "Sheets," you'll see the worksheets you just created ("Sheet 1" and "Sheet 2").

  3. Click and drag Sheet 1 (your bar chart) onto the canvas area that says "Drop sheets here." It will snap into place.

  4. Now, drag Sheet 2 (your line chart) onto the canvas. As you drag, you'll see grey areas appear. This shows you where Tableau can place the new sheet. Drop it next to or below your first chart.

  5. You can now resize the charts by hovering your mouse over the borders between them and dragging. On the right, Tableau often adds legends for things like color or size - you can keep these or remove them by clicking on them and selecting "Remove from Dashboard."

Step 5: Adding Interactivity

This is where Tableau really shines and what transforms a static report into a dynamic analysis tool. We'll make it so that clicking on a bar in your sales chart filters your profit trend line.

  1. On your dashboard, click once on the bar chart to select it. You should see a grey border appear around it with a few icons at the top-right.

  2. Click the funnel-shaped icon that says "Use as Filter."

That's it. Now try it out. Click on a single bar in your sales chart, like "Technology." You'll see the profit line chart instantly update to show the profit trend for only the Technology category. This simple action allows you or your team to self-serve and explore the data, answering follow-up questions in seconds.

Tips for Creating Reports People Will Actually Use

Building a dashboard is one thing, building one that's actually useful is another. Keep these principles in mind.

Know Your Audience

Before you drag a single field, ask yourself: Who is this for, and what single question do they need answered? A report for a CEO needs a high-level overview, while a report for a campaign manager needs granular marketing data. Tailor your charts to the audience's needs, not your own curiosity.

Keep It Simple

The goal is clarity, not complexity. Resist the temptation to cram 10 different charts onto a single dashboard. A successful dashboard should communicate its primary message within 5-10 seconds. If it takes longer to understand, you've probably included too much information.

Use Color with Purpose

Color is a powerful tool for visual analysis. Don't use it just for decoration. Use it to highlight what's important. For example, use a consistent color for a specific category across all charts, or use a diverging color scheme (like red-to-green) to show positive and negative performance.

Clean It Up and Add Titles

The details matter. Give your dashboard a clear, descriptive title ("Quarterly Sales & Profit Performance"). Give each worksheet a sensible name by double-clicking its tab. Hide unnecessary grid lines or axes labels that add clutter. Your goal is to guide the viewer’s eye to the most important insights without distraction.

Final Thoughts

You’ve now walked through the core mechanics of creating a visual report in Tableau - from connecting data and understanding the lingo to building individual charts and combining them into an interactive dashboard. While it does take practice, these fundamentals are the building blocks you’ll use for every analysis you create.

While mastering tools like Tableau is a powerful skill, we know the learning curve can be steep and the process time-consuming - especially when you just need a quick answer. That's why we created Graphed. Our platform lets you connect your data sources in seconds and create the exact dashboards you need by simply describing them in plain English. We turn the manual, multi-step process you just learned into a 30-second conversation, so you can get back to acting on insights instead of just finding them.