Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About KPMG hiring for Tableau roles
KPMG is one of the Big Four professional services networks, providing audit, tax and advisory services. KPMG in India and its global delivery centres support clients with technology consulting, data and analytics, risk advisory and cybersecurity. It hires in India for analysts and consultants in data analytics, governance and risk, IT audit, testing and ERP implementation.
For Tableau roles, this KPMG practice set focuses most on LOD Expressions (6), Calculated Fields (5), Filters, Parameters and Actions (4), Data Connections and Modelling (4). It has 6 easy, 20 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Consulting
Headquarters
Amstelveen, Netherlands
Main India offices
Gurugram, Bengaluru, Mumbai, Hyderabad, Pune
KPMG Tableau interview process
Online assessment or screening test
Technical interview
Managerial or case round
Partner or HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for KPMGStart 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.
DATEPART returns an integer part of a date such as month number. DATENAME returns the name, such as March. DATETRUNC truncates to a level, giving a date such as the first of the month. DATEADD adds intervals, DATEDIFF computes the difference between two dates in a unit, MAKEDATE builds a date, and TODAY and NOW return the current date and time.
02
Show each state's sales compared with its region's total.
Region Sales:
{EXCLUDE [State] : SUM([Sales])}
Share of Region:
SUM([Sales]) / SUM([Region Sales])
With Region and State in the view, EXCLUDE removes State so each row shows the regional total. Alternatively {FIXED [Region] : SUM([Sales])} works but ignores dimension filters.
03
Your percent of total changes when a user filters Category. The business wants it to stay fixed. What do you do?
If you used a quick table calculation, the total is computed on the filtered view, so it changes. Replace it with a FIXED LOD for the total, which ignores dimension filters, or use EXCLUDE for the filtered dimension. Make sure any filters that should affect the total are added to context. Test with and without filters and document the behaviour.
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.
05
Build a dimension switcher so users choose Region, Category or Segment.
Create a string parameter Dimension Choice with values Region, Category and Segment. Then:
Selected Dimension:
CASE [Dimension Choice]
WHEN 'Region' THEN [Region]
WHEN 'Category' THEN [Category]
ELSE [Segment]
END
Put Selected Dimension on Rows and show the parameter control.
Relative date filters show data relative to today or an anchor date, such as last 7 days, this month, previous quarter, or year to date. They update automatically each day, so dashboards always show current periods without manual editing. You can set an anchor date for testing or use a parameter, and choose whether to include null dates.
07
You get the error cannot mix aggregate and non-aggregate arguments. How do you fix it?
The formula mixes a row-level field with an aggregated one, such as IF [Sales] > AVG([Sales]). Either aggregate everything, for example IF SUM([Sales]) > 1000, or make everything row level. If you need to compare a row with an overall average, use an LOD such as [Sales] > {FIXED : AVG([Sales])}, which returns a row-level value that can be mixed safely.
08
How do you calculate each category's percent of total sales using LOD?
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
A user wants the region filter on one sheet to apply to all dashboard sheets. What do you do?
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.
10
What is the difference between bins and histograms in Tableau?
A bin is a dimension created from a continuous measure by splitting values into equal-sized ranges, for example ages in buckets of 10. A histogram is the chart that counts records in each bin. Tableau can create both automatically through Show Me. You can choose bin size manually or tie it to a parameter so users change bucket width interactively.
11
A live connection dashboard on a large database is very slow. What options would you evaluate?
Check the performance recording to see slow queries. Options include switching to an extract with aggregation and extract filters, adding database indexes or materialised views, removing custom SQL, enabling referential integrity assumptions, reducing the number of marks and quick filters, and using context filters wisely. If real-time is not required, a scheduled extract usually gives the biggest improvement.
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.
13
A workbook with many nested table calculations is slow in the browser. How do you approach it?
Table calcs run on the result set, so large numbers of marks make them slow. Reduce marks by aggregating to the needed level, filter data earlier with context or data source filters, replace some table calcs with LODs or database-side calculations, and avoid nested WINDOW functions over thousands of rows. Use a performance recording to confirm computing layouts and query time.
Create a pie on the first axis using a measure on Angle and a dimension on Color. Put two copies of MIN(0) on Rows, set the second to circle mark, make it smaller and white, and select Dual Axis with synchronised axes. Place a total label on the inner circle. Use donuts only for two to four segments; bar charts are usually clearer.
15
What is the difference between FIXED, INCLUDE and EXCLUDE?
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.
16
Different analysts calculate active customer differently. How do you resolve it?
Agree on a business definition with stakeholders, such as a customer with at least one order in the last 90 days, and document it. Create one calculated field using an LOD on the last order date, add it to a certified published data source with a description, and deprecate old versions. Communicate the change and compare old and new numbers so users understand the difference.
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.
18
You need to show the percent of customers who ordered more than once. How do you do it?
Create Orders per Customer: {FIXED [Customer ID] : COUNTD([Order ID])}. Summing a row-level 1 or 0 flag would count order lines, not customers, so instead use COUNTD(IF [Orders per Customer] > 1 THEN [Customer ID] END) / COUNTD([Customer ID]). Format as percentage and break it down by region or segment to compare loyalty.
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.
20
Your Excel source has merged header cells and title rows, and Tableau reads it incorrectly. What do you do?
Turn on Data Interpreter on the data source page, which detects headers, removes title rows and handles sub-tables. Review the interpreter results sheet it produces. If it still fails, clean the file in Excel or Tableau Prep by removing merged cells and keeping one header row. Ask the data owner for a clean, tabular format for future files.
21
Your map shows many cities with an unknown indicator. How do you fix it?
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.
22
Business wants financial year April to March in reports. How do you handle it?
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.
23
Your manager says the dashboard total does not match the Excel total. How do you investigate?
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.
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.
25
Describe how you work with data engineers on a BI project.
Situation: my dashboard needed customer data that was spread across three systems. Task: get a reliable, single table. Action: I wrote clear requirements with grain, fields and refresh needs, shared sample SQL, and reviewed their view together, testing counts against source systems. Result: they built a curated table, my dashboard became simpler and faster, and we reused the table for two other reports.
26
Management wants new versus repeat customers per month. How would you build it?
Create First Purchase Month: {FIXED [Customer ID] : MIN(DATETRUNC('month', [Order Date]))}. Then Customer Type: IF DATETRUNC('month', [Order Date]) = [First Purchase Month] THEN 'New' ELSE 'Repeat' END. Put MONTH(Order Date) on Columns, COUNTD(Customer ID) on Rows and Customer Type on Color. Validate a few customers manually to make sure classification is correct.
27
How do you show a dynamic title that reflects the selected filter?
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.
Create an extract from the Data menu, choose Extract Data, and tick Incremental refresh. Select a column whose values always increase, such as Order ID or Load Timestamp. Publish to Server or Cloud and create a schedule for incremental refresh, plus an occasional full refresh. Ensure the source does not update old records, or those changes will be missed.
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.
30
After joining Orders with Returns, total sales went up. What happened?
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.
Tips to crack the KPMG Tableau interview
Learn basics of IT audit, internal controls and risk frameworks, since advisory roles often combine data with governance work.
Practise structured answers for guesstimates and business problems, explaining assumptions clearly step by step.
Prepare examples of working with stakeholders and meeting deadlines, which are common themes in Big Four interviews.
Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
Practise the hard questions on this page aloud; KPMG interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the KPMG Tableau interview?
Candidates usually go through 4 stages: Online assessment or screening test; Technical interview; Managerial or case round; Partner or HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the KPMG Tableau interview?
This practice set leans on LOD Expressions (6), Calculated Fields (5), Filters, Parameters and Actions (4), Data Connections and Modelling (4). Revise those first, then practise explaining one or two of your own projects end to end, because most KPMG interviewers ask you to walk through real work.
Are these the exact questions asked at KPMG?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like KPMG's. They are not a leaked or verified list of past questions.
Where does KPMG hire Tableau professionals in India?
KPMG has large teams in Gurugram, Bengaluru, Mumbai, Hyderabad, Pune. Openings and locations change often, so check the KPMG careers page and filter by city and experience.