How to View Data Source in Tableau

Viewing your data source in Tableau is the first and most critical step in any analysis. Before you create a single chart, understanding the structure, quality, and composition of your data on the Data Source page is essential for building accurate and effective visualizations. This article will guide you through exactly how to view and manage your data source in Tableau, breaking down each component of the interface and providing practical tips for data preparation.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is the Tableau Data Source Page?

The Data Source page is your central hub for data preparation inside Tableau. Immediately after you connect to a new data set - whether it's an Excel file, a text file, or a direct connection to a database like SQL Server - Tableau brings you to this screen. It's much more than just a simple preview, it's an interactive workspace where you can see all the tables in your connection, establish how they should be combined, and perform initial cleaning and metadata management tasks.

Think of it as the kitchen where you prepare your ingredients before you start cooking. Here, you can:

• View the columns and first few thousand rows of your data.
• Join or relate different data tables together.
• Union files to stack them on top of each other.
• Change data types (e.g., from a number to a string).
• Rename columns for clarity.
• Hide unnecessary fields.
• Create basic calculations.
• Choose between a live connection and a Tableau data extract.

Taking a few moments to inspect and organize your raw data on this page will save you countless headaches once you move into the worksheet view to build your dashboards.

How to Get to the Data Source Page

There are two primary ways you'll access the Data Source page. Which one you use depends on whether you're starting a new project or working on an existing one.

When Creating a New Connection

This is the most common scenario. When you open Tableau Desktop, you're immediately prompted to connect to data.

1. On the startup screen, under the Connect pane on the left, select the type of file or server you want to connect to. Let's use Microsoft Excel as an example.
2. A file explorer window will open. Navigate to and select your Excel file, then click Open.
3. Tableau will instantly connect to the file and automatically take you directly to the Data Source page. You don't need to do anything else!

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

From an Existing Worksheet

If you're already building visualizations in a worksheet and need to go back and check your data structure, you can easily navigate back to the Data Source page.

1. Look at the bottom left corner of the Tableau window.
2. You will see a series of tabs. The first one is labeled Data Source. Others will be your worksheets ("Sheet 1", "Sheet 2", etc.) and dashboards.
3. Click the Data Source tab. You will be taken back to the data preparation view for that specific connection.

You can seamlessly switch back and forth between your data source and your worksheets at any time.

The Anatomy of the Data Source Page

The Data Source page is divided into a few key areas, each with a specific purpose. Understanding how they work together is crucial for effective data preparation.

1. The Left Pane: Connections and Tables

On the far left, you'll see information about what you're connected to.

• Connections: This section lists the data sources you are currently connected to in this workbook. You can add more than one connection if you need to blend data from, for example, an Excel file and a SQL Server database.
• Sheets/Tables: Below your connection details, you'll see a list of the available tables. For an Excel workbook, these will be the individual sheets. For a database, they will be the tables within that database. You can drag these tables into the canvas to start modeling your data.

2. The Top Pane: The Canvas

The canvas is the large, open area at the top where you build your data model. This is where you tell Tableau how your tables fit together.

The Logical Layer (Relationships)

When you drag your first table onto the canvas, you are working in the logical layer. If you drag a second table that has a field in common with the first (like an "Order ID"), Tableau will automatically connect them with a flexible line called a "noodle." This creates a relationship. Relationships are Tableau's default, modern way of combining data. They're smart and flexible, acting like contextual joins that only pull in data from related tables when it’s actually needed by a specific visualization. This often leads to better performance.

The Physical Layer (Joins)

If you need more direct control, you can define traditional joins. Double-click the first logical table in the canvas to open the physical layer. Here, you can drag another table and create a specific join type: Inner, Left, Right, or Full Outer. This physically merges the tables into a single, wider table based on your join condition. Use this when you have a specific, rigid requirement for matching records that a relationship can't handle.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. The Bottom Pane: The Data Grid

Below the canvas, you will see a preview of your data's structure and contents. This grid dynamically updates to reflect the model you've built in the canvas.

Data Type Icons

At the top of each column header, you'll see a small icon representing the data type Tableau has assigned to that field.

• Abc: String (text) data
• #: Numeric data
• 🗓️: Date or DateTime data
• 🌐: Geographic data (e.g., Country, State, Zip Code)
• T|F: Boolean (True/False) data

You can click this icon to quickly change the data type if Tableau has misidentified it. For example, if a Zip Code field with leading zeros is classified as a number (which strips the zeros), you can change it to a string here to preserve them.

Column Management

Clicking the small downward arrow on any column header reveals a dropdown menu with several useful data management options:

• Rename: Change the column's name to something more intuitive for your analysis. For example, rename Cust_ID to Customer ID.
• Hide: Remove the column from view if you don’t need it for your dashboard. This doesn't delete the data but declutters the Data pane in your worksheet.
• Create Calculated Field: Build a new column based on a calculation using other fields.
• Split / Custom Split: A fantastic feature for parsing data. If you have a column like "First Name-Last Name," you can use "Split" to automatically create two new columns: one for first names and one for last names.

4. The Top-Right: Connection Settings

Finally, in the top-right corner, you’ll find two of the most important settings that affect your dashboard’s performance and data freshness.

Live vs. Extract

This setting controls how Tableau queries your data.

• Live: A live connection sends queries directly to your source database every time you interact with your dashboard (e.g., change a filter). This means your data is always 100% current. However, if the database is slow or large, your dashboard's performance can suffer.
• Extract: An extract takes a full or partial snapshot of your data and saves it in a highly optimized file format (.hyper) on your computer or Tableau Server. Dashboards built on extracts are usually extremely fast because Tableau is querying this optimized local file, not the original database. The tradeoff is that the data is only as fresh as your last refresh.

General guideline: Use a live connection if your data is small or if having real-time information is absolutely critical. For large data sets or to maximize performance, an extract is almost always the better choice.

Practical Tips for the Data Source Page

Getting in the habit of doing a few simple checks here will make your analysis much smoother.

Tip 1: Always Sanity-Check Your Data

Before doing anything else, scroll through the data grid. Are customer names appearing correctly? Do sales numbers look plausible? Are the dates in the expected format? A quick visual inspection can help you spot missing values (nulls) or formatting errors right away.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Tip 2: Rename Awkward Field Names

Databases often have column names like SALE_AMT or trx_date. Rename them to readable names like Sales Amount and Transaction Date immediately. This makes building visualizations far more intuitive for you and anyone else who uses your workbook.

Tip 3: Hide Columns You Don't Need

Your data source might have dozens of columns, but you may only need ten of them. Hide the unnecessary fields (like record_id or meta-fields you'll never use). This will result in a much cleaner Data pane in your worksheet, making it easier to find the fields you actually care about.

Tip 4: Correct Mismatched Data Types

This is a common issue. Check that your geographic fields (like countries or states) have a globe icon so they can be used for maps. Confirm that fields containing dates are correctly identified as dates. Fixing these issues on the Data Source page prevents unexpected errors when you start creating charts.

Final Thoughts

The Data Source page is the foundation of every Tableau project. By mastering this critical workspace, you can ensure your data is clean, well-structured, and ready for analysis before you ever drag a field onto a worksheet. Taking the time to properly set up your connections, joins, data types, and field names here is a fundamental best practice that separates good analysts from great ones.

We know that even before you get to Tableau, the biggest challenge is often just pulling and consolidating all your data in one place. At Graphed you connect directly to platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce. Your data is unified for you so you can ask business questions in simple language and get real-time dashboards and reports instantly, skipping the tedious manual export and cleaning process entirely.