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

MIS and Reporting Analyst Interview Questions & Answers

40 questions for MIS and Reporting Analyst interviews — 25 easy, 15 medium.

About the MIS and Reporting Analyst role

An MIS or Reporting Analyst automates recurring business reports, moving teams from manual Excel files to scheduled Tableau dashboards. They manage data refreshes, validate numbers with finance or operations, set up subscriptions and handle report requests. The role is common in banks, BPOs, retail and manufacturing companies and is a good starting point for BI careers.

Report automation Excel Data validation Extract refresh Subscriptions
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 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.
02

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

What are the main products in the Tableau platform?

Tableau FundamentalsEasy
Save to ▾
Show answer
The core products are Tableau Desktop for authoring, Tableau Prep Builder for cleaning and shaping data, Tableau Server for on-premise sharing, Tableau Cloud for hosted sharing, and Tableau Public for free public visualisations. Tableau Reader was retired, and newer features such as Tableau Pulse deliver metric summaries. In most Indian analytics teams, analysts build in Desktop and publish to Server or Cloud for business users.
04

What is a union and when do you use it?

Data Connections and ModellingMedium
Save to ▾
Show answer
A union stacks tables with the same structure on top of each other, adding rows rather than columns. It is used for monthly or regional files such as Sales_Jan, Sales_Feb and Sales_Mar. Tableau supports manual unions and wildcard unions that pick up files or sheets matching a name pattern, and adds Table Name and Path fields to identify the source of each row.
05

What is the difference between a live connection and an extract?

Data Connections and ModellingEasy
Save to ▾
Show answer
A live connection sends queries directly to the source database each time the view changes, so data is always current but performance depends on the database. An extract is a compressed snapshot stored in the Hyper format, which is usually faster and works offline, but must be refreshed on a schedule. Teams choose live for real-time needs and extracts for speed or slow sources.
06

What is the Tableau order of operations?

Tableau FundamentalsMedium
Save to ▾
Show answer
Tableau applies filters and calculations in a fixed sequence: extract filters, data source filters, context filters, then sets, Top N and FIXED LOD, then dimension filters, then INCLUDE and EXCLUDE LOD and blending, then measure filters, then table calculations, totals and reference lines, and finally table calculation filters and trend lines. Knowing this explains why a FIXED calculation ignores a normal dimension filter unless it is added to context.
07

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

Your Excel source has merged header cells and title rows, and Tableau reads it incorrectly. What do you do?

Data Connections and ModellingEasy
Save to ▾
Show answer
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.
09

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

How do you create a filter action from a map to other sheets?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Go to Dashboard, Actions, Add Action, Filter. Choose the map as source sheet, select the target sheets, set run on Select, and choose what happens when clearing the selection, such as Show all values. Under Filter, choose Selected Fields and map State to State. Test by clicking a state and checking that the bar and trend charts update.
11

How do you connect Tableau to an Excel file with multiple sheets?

Data Connections and ModellingEasy
Save to ▾
Show answer
Open Tableau Desktop, choose Microsoft Excel under Connect, select the file, and the sheets appear on the left. Drag the main sheet to the canvas, then drag another sheet next to it to create a relationship and choose matching fields. Use Data Interpreter if the sheet has titles or merged cells. Go to a worksheet to start building views.
12

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

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

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

How do you set up an incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
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.
16

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

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

What are relative date filters?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
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.
19

Users complain that a dashboard with 10 dropdown filters is slow. How do you improve it?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
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.
20

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

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

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

Why do you want to work as a Tableau developer or BI analyst?

Tableau FundamentalsEasy
Save to ▾
Show answer
Situation: during my final-year project I had sales data in spreadsheets that nobody could read quickly. Task: I wanted to make the trends obvious. Action: I learned Tableau, built a dashboard with KPIs, trends and filters, and presented it to faculty. Result: decisions took minutes instead of hours. I enjoy turning data into decisions, and a BI role lets me do that daily while growing in SQL and analytics.
24

What is the difference between joining, blending and relationships?

Data Connections and ModellingMedium
Save to ▾
Show answer
Joins merge tables at row level before analysis and can duplicate values. Blending queries each source separately, aggregates the secondary to the linking fields, and combines results per sheet, so it works across sources but has limitations such as no COUNTD from secondary in some cases. Relationships define flexible links and let Tableau choose joins per view while keeping each table's grain.
25

How do you create a hierarchy and a group from the Data pane?

Tableau FundamentalsMedium
Save to ▾
Show answer
For a hierarchy, drag Sub-Category onto Category in the Data pane and name it, then drag Product below Sub-Category. For a group, right-click a dimension, choose Create, then Group, select members with Ctrl, and click Group, renaming it. Optionally tick Include Other to bucket remaining members. Both appear as new fields and can be used on any sheet.
26

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

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

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

What is the difference between a filter and a parameter?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A filter directly restricts data in the view based on field values and can show multiple selections. A parameter is a single value variable that users change, and it affects the view only through calculations or features that reference it. Filters are tied to data fields; parameters are global and can be used across data sources, making them useful for switching measures or dimensions.
30

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

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

How do you build a dynamic Top 10 customers chart?

Tableau FundamentalsMedium
Save to ▾
Show answer
Drag Customer Name to Rows and SUM(Sales) to Columns. Drag Customer Name to Filters, open the Top tab, choose By field, Top 10 by Sales Sum. For a flexible version, create an integer parameter and select it instead of the fixed 10, then show the parameter control. If other filters must apply first, add them to context so Top N works on filtered data.
33

Your dashboard looks perfect on your laptop but broken on the manager's screen. How do you fix it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
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.
34

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

What join types are available in Tableau?

Data Connections and ModellingEasy
Save to ▾
Show answer
Tableau supports inner, left, right and full outer joins in the physical layer. Inner keeps matching rows only, left keeps all rows from the left table, right keeps all rows from the right, and full outer keeps everything with nulls where no match exists. You can also create join calculations when keys need transformation, such as trimming or changing case, before matching.
36

Where do you see yourself in five years in BI and analytics?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
I see myself growing from building dashboards to owning analytics for a business area. In the first two years I want to master Tableau, SQL and data modelling and get certified. Later I want to design data sources, mentor juniors and work closely with business leaders on decisions. I would like to grow within one organisation where I can see the long-term impact of my work.
37

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

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

How do you use pivot in Tableau to reshape monthly columns into rows?

Data Connections and ModellingMedium
Save to ▾
Show answer
On the data source page, select the month columns such as Jan, Feb and Mar using Ctrl, right-click and choose Pivot. Tableau creates two fields, Pivot Field Names and Pivot Field Values. Rename them to Month and Sales. This converts wide data into long format, which works better for time-series charts and filters. The same is possible in Tableau Prep.
40

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.

Frequently asked questions

What does a MIS and Reporting Analyst do?

An MIS or Reporting Analyst automates recurring business reports, moving teams from manual Excel files to scheduled Tableau dashboards. They manage data refreshes, validate numbers with finance or operations, set up subscriptions and handle report requests. The role is common in banks, BPOs, retail and manufacturing companies and is a good starting point for BI careers.

Which skills are tested in a MIS and Reporting Analyst interview?

Expect questions on Report automation, Excel, Data validation, Extract refresh, Subscriptions. Most rounds also ask you to explain a project and solve one practical problem live.

How do I prepare for a MIS and Reporting Analyst interview?

Revise Tableau Fundamentals, Data Connections and Modelling, 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 questionsData Connections and Modelling questionsFilters, Parameters and Actions questions

Other roles

Tableau DeveloperBI AnalystData Analyst (Tableau)Senior 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