How to Analyze Data in Tableau

Jumping into Tableau for the first time can feel like stepping into the cockpit of a 747 - the potential is enormous, but the number of buttons, shelves, and panes can be intimidating. You have your data ready to go, but the path from a raw spreadsheet to a clear, actionable insight isn't always obvious. This guide will walk you through the fundamental steps of analyzing data in Tableau, from connecting your first data source to building visualizations that answer real business questions.

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

Before you can analyze anything, you need to bring your data into Tableau. The platform is incredibly flexible, connecting to everything from a simple Excel file on your desktop to complex SQL databases or cloud services like Google Analytics and Salesforce.

For most beginners, starting with a flat file like a CSV or Excel spreadsheet is the easiest way to get comfortable. Here’s how you do it:

1. Open Tableau Desktop. On the start page, you'll see a blue "Connect" pane on the left side.
2. Choose Your Connector. Under "To a File," you’ll find options like "Microsoft Excel," "Text File" (for CSVs), "PDF File," and more. Click on the one that matches your file type.
3. Select Your File. A file browser window will pop up. Navigate to where you saved your data file and open it.

Once connected, Tableau will take you to the Data Source page. Here, you'll see the tables or sheets from your file. You can drag the sheet you want to analyze onto the canvas. This is also where you can join different tables, clean up column headers, or change data types (e.g., telling Tableau that a column of numbers is actually a postal code, not a number to be summed up).

Live Connection vs. Extract: What's the Difference?

In the top right corner of the Data Source page, you’ll see an option for "Live" or "Extract."

• A Live connection queries your original data source directly. If your underlying spreadsheet or database is updated, Tableau will reflect those changes immediately. It's great for real-time data but can be slow if the data source is large or complex.
• An Extract takes a snapshot of your data and saves it as a highly compressed file (.hyper) within Tableau. Queries are much faster since Tableau is working with this optimized snapshot, not the original source. You can set the extract to refresh on a schedule to keep the data current. For most day-to-day analysis, using an extract is your best bet for better performance.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding the Tableau Workspace

After you’ve connected your data and selected a sheet to work with, click on "Sheet 1" at the bottom of the screen. This is where the magic happens. Let’s break down the main components of the worksheet.

The Data Pane

On the left, you'll see the Data Pane, which lists all the columns from your data source. Tableau automatically categorizes them into two types:

• Dimensions (Blue): These are qualitative or categorical fields. Think of them as the "who, what, and where" of your data. Examples include customer names, product categories, geographic regions, or dates. Dimensions are used to slice and dice your data. They're typically represented by blue pills when you drag them into your view.
• Measures (Green): These are quantitative, numerical fields that you can perform mathematical operations on. They are the "how much" and "how many" in your data. Examples include sales, profit, quantity, or website clicks. Tableau defaults to aggregating measures (e.g., SUM of Sales). They show up as green pills.

Shelves and Cards

At the top and center of your workspace are the "shelves" and "cards." This is where you build your visualization by dragging and dropping fields from the Data Pane.

• Columns and Rows Shelves: These are the most important shelves. Placing a field on the Columns shelf creates columns in your view, and placing a field on the Rows shelf creates rows. The combination of fields on these two shelves forms the basic structure of your visualization (like the X and Y axes of a chart).
• The Marks Card: This card controls the visual properties of the data points (or "marks") in your view. You can change the chart type (e.g., from Automatic to Bar, Line, or Square) and enhance your visualization by dragging fields to different properties like:
• The Filters Shelf: Drag any field here to filter the data shown in your view. For instance, you could filter your view to only show data for the last calendar year.

Finally, the large blank area is the Canvas or View, where your visualization comes to life as you add fields.

Performing Basic Analysis: Building Your First Viz

The best way to learn is by doing. Let's build a couple of simple but common charts to answer some basic business questions, assuming we're working with a typical retail sales dataset.

Example 1: Which Product Category Generates the Most Sales? (A Bar Chart)

This is a classic "category vs. number" question, which is a perfect use case for a bar chart.

1. From the Data Pane under Dimensions, find the "Category" field. Drag it and drop it onto the Columns shelf.
2. Under Measures, find the "Sales" field. Drag it and drop it onto the Rows shelf.

And that's it! Tableau instantly generates a vertical bar chart showing the total sales for each product category. To make it even clearer, you can click the "Sort" icon in the toolbar to arrange the bars from highest sales to lowest.

Example 2: How Have Our Profits Trended Over Time? (A Line Chart)

Analyzing performance over time is best done with a line chart.

1. Drag the "Order Date" dimension from the Data Pane onto the Columns shelf. By default, Tableau will probably show YEAR(Order Date).
2. Drag the "Profit" measure onto the Rows shelf.

Tableau automatically recognizes that you're working with time-series data and creates a line chart. Want more detail? You can click the little "+" sign on the YEAR(Order Date) pill to "drill down" to the Quarter, Month, and eventually the Day level.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Digging Deeper with More Advanced Features

Once you've mastered the basics, you can start layering on more information to uncover deeper insights.

Using the Marks Card to Add Context

Let's go back to our "Sales by Category" bar chart. Right now, it shows us which categories are the biggest revenue drivers. But are they also the most profitable?

Find the "Profit" measure in the Data Pane and drag it directly onto the Color property on the Marks card. Your bars will instantly be color-coded based on their profitability, with high-profit categories in one color and low-profit or even loss-making categories in another. Suddenly, you might see that your highest-selling category is actually one of your least profitable - a critical insight.

Creating Calculated Fields

Sometimes, the single field you need doesn't exist in your dataset. For example, we have Sales and Profit, but what we really want to see is the Profit Ratio (Profit / Sales). Tableau's calculated fields let you create new fields on the fly.

1. Right-click anywhere in the Data Pane and select "Create Calculated Field."
2. A dialog box will appear. Name your new field - something like "Profit Ratio."
3. In the formula box, type out the calculation. For Profit Ratio, it would be:

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

1. Click "OK." Your new "Profit Ratio" field will appear in the Data Pane.

You can now use this calculated field just like any other measure. Drag it to the Rows shelf, color, or use it to label your charts. Pro tip: right-click your new "Profit Ratio" pill, go to "Default Properties," then "Number Format," and set it to a percentage for easier reading.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Telling a Story with Dashboards

Individual visualizations are useful, but their real power is unlocked when you combine them into an interactive dashboard. A dashboard is a single canvas where you can arrange multiple worksheets and have them interact with each other.

For example, you could create a dashboard that includes:

• Your "Sales by Category" bar chart.
• Your "Profit Over Time" line chart.
• A map showing sales by state.

Once on the dashboard, you can enable interactivity. For example, click the "Use as Filter" icon on the map worksheet. Now, when a user clicks on a state (say, California), both the bar chart and the line chart will automatically update to show sales and profit data for only California. This allows users to explore the data for themselves and uncover their own insights.

Final Thoughts

Analyzing data in Tableau is a process of discovery. It’s about dragging and dropping dimensions and measures to see what patterns emerge, then iteratively adding filters, colors, and calculated fields to refine your view and answer deeper questions. The journey from a grid of numbers to a powerful, interactive dashboard is what makes it such a valuable skill for anyone in a data-driven role.

While mastering tools like Tableau unlocks incredible analytical power, the process of configuring data sources, building visualizations, and writing custom calculations can be time-consuming, especially for those just starting out. Here at Graphed, we’ve streamlined this process by making it conversational. Instead of building reports manually, you can simply ask your data questions in plain English - like "create a dashboard comparing Facebook Ads spend vs revenue by campaign" - and get a live, interactive visualization in seconds, connecting all your data sources automatically.