01
What is the difference between a chart and a dashboard?
Show answer
A chart shows one view of data; a dashboard combines several charts and KPIs on one page for monitoring.
Power BI and Tableau Interview Questions for Business Analytics
36 Power BI and Tableau questions with answers for business analytics roles — 11 easy, 16 medium, 9 hard.
About Power BI and Tableau
BI tool questions test whether you can turn data into reliable, fast dashboards. Interviewers cover data modelling with star schemas, DAX measures and filter context, Power Query, Tableau LOD expressions, row-level security, refresh and performance tuning. Scenario questions focus on numbers not matching, slow reports and designing dashboards that leadership actually uses for decisions.
Sheet progressStart 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
02
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
Show answer
Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.
03
What is the difference between a calculated column and a measure in Power BI?
Show answer
A calculated column is computed row by row at refresh time and stored in the model, so it uses memory and can be used in slicers, rows and relationships. A measure is computed at query time based on the current filters, so it is not stored and responds to slicers. Use a column for attributes such as an age band, and a measure for aggregations such as Total Sales or Margin %.
04
What is Power Query and what is it used for?
Show answer
Power Query is the data preparation engine inside Power BI and Excel. It connects to sources like Excel, CSV, SQL databases and web APIs, then lets you clean and shape data with recorded steps: remove columns, change types, split, merge, unpivot, append and group. Each step is written in the M language and replays on every refresh, so a monthly cleanup job becomes repeatable instead of manual.
05
What are dimensions and measures in Tableau?
Show answer
Dimensions are qualitative fields such as Region, Category or Customer Name; placing them on a shelf creates headers and splits the view into groups. Measures are numeric fields such as Sales or Quantity that Tableau aggregates, usually with SUM or AVG. Tableau also marks fields as discrete (blue pills, headers) or continuous (green pills, axes). A date can act as either, which changes whether you get separate bars or a continuous trend line.
06
Which chart would you choose for trend, part-to-whole, comparison and distribution?
Show answer
For a trend over time use a line chart. For part-to-whole use a stacked bar or a 100 percent bar; a pie or donut only works with two to four slices. For comparing categories use a sorted horizontal bar chart. For distribution use a histogram or box plot. For correlation between two measures use a scatter plot. Choosing by the question being answered, not by looks, keeps dashboards readable.
07
What Power Query steps would you use to clean a messy monthly sales file?
Show answer
Promote the first row to headers and remove blank or total rows. Set correct data types for dates and amounts, and use locale settings for Indian date formats. Trim and clean text columns, replace errors and nulls, split combined fields like 'City-State', and unpivot month columns into rows. Remove duplicates on the order ID, then merge with the product master. Rename steps clearly so others can follow the logic.
08
Write Tableau calculated fields for profit ratio and a flag for loss-making orders.
Show answer
// Profit Ratio (aggregate so it works at any level)
SUM([Profit]) / SUM([Sales])
// Loss Flag (row level)
IF [Profit] < 0 THEN "Loss" ELSE "Profit" END
// Put Loss Flag on Color to highlight loss-making orders
09
What are the steps to publish and share a Power BI report with your team?
Show answer
Save the .pbix and click Publish, choosing the team workspace. In the Service, set data source credentials and, for on-premises data, configure the gateway. Schedule refresh. Then share by giving workspace access to editors, or package it as an app for viewers, and apply row-level security roles if needed. Finally, check it on web and mobile and send the link with a short note on what each page answers.
10
What is the difference between a report and a dashboard in Power BI Service?
Show answer
A report is a multi-page, interactive view built in Power BI Desktop from one semantic model, with slicers, drill-through and cross-filtering. A dashboard is a single-page canvas in the Service made of tiles pinned from one or more reports, and is meant for monitoring key numbers at a glance. Dashboards support data alerts on card and KPI tiles, but have limited interactivity; clicking a tile opens the underlying report for detailed exploration.
11
Tell me about a time you had to learn a new analytics tool quickly for a project.
Show answer
Situation: my team moved reporting from Excel to Power BI, and I had two weeks to rebuild the weekly sales report. Task: deliver it on time without errors. Action: I took a short online course, practised data modelling on a copy of our data, and asked a colleague to review my DAX measures. I reconciled every number with the old Excel report before launch. Result: the report went live on schedule, and refresh time dropped from half a day to minutes.
12
What is Power Pivot?
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
13
What is a star schema and why do BI tools prefer it?
Show answer
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
14
What does the CALCULATE function do in DAX?
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
15
Compare Import mode, DirectQuery and Live Connection in Power BI.
Show answer
Import copies data into the compressed in-memory model, giving the fastest visuals and full DAX, but data is only as fresh as the last refresh and size is limited. DirectQuery sends queries to the source at view time, so data is near real time but visuals are slower and some DAX is restricted. Live Connection points to an existing published semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery.
16
What is row-level security in Power BI and how do you set it up?
Show answer
Row-level security restricts which rows a user can see in the same report. In Desktop you create roles under Manage Roles with a DAX filter, such as 'Region'[Manager Email] = USERPRINCIPALNAME() for dynamic RLS. You test with View as Role, publish, and then map users or groups to roles in the Service. Dynamic RLS with a mapping table scales better than creating one static role per region.
17
What is a date table in Power BI and why should you mark it as a date table?
Show answer
A date table has one row per day with no gaps, plus columns like Year, Quarter, Month, Week and Fiscal Period. It is related to the fact table date column. Marking it as a date table tells Power BI to use it for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR and DATESINPERIOD, which require a continuous date range. It also gives consistent month sorting and fiscal calendars across every report.
18
What is the difference between a Tableau extract and a live connection?
Show answer
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
19
A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?
Show answer
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
20
Your measure shows the same value on every row of a matrix. Why might that happen?
Show answer
The filter from the row field is not reaching the fact table. Usually there is no relationship between that dimension and the fact, the relationship is inactive, or it filters in the wrong direction. It can also happen when the measure uses ALL or REMOVEFILTERS on that column, or when the row field comes from the fact table of a different grain. Check the model view and test the measure with a simple SUM.
21
A business head wants 25 charts on one dashboard page. How do you respond?
Show answer
Ask what decisions they make weekly and which three to five KPIs drive them. Propose a summary page with those KPIs, trends and one breakdown, then drill-through or separate pages for detail. Show a quick mock-up of both versions so they see the clutter and the load time. Use bookmarks or a field parameter to let them switch views without adding charts. Agree on the layout before building.
22
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
Show answer
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
23
Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.
Show answer
Total Sales = SUM(Sales[Amount])
Sales LY =
CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))
YoY % =
DIVIDE([Total Sales] - [Sales LY], [Sales LY])
-- needs a marked date table; DIVIDE avoids divide-by-zero errors
24
Write a DAX measure that shows each category's percent share of total sales.
Show answer
Category Share % =
DIVIDE(
[Total Sales],
CALCULATE([Total Sales], ALL('Product'[Category]))
)
-- ALLSELECTED instead of ALL respects slicers on the page
25
Tell me about a dashboard you built that changed a business decision.
Show answer
Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.
26
Managers want to click a region on a summary report page and jump to a detail page for only that region. How do you build it in Power BI?
Show answer
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
27
Write a DAX measure for the product return rate that avoids divide-by-zero errors.
Show answer
Return Rate % =
VAR ReturnedQty = SUM ( Returns[Quantity] )
VAR SoldQty = SUM ( Sales[Quantity] )
RETURN
DIVIDE ( ReturnedQty, SoldQty, 0 )
// DIVIDE returns the third argument (0) when SoldQty is zero or blank.
// Format the measure as a percentage in the model.
28
Explain row context and filter context in DAX.
Show answer
Row context means DAX is evaluating one row at a time, as in a calculated column or inside iterators like SUMX. Filter context is the set of filters coming from slicers, visuals, rows, columns and CALCULATE that decides which rows a measure sees. Row context does not filter other tables by itself; context transition through CALCULATE converts it into filter context. Most wrong-number bugs in DAX come from misunderstanding these two.
29
What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?
Show answer
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
30
Why should you avoid bidirectional relationships in a Power BI model?
Show answer
Relationships normally filter one way, from the dimension (one side) to the fact (many side). Bidirectional filtering lets facts filter dimensions too, which can create ambiguous filter paths, unexpected totals and slower queries, especially with multiple fact tables. Prefer a clean star schema with single-direction filters, and when you need a reverse filter for one measure, use CROSSFILTER or TREATAS inside CALCULATE instead of changing the model globally.
31
What is incremental refresh and when do you need it?
Show answer
Incremental refresh partitions a large table by date so each refresh reloads only recent data, such as the last 10 days, while older partitions stay stored. You define RangeStart and RangeEnd parameters in Power Query, filter the date column with them, and set the policy for how much history to keep. It is needed when full refreshes of millions of rows take too long or fail, and it reduces load on the source system.
32
Your Power BI report takes 30 seconds to load. How do you speed it up?
Show answer
Start with Performance Analyzer to see which visuals and DAX queries are slow. Then fix the model: remove unused columns, reduce high-cardinality text, use a star schema and correct data types. Rewrite heavy measures, avoiding FILTER over whole tables and nested iterators. Cut the number of visuals per page, use aggregations or Import instead of DirectQuery where possible, and push transformations upstream into SQL or Power Query.
33
Five departments each build their own Power BI reports with different revenue numbers. How would you design a better BI setup?
Show answer
Create a shared, certified semantic model with one definition per KPI, built on a governed warehouse layer. Departments build thin reports on top of it through live connection instead of copying data. Set up workspaces by environment (dev, test, prod), deployment pipelines, naming standards, a KPI glossary and owners for each measure. Keep a small central team for the core model and let departments self-serve on top, which balances control and speed.
34
A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?
Show answer
Use an extract with only the needed columns and rows, aggregated to the visible grain where possible. Replace quick filters showing all values with fewer filters, use context filters wisely and avoid 'only relevant values' on large fields. Move complex calculations into the data source, reduce marks per view and the number of sheets per dashboard. Use the Performance Recorder to find the slowest queries and fix those first.
35
Write a DAX measure for a running total of sales by date.
Show answer
Running Sales =
CALCULATE(
[Total Sales],
FILTER(
ALL('Date'[Date]),
'Date'[Date] <= MAX('Date'[Date])
)
)
-- for a yearly reset use TOTALYTD([Total Sales], 'Date'[Date])
36
Write a DAX measure to count distinct active customers in the last 30 days.
Show answer
Active Customers 30D =
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)
)
-- MAX('Date'[Date]) makes it relative to the date in the current filter
Frequently asked questions
How important is Power BI and Tableau in Business Analytics interviews?
BI tool questions test whether you can turn data into reliable, fast dashboards. Interviewers cover data modelling with star schemas, DAX measures and filter context, Power Query, Tableau LOD expressions, row-level security, refresh and performance tuning. Scenario questions focus on numbers not matching, slow reports and designing dashboards that leadership actually uses for decisions.
How should I use the Power BI and Tableau sheet?
Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.
More question sheets
Case Studies and Guesstimates questionsExcel for Business Analysts questionsRequirements and Agile questionsSQL for Business Analysis questionsBusiness Metrics and KPIs questionsStakeholder Communication questionsProduct Analytics questionsProcess Modelling and BPMN questionsFinancial and Business Analysis questionsUAT and BA Documentation questions