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

MIS Reporting Analyst Interview Questions & Answers

40 questions for MIS Reporting Analyst interviews — 28 easy, 11 medium, 1 hard.

About the MIS Reporting Analyst role

MIS Reporting Analysts prepare regular management reports on sales, collections, operations or HR, and increasingly automate them with Power BI instead of manual Excel. They consolidate files, apply business rules, reconcile numbers with source systems and deliver daily, weekly and monthly dashboards. The role is common in banks, BPOs, NBFCs and manufacturing firms and suits freshers with strong Excel skills.

Advanced Excel Power Query automation Report scheduling Data reconciliation KPI tracking
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 Power Query and where is it used?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Power Query is the data connection and transformation engine in Power BI, Excel, dataflows and Fabric Data Factory. It lets you connect to hundreds of sources and shape data with a recorded series of steps, such as removing columns, changing types, merging and unpivoting. Behind the interface each step is written in the M language. Steps re-run automatically on every refresh, making cleaning repeatable.
02

What is a semantic model in Power BI?

Power BI FundamentalsEasy
Save to ▾
Show answer
A semantic model, earlier called a dataset, is the published data model behind reports: tables, relationships, measures, hierarchies, security roles and refresh settings. Many reports can connect to one shared semantic model, which keeps business logic and numbers consistent across teams. Certified or promoted endorsements help users find trusted models. Build permission controls who can create new reports on it.
03

What makes a good dashboard design?

Visualisation and Report DesignEasy
Save to ▾
Show answer
A good dashboard answers specific questions for a specific audience. Put the most important KPIs at the top left, follow a logical flow from summary to detail, use a few consistent colours with one highlight colour, and choose simple visuals like bar and line charts. Remove clutter such as 3D effects and heavy borders, label clearly, show context like targets or last year, and keep each page to a manageable number of visuals.
04

What is the difference between a report and a dashboard in Power BI?

Power BI FundamentalsEasy
Save to ▾
Show answer
A report is a multi-page, fully interactive document built on one semantic model, with slicers, filters, drill-through and cross-highlighting. A dashboard is a single-page canvas in the Power BI Service made of pinned tiles that can come from several reports and models; it is used for a quick at-a-glance view. Dashboards are created only in the Service, while reports are usually built in Desktop.
05

Why should you set data types correctly in Power Query?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Correct data types make sorting, filtering, aggregation and relationships work properly; text-typed numbers cannot be summed and mismatched key types break relationships. Types also affect compression and model size, for example whole numbers compress better than decimals or text. Set types once near the end of a query and avoid repeated automatic Changed Type steps, which can fail when column names change.
06

A manager wants a single KPI view combining sales, HR and finance reports. What do you build?

Power BI FundamentalsEasy
Save to ▾
Show answer
I would build a dashboard in the Power BI Service and pin the key KPI tiles from each report, so the manager sees all areas on one page and can click through to details. If the KPIs need cross-filtering together, a better option is a summary report built on a shared model or composite model that combines the needed tables, published inside an app.
07

How do you connect Power BI Desktop to a SQL Server database?

Power BI FundamentalsEasy
Save to ▾
Show answer
Use Home, Get Data, SQL Server. Enter the server name and optionally the database, choose Import or DirectQuery, and optionally paste a native SQL query under Advanced options. Choose Windows or database authentication, then pick tables in the Navigator and select Transform Data to clean them in Power Query. For scheduled refresh of an on-premises server, an on-premises data gateway must be configured in the Service.
08

Every month a new Excel file arrives in a folder. How do you load all of them automatically?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Use the Folder connector, or SharePoint Folder for files on SharePoint, pointing to the folder, filter to the right file extension and naming pattern, then use Combine Files. Power Query creates a sample-file transform function applied to every file and appends the results. New files dropped into the folder are included on the next refresh, as long as their structure matches the sample.
09

How do you stay current with frequent Power BI updates?

Performance Optimisation and AdministrationEasy
Save to ▾
Show answer
Power BI releases features monthly, so I read the monthly update blog and Fabric release notes, try new features on a test report, and follow community experts and forums. I keep a short list of features relevant to our team, such as visual calculations or TMDL view, and share a five-minute demo in team meetings when something will save us effort.
10

What is the difference between SUM and SUMX?

DAX FundamentalsEasy
Save to ▾
Show answer
SUM aggregates a single column, such as SUM(Sales[Amount]). SUMX is an iterator: it evaluates an expression for each row of a table and then sums the results, such as SUMX(Sales, Sales[Qty] * Sales[Price]). Use SUMX when you need row-level calculations before aggregating. Other iterators include AVERAGEX, MAXX, COUNTX and RANKX.
11

Write a measure for percentage of grand total sales.

DAX FundamentalsMedium
Save to ▾
Show answer
Sales % of Total = DIVIDE( [Total Sales], CALCULATE([Total Sales], REMOVEFILTERS('Product')) ) This gives each product's share of total across all products. Use ALLSELECTED('Product') instead if the denominator should respect slicer selections on products.
12

What is a Power BI workspace and what roles does it have?

Power BI FundamentalsEasy
Save to ▾
Show answer
A workspace is a container in the Power BI Service for semantic models, reports, dashboards, dataflows and other items that a team works on together. Roles are Admin, Member, Contributor and Viewer. Admins manage everything including access, Members can publish and share, Contributors can create and edit content but not share, and Viewers can only view. Consumers are usually given access through an app instead.
13

Why do you want to work as a Power BI developer?

Power BI FundamentalsEasy
Save to ▾
Show answer
I like turning raw data into clear answers that people can act on. In my projects I enjoyed the full flow: cleaning messy Excel and SQL data, designing a proper model, writing DAX and making reports that users actually open every day. Power BI is widely used across Indian companies and global clients, so the role offers strong growth into data analytics, data engineering with Fabric, or BI architecture.
14

Leadership wants to see a red, amber, green status for each region against target. How do you build it?

Visualisation and Report DesignEasy
Save to ▾
Show answer
I would create a measure for achievement percentage, DIVIDE(Sales, Target), and a status measure returning a colour or icon based on thresholds agreed with leadership, such as below 90 percent red, 90 to 100 amber, above 100 green. Apply it through conditional formatting in a matrix or as icon rules. I would also add text or icons so status is clear without colour.
15

Describe a time you cleaned very messy data under a deadline.

Power Query and Data TransformationMedium
Save to ▾
Show answer
Situation: a client sent 36 monthly Excel files with merged headers and changing columns two days before a review. Task: build a consolidated sales report. Action: I used the Folder connector with a custom function that promoted the right header row, unpivoted month columns and mapped renamed fields through a lookup table. Result: the report was ready a day early, and future files loaded automatically with no manual work.
16

How do you sort a month name column correctly?

Data ModellingEasy
Save to ▾
Show answer
By default month names sort alphabetically, April first. In the Date table add a Month Number column, select the Month name column, then choose Column tools, Sort by column, Month Number. The same applies to weekday names and fiscal months. The sort column must have one value per name value, otherwise Power BI shows an error.
17

What does Unpivot do and when would you use it?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Unpivot turns columns into rows, creating attribute and value columns. It is used when data comes in a wide, report-style layout, such as months as separate columns Jan, Feb, Mar. Unpivoting them into a Month column and an Amount column gives a tall, tidy table that works well with relationships, a date table and DAX. Unpivot Other Columns is safer because new months are handled automatically.
18

What are Import, DirectQuery and Live Connection modes?

Power BI FundamentalsMedium
Save to ▾
Show answer
Import loads a compressed copy of data into the in-memory VertiPaq engine, giving the fastest queries but requiring refresh. DirectQuery sends queries to the source at view time, so data is current but performance depends on the source and some DAX is limited. Live Connection connects a report to an existing semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery tables.
19

What is the difference between Group By in Power Query and summarising in DAX?

Power Query and Data TransformationMedium
Save to ▾
Show answer
Group By in Power Query aggregates rows at refresh time and stores only the summarised table, reducing model size, which is useful when detail is never needed. Summarising in DAX through measures keeps detail in the model and aggregates dynamically for any filter at query time. Use Power Query grouping for fixed summaries such as monthly snapshots, and DAX measures when users need flexible slicing.
20

How do you set up drill-through to a customer details page?

Visualisation and Report DesignEasy
Save to ▾
Show answer
Create a new page named Customer Details, add visuals showing customer information, orders and trends, and drag Customer Name or Customer ID into the Drill through well in the Visualizations pane. Power BI adds a back button automatically. Users can now right-click a customer in any visual and choose Drill through, Customer Details, and the page opens filtered to that customer.
21

What is conditional formatting and where can you apply it?

Visualisation and Report DesignEasy
Save to ▾
Show answer
Conditional formatting changes colours, icons, data bars or font based on values or rules, helping users spot good and bad performance quickly. You can apply it to table and matrix cells, backgrounds, font colour, chart data colours and titles using field values, rules or a measure that returns a colour code. A measure returning hex colours gives full control, such as red when below target.
22

How do you build a custom tooltip page?

Visualisation and Report DesignMedium
Save to ▾
Show answer
Create a new page, set Page information, Allow use as tooltip on, and set Canvas settings to the Tooltip size. Add small visuals like a monthly trend line for the hovered item. On the main visual, go to Format, Tooltips, set Type to Report page and select the tooltip page. Fields in the main visual automatically filter the tooltip page on hover.
23

What licence types exist for Power BI?

Power BI FundamentalsMedium
Save to ▾
Show answer
Power BI Free lets a user build in Desktop and use My workspace but not share content. Power BI Pro is needed to publish to shared workspaces and share with other Pro users. Premium Per User adds larger models, more refreshes and premium features per user. Fabric capacity (F SKUs) provides dedicated capacity; at F64 and above, viewers with a free licence can consume shared content.
24

What is the difference between Power Query M and DAX?

Power Query and Data TransformationEasy
Save to ▾
Show answer
M is the language of Power Query, used at refresh time to extract, clean and shape data before it enters the model, such as merging tables or splitting columns. DAX is used after data is loaded, to define measures, calculated columns and security that evaluate in filter context at query time. As a rule, do row-level shaping in M or the source and dynamic calculations in DAX.
25

How do you split a full name column and clean text in Power Query?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Select the column, use Transform, Split Column by Delimiter (space, leftmost) to get first and last names. Then use Format, Trim and Clean to remove extra spaces and non-printable characters, and Capitalize Each Word for consistent case. In M: = Table.TransformColumns(Source, {{"Name", each Text.Proper(Text.Trim(_)), type text}})
26

How do you manage multiple report requests from different departments with tight deadlines?

Power BI Service, Sharing and SecurityEasy
Save to ▾
Show answer
I log every request with its business goal, deadline and effort, and agree priorities with my manager instead of choosing alone. I reuse shared semantic models so new reports are faster, and I communicate realistic timelines early. In one quarter this helped me deliver eight reports, with two lower-priority ones moved by a week after discussion with requesters, without escalations.
27

What is time intelligence in DAX?

Advanced DAX and Time IntelligenceEasy
Save to ▾
Show answer
Time intelligence functions compare values across periods using a proper date table, for example year-to-date, same period last year, moving averages and quarter-over-quarter growth. Key functions are TOTALYTD, DATESYTD, SAMEPERIODLASTYEAR, DATEADD, PARALLELPERIOD and DATESINPERIOD. They return sets of dates used as CALCULATE filters, so the date table must be contiguous, marked as a date table and related to the facts.
28

What is the difference between Merge Queries and Append Queries?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Merge is like a SQL join: it combines columns from two tables based on matching key columns, with join kinds like left outer, inner, full outer, left anti and right anti. Append stacks rows of tables with the same structure on top of each other, like a SQL UNION ALL, for example combining monthly sales files. Merge widens a table, append lengthens it.
29

What is the PBIP project format and why use it?

Power BI FundamentalsHard
Save to ▾
Show answer
Power BI Project (PBIP) saves a report and model as folders of text files instead of one binary PBIX file. The semantic model is stored in TMDL or TMSL and the report in JSON definitions. This makes Git version control, code reviews, diffs and merge of changes practical, and works with Fabric Git integration and deployment pipelines. It is preferred for team development and CI/CD.
30

What are tooltips and report page tooltips?

Visualisation and Report DesignMedium
Save to ▾
Show answer
Default tooltips show field values when hovering over a data point. Report page tooltips let you design a small custom page, set as a tooltip page type, showing extra visuals like a mini trend chart for the hovered category. They add detail without cluttering the main page. Keep tooltip pages light because they run queries on every hover.
31

How do you add a conditional column in Power Query?

Power Query and Data TransformationEasy
Save to ▾
Show answer
Use Add Column, Conditional Column and define rules, or write M directly: = Table.AddColumn(Source, "Band", each if [Amount] >= 100000 then "High" else if [Amount] >= 25000 then "Medium" else "Low", type text) Adding the type at the end avoids an extra Changed Type step. Conditional columns built here are computed at refresh, not at query time.
32

What is query folding and why does it matter?

Power Query and Data TransformationMedium
Save to ▾
Show answer
Query folding is when Power Query translates transformation steps into a native source query, such as SQL, so the source does the work and only the result is loaded. It makes refreshes much faster and is required for incremental refresh and efficient DirectQuery. Steps like filtering, removing columns and grouping usually fold on SQL sources, while some custom M functions or adding an index column can break folding.
33

What is the difference between Power BI and Excel for reporting?

Power BI FundamentalsEasy
Save to ▾
Show answer
Excel is flexible for ad hoc analysis and small models but struggles with large data, version control and secure sharing. Power BI handles millions of rows with a compressed columnar engine, central semantic models, scheduled refresh, row-level security and interactive web and mobile sharing. They work together: Power Query and Power Pivot exist in both, and users can analyse Power BI models in Excel.
34

Users complain the report page is cluttered with 22 visuals. How do you redesign it?

Visualisation and Report DesignMedium
Save to ▾
Show answer
I would ask which decisions the page supports and keep only visuals that answer those questions. Then group related KPIs into a top row of cards, keep two or three main charts, and move details to drill-through or tooltip pages. Slicers can move into a collapsible panel using bookmarks. Fewer visuals also make the page load faster.
35

How do you design a KPI card that shows value, target and variance?

Visualisation and Report DesignEasy
Save to ▾
Show answer
Use the new Card visual or a KPI visual with a main measure such as Total Sales, a target measure and a variance percent measure. Add conditional formatting so the variance turns red below target and green above it, and include a small trend if space allows. Keep labels short, such as Sales vs Target, and show the comparison period in the subtitle.
36

What is Power BI and what are its main components?

Power BI FundamentalsEasy
Save to ▾
Show answer
Power BI is a business intelligence platform for connecting to data, modelling it and building interactive reports and dashboards. Main components are Power BI Desktop for building reports, Power BI Service (part of Microsoft Fabric) for publishing, sharing and refresh, Power BI Mobile apps for viewing, the on-premises data gateway for refreshing local sources, and Power BI Report Server for fully on-premises hosting of paginated and Power BI reports.
37

How do you publish a report and share it with business users?

Power BI FundamentalsEasy
Save to ▾
Show answer
In Desktop, choose Publish and select a workspace. In the Service, set up the semantic model's credentials and scheduled refresh. Then create or update an app from the workspace, choose the reports and audiences, and grant access to user groups. Apps give consumers a clean, stable view while authors keep working in the workspace. Avoid sharing from My workspace for team content.
38

What are report themes and why use them?

Visualisation and Report DesignEasy
Save to ▾
Show answer
A report theme is a JSON file that sets default colours, fonts, visual styles and backgrounds for all visuals. Using a company theme keeps reports consistent with brand guidelines and saves formatting time, since new visuals adopt it automatically. Themes can be built in Desktop's theme customiser or edited as JSON and shared across the team as a standard.
39

What are bookmarks and how are they used?

Visualisation and Report DesignMedium
Save to ▾
Show answer
Bookmarks capture the current state of a report page, including filters, slicers, visual visibility and sort order. They are used for storytelling, toggling between chart and table views with buttons, creating custom navigation, and resetting filters. Combined with the selection pane, they show and hide visuals. Too many bookmarks become hard to maintain, so field parameters are often a simpler alternative for switching measures.
40

What are query parameters in Power Query?

Power Query and Data TransformationMedium
Save to ▾
Show answer
Parameters are named values used inside queries, such as server name, database, file path or a date range. They let you switch from a development to a production database without editing each query, and they are required for incremental refresh through RangeStart and RangeEnd. Parameters can be changed in the Service under semantic model settings, which helps deployment pipelines between environments.

Frequently asked questions

What does a MIS Reporting Analyst do?

MIS Reporting Analysts prepare regular management reports on sales, collections, operations or HR, and increasingly automate them with Power BI instead of manual Excel. They consolidate files, apply business rules, reconcile numbers with source systems and deliver daily, weekly and monthly dashboards. The role is common in banks, BPOs, NBFCs and manufacturing firms and suits freshers with strong Excel skills.

Which skills are tested in a MIS Reporting Analyst interview?

Expect questions on Advanced Excel, Power Query automation, Report scheduling, Data reconciliation, KPI tracking. Most rounds also ask you to explain a project and solve one practical problem live.

How do I prepare for a MIS Reporting Analyst interview?

Revise Power Query and Data Transformation, Power BI Fundamentals, Visualisation and Report Design 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

Power Query and Data Transformation questionsPower BI Fundamentals questionsVisualisation and Report Design questions

Other roles

Power BI DeveloperData Analyst (Power BI)BI ConsultantPower BI / BI ArchitectSenior Power BI Developer

More ways to practise

Company-wise Power BI questionsExperience-wise Power BI questionsRole-wise Power BI questionsCity-wise Power BI questionsMost asked Power BI questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsPower BI mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsPower BI topic sheets