Tableau Interface
Tableau Interface Interview with follow-up questions
1. Can you describe the main components of the Tableau interface?
The Tableau Desktop interface is organized into several key areas:
Menu Bar: Provides access to file management, data connections, worksheet options, and server publishing commands.
Toolbar: Quick-access icons for common actions — undo/redo, save, add data source, swap axes, sort, and show/hide cards and shelves.
Data pane (left sidebar, Data tab): Lists all connected data sources along with their fields, split into Dimensions (blue) and Measures (green). Custom calculated fields and parameters also appear here.
Analytics pane (left sidebar, Analytics tab): Drag-and-drop access to statistical overlays such as trend lines, reference lines, box plots, forecasts, and cluster analysis.
Shelves (Rows and Columns): The horizontal and vertical axes of the view. Fields dropped here define the structure of the chart — which dimensions segment the data and which measures determine size or position.
Marks card: Controls how data is visually encoded. Includes a mark-type selector (bar, line, circle, map, text, etc.) and encoding slots for Color, Size, Label, Detail, and Tooltip.
Filters shelf: Fields added here filter the data in the current view. Right-clicking a filter allows showing it as an interactive control on the dashboard.
Pages shelf: Adds a playback control for animating the view across the values of a dimension (e.g., stepping through years).
View canvas: The central area where the visualization renders. Tooltips, selections, and highlighting are all interactive here.
Sheet tabs: Along the bottom, tabs for individual worksheets, dashboards, and stories within the workbook.
Status bar: Displays the number of marks, row count, and active data source information at the bottom of the screen.
Follow-up 1
What is the purpose of the Data Pane?
The Data Pane in Tableau is used to manage and explore the data sources and fields available for analysis. It allows users to:
Connect to different data sources and import data into Tableau.
View and navigate through the tables and fields in the data source.
Drag and drop fields onto shelves or directly onto the worksheet to create visualizations.
Rename, group, filter, sort, and aggregate fields to manipulate the data.
Create calculated fields and parameters to perform advanced calculations and analysis.
Define relationships between multiple data sources, if applicable.
Follow-up 2
How do you use the Data Source Page?
The Data Source Page in Tableau is used to manage the data source and perform various data preparation tasks. Here's how you can use it:
Connect to a data source: Click on the 'Connect to Data' button and choose the desired data source type.
Import data: Select the tables or files you want to import and specify any necessary connection details.
Join or blend data: If you have multiple tables or data sources, you can join them based on common fields or blend them together.
Clean and transform data: Use the data preparation tools in Tableau to clean, filter, pivot, split, or aggregate the data as needed.
Define relationships: If you have multiple data sources, you can define relationships between them to enable cross-database joins.
Refresh data: If your data source is live or connected to a data server, you can refresh the data to get the latest updates.
Follow-up 3
What are the different shelves and cards in the Tableau interface?
In the Tableau interface, there are several shelves and cards that are used to define the visual encoding of the data and provide additional options and settings. Here are the main ones:
Columns Shelf: It is used to place dimensions or measures that define the columns of the visualization.
Rows Shelf: It is used to place dimensions or measures that define the rows of the visualization.
Marks Card: It is used to control the appearance and behavior of the marks (data points) in the visualization.
Filters Shelf: It is used to apply filters to the data, restricting what is shown in the visualization.
Pages Shelf: It is used to create a series of visualizations based on a specific field, allowing you to animate the data over time.
Tooltip Card: It is used to customize the tooltips that appear when hovering over marks in the visualization.
Color, Size, and Label Cards: They are used to control the visual encoding of the marks based on specific fields.
Follow-up 4
How do you navigate between worksheets and dashboards in Tableau?
To navigate between worksheets and dashboards in Tableau, you can use the following methods:
Worksheet Tabs: At the bottom of the Tableau interface, there are tabs for each open worksheet. Click on a tab to switch to that worksheet.
Dashboard Tabs: If you have created dashboards, you can switch between them using the dashboard tabs located next to the worksheet tabs.
Navigation Buttons: In the toolbar, there are navigation buttons (Back, Forward, Home) that allow you to navigate through the history of worksheets and dashboards you have visited.
Go to Sheet: In the Worksheet menu, there is an option called 'Go to Sheet' that allows you to quickly navigate to a specific worksheet or dashboard by name.
Table of Contents: If you are in a dashboard, you can use the Table of Contents pane on the left side to navigate to different worksheets or objects within the dashboard.
2. How do you import data into Tableau?
Tableau provides multiple methods for importing and connecting to data:
File-based sources: Connect directly to Excel workbooks, CSV/TSV files, JSON, PDF tables, spatial files (.shp, .kml), and statistical files (SAS, SPSS, R). Open the Start page, click the file type under "To a File," and browse to the file location.
Relational databases: Use built-in connectors for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Teradata, Amazon Redshift, Google BigQuery, Snowflake, and many others. Provide the server address, port, database name, and credentials to establish the connection.
Cloud applications and SaaS sources: Native connectors exist for Salesforce, Google Analytics, Google Sheets, ServiceNow, Marketo, and similar platforms. OAuth is used for authentication where supported.
Tableau Server / Tableau Cloud published data sources: Connect to centrally governed, certified data sources that have already been published by your data team. This promotes consistency and reduces redundant connections across workbooks.
Web Data Connector (WDC): A JavaScript-based framework that allows developers to build custom connectors for web APIs or other HTTP-accessible data. WDC v2 is widely used for sources without a native connector.
Tableau Prep Builder: For data that requires cleaning or reshaping before analysis, Prep Builder is the recommended entry point. Flows output cleaned datasets that can then be connected to in Tableau Desktop.
After establishing a connection, you can switch between live connection mode (queries run against the source in real time) or create a Hyper extract (.hyper) for faster, offline-capable analysis.
Follow-up 1
What types of data can you import?
Tableau supports importing a wide range of data types. Some of the common data types that can be imported into Tableau include:
- Excel files (.xls, .xlsx)
- CSV files (.csv)
- JSON files (.json)
- Text files (.txt)
- Access databases (.mdb, .accdb)
- SQL databases (MySQL, SQL Server, Oracle, etc.)
- Cloud-based data sources (Google Sheets, Salesforce, etc.)
- Big data sources (Hadoop, Amazon Redshift, etc.)
These are just a few examples, and Tableau provides support for many other data types as well.
Follow-up 2
Can you explain the process of connecting to a database?
To connect to a database in Tableau, follow these steps:
Open Tableau Desktop and click on the "Connect to Data" button.
In the "Connect" pane, select the type of database you want to connect to (e.g., MySQL, SQL Server, Oracle, etc.).
Enter the necessary connection details such as server name, port, database name, username, and password.
Click on the "Sign In" or "Connect" button to establish the connection.
Once connected, you can select the tables or views you want to import into Tableau and customize the data import settings.
Finally, click on the "Sheet" tab to start analyzing and visualizing the imported data.
Follow-up 3
What is the difference between a live connection and a data extract?
In Tableau, a live connection and a data extract are two different ways of connecting to data:
Live Connection: With a live connection, Tableau directly connects to the data source in real-time. Any changes made to the data source will be immediately reflected in Tableau. However, a live connection requires a stable and fast network connection to the data source.
Data Extract: A data extract is a subset of the data source that is imported and stored in Tableau's proprietary format (.tde or .hyper). It allows for faster performance and offline access to the data. Data extracts can be refreshed on a schedule or manually.
The choice between a live connection and a data extract depends on factors such as data size, performance requirements, and network availability.
Follow-up 4
How do you refresh data in Tableau?
To refresh data in Tableau, you can use the following methods:
Manual Refresh: You can manually refresh the data by right-clicking on a data source in the "Data" pane and selecting "Extract" > "Refresh".
Scheduled Refresh: You can schedule automatic data refreshes at specific intervals. This can be done by going to the "Server" menu and selecting "Schedules & Extracts" > "Extract Refreshes".
Refresh on Open: You can configure Tableau to automatically refresh the data whenever a workbook is opened. This can be done by going to the "Server" menu and selecting "Schedules & Extracts" > "Refresh on Open".
These options allow you to keep your data up-to-date and ensure that your visualizations reflect the latest information.
3. What is the role of the workspace in the Tableau interface?
The workspace in Tableau is the central authoring environment where all analysis and visualization creation takes place. It consists of three main workspace areas:
Worksheets are the foundational building blocks. Each worksheet contains a single view built by placing fields on shelves and the Marks card. Worksheets hold the logic for one chart, table, or map, and they connect directly to a data source.
Dashboards are composition canvases where multiple worksheets and other objects (text, images, web pages, buttons) are arranged into a cohesive, interactive layout. Dashboard actions — filter actions, highlight actions, and URL actions — wire views together so that interacting with one chart updates another.
Stories are a presentation layer that sequences worksheets and dashboards into a narrative, using "story points" to walk an audience through an analytical conclusion step by step.
Within each worksheet, the workspace is subdivided into functional zones: the Rows and Columns shelves define the chart structure; the Marks card controls visual encoding; the Filters and Pages shelves modify what data is shown and how it animates. The view canvas in the center renders the visualization and supports direct user interaction such as clicking, hovering, and selecting marks.
In practice, the workspace is designed so analysts can iterate rapidly: changing what is on a shelf immediately re-queries the data and updates the view, making exploration fast and exploratory.
Follow-up 1
How do you customize the workspace?
You can customize the workspace in Tableau by rearranging and resizing the various panes and windows. To customize the workspace, you can drag and drop panes to different locations, resize panes by dragging their edges, and hide or show specific panes using the View menu. You can also save your customized workspace as a layout and switch between different layouts as needed.
Follow-up 2
What are the different views available in the workspace?
Tableau provides several views in the workspace to help you analyze and visualize your data. The main views include:
Data Source View: This view allows you to connect to data sources, join tables, and perform data preparation tasks.
Worksheet View: This view is where you create visualizations by dragging and dropping fields onto shelves and configuring their properties.
Dashboard View: This view allows you to combine multiple worksheets and other objects into a single interactive dashboard.
Story View: This view enables you to create a sequence of visualizations and annotations to tell a data-driven story.
Follow-up 3
How do you use the toolbar in the workspace?
The toolbar in the Tableau workspace provides quick access to various tools and commands. It includes buttons for common actions such as connecting to data, saving workbooks, refreshing data, and undoing or redoing actions. The toolbar also contains options for selecting different views, switching between worksheets and dashboards, and accessing additional features like formatting, filtering, and sorting data.
Follow-up 4
Can you explain how to use the status bar in the workspace?
The status bar in the Tableau workspace displays information about the current state of your workbook and provides quick access to certain settings. It shows details such as the number of records in the data source, the time taken to execute queries, and the status of data updates. You can also use the status bar to change the aggregation level of measures, switch between different data sources, and access options for data blending and data source filters.
4. Can you explain how to use the sidebar in the Tableau interface?
The left sidebar in Tableau Desktop contains two main panes that you toggle between using the tabs at the top:
Data pane: This is the primary panel for working with your data. It shows:
- All connected data sources (switch between them if multiple are connected).
- Dimensions (blue fields): categorical, qualitative fields like names, dates, and IDs that segment data.
- Measures (green fields): numerical fields that Tableau aggregates by default (SUM, AVG, COUNT, etc.).
- Calculated fields and parameters you have created appear here alongside source fields.
- Right-click any field to rename it, change its data type, create a calculated field, add to hierarchy, or convert between dimension and measure.
Analytics pane: Provides drag-and-drop access to analytical overlays without requiring any calculation authoring:
- Summarize: Constant line, average line, median with quartiles, box plot, totals.
- Model: Trend line (linear, logarithmic, exponential, polynomial, power), forecast, average with 95% CI.
- Custom: Reference line, reference band, distribution band, box plot. Drag an item from the Analytics pane onto the view canvas and Tableau prompts you to configure it (scope, color, label, etc.).
Additionally, the sidebar area around the canvas includes the Marks card, Filters shelf, and Pages shelf, which control visual encoding, data filtering, and animation respectively. These are technically part of the worksheet layout rather than the sidebar itself, but they work closely with the Data and Analytics panes during authoring.
Follow-up 1
What is the purpose of the Data pane in the sidebar?
The Data pane in the sidebar is used to connect to data sources, view and manage data tables, and define relationships between tables. It provides a comprehensive view of the data that you have connected to Tableau. From the Data pane, you can perform various actions such as:
- Connecting to different data sources
- Adding or removing tables
- Creating calculated fields
- Defining relationships between tables
- Renaming fields
- Sorting and filtering data
The Data pane is an essential tool for data preparation and exploration in Tableau.
Follow-up 2
How do you use the Analytics pane?
The Analytics pane in the sidebar provides access to various analytical functions and features in Tableau. To use the Analytics pane, follow these steps:
- Open the Analytics pane by clicking on the Analytics tab in the sidebar.
- Select the visualization or chart type you want to create.
- Drag and drop the required fields from the Data pane onto the view.
- Customize the analytics options by selecting the desired options from the Analytics pane.
- Explore the different options available, such as trend lines, reference lines, forecasting, clustering, and more.
The Analytics pane allows you to enhance your visualizations with advanced analytics and statistical features.
Follow-up 3
What are the different options available in the Pages shelf?
The Pages shelf in the sidebar allows you to create animated visualizations by adding different dimensions or measures to create a story or narrative. Some of the options available in the Pages shelf include:
- Dragging a dimension or measure to the Pages shelf to create a page-by-page view of the data.
- Using the play button to animate the visualization and see how the data changes over time.
- Adding filters to the Pages shelf to control which data is displayed on each page.
- Customizing the page transitions and duration.
The Pages shelf is useful for creating dynamic visualizations that show changes over time or other dimensions.
Follow-up 4
Can you explain how to use the Filters shelf?
The Filters shelf in the sidebar allows you to apply filters to your data, enabling you to focus on specific subsets of your data. To use the Filters shelf, follow these steps:
- Open the Filters shelf by clicking on the Filters tab in the sidebar.
- Drag and drop the desired fields from the Data pane onto the Filters shelf.
- Customize the filter options by selecting the desired options from the Filters shelf.
- Explore the different filter types, such as categorical filters, range filters, and relative date filters.
- Apply the filters to your visualization to see the data subset.
The Filters shelf is a powerful tool for data exploration and analysis in Tableau.
5. How do you use the Marks card in the Tableau interface?
The Marks card is one of the most important controls in Tableau — it determines how data is visually encoded in the view. Here is how each part of it is used:
Mark type selector (dropdown at the top): Choose the chart type — Automatic, Bar, Line, Area, Circle, Square, Shape, Text, Map, Pie, Gantt Bar, Polygon, or Density. Tableau selects Automatic by default based on the fields in the view, but you can override it.
Color: Drag a dimension here to color-code marks by category, or drag a measure to apply a continuous color gradient. Use the color legend that appears to customize the palette, set opacity, or add borders to marks.
Size: Drag a measure here to scale marks proportionally (useful in bubble charts or symbol maps). Adjust the size range with the size slider that appears in the legend.
Label: Drag a field here to annotate marks with text values. Control font, alignment, and whether labels show on all marks or only selected ones via the Label options.
Detail: Drag a dimension here to increase granularity of the view without changing any visual property. This is useful when you need finer-grained tooltips or calculations without cluttering the chart.
Tooltip: Drag additional fields here to include them in the hover tooltip without affecting the visualization itself. You can also click "Tooltip" to write rich, formatted tooltip text with inserted field values, or embed another sheet as a viz-in-tooltip.
Shape (when mark type is Shape): Drag a dimension to map different shapes to its members — useful for scatter plots where you want both color and shape encoding to differentiate categories.
A common interview point: fields placed on the Marks card at the Detail slot affect the level of detail of the view without adding visual encoding, which is distinct from using LOD expressions.
Follow-up 1
What are the different options available in the Marks card?
The Marks card in Tableau provides several options to customize the visual properties of the marks:
- Shape: This option allows you to change the shape of the marks, such as circles, squares, or custom shapes.
- Color: This option allows you to assign colors to the marks based on a specific field or measure.
- Size: This option allows you to adjust the size of the marks based on a specific field or measure.
- Detail: This option allows you to add additional levels of detail to the marks, such as labels or tooltips.
- Label: This option allows you to add labels to the marks, displaying specific information about each data point.
- Tooltip: This option allows you to customize the tooltip that appears when you hover over a mark.
Follow-up 2
How do you use the Color shelf in the Marks card?
The Color shelf in the Marks card is used to assign colors to the marks in a visualization. To use the Color shelf:
- Drag a field or measure to the Color shelf.
- Tableau will automatically assign colors to the marks based on the values in the selected field or measure.
- You can customize the colors by clicking on the Color shelf and selecting 'Edit Colors'. This allows you to choose a different color palette or define custom colors.
- You can also use the Color shelf to create color legends, which provide a visual representation of the color encoding in the visualization.
Follow-up 3
Can you explain how to use the Size shelf in the Marks card?
The Size shelf in the Marks card is used to adjust the size of the marks in a visualization. To use the Size shelf:
- Drag a field or measure to the Size shelf.
- Tableau will automatically adjust the size of the marks based on the values in the selected field or measure.
- You can customize the size range by clicking on the Size shelf and selecting 'Edit Sizes'. This allows you to define the minimum and maximum size of the marks.
- You can also use the Size shelf to create size legends, which provide a visual representation of the size encoding in the visualization.
Follow-up 4
What is the purpose of the Detail shelf in the Marks card?
The Detail shelf in the Marks card is used to add additional levels of detail to the marks in a visualization. It allows you to include more information about the data points without cluttering the visualization. To use the Detail shelf:
- Drag a field or measure to the Detail shelf.
- Tableau will add the selected field or measure as an additional level of detail to the marks.
- You can customize the level of detail by clicking on the Detail shelf and selecting 'Edit Details'. This allows you to choose which fields or measures should be included in the detail.
Live mock interview
Mock interview: Tableau Interface
- Read your scene and goals
- Talk it out; goals tick off live
- Get a score and stronger lines
Your voice and your AI key never touch our servers; the key stays in this browser and is sent only to Google. Only your round scores are saved to track progress.