How to Create a Report in Tableau

Building a report in Tableau might seem like a complex task reserved for data scientists, but it's actually a skill anyone can learn. The platform is designed to turn raw numbers into clear, insightful visualizations without needing to write any code. This tutorial will walk you through creating your first report - from connecting to a data source to building an interactive dashboard you can share.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, An Important Clarification: Reports vs. Dashboards in Tableau

Before we begin, let's clear up some terminology. In the business world, a "report" is often a static document with charts and tables. In Tableau, the goal is usually to create something more dynamic. What you might call a "report," Tableau calls a "dashboard."

• Worksheet: An individual chart or graph (like a bar chart or a map).
• Dashboard: A collection of one or more worksheets arranged on a single screen, often with interactive filters and actions.
• Story: A sequence of dashboards or worksheets used to narrate a data-driven story.

For this guide, we'll focus on creating a dashboard, which is the most common and powerful way to present data in Tableau.

Step 1: Connect to Your Data

Every report starts with data. When you first open Tableau Desktop, you’ll be greeted by the "Connect" pane. This is where you tell Tableau where to find your information. Tableau can connect to a remarkable variety of data sources.

You can connect to simple files like:

• Microsoft Excel
• Text files (CSV, TXT)
• PDF files

Or, you can connect to more complex servers and cloud platforms like:

• Microsoft SQL Server
• Google Analytics
• Salesforce
• Amazon Redshift
• Google Sheets

For this example, we’ll use a simple Excel file containing basic sales data. Imagine we have a spreadsheet with columns for Order Date, Region, Product Category, and Sales.

To connect, simply click on "Microsoft Excel" in the Connect pane, navigate to your file, and click "Open."

Tableau will then take you to the Data Source screen. Here, you can see your data and confirm everything looks right before you start building. If your Excel file has multiple tabs (or sheets), you can drag the sheet you want to use onto the canvas area. Once you're happy, click the "Sheet 1" tab at the bottom of the screen to go to the main workspace.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Get Familiar With the Tableau Workspace

The Tableau workspace is where your visualizations come to life. It might look a little busy at first, but it’s logically organized into a few key areas.

1. Data Pane (Left side): This is a list of all the fields (or columns) from your data source. Tableau automatically categorizes them into two types:
2. Shelves (Top): This section has the Columns and Rows shelves. You'll drag fields from the Data Pane onto these shelves to build the structure of your chart. What you put on Columns creates the x-axis, and what you put on Rows creates the y-axis.
3. Marks Card (Middle Left): This powerful card controls the visual details of your chart. You can drag fields here to control things like color, size, text labels, and the information that appears in tooltips.
4. Canvas (The large open space): This is where your chart or graph will appear as you build it.

Step 3: Build Your First Visualization (A Bar Chart)

Let's create a simple bar chart to see our total sales for each product category. Creating a visualization in Tableau is all about dragging and dropping fields (often called "pills") from your Data Pane onto the different shelves.

1. Select the fields: From the Data Pane, find your 'Product Category' dimension and your 'Sales' measure.
2. Drag and Drop:

Instantly, Tableau generates a vertical bar chart. It intelligently figures out that because you used a dimension and a measure, a bar chart is a good way to show the comparison.

Enhancing the Bar Chart

Now, let's add more context. A good visualization communicates clearly without making the user work too hard.

• Add Color: To make the bars stand out, let’s color them based on their sales value. Drag the 'Sales' measure again, but this time, drop it onto the Color button on the Marks card. The bars will now be shaded based on their value, with darker colors representing higher sales.
• Add Labels: To see the exact sales numbers, let's add labels to the bars. Drag the 'Sales' measure one more time and drop it onto the Label button on the Marks card. The sales figures will appear directly on your chart.

Finally, it's good practice to name your worksheets. Double-click the "Sheet 1" tab at the bottom and rename it to something descriptive, like "Sales by Category."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Build a Second Visualization (A Line Chart)

Reports are rarely a single chart. Let's create another one to add to our dashboard. This time, we'll build a line chart to see how our sales have trended over time.

1. Create a New Worksheet: Click the small icon next to your "Sales by Category" tab at the bottom (it looks like a bar chart with a plus sign) to create a new worksheet.
2. Drag and Drop:

Just like that, Tableau creates a line chart, recognizing that line charts are ideal for displaying data over time.

Adjusting Date Granularity

Seeing sales by year is good, but what if you want a more detailed view? Tableau makes this easy. Notice the 'YEAR(Order Date)' pill on the Columns shelf has a small '+' on it. Click that '+' to drill down to the next level of detail, which is Quarter. Click it again to see Months. You can also right-click the pill to choose the exact date level you want, such as 'Month' or 'Week'.

Let's set our view to be continuous 'Month'. Right-click the date pill, and under the second section, select 'Month'. This will give you a smooth line charting sales across all months in your data. Now, rename this worksheet to "Sales Trend."

Step 5: Assemble Your Dashboard ("The Report")

We now have two worksheets: "Sales by Category" and "Sales Trend." It's time to combine them into a single-view dashboard.

1. Create a New Dashboard: At the bottom of the screen, next to your worksheet tabs, is an icon that looks like a grid of four squares. Click it to create a new dashboard.
2. The Dashboard Interface: The view changes slightly. On the left, you'll see a list of your worksheets. The right is a blank canvas.
3. Drag Your Sheets: Simply click on your "Sales by Category" worksheet from the list and drag it onto the blank canvas. It will fill the entire space. Now, drag the "Sales Trend" worksheet and hover it over the right half of the canvas. You'll see a gray area appear. Drop it there. Tableau will automatically resize the two charts to fit side-by-side.

Just by dragging and dropping, you've created a dashboard that shows two different views of your sales data on one screen.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 6: Make Your Dashboard Interactive with a Filter

The true power of Tableau lies in interactivity. Let's add a filter that allows a user to view the sales data for specific regions.

1. Add the Filter: While viewing your dashboard, select one of the worksheets on the canvas (like "Sales by Category"). Click the small dropdown arrow that appears in its top right corner and go to Filters > Region.
2. Configure the Filter Card: A filter card for 'Region' will now appear on the right side of your dashboard, showing checkboxes for different regions. Right now, it only controls the "Sales by Category" chart.
3. Apply to All Worksheets: To make the filter control both charts, click the dropdown arrow on the filter card itself and select Apply to Worksheets > All Using This Data Source.

Now, try unchecking one of the regions in your filter. You'll see both the bar chart and the line chart update simultaneously to reflect your selection. This simple interactive element has transformed your static report into a dynamic analytical tool.

Step 7: Share Your Report

Once your dashboard is complete, you need to share it. You have several options:

• Packaged Workbook (.twbx): Use File > Save As... and select "Tableau Packaged Workbook (.twbx)". This bundles the dashboard and the source data into a single file that can be opened by anyone with Tableau Desktop or the free Tableau Reader.
• Export a Static Version: You can export your dashboard as a static image (Dashboard > Export Image...) or a PDF (File > Print to PDF...). This is useful for placing your report in presentations or emails, but you'll lose the interactivity.
• Publish to Tableau Server/Online: In a business setting, the most common method is publishing the dashboard to Tableau Server or Tableau Online. This makes your interactive report accessible to colleagues via their web browser, allowing them to explore the data in real-time.

Final Thoughts

In this guide, you've gone from a blank slate to a professional, interactive dashboard. You learned the fundamental workflow: connect to your data source, create individual visualizations on different worksheets, and then combine those sheets into a dynamic dashboard with filters. Mastering this process is the core foundation of becoming proficient with Tableau.

While creating custom reports in tools like Tableau offers endless possibilities, it can still take hours to learn the nuances of shelves, marks, and different chart types. We started Graphed because we wanted to give everyone access to powerful data analysis without the long journey. Simply connect your data sources, then describe what you want to see - "show me my sales compared to last quarter split by region," for example - and we instantly build the dashboard for you with live, updating data. Our goal is to empower you to answer your business questions in seconds, not hours.