Skip to content
Tableau
All coursesPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Tableau Online Assessment Questions & Answers

40 questions for the online assessment stage — 16 easy, 24 medium.

About the online assessment round

Most companies start with an online test: aptitude and reasoning, a few MCQs on core Tableau concepts, and one or two short hands-on tasks. It filters a large number of applicants, so speed and accuracy both count.

Tips for the online assessment round

  • Practise under a timer: about one minute per MCQ and 15-20 minutes per hands-on task.
  • Read every option before answering; tests often include two nearly correct choices.
  • Use a stable internet connection, keep your camera on and avoid switching tabs in proctored tests.
  • Attempt the questions you are sure about first, then return to the harder ones.
Solved — online assessmentStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

How does forecasting work in Tableau?

Charts and Visual DesignMedium
Save to ▾
Show answer
Tableau uses exponential smoothing models to forecast continuous time series. It chooses the best model, with or without trend and seasonality, based on the data and shows prediction intervals. You need a continuous date and a measure. Options include forecast length, aggregation level and ignoring the last incomplete period. It suits quick projections, while complex forecasting needs Python or R integration.
02

A user wants the region filter on one sheet to apply to all dashboard sheets. What do you do?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Right-click the filter pill or quick filter and choose Apply to Worksheets, then either All Using Related Data Sources, All Using This Data Source, or Selected Worksheets. Pick the sheets on the dashboard. If sheets use different sources, ensure the field is related or use a parameter. Test each sheet after applying.
03

What are the main table calculation functions?

Table CalculationsMedium
Save to ▾
Show answer
Key functions are RUNNING_SUM, RUNNING_AVG, WINDOW_SUM, WINDOW_AVG, WINDOW_MAX, LOOKUP, PREVIOUS_VALUE, INDEX, FIRST, LAST, SIZE, RANK, RANK_DENSE, RANK_PERCENTILE and TOTAL. They operate on aggregates, so arguments must be aggregated, such as RUNNING_SUM(SUM([Sales])). WINDOW functions accept start and end offsets for moving calculations.
04

What are small multiples and why are they useful?

Charts and Visual DesignEasy
Save to ▾
Show answer
Small multiples are a grid of similar charts that share axes, one for each category, such as a sales line chart per region. They make comparisons easier than one crowded chart with many coloured lines. In Tableau you create them by adding a dimension to Rows or Columns alongside the chart fields, or with index-based calculations for a trellis grid.
05

What is the Marks card and what can you control with it?

Tableau FundamentalsEasy
Save to ▾
Show answer
The Marks card controls how data points are drawn. You choose the mark type such as bar, line, area, circle, text, map or Gantt, and then drop fields on Color, Size, Label, Detail, Tooltip, Shape and Path. Detail adds granularity without changing visual encoding, while Tooltip adds information on hover. Most chart customisation in Tableau happens through the Marks card.
06

What is the difference between full and incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
A full refresh rebuilds the entire extract from the source, guaranteeing accuracy but taking longer. An incremental refresh adds only new rows based on a column such as an increasing ID or a date, which is fast but does not capture updates or deletes to old rows. Teams often schedule incremental refreshes daily and a full refresh weekly to keep data correct.
07

What is the difference between Tableau Server and Tableau Cloud?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Tableau Server is self-hosted on the company's own infrastructure or cloud machines, so IT manages installation, upgrades, scaling and security. Tableau Cloud is a fully hosted software-as-a-service platform managed by Tableau, with automatic upgrades. Cloud reaches on-premise data through Tableau Bridge. Companies with strict data residency or customisation needs may prefer Server.
08

How do you calculate each category's percent of total sales using LOD?

LOD ExpressionsMedium
Save to ▾
Show answer
Total Sales: {FIXED : SUM([Sales])} Percent of Total: SUM([Sales]) / MIN([Total Sales]) Place Category on Rows and Percent of Total on Columns, formatted as percentage. Add Region to context filters if the total should respect the region selection.
09

What are subscriptions and data-driven alerts?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Subscriptions email users an image or PDF snapshot of a view or dashboard on a schedule, such as every Monday at 9 AM. Data-driven alerts notify users when a measure crosses a threshold, such as inventory below safety stock, checked when data refreshes. Both help business users who do not open dashboards daily, but too many can cause email fatigue.
10

What is the difference between FIXED, INCLUDE and EXCLUDE?

LOD ExpressionsEasy
Save to ▾
Show answer
FIXED computes at exactly the listed dimensions, regardless of the view. INCLUDE computes at the view level plus extra dimensions, then re-aggregates, for example average sales per customer per region. EXCLUDE removes dimensions from the view level, for example regional total shown against each state. FIXED ignores dimension filters unless in context, while INCLUDE and EXCLUDE respect them.
11

Explain the difference between .twb and .twbx files.

Tableau FundamentalsEasy
Save to ▾
Show answer
A .twb file is an XML workbook that stores sheets, dashboards, calculations and connection information but not the data itself, so the receiver needs access to the original source. A .twbx is a packaged workbook: a zip containing the .twb plus extracts, local files and images. Use .twbx when sharing with someone who cannot reach your database or file, and .twb when everyone connects to the same live source.
12

What is the difference between discrete and continuous fields?

Tableau FundamentalsEasy
Save to ▾
Show answer
Discrete fields (blue pills) contain distinct, separate values and create headers or labels in the view. Continuous fields (green pills) form an unbroken range and create axes. Both dimensions and measures can be either. For example, YEAR(Order Date) as discrete shows separate year headers, while continuous dates draw a single timeline axis. Choosing correctly changes how the chart looks and how filters behave.
13

How do you build a line chart showing monthly sales trend?

Charts and Visual DesignEasy
Save to ▾
Show answer
Drag Order Date to Columns, right-click and choose continuous MONTH. Drag Sales to Rows; Tableau draws a line. Add Category to Color for multiple lines, enable markers from Color options, and add a trend line from the Analytics pane if needed. Format the axis, add a title and tooltip, and check that the latest incomplete month is labelled or excluded.
14

What is a published data source and why use it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
A published data source is a data connection with calculations, metadata and refresh schedules stored on Server or Cloud, which many workbooks can connect to. It provides a single version of truth, central refresh, and permissions, and can be certified by data stewards. Changes to calculations update all connected workbooks. It is a key practice for governance in enterprise Tableau.
15

What options does the Analytics pane provide?

Charts and Visual DesignMedium
Save to ▾
Show answer
The Analytics pane offers summarise options such as constant line, average line, median with quartiles, box plot and totals, model options such as average with confidence interval, trend line, forecast and clustering, and custom reference lines, bands, distributions and box plots. Dragging an item onto the view adds it at table, pane or cell scope.
16

What are reference lines, bands and distributions?

Charts and Visual DesignMedium
Save to ▾
Show answer
Reference lines mark a constant, average, median or parameter value across an axis, such as a target. Reference bands shade a range between two values, such as acceptable delivery time. Distributions show percentiles, quantiles or standard deviations. They are added from the Analytics pane or by right-clicking an axis, and can be computed per table, pane or cell.
17

What is a highlight action and when is it better than a filter action?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A highlight action emphasises related marks across sheets and dims others, without removing data. It is better when users need to see the selected item in context, such as one category within the total. Filter actions remove other data and change totals. Highlighters can also be added from a field's menu so users can search and highlight specific values.
18

Monthly sales files arrive in a folder every month. How do you avoid manual work each time?

Data Connections and ModellingMedium
Save to ▾
Show answer
Use a wildcard union on the folder with a pattern such as Sales_*.xlsx so new files are included automatically on refresh. Alternatively, build a Tableau Prep flow with a wildcard input and schedule it with Prep Conductor. Ensure every file has the same column names and types. Use the Path or Table Name field to derive the month if it is not in the data.
19

What do addressing and partitioning mean in table calculations?

Table CalculationsMedium
Save to ▾
Show answer
Addressing fields define the direction the calculation moves along, such as across months. Partitioning fields define the groups where the calculation restarts, such as each region. In Compute Using, checked dimensions are addressing and unchecked ones are partitioning. For a running total of sales by month restarting each year, month is addressing and year is partitioning.
20

An Employee ID field is being summed in your view. What do you do?

Tableau FundamentalsMedium
Save to ▾
Show answer
Employee ID is numeric, so Tableau classified it as a measure. Right-click it in the Data pane and choose Convert to Dimension, and optionally Convert to Discrete. Now it acts as a label rather than an aggregated number. If you need the number of employees, use COUNTD(Employee ID) instead of SUM. Fixing default properties early avoids wrong numbers across all sheets.
21

Your manager says the dashboard total does not match the Excel total. How do you investigate?

Tableau FundamentalsMedium
Save to ▾
Show answer
First compare filters, date ranges and data refresh time between both sources. Check the aggregation used, for example SUM versus AVG, and whether joins have duplicated rows, which inflates totals. Use View Data to inspect underlying rows and COUNT the records. Check null handling and whether Excel has hidden rows or manual adjustments. Document the cause and fix it at the data source level.
22

A manager wants the grand total row to show the sum of displayed values, but it shows something else. Why?

Table CalculationsEasy
Save to ▾
Show answer
Grand totals in Tableau are computed at a higher level using the same aggregation, so for averages or ratios the total is recomputed rather than summed. For table calculations or LODs, results can look inconsistent. Right-click the measure, choose Total Using and select Sum to add displayed values, or create a custom calculation using WINDOW_SUM. Confirm with the manager which total makes sense.
23

Users say the dashboard takes 30 seconds to load on Server but is fast in Desktop. What do you check?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Compare data connection, since Server may use a live connection through a slower network or different credentials. Record performance on Server using the performance recording parameter. Check concurrent load, VizQL and cache settings, the number of quick filters and marks, and whether extracts are refreshing at the same time. Ask the Server admin for resource usage and background job schedules.
24

Your map shows many cities with an unknown indicator. How do you fix it?

Charts and Visual DesignMedium
Save to ▾
Show answer
Click the unknown indicator and choose Edit Locations. Tableau shows unmatched names; correct spellings such as Bengaluru versus Bangalore, set the correct country and state context, or map them manually. Make sure State is in the view to resolve duplicate city names. For permanent fixes, clean names at the source or add latitude and longitude columns.
25

A rank changes when the user selects a filter value. The business wants overall rank. What do you do?

Table CalculationsMedium
Save to ▾
Show answer
Normal filters remove rows before the rank is computed, so rank recalculates on the filtered set. Either replace the filter with a table calculation filter such as LOOKUP(MIN([Product]), 0), which hides rows after ranking, or compute rank with an LOD-based approach. Explain both behaviours to the user and confirm which rank they actually need.
26

What are hierarchies and how do you use drill down in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
A hierarchy groups related dimensions in order, such as Category to Sub-Category to Product, or Country to State to City. You create one by dragging a field onto another in the Data pane. In the view, a plus icon on the pill lets users drill down and a minus icon rolls up. Dates have built-in hierarchies from year to quarter, month and day.
27

Create a 3-month moving average of sales.

Table CalculationsMedium
Save to ▾
Show answer
Moving Avg: WINDOW_AVG(SUM([Sales]), -2, 0) This averages the current month and the two previous months. Compute along month. Use a dual axis to show actual sales as bars and the moving average as a line, which smooths seasonal noise for trend analysis.
28

How do you create a basic bar chart of sales by region?

Tableau FundamentalsEasy
Save to ▾
Show answer
Connect to the data source, drag Region to Columns and Sales to Rows. Tableau aggregates Sales with SUM and chooses bars. Sort descending using the toolbar sort icon, drag Region to Color for distinct colours if needed, and drag SUM(Sales) to Label to show values. Rename the sheet and add a meaningful title such as Sales by Region, current year.
29

What is the difference between row-level and aggregate calculations?

Calculated FieldsEasy
Save to ▾
Show answer
A row-level calculation is computed for each record, for example [Sales] - [Cost]. An aggregate calculation works on groups at the view level, for example SUM([Profit]) / SUM([Sales]). Mixing them in one expression causes the error cannot mix aggregate and non-aggregate arguments. Ratios should usually be aggregate so they are correct at any level, instead of averaging row-level ratios.
30

What is Tableau and why do companies use it?

Tableau FundamentalsEasy
Save to ▾
Show answer
Tableau is a visual analytics and business intelligence tool that lets users connect to data, build interactive charts and share dashboards without heavy coding. Companies use it because analysts can explore data by drag and drop, managers get self-service dashboards, and results can be published to Tableau Server or Tableau Cloud with security. It reduces the time between a business question and a visual answer.
31

What is the difference between IF, IIF and CASE in Tableau?

Calculated FieldsEasy
Save to ▾
Show answer
IF supports multiple conditions with ELSEIF and complex logical tests. IIF is a compact form taking a test, a true value, a false value and an optional unknown value for nulls. CASE compares one expression against exact values and is easier to read for many fixed options, such as parameter selections. CASE cannot test ranges like Sales greater than 1000, so use IF for that.
32

What types of data sources can Tableau connect to?

Data Connections and ModellingEasy
Save to ▾
Show answer
Tableau connects to files such as Excel, CSV, JSON, PDF and spatial files, relational databases such as MySQL, PostgreSQL, SQL Server and Oracle, cloud warehouses such as Snowflake, BigQuery, Redshift and Databricks, and applications through connectors or ODBC and JDBC. It also supports published data sources on Server or Cloud and web data connectors for custom APIs.
33

Write an LOD to find the first order date of each customer.

LOD ExpressionsEasy
Save to ▾
Show answer
First Order Date: {FIXED [Customer ID] : MIN([Order Date])} Cohort Year: YEAR({FIXED [Customer ID] : MIN([Order Date])}) Convert Cohort Year to a dimension and place it on Rows with YEAR(Order Date) on Columns to see how each cohort keeps buying over time.
34

What are user functions and how are they used for row-level security?

Calculated FieldsMedium
Save to ▾
Show answer
User functions such as USERNAME, FULLNAME, ISMEMBEROF and USERDOMAIN return details of the person viewing the workbook on Server or Cloud. A calculation like [Manager Email] = USERNAME() or ISMEMBEROF('North Team') can be used as a data source filter set to true. Each user then sees only their rows. This is a common way to implement row-level security in Tableau.
35

What is data blending and when would you use it?

Data Connections and ModellingMedium
Save to ▾
Show answer
Data blending combines data from two separate data sources on a sheet using linking fields, with one primary and one or more secondary sources. Secondary data is aggregated to the linking level and then joined like a left join. Use it when data lives in different systems and cannot be joined, such as sales in a database and targets in Excel. Relationships have replaced many blending use cases.
36

What are the Compute Using options such as Table Across and Pane Down?

Table CalculationsMedium
Save to ▾
Show answer
Table Across computes left to right across the whole table, Table Down top to bottom, Table Across then Down moves across then wraps, Pane options restrict the calculation to each pane, Cell computes within a single cell, and Specific Dimensions lets you tick exact addressing fields. Specific Dimensions is the most reliable because it does not change when the layout is rearranged.
37

What are site roles in Tableau Server or Cloud?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Site roles define the maximum capabilities a user can have. Creator users can connect to data, build in Desktop and Prep and publish. Explorer users can explore and web edit existing data sources, with Explorer (can publish) allowing publishing. Viewer users can view and interact with dashboards. Site Administrator roles manage users and content. Permissions on content further restrict what each user can do.
38

Build a Pareto chart showing what share of customers drive 80 percent of sales.

Table CalculationsMedium
Save to ▾
Show answer
Sort customers by sales descending on Columns. Running share of sales: RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) Running share of customers: INDEX() / SIZE() Use a dual axis with bars for sales and a line for running percent, and add a reference line at 0.8.
39

Why is SUM([Profit])/SUM([Sales]) better than AVG([Profit]/[Sales])?

Calculated FieldsMedium
Save to ▾
Show answer
SUM over SUM gives a weighted ratio that reflects total profit against total sales at whatever level the view shows. AVG of a row-level ratio gives every order equal weight, so a tiny order with high margin distorts the result. Business users expect the weighted ratio, which also matches totals in finance reports. Always build ratios as aggregate calculations.
40

How do you show a dynamic title that reflects the selected filter?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Double-click the sheet title and use Insert to add fields or parameters, for example Sales for <Region> in <Parameters.Year>. For multiple selected values, the title shows All or the value list; for cleaner text, create a calculation that returns the selection or All, using a FIXED or table calc approach. Dynamic titles reduce confusion during presentations.

Frequently asked questions

What happens in the Tableau online assessment round?

Most companies start with an online test: aptitude and reasoning, a few MCQs on core Tableau concepts, and one or two short hands-on tasks. It filters a large number of applicants, so speed and accuracy both count.

How do I clear the online assessment round?

Practise under a timer: about one minute per MCQ and 15-20 minutes per hands-on task. Read every option before answering; tests often include two nearly correct choices. Use a stable internet connection, keep your camera on and avoid switching tabs in proctored tests.

Which round comes next?

A typical order is online assessment, telephonic screening, one or two technical rounds, a managerial round and HR. Use the other round pages to practise each stage.

Practise every interview round

Telephonic Interview questionsTechnical Round questionsManagerial Round questionsRapid-Fire questionsHR & behavioural questionsFull mock interview

More ways to practise

Company-wise Tableau questionsExperience-wise Tableau questionsRole-wise Tableau questionsCity-wise Tableau questionsMost asked Tableau questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsTableau mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsTableau topic sheets