How to Do Data Analysis in Tableau

Jumping into Tableau for the first time can feel like opening up the cockpit of a passenger jet - it's powerful, professional, and there are a lot of buttons. But you don't need a pilot's license to get started. The core of data analysis in Tableau is about asking questions and using the visual interface to find answers. This guide will walk you through the essential steps, from connecting your data to building an interactive dashboard that tells a clear story.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Getting Started: Connecting to Your Data

The first step in any analysis is getting your data into the application. When you open Tableau, you're greeted with a "Connect" pane on the left side of the screen. This is your gateway to your data, wherever it lives.

Tableau can connect to a surprising number of data sources. Some of the most common ones include:

• To a File: This is perfect for beginners. You can easily connect to Microsoft Excel files, CSV files (Comma Separated Values), text files, and more. Most data you get from app exports will be in one of these formats.
• To a Server: For more robust, live business data, you can connect directly to dozens of database servers, like MySQL, Amazon Redshift, PostgreSQL, or a Microsoft SQL Server.
• Saved Data Sources: Tableau can also save pre-configured connections to data sources you use often.

For this walkthrough, let's imagine we're connecting to a simple Excel file containing sales data. You'd click on "Microsoft Excel," navigate to your file, and open it. Once a connection is made, Tableau takes you to the Data Source page.

The Data Source Page: Live vs. Extract

On the Data Source page, you will see the sheets from your Excel file listed on the left. You can drag the sheet you want to analyze into the canvas area at the top of the window. Here, you'll see a preview of your data's columns and rows.

At the top right, you'll see a critical choice: Live vs. Extract.

• A Live connection means Tableau will query your original data source directly every time you make a change. This is great for data that changes constantly, but it can be slow if your data source is large or complex.
• An Extract connection creates a highly compressed snapshot of your data that is stored inside Tableau. This is often much faster and is the recommended option for most analyses, especially when working with flat files like Excel or CSVs. You can schedule the extract to refresh periodically (e.g., daily) to keep it up to date.

For now, select Extract and then click on "Sheet 1" at the bottom of the window to move into the main analytics workspace.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding the Tableau Workspace

This is where the magic happens. The Tableau workspace (or "worksheet") is intuitively designed once you understand its main components. Think of it as a canvas and your palette of an artist.

The Data Pane

On the left, you'll find the Data pane. Tableau automatically classifies each column from your data file into one of two categories:

• Dimensions (Blue): Think of these as your categorical data - the "who, what, where, and when" of your analysis. Examples include Product Name, Customer Segment, Region, or Order Date. They are typically used to slice and dice your numbers.
• Measures (Green): These are your numerical data - the metrics you want to aggregate. Examples include Sales, Profit, Quantity, or Customer Count. Tableau usually defaults to an aggregation like SUM or AVG when you use them.

This distinction between Dimensions and Measures is fundamental to how Tableau works and is what makes visualization so fast and easy.

Shelves and Cards

At the top and center of the workspace are the Columns and Rows shelves. This is where you drag your Dimensions and Measures to build the structure of your visualization. Whatever you place on Columns determines the columns in your chart, and whatever you place on Rows determines the rows.

Just below the shelves is the Marks Card. This powerful little box controls the visual details of your chart. You can drag fields here to encode them as:

• Color: Assign colors based on a dimension (e.g., blue for the 'Corporate' segment, orange for 'Consumer') or a measure (e.g., light blue for low profit, dark blue for high profit).
• Size: Adjust the size of data points based on a measure.
• Label: Display text labels directly on your marks.
• Detail: Add a more granular level of detail to the view without changing the overall structure.
• Tooltip: Customize the information that appears when you hover over a data point.

Building Your First Visualizations (The Fun Part)

Data analysis is an iterative process of asking questions and finding answers. Tableau's drag-and-drop interface is designed for exactly that. Let's build a few common charts with our sales data.

Example 1: Top-Selling Product Categories

Question: "Which product category generated the most sales?"

1. Drag the Category dimension (remember, this is our categorical data) from the Data pane onto the Columns shelf.
2. Drag the Sales measure (our numerical data) onto the Rows shelf.

Instantly, Tableau creates a vertical bar chart. It automatically summed the sales for each category and displayed it in a way that’s easy to compare. You have your answer already.

Refinement: Let's see profit too. Drag the Profit measure onto the Color card in the Marks Card. Now, each bar is colored based on its total profit, instantly adding another layer of insight. You might see a category with high sales but low, or even negative, profitability.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example 2: Sales Trend Over Time

Question: "How have our sales performed over the past two years?"

1. Drag the Order Date dimension onto the Columns shelf. Tableau will likely default it to YEAR(Order Date).
2. Drag the Sales measure onto the Rows shelf.

Tableau generates a line chart showing total sales by year. You can drill down for more detail by clicking the little "+" sign on the YEAR(Order Date) pill. This will expand it to show quarters, months, and days, letting you view trends at whichever level makes the most sense.

Digging Deeper with Filters and Calculations

Real analysis often requires more than just high-level charts. You'll need to focus on specific segments or create new metrics to uncover deeper insights.

Adding Filters

Filters allow you to include or exclude data from your view. It’s incredibly easy to do. Let's say you want to see the sales trend for just one region.

1. Find the Region dimension in the Data pane.
2. Drag it onto the Filters card (just above the Marks card).
3. A dialog box will appear showing all the regions in your data (e.g., West, East, Central, South). Check the boxes for the regions you want to see.
4. Click "OK." Your entire visualization will update to reflect only the data from the selected region(s).

Creating Calculated Fields

Sometimes, your data source won't have the exact metric you need. Tableau's Calculated Fields let you create new measures from your existing data using formulas, similar to Excel.

A classic example is creating a Profit Ratio.

1. Right-click anywhere in the Data pane and select "Create Calculated Field."
2. Give your calculation a name, like "Profit Ratio."
3. In the formula box, type the following:

SUM([Profit]) / SUM([Sales]) 

1. Click "OK."

You’ve just created a new field! You'll see "Profit Ratio" appear in the Data pane. Since it's a number, Tableau saves it as a measure. You can now drag this field into your visualizations just like any other, perhaps to color a map of states by their profitability.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Bringing It All Together in a Dashboard

A single chart (a "Worksheet" in Tableau) can answer one question, but a dashboard combines multiple worksheets to provide a comprehensive overview and tell a complete story.

1. Create a few different worksheets, each answering a different business question (e.g., one with sales by category, one sales overtime map, one profit ratio table).
2. Click the "New Dashboard" icon at the bottom of the window (the one with the four squares).
3. You'll see a blank dashboard canvas and a list of your worksheets on the left.
4. Simply drag and drop your worksheets onto the canvas. You can rearrange and resize them to create a clean, logical layout.

The best part of a Tableau dashboard is its interactivity. Select any worksheet on your dashboard and click the little "funnel" icon to enable "Use as Filter." Now, when you click on a bar in your "Sales by Category" chart, all the other charts on the dashboard will automatically filter to show data only for that category. This turns a static report into a dynamic analytical tool for anyone to explore.

Final Thoughts

Learning Tableau is about mastering a workflow: connect to data, ask a question, build a view to answer it, refine your view, and then combine those views into an interactive dashboard. While it takes practice to master all the features, this core process is what will allow you to turn mountains of raw data in spreadsheets and databases into actionable insights.

While Tableau is remarkably powerful, there's a definite learning curve to get good. We created Graphed because we believe getting insights shouldn't require weeks of training or manually constructing reports. Instead of learning where to drag and drop different fields, you just connect your marketing and sales data once - like Google Analytics, Shopify, or Facebook Ads - and ask your questions in plain English. Want to see sales by country as a map? Just type, "Show me a map of sales by country," and it's built for you instantly. We automate the report-building, so you can spend less time inside the software and more time making smart business decisions.