Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

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.

Tableau - Data Source Connections Sample - Superstore Sheets Orders People Returns Data Model / Canvas Orders People Data Preview Grid Order ID Region Category Sales Profit 1001 East Furniture 1200 250 1002 West Technology 2500 600 1003 Central Office Supplies 800 120

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?
Tip: Inspect the data before creating worksheets. Finding structural problems early can prevent incorrect calculations and misleading visualizations.

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
Important: The exact metadata options available depend on the data source, connector, and Tableau version.

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

  1. Open the Data Source page or worksheet Data Pane.
  2. Locate the field you want to rename.
  3. Right-click the field name.
  4. Select Rename.
  5. Enter a meaningful display name.
  6. Press Enter to apply the change.
Best Practice: Use consistent naming conventions across your dataset. Clear names make worksheets, calculations, and dashboards easier to maintain.

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

  1. Locate the field in the Data Source page or Data Pane.
  2. Click the data type icon beside the field name.
  3. Select the correct data type from the available options.
  4. Verify that the values are interpreted correctly.
  5. Check the resulting worksheet behavior.
Warning: Changing a data type does not repair invalid source values automatically. Verify that the underlying values can be interpreted using the selected type.

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.

Tableau Data Model Orders Order ID Customer ID Customers Customer ID Customer Name Relationship Tables connected using matching fields

Conceptual example of two logical tables connected through a relationship.

Remember: Relationships and joins are not the same. Relationships keep logical tables separate in the model, while joins combine physical tables based on matching fields.

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

  1. Open the Data Source page.
  2. Locate the Filters section, if available for the connection.
  3. Select Add to create a data source filter.
  4. Choose the Region field.
  5. Select the required region values.
  6. 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.

1. Connect to Data Source 2. Select Tables or Sheets 3. Inspect Data Preview 4. Check Fields and Data Types 5. Prepare Data and Open Worksheet

Recommended workflow for inspecting a newly connected data source.

Step-by-Step Practice

  1. Launch Tableau Desktop or Tableau Public.
  2. Connect to an Excel or CSV sales dataset.
  3. Select the required sheet or table.
  4. Review the available columns in the preview grid.
  5. Verify data types for dates, numbers, and text fields.
  6. Rename unclear field names where appropriate.
  7. Inspect missing values and unexpected records.
  8. Review the data model if multiple tables are involved.
  9. 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.
Industry Tip: Data validation is an important part of business intelligence development. Incorrect source data can lead to misleading reports, even when the charts themselves are configured correctly.

12. Practical Exercise

Exercise: Inspect a Sample Superstore Dataset

Connect Tableau to a Sample Superstore dataset and complete the following tasks.

  1. Connect to the Sample Superstore Excel file.
  2. Select the Orders sheet.
  3. Inspect the data preview grid.
  4. Identify the Order ID, Customer Name, Region, and Category fields.
  5. Verify the data types of Order Date, Sales, and Profit.
  6. Check for null values in important fields.
  7. Review the field names and rename unclear fields if needed.
  8. Open a worksheet and create a simple sales visualization.
  9. 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.