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

BI Analyst Interview Questions & Answers

40 questions for BI Analyst interviews — 27 easy, 13 medium.

About the BI Analyst role

A BI Analyst turns business questions into metrics and dashboards, analyses trends and explains insights to managers. They use Tableau with SQL and Excel to track sales, operations, finance or marketing performance, run ad-hoc analysis and maintain recurring reports. Strong communication and business understanding matter as much as tool skills in this role.

Tableau Desktop SQL queries KPI design Data storytelling Excel
Solved for this roleStart 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

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.
02

What are quick table calculations?

Table CalculationsEasy
Save to ▾
Show answer
Quick table calculations are ready-made table calcs available from a measure pill's dropdown: running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, year over year growth and YTD growth. They are fast to apply and can be edited later to change addressing or turned into a calculated field by dragging the pill to the Data pane.
03

Extract the first name from a full name field.

Calculated FieldsMedium
Save to ▾
Show answer
Using SPLIT: SPLIT([Customer Name], ' ', 1) Using FIND and LEFT: LEFT([Customer Name], FIND([Customer Name], ' ') - 1) Trim spaces first if data is messy: SPLIT(TRIM([Customer Name]), ' ', 1) SPLIT is simpler, while the second method shows string function skills.
04

After joining Orders with Returns, total sales went up. What happened?

Data Connections and ModellingMedium
Save to ▾
Show answer
The join type or grain caused duplication. If Returns has multiple rows per order, an inner or left join repeats each order line, so SUM(Sales) inflates. Fix it by using a relationship instead of a join, aggregating Returns to order level before joining, or using an LOD to deduplicate. Always check row counts before and after a join to catch this problem early.
05

What is a context filter?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A context filter is an independent filter that runs before other dimension filters, Top N filters and FIXED LODs. Tableau creates a temporary result set from it, and other filters work on that subset. Use it when Top N should apply within a selection, such as top 10 products within a chosen region. Context filter pills turn grey in the Filters shelf.
06

What is a calculated field in Tableau?

Calculated FieldsEasy
Save to ▾
Show answer
A calculated field is a new field created from existing data using Tableau's formula language. It can perform arithmetic, string manipulation, date logic, conditional logic, aggregations, LOD expressions or table calculations. Calculations are saved in the data source of the workbook and can be reused on any sheet. Examples are profit ratio, customer age group, or a flag for late deliveries.
07

What other Tableau file types should an analyst know?

Tableau FundamentalsEasy
Save to ▾
Show answer
Common types are .tds (data source definition with connection and metadata), .tdsx (packaged data source with extract), .hyper (extract file), .tfl and .tflx (Tableau Prep flows), .tbm (bookmark of a single sheet) and .tps (preferences for custom colour palettes). Knowing them helps when publishing reusable data sources, sharing flows, or troubleshooting why a colleague cannot open a workbook.
08

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.
09

How do you add a date range filter showing the last 12 months?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Drag Order Date to Filters, choose Relative Date, select Months and Last 12 months, optionally anchoring it to a specific date. Right-click the filter and choose Show Filter so users can change it. If data has a lag, anchor to the latest date in data using a parameter. Check the view title to display the active date range.
10

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.
11

How do you change the default number format of a measure?

Tableau FundamentalsEasy
Save to ▾
Show answer
Right-click the measure in the Data pane, choose Default Properties, then Number Format, and pick currency, percentage or custom format with decimal places and units such as thousands or millions. For Indian reports, a custom format can show the rupee symbol. Default formatting applies everywhere the field is used, while formatting a pill only affects that one sheet.
12

What is a dual axis chart and when do you use it?

Charts and Visual DesignEasy
Save to ▾
Show answer
A dual axis chart places two measures on the same view with independent or synchronised axes, by dragging the second measure to the right side of the chart or choosing Dual Axis from the pill menu. Use it to compare related measures such as sales bars with profit ratio line. Synchronise axes when units are the same, and label clearly to avoid misleading readers.
13

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.
14

Top 10 products do not change when the user selects a region. Why?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Top N filters run before normal dimension filters, so Top 10 is computed on all regions, and then the region filter removes some of those products. Add the Region filter to context, so it runs first and Top 10 is calculated within the selected region. The Region pill turns grey to show it is a context filter.
15

A stakeholder asks for a pie chart with 15 categories. What do you suggest?

Charts and Visual DesignMedium
Save to ▾
Show answer
Explain that a pie with 15 slices is hard to read because people compare angles poorly. Suggest a sorted horizontal bar chart showing values and percentages, which makes ranking clear, or group the smallest categories into Others and show the top five. If they still want a pie, limit it to a few slices. Offer both and let them choose based on readability.
16

Write a calculation for profit ratio and a profit flag.

Calculated FieldsEasy
Save to ▾
Show answer
Profit Ratio: SUM([Profit]) / SUM([Sales]) Profit Flag: IF SUM([Profit]) > 0 THEN 'Profitable' ELSEIF SUM([Profit]) = 0 THEN 'Break-even' ELSE 'Loss' END Format Profit Ratio as percentage. Both are aggregate, so they work at any view level.
17

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.
18

How do you choose the right chart type for data?

Charts and Visual DesignEasy
Save to ▾
Show answer
Choose by the question: comparison of categories uses bar charts, trends over time use line charts, part to whole uses stacked bars or treemaps with few categories, relationships between two measures use scatter plots, distributions use histograms or box plots, and geography uses maps. Keep charts simple and avoid pie charts with many slices, 3D effects or dual axes that confuse readers.
19

A client wants dashboards embedded in their internal web portal. How would you approach it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Use Tableau's embedding API or the Tableau web component to embed views in the portal, with single sign-on such as SAML or connected apps for authentication so users do not log in twice. Ensure users have licences and correct permissions, apply row-level security, set the dashboard size to fit the portal, and use the API to pass filters or parameters from the page.
20

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.
21

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.
22

Write the general syntax of an LOD expression.

LOD ExpressionsEasy
Save to ▾
Show answer
The syntax is {KEYWORD [Dimension1], [Dimension2] : AGGREGATE([Measure])}, where the keyword is FIXED, INCLUDE or EXCLUDE. For example {FIXED [Region] : SUM([Sales])} returns total sales per region on every row. The dimension list can be empty for FIXED to get a table-level value. The aggregation part must always be an aggregate such as SUM, AVG, MIN, MAX or COUNTD.
23

What are the main categories of functions in Tableau calculations?

Calculated FieldsEasy
Save to ▾
Show answer
Tableau offers number functions such as ROUND and ABS, string functions such as LEFT, CONTAINS and SPLIT, date functions such as DATEDIFF, DATEADD and DATETRUNC, type conversion such as STR, INT and DATE, logical functions such as IF, CASE and IIF, aggregate functions such as SUM and COUNTD, user functions such as USERNAME, and table calculation functions such as RUNNING_SUM and RANK.
24

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.
25

How do you create a parameter-based Top N filter?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Create an integer parameter Top N with a range 5 to 50 and step 5. Drag Product to Filters, open the Top tab, choose By field, select Top and pick the Top N parameter, by SUM of Sales. Right-click the parameter and Show Parameter. Add region to context if Top N should apply within the selected region.
26

How do you gather requirements before building a dashboard?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Situation: a supply chain team asked for an inventory dashboard without clear details. Task: understand what they needed. Action: I met users to ask which decisions they make, which KPIs and filters matter, refresh frequency and who will use it, then sketched a wireframe and confirmed it. Result: the first version was accepted with only minor changes, saving rework time.
27

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.
28

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.
29

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.
30

How do you handle pressure when a dashboard is needed urgently?

Table CalculationsEasy
Save to ▾
Show answer
Situation: a director needed weekly sales numbers for a board call in three hours. Task: deliver correct numbers fast. Action: I clarified the exact metrics, reused an existing certified data source, built a simple view first, validated totals with finance, then improved formatting. Result: the numbers were ready in two hours and matched finance, and I later added the view to our standard dashboard.
31

What are Show Me and the automatic mark type in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
Show Me is a panel that suggests chart types based on the fields you have selected, highlighting valid options such as bar, map, scatter or histogram and stating minimum field requirements. Automatic mark type lets Tableau pick a mark based on the pills, for example line for continuous dates. Both speed up exploration, but experienced analysts often build charts manually for full control.
32

What is a parameter in Tableau?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A parameter is a user-controlled variable, such as a number, date or string, that is not tied to the data. It does nothing alone; you reference it in calculations, filters, reference lines, Top N or bins. Examples are a measure switcher, a what-if discount rate, or a dynamic Top N. Parameters can be shown as dropdowns, sliders or type-in fields.
33

What do you do when you are stuck on a Tableau problem?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Situation: in my internship I could not get a running total to restart each year. Task: solve it without wasting a day. Action: I reproduced it on sample data, checked documentation on addressing and partitioning, tried Specific Dimensions, and asked a senior with a clear description when still stuck. Result: I fixed it within an hour and wrote a note for the team.
34

What types of filters are available in Tableau?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Tableau has extract filters, data source filters, context filters, dimension filters, measure filters, table calculation filters and date filters such as relative date, range and individual dates. Filters can be shown as quick filter controls like dropdown, single value list, multiple values list, slider or wildcard match. Each type applies at a different stage in the order of operations.
35

What is the difference between dimensions and measures in Tableau?

Tableau FundamentalsEasy
Save to ▾
Show answer
Dimensions are qualitative fields such as Region, Product or Order Date that slice data and create headers. Measures are quantitative fields such as Sales or Profit that Tableau aggregates, usually with SUM by default. Dragging a dimension adds detail or categories to the view, while a measure produces an axis. A numeric field like Employee ID can be converted to a dimension when it should not be summed.
36

What is a box plot and what does it show?

Charts and Visual DesignEasy
Save to ▾
Show answer
A box plot shows the distribution of a measure: the median line, the box covering the 25th to 75th percentile, whiskers extending to the data within 1.5 times the interquartile range, and outliers as points. In Tableau you add it from the Analytics pane or Show Me. It is useful for comparing delivery time, salary or order value distributions across groups.
37

What does aggregation mean in Tableau and how can you turn it off?

Tableau FundamentalsMedium
Save to ▾
Show answer
Tableau aggregates measures to the view level, using SUM, AVG, MIN, MAX, COUNT, COUNTD, MEDIAN and others. Aggregation can be changed per pill from its dropdown. To see every row, you can uncheck Aggregate Measures in the Analysis menu, which plots disaggregated rows, useful for scatter plots of raw records. For large data it can create many marks and slow the view.
38

How do you calculate the number of days taken to ship an order?

Calculated FieldsEasy
Save to ▾
Show answer
Days to Ship: DATEDIFF('day', [Order Date], [Ship Date]) Late Flag: IF DATEDIFF('day', [Order Date], [Ship Date]) > 4 THEN 'Late' ELSE 'On time' END Use AVG(Days to Ship) per region to compare delivery performance.
39

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.
40

Business wants financial year April to March in reports. How do you handle it?

Calculated FieldsMedium
Save to ▾
Show answer
Right-click the date field, choose Default Properties, then Fiscal Year Start, and select April. Tableau then shows FY quarters and years based on April. For a label such as FY 2025-26, create a calculation: IF MONTH([Order Date]) >= 4 THEN STR(YEAR([Order Date])) + '-' + RIGHT(STR(YEAR([Order Date]) + 1), 2) ELSE STR(YEAR([Order Date]) - 1) + '-' + RIGHT(STR(YEAR([Order Date])), 2) END.

Frequently asked questions

What does a BI Analyst do?

A BI Analyst turns business questions into metrics and dashboards, analyses trends and explains insights to managers. They use Tableau with SQL and Excel to track sales, operations, finance or marketing performance, run ad-hoc analysis and maintain recurring reports. Strong communication and business understanding matter as much as tool skills in this role.

Which skills are tested in a BI Analyst interview?

Expect questions on Tableau Desktop, SQL queries, KPI design, Data storytelling, Excel. Most rounds also ask you to explain a project and solve one practical problem live.

How do I prepare for a BI Analyst interview?

Revise Tableau Fundamentals, Calculated Fields, Charts and Visual Design, Filters, Parameters and Actions first using the topic sheets, practise the questions on this page aloud, then do one full mock interview to practise timing.

Topic sheets for this role

Tableau Fundamentals questionsCalculated Fields questionsCharts and Visual Design questionsFilters, Parameters and Actions questions

Other roles

Tableau DeveloperData Analyst (Tableau)MIS and Reporting AnalystSenior BI DeveloperTableau Server Administrator

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