Data Source Preview in Tableau
Learn how to inspect connected data in Tableau using the Data Source page. Understand data grids, metadata, field names, data types, table structures, and basic data preparation before creating visualizations.
1. Introduction to Data Source Preview
The Data Source page in Tableau allows users to inspect and understand data after connecting to a file, database, or other supported data source. It provides a preview of the records and fields available for analysis.
Before creating charts or dashboards, it is important to understand the structure of the connected dataset. The preview helps identify field names, data types, sample records, and possible data-quality issues.
Why Is Data Source Preview Important?
- Inspect records before beginning analysis.
- Understand the structure of connected tables.
- Verify field names and data types.
- Identify missing or unexpected values.
- Review relationships between connected tables.
- Perform basic data preparation before creating worksheets.
2. Understanding the Tableau Data Source Page
After connecting to a data source, Tableau opens the Data Source page. This page provides different areas for selecting tables, reviewing the data model, and inspecting the underlying records.
Conceptual layout of the Tableau Data Source page.
Main Areas
| Area | Purpose |
|---|---|
| Connections | Displays the connected files, databases, or other data sources. |
| Tables and Sheets | Displays available tables or sheets from the selected source. |
| Data Model Canvas | Allows users to add tables and define relationships or joins. |
| Data Preview Grid | Displays sample records and field values from the selected table. |
| Metadata Area | Helps inspect field names, roles, and data types. |
3. Working with the Data Preview Grid
The Data Preview Grid displays records from the selected table. Each column represents a field, and each row represents a record. It helps users understand the actual values stored in the dataset.
Example Sales Dataset
| Order ID | Region | Category | Sales | Profit |
|---|---|---|---|---|
| 1001 | East | Furniture | 1200 | 250 |
| 1002 | West | Technology | 2500 | 600 |
| 1003 | Central | Office Supplies | 800 | 120 |
| 1004 | South | Furniture | 1500 | -100 |
What Should You Check?
- Are the expected columns available?
- Are field names meaningful and understandable?
- Are numerical fields displaying numeric values?
- Are dates recognized correctly?
- Are there blank or null values?
- Are records duplicated or inconsistent?
4. Understanding Metadata
Metadata describes the structure and properties of data. In Tableau, metadata information helps users understand the fields available in a connected data source.
You can inspect field names, data types, default roles, and other available field properties. These details help determine how a field should be used in analysis.
| Metadata Property | Description | Example |
|---|---|---|
| Field Name | Name of a column in the dataset. | Customer Name |
| Data Type | Defines the kind of values stored in the field. | String, Number, Date |
| Role | Describes how Tableau categorizes a field. | Dimension or Measure |
| Geographic Role | Identifies geographical information when assigned. | Country, State, City |
| Default Properties | Controls certain default field behaviors. | Number Format, Aggregation |
5. Reviewing and Renaming Field Names
Field names should be clear and meaningful so that users can understand the purpose of each column. Sometimes source systems contain technical names that are difficult to understand.
Example: Field Name Improvement
| Original Field | Improved Display Name |
|---|---|
| cust_nm | Customer Name |
| ord_dt | Order Date |
| tot_sales | Total Sales |
| prod_cat | Product Category |
How to Rename a Field
- Open the Data Source page or worksheet Data Pane.
- Locate the field you want to rename.
- Right-click the field name.
- Select Rename.
- Enter a meaningful display name.
- Press Enter to apply the change.
6. Checking Data Types in the Preview
Tableau identifies data types to determine how values should be interpreted. Reviewing these types is important because an incorrect data type can affect calculations, filtering, sorting, and visualizations.
| Data Type | Example Field | Example Value |
|---|---|---|
| String | Customer Name | Rahul Sharma |
| Number (Whole) | Quantity | 25 |
| Number (Decimal) | Sales | 1250.75 |
| Date | Order Date | 2026-10-15 |
| Date & Time | Created At | 2026-10-15 10:30 |
| Boolean | Is Active | True / False |
How to Change a Data Type
- Locate the field in the Data Source page or Data Pane.
- Click the data type icon beside the field name.
- Select the correct data type from the available options.
- Verify that the values are interpreted correctly.
- Check the resulting worksheet behavior.
7. Understanding Tables in the Data Model
When working with multiple tables, Tableau allows users to build a data model on the Data Source page. Tables can be connected using relationships or combined through joins in the physical layer.
The logical layer represents tables and their relationships. Opening a logical table can reveal the physical layer, where joins and unions can be configured.
Conceptual example of two logical tables connected through a relationship.
8. Using Data Source Filters
Data Source Filters allow you to restrict the records available from a data source. They can be useful when you want to limit the dataset to a particular region, date range, or business category.
Example: Filter Orders by Region
- Open the Data Source page.
- Locate the Filters section, if available for the connection.
- Select Add to create a data source filter.
- Choose the Region field.
- Select the required region values.
- Apply the filter and inspect the resulting data.
Example Filter Requirement
Suppose a business wants to analyze only East and West region sales. A data source filter can restrict the available records to those selected regions.
This helps focus analysis on the required business segment instead of working with every record.
9. Complete Practical Workflow
Follow this workflow after connecting Tableau to a new dataset. It helps establish a consistent process for inspecting and preparing data before analysis.
Recommended workflow for inspecting a newly connected data source.
Step-by-Step Practice
- Launch Tableau Desktop or Tableau Public.
- Connect to an Excel or CSV sales dataset.
- Select the required sheet or table.
- Review the available columns in the preview grid.
- Verify data types for dates, numbers, and text fields.
- Rename unclear field names where appropriate.
- Inspect missing values and unexpected records.
- Review the data model if multiple tables are involved.
- Open a worksheet and begin creating visualizations.
10. Common Issues and Troubleshooting
1. Expected Columns Are Missing
Verify that you selected the correct sheet or table. Check whether the source file has changed or whether the required fields are present in the original dataset.
2. Incorrect Data Type
Inspect the field's data type and change it when necessary. Check for invalid or mixed values that may prevent correct interpretation.
3. Null Values in the Preview
Check the original source file to determine whether values are genuinely missing or whether the connector cannot interpret the source values correctly.
4. Duplicate Records
Inspect the source data and identify whether duplicate records are expected. Check the table structure and data-combination logic before removing records.
5. Incorrect Table Relationship
Verify that the selected relationship fields represent the same business entity and have compatible values.
6. Changes in the Source File Are Not Reflected
Check the connection type and refresh the data when required. Extract-based connections may need an extract refresh to reflect source changes.
11. Best Practices for Data Source Inspection
- Always inspect the source data before creating visualizations.
- Use meaningful and consistent field names.
- Verify date, number, and string data types.
- Check for missing, duplicate, and inconsistent values.
- Understand table relationships before combining data.
- Apply data source filters only when they match the analysis requirement.
- Keep a record of important data preparation decisions.
- Validate important totals against the original source whenever possible.
12. Practical Exercise
Exercise: Inspect a Sample Superstore Dataset
Connect Tableau to a Sample Superstore dataset and complete the following tasks.
- Connect to the Sample Superstore Excel file.
- Select the Orders sheet.
- Inspect the data preview grid.
- Identify the Order ID, Customer Name, Region, and Category fields.
- Verify the data types of Order Date, Sales, and Profit.
- Check for null values in important fields.
- Review the field names and rename unclear fields if needed.
- Open a worksheet and create a simple sales visualization.
- Compare the displayed totals with the source data.
13. Practice and Interview Questions
Q1. What is the Data Source page in Tableau?
The Data Source page is where users inspect connected data, select tables, review records, and prepare the data model before creating worksheets.
Q2. What is the Data Preview Grid?
It displays records and field values from a selected table or data source so users can inspect the data.
Q3. What is metadata in Tableau?
Metadata describes information about the dataset, including field names, data types, and field properties.
Q4. Why should we inspect data before creating dashboards?
Inspecting data helps identify missing values, incorrect data types, unexpected fields, and structural problems that could affect analysis.
Q5. What is a Data Source Filter?
A Data Source Filter restricts the records available from a data source based on specified conditions.
Q6. What is the difference between a logical and physical layer?
The logical layer represents tables and their relationships. The physical layer contains the underlying table combinations, including joins and unions.
Q7. Can we rename fields in Tableau?
Yes. Users can rename fields to provide meaningful display names without necessarily changing the original source column name.
14. Summary
The Data Source page is an important part of Tableau's data preparation workflow. It allows users to inspect connected datasets, review tables, understand the data model, and examine records before building worksheets and dashboards.
The Data Preview Grid provides a practical way to examine field values, while metadata information helps users understand field names, data types, and other properties. Reviewing these details can help identify missing values, inconsistent records, and incorrect data types early.
A careful data inspection process improves the reliability of Tableau analysis. By validating source data and understanding the data model before creating visualizations, users can build more accurate reports and meaningful dashboards.