Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Mu Sigma hiring for Tableau roles
Mu Sigma is a decision science and analytics company with its main delivery centre in Bengaluru. It works with large enterprises on analytics problems in areas like marketing, supply chain and risk. It typically hires freshers as trainee decision scientists, with a selection process known for aptitude, puzzles and group discussions.
For Tableau roles, this Mu Sigma practice set focuses most on Dashboards and Tableau Server (7), Calculated Fields (6), Filters, Parameters and Actions (5), LOD Expressions (4). It has 6 easy, 19 medium, 5 hard questions, so you can start easy and work up to the harder ones.
Company type
Analytics
Headquarters
Northbrook, Illinois, USA
Main India offices
Bengaluru
Mu Sigma Tableau interview process
Online assessment (aptitude + reasoning)
Video or written communication test
Group discussion
Technical and HR interview
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Mu SigmaStart 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 do you calculate the current month and previous month sales in a KPI?
Current Month:
IF DATETRUNC('month', [Order Date]) =
DATETRUNC('month', TODAY()) THEN [Sales] END
Previous Month:
IF DATETRUNC('month', [Order Date]) =
DATEADD('month', -1, DATETRUNC('month', TODAY()))
THEN [Sales] END
MoM %:
SUM([Current Month]) / SUM([Previous Month]) - 1
02
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.
03
What does aggregation mean in Tableau and how can you turn it off?
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.
04
How do you build a bullet chart for actual versus target?
Select Sales and Target with a dimension such as Region, then choose bullet graph from Show Me. Tableau puts Sales as bars and Target as a reference line with distribution bands. If the roles are reversed, right-click the axis and choose Swap Reference Line Fields. Add colour for achieved versus missed using a calculation comparing SUM(Sales) with SUM(Target).
05
How do you use a parameter action to let users click a bar and change a reference line?
Create a float parameter, for example Selected Value. Add a reference line using that parameter. Then go to Dashboard, Actions, Add Action, Change Parameter, choose the source sheet, target parameter Selected Value, and source field SUM(Sales), with aggregation set as needed. Clicking a bar updates the parameter, and the reference line moves to compare other bars with it.
06
Build a Pareto chart showing what share of customers drive 80 percent of sales.
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.
07
A business user wants a what-if analysis for price increase on profit. How would you build it?
Create a float parameter Price Change with a slider range of -20 to 20 percent. Build calculations: New Revenue = SUM([Sales]) * (1 + [Price Change]) and New Profit = New Revenue - SUM([Cost]). Optionally include an elasticity parameter for demand change. Show current versus projected profit side by side, and label assumptions clearly on the dashboard.
08
Write an LOD to find the first order date of each customer.
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.
09
Tell me about a time your analysis changed a business decision.
Situation: the marketing team planned to increase spend on a segment they believed was growing. Task: check the trend before budget approval. Action: I built a cohort analysis using FIXED first purchase date and found repeat purchase rates in that segment had fallen for three quarters. Result: they shifted part of the budget to retention campaigns, and repeat purchases improved the next quarter.
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.
11
What is the difference between Tableau Server and Tableau Cloud?
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.
12
How do you improve dashboard performance in Tableau?
Use the performance recorder to find slow queries and rendering. Use extracts with only needed fields and rows, aggregate data, reduce marks and sheets, limit quick filters and relevant values, prefer integer and boolean calculations, avoid heavy custom SQL, use fixed dashboard size for caching, and hide unused fields. Workbook Optimizer in Desktop also suggests improvements based on best practices.
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.
14
A stakeholder says the dashboard is too crowded. How do you redesign it?
Ask which questions they need answered first. Follow a top-down layout: KPIs at the top, main trend and comparison charts in the middle, details at the bottom or on drill-through. Remove decorative elements, reduce colours, align objects in containers, use white space and consistent fonts, and move secondary filters into a collapsible panel using show and hide buttons.
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.
A URL action opens a web page, a file or an email link using field values from the selected mark. For example, clicking an order can open the order details page in an internal system with the Order ID passed in the URL, or clicking a company can open a search. URL actions can open in a new tab or inside a web page object in the dashboard.
17
What is the difference between a calculated field and an ad-hoc calculation?
A calculated field is created through the Analysis menu or Data pane and saved in the data source for reuse. An ad-hoc calculation is typed directly into a pill on Rows, Columns or the Marks card by double-clicking, useful for quick tests. Ad-hoc calcs can be dragged to the Data pane to save them. Saved fields are better for maintainability and naming.
Show and hide buttons let users collapse or expand a floating container, such as a filter panel or help text, by clicking a button. They save space on crowded dashboards and keep the main view clean. You enable it from the container menu with Add Show/Hide Button, and style it with images or text. They also work well for mobile layouts.
Extract, data source and context filters apply before FIXED, so they change FIXED results. Normal dimension filters apply after FIXED, so they do not affect it but do affect INCLUDE and EXCLUDE. Measure filters apply later still. Therefore, to make a region filter change a FIXED total, add it to context. Knowing this order prevents incorrect percent-of-total and cohort results.
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.
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.
Put the KPI dimension on Rows and continuous MONTH(Order Date) with SUM(Sales) on a separate column, choose line marks, and set Independent Axis Ranges for each row via Edit Axis. Remove gridlines, axes, headers and borders, and highlight the last point using a calculation such as IF LAST() = 0 THEN SUM([Sales]) END as a dual axis circle.
23
Users complain that a dashboard with 10 dropdown filters is slow. How do you improve it?
Measure first with performance recording. Reduce the number of quick filters and replace some with dashboard filter actions. Change Only Relevant Values to All Values in Database where cascading is not needed. Add an Apply button to multi-select filters, convert high-cardinality filters to wildcard search, and move fixed restrictions to data source filters. Re-test after changes.
24
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.
25
How would you set up row-level security using a user entitlement table?
Create an entitlement table with Username and Region columns, maintained by the business or IT. Relate or join it to the fact table on Region. Create a calculation USERNAME() = [Username] and add it as a data source filter set to True. Publish the data source with embedded credentials and restrict download permissions. Test with View As or user impersonation for each role.
26
How does Tableau handle null values in calculations?
Most operations involving a null return null, so [Sales] + null is null. Use ZN to convert null numbers to zero, IFNULL to replace nulls with a value, and ISNULL to test for them. Aggregations such as SUM ignore nulls. In charts, nulls may appear as an indicator at the bottom right, and you can choose to filter, show at default position or hide them.
27
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.
28
Using FIXED with SUM in the view gives a huge inflated number. Why?
FIXED returns a value repeated on every row at the fixed level. If the view is at a finer level, or at the total level, SUM adds the repeated values, multiplying the result. Use MIN, MAX or AVG to bring back the single value, or make sure the view level matches the FIXED dimensions. This is a frequent mistake when using table-level totals.
A table calculation is computed on the aggregated values already in the view, rather than in the data source. Examples include running total, difference, percent difference, percent of total, rank, percentile and moving average. Because they work on the result table, their output depends on the dimensions in the view and on the direction set by Compute Using. A delta symbol appears on the pill.
30
Your dashboard looks perfect on your laptop but broken on the manager's screen. How do you fix it?
The dashboard probably uses Automatic or Range size, so objects reflow on different resolutions. Set a fixed size suitable for the audience, such as 1366 by 768 or 1200 by 900, or use Range carefully with tiled containers. Avoid floating objects that overlap. Create a device layout for phones if needed and test on common screen sizes before sharing.
Tips to crack the Mu Sigma Tableau interview
Practise puzzles, logical reasoning and quantitative aptitude, which feature prominently in Mu Sigma assessments.
Prepare for group discussions by practising structured arguments on business and analytics topics.
Learn basic analytics concepts and show curiosity about solving ambiguous problems, which Mu Sigma emphasises.
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; Mu Sigma interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Mu Sigma Tableau interview?
Candidates usually go through 4 stages: Online assessment (aptitude + reasoning); Video or written communication test; Group discussion; Technical and HR interview. 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 Mu Sigma Tableau interview?
This practice set leans on Dashboards and Tableau Server (7), Calculated Fields (6), Filters, Parameters and Actions (5), LOD Expressions (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Mu Sigma interviewers ask you to walk through real work.
Are these the exact questions asked at Mu Sigma?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like Mu Sigma's. They are not a leaked or verified list of past questions.
Where does Mu Sigma hire Tableau professionals in India?
Mu Sigma has large teams in Bengaluru. Openings and locations change often, so check the Mu Sigma careers page and filter by city and experience.