Read Data into Tableau

Data Connection

Tableau refers to reading a data file as “connecting to the data”. A connection to the data file is required to read the data. However, the term connection alone does not adequately describe the process. Tableau does more than just connect to the data file. Once connected, it also reads the data into the current Tableau process for further analysis.

Open the Tableau app. The Connect tab in the left margin invites you to open a data file in a specified format, shown in Figure 1. Here, select an Excel formatted data file.

Figure 1: Connect to the data.

When installed, Tableau creates a My Tableau Repository folder in your Documents folder. You can also create folders (directories) in the repository, or anywhere else in you computer file directory. Here, I created a folder named data in addition to the Datasources folder that Tableau created, shown in Figure 2.

Figure 2: Locate the data file.

Click on Open to read the data table into Tableau. The Excel worksheet is named d, which is the name of the data table adopted by Tableau.

The data table is then automatically displayed in the Data Source window pane, which can be manually access by the tab of the same name in the lower-left corner of the Tableau window.

Field

Reference for a variable in the terminology of relational database, adopted also by Tableau .

The variables, or fields, are listed first. Following, the beginning rows of the data table are listed, shown in Figure 3.

Figure 3: Data display in the Data Source tab.

Not all data values were present in the original Excel data file.

Tableau missing data code

null a indicates a missing data value.

The blank cells in an Excel file are replaced with null for the Tableau representation.

Multiple Excel Worksheets

When Tableau accesses an Excel data file with multiple worksheets, the worksheets are listed and you need to select at least one as a data source. To select, drag the worksheet name into the center of the window.

Figure 4: An Excel data source with two worksheets.

Relational data base option

If you select more than one worksheet, Tableau provides the option of setting up a relational database in which the tables are related to each other by a unique ID shared by both tables.

When multiple data tables are selected, Tableau lists the tables under the Data tab by their names, shown in Figure 5. If only one day table is present, it is not named.

Figure 5: From multiple Excel worksheets, multiple data tables.

Next Step

The next step visualizes the data. To begin that analysis, open a new Tableau worksheet. Tableau prompts you for that step with the message in the lower-left corner of the data display window, show in Figure 6.

Figure 6: Prompt to open a new worksheet.

Click on Sheet1 and move on to data visualization. Return to the Data Source tab at any time to view the data.