Introduction to Tableau

• A. To write server-side application code
• B. To create interactive data visualizations and dashboards ✓
• C. To manage relational database schemas
• D. To design vector graphics for print publishing

Why: Tableau is a business intelligence and data visualization tool designed to help users connect to data and create interactive charts, graphs, and dashboards for analysis and storytelling.

• A. Data extract
• B. Packaged workbook ✓
• C. Data source
• D. Calculated field

Why: A packaged workbook (.twbx) bundles the workbook with its data sources and any local files, making it portable. A .twb file, by contrast, stores only the workbook definition and references its data sources.

• A. Dimensions are numeric and measures are text
• B. Dimensions are categorical fields used to segment data, while measures are numeric fields that are aggregated ✓
• C. Dimensions can only come from Excel, measures only from SQL databases
• D. There is no difference; the terms are interchangeable

Why: Dimensions hold qualitative or categorical values such as names, dates, and regions that organize data, while measures hold quantitative values such as sales or quantity that Tableau typically aggregates like SUM or AVG.

• A. Real-time data updates on every interaction
• B. A compressed, in-memory snapshot of data that can improve performance ✓
• C. Automatic writing of changes back to the source database
• D. Permanent deletion of the original source data

Why: Extracts are a snapshot of the data stored in Tableau's optimized .hyper format. They are often faster for large datasets and work offline, but they do not update in real time unless refreshed.

• A. The Marks card
• B. The Filters shelf
• C. The Data pane ✓
• D. The Story points pane

Why: The Data pane, located on the left side of the Tableau workspace, displays all the tables and fields from your connected data sources, which you drag onto shelves to build views.

• A. .twb
• B. .tds ✓
• C. .tfl
• D. .hyper

Why: A .tds file is a Tableau Data Source file that stores connection information and metadata, so it can be reused across workbooks. A .twb is a workbook, .tfl is a flow file, and .hyper is a data extract format.

• A. A live connection stores a snapshot of the data inside Tableau, while an extract queries the database each time
• B. A live connection queries the source data in real time, while an extract is a stored copy of the data loaded into Tableau ✓
• C. A live connection only works with Excel files, while an extract works with all databases
• D. There is no difference; the two terms are interchangeable

Why: A live connection sends queries to the source every time the view updates, reflecting current data. An extract is a compressed snapshot saved in Tableau's .hyper format, which can improve performance and works offline.

• A. It automatically creates charts from the dataset
• B. It detects and cleans up messy Excel-style spreadsheets with headers, subheaders, and footnotes ✓
• C. It converts text fields into numeric fields
• D. It joins two tables based on matching column names

Why: Data Interpreter analyzes spreadsheets that contain formatting such as multiple header rows, blank rows, and notes, and reshapes them into a clean table that Tableau can use.

• A. Permanently editing values in the original source database
• B. Creating a new field by applying formulas to existing fields in the data ✓
• C. Changing the color of data marks in a view
• D. Setting the sort order of a dimension

Why: Calculated fields let you create new values using formulas, such as combining first and last name or computing profit margin. They do not modify the original source data.

• A. The alphabetical order of the table names
• B. The join clause, which specifies the fields that must match between the tables ✓
• C. The number of columns in each table
• D. The date each table was created

Why: A join clause defines the matching fields, such as CustomerID in both tables. Tableau combines rows where those join field values are equal, according to the join type selected.

• A. Drag the field into the Filters shelf
• B. Drag the field into the Columns shelf ✓
• C. Double-click the field in the Data pane to open a dialog box
• D. Right-click the field and select Hide

Why: Dragging a field onto the Columns shelf is a standard way to assign it to the horizontal axis of a view, which is a foundational step in building basic charts in Tableau.

• A. Marks card
• B. Filters shelf
• C. Rows and Columns shelves ✓
• D. Pages shelf

Why: The Rows and Columns shelves determine how data is positioned on the vertical and horizontal axes, respectively, defining the structure of the chart.

• A. Line chart
• B. Scatter plot
• C. Bar chart ✓
• D. Histogram

Why: Bar charts display categorical data with rectangular bars whose lengths are proportional to values, making them ideal for comparing quantities across categories.

• A. Size ✓
• B. Label
• C. Detail
• D. Tooltip

Why: Dragging a field to the Size property in the Marks card changes the size of marks according to the field's values, though Color is also a common encoding; Size specifically adjusts mark dimensions.

• A. Proportions of a whole
• B. Trends over time ✓
• C. Exact individual values only
• D. Geographic locations

Why: Line charts connect data points in sequence, making them well suited for showing how a measure changes over a continuous time dimension.

• A. Measure
• B. Dimension ✓
• C. Calculated field
• D. Parameter

Why: Dimensions are categorical or qualitative fields (like names, dates, or regions) that Tableau uses to break down and group data, forming the rows and columns of a view.

• A. Customer ID
• B. Order Date
• C. Sales ✓
• D. State

Why: Measures are numeric fields that can be aggregated, such as Sales, Profit, or Quantity. Sales is a numeric value that Tableau sums, averages, or counts by default.

• A. Average
• B. Count
• C. Maximum
• D. Sum ✓

Why: Tableau applies SUM as the default aggregation to numeric measures, so dragging Sales onto the view will show the total sales for each category.

• A. Tableau removes the dimension from the data source
• B. Tableau assigns a distinct color to each member of the dimension ✓
• C. Tableau converts the dimension into a measure
• D. Tableau creates a continuous gradient for every value

Why: A discrete dimension placed on the Color shelf generates a separate color for each unique member, such as one color per region, and adds a legend to the view.

• A. Discrete fields are always numeric; continuous fields are always text
• B. Discrete fields produce headers and distinct values; continuous fields produce axes and a continuous range ✓
• C. Discrete fields can only be used on the Size shelf; continuous fields can only be used on Text
• D. Discrete fields cannot be filtered; continuous fields can be filtered

Why: Discrete fields create individual headers or categories in the view, while continuous fields create a continuous axis that displays a range of values.

• A. To store raw data extracts for later use
• B. To combine multiple worksheets into a single, unified view ✓
• C. To write custom SQL queries against a database
• D. To publish data sources to Tableau Server only

Why: A dashboard lets you arrange multiple worksheets, legends, filters, and text objects together in one view so users can analyze related visualizations at once.

• A. Parameter actions
• B. Filter actions ✓
• C. Highlight actions
• D. Data blending

Why: Filter actions pass the values selected in a source sheet to target sheets, filtering them automatically when a user clicks a mark.

• A. A calculated field that always returns a Boolean value
• B. A single value that users can change to control calculations or displays ✓
• C. A saved connection to a data source
• D. A type of chart used for comparing two measures

Why: Parameters are user-controlled single values, such as a number or date, that can be referenced in calculations, filters, or reference lines to make dashboards interactive.

• A. Floating layout
• B. Tiled layout ✓
• C. Story layout
• D. Canvas layout

Why: Tiled objects automatically adjust their size and position to fit the dashboard, keeping the layout organized without overlapping, unlike floating objects which can be placed freely.

• A. It makes the data load faster
• B. It ensures the layout displays consistently across different screen sizes ✓
• C. It enables more filter actions
• D. It removes the need for a title

Why: A fixed size preserves the exact layout you designed, so the dashboard looks the same on every device, while Automatic resizing can change how objects are arranged.

• A. To change the color palette of the visualization
• B. To limit which data rows are displayed in the view ✓
• C. To create a new calculated field from existing data
• D. To rename the dimensions in the data source

Why: Filters restrict the data shown in a view to only the records that meet specified conditions, without changing the underlying data source.

• A. Data Blending
• B. Calculated Field ✓
• C. Parameter Control
• D. Dashboard Action

Why: Calculated fields allow you to define new values using formulas that reference existing fields in your data source.

• A. Dimensions are always numeric, while measures are always text
• B. Dimensions are categorical fields used to segment data, while measures are numeric fields that are aggregated ✓
• C. Dimensions can only be used in filters, while measures can only be used in charts
• D. There is no difference; the terms are interchangeable

Why: Dimensions hold categorical or descriptive values (like region or product name) used to break data into groups, while measures are quantitative values (like sales or quantity) that are typically aggregated.

• A. SUM([Profit]) + SUM([Sales])
• B. SUM([Profit]) / SUM([Sales]) ✓
• C. SUM([Profit]) - SUM([Sales])
• D. SUM([Profit]) * 100 + [Sales]

Why: Profit margin is calculated by dividing total profit by total sales, which is expressed as SUM([Profit]) / SUM([Sales]).

• A. Right-click on a blank area of the worksheet and select 'Create Dashboard'
• B. Right-click in the Data pane and select 'Create Calculated Field' ✓
• C. Click the Format menu and select 'Add Formula'
• D. Open the Server menu and choose 'New Field'

Why: You can create a calculated field by right-clicking in the Data pane (or using the Analysis menu) and selecting 'Create Calculated Field', which opens the calculation editor.

• A. Tableau Public
• B. Tableau Cloud or Tableau Server ✓
• C. Tableau Reader only
• D. Exporting a static PNG image

Why: Tableau Cloud and Tableau Server are the enterprise platforms designed for securely sharing dashboards with licensed users within an organization, while keeping access controlled and data private.

• A. Tableau Public can only display bar charts
• B. Tableau Public workbooks are saved to a publicly accessible online gallery, so anyone can view them ✓
• C. Tableau Public requires a paid license to publish
• D. Tableau Public does not support dashboards

Why: Tableau Public publishes workbooks to a free, open web gallery where anyone can view and download them, so it should not be used for confidential or sensitive data.

• A. .twb
• B. .csv
• C. .twbx ✓
• D. .pdf

Why: .twbx is a packaged workbook that bundles the workbook definition (.twb) with the local data extracts or files it uses, making it portable to others who have Tableau Reader.

• A. Export as a Tableau Packaged Workbook
• B. Export as PDF ✓
• C. Export as a Tableau Data Source
• D. Copy the URL of the view

Why: Exporting to PDF creates a static, print-friendly document that preserves the layout of the dashboard or sheets and works well for distributing reports to people who will not use Tableau.

• A. The data is deleted after the workbook is opened
• B. Multiple workbooks can reuse one centrally managed data source, which keeps data consistent and simplifies updates ✓
• C. The data is converted into an image
• D. Only the workbook owner can view the underlying data

Why: Publishing a data source separately lets several workbooks connect to the same governed source, so when the data is refreshed or corrected, every connected workbook reflects the change.