Data Analyst Interview Questions for SQL, Power BI, Excel & Business Skills
A free, no-login guide to the SQL, Power BI, Excel, Tableau, Finance, and Communication questions that come up most often in Data Analyst, BI Analyst, and Business Analyst interviews — with clear explanations and real workplace examples. Useful for freshers, experienced analysts, and last-minute interview revision.
SQL & Excel Interview Questions and Answers
Commonly asked SQL interview questions for data analysts cover filtering, joins, and window functions. Excel interview questions for freshers focus on lookups and day-to-day data-cleaning tasks.
Q.Which SQL clause is used to filter grouped records?
A.HAVING
HAVING filters grouped data after aggregation, while WHERE filters rows before grouping — a distinction that comes up in almost every SQL interview.
Q.Which function can rank rows within a partition without skipping rank values after ties?
A.DENSE_RANK()
DENSE_RANK assigns the same rank to ties and continues with the next consecutive rank — a common window-function interview question.
Q.Which Excel function is commonly used to search vertically in a table?
A.VLOOKUP
VLOOKUP searches for a value in the first column of a range and returns a value from another column — a frequently asked Excel interview question for freshers.
Power BI & Tableau Interview Questions
Power BI interview questions frequently focus on Power Query, relationships, and DAX. Tableau interview questions cover dimensions, measures, and dashboard design.
Q.What is the main purpose of Power Query in Power BI?
A.Cleaning and transforming data
Power Query connects, cleans, shapes, and transforms data before it's loaded into the model — a foundational Power BI interview question.
Q.What does a relationship in Power BI connect?
A.Tables using related columns
Relationships connect tables so measures and filters work correctly across a data model — commonly asked alongside DAX questions.
Finance & Business Analyst Interview Questions
Business analyst interview questions often test basic finance concepts — revenue, profit, and margin — since analysts are expected to speak the language of the business.
Q.How is profit generally calculated?
A.Revenue − Cost
Profit is the amount left after subtracting total costs from revenue — a basic finance question frequently asked in business analyst interviews.
Q.If profit is ₹3,00,000 and revenue is ₹10,00,000, what is the profit margin?
A.30%
Profit margin = Profit ÷ Revenue × 100. Analysts use this to compare which product or region is more profitable.
Analyst Communication Interview Questions
Interviewers regularly test how clearly a candidate can communicate with stakeholders — a skill just as important as technical ability for a data analyst role.
Q.What should a good stakeholder update include?
A.Status, issue, impact, and next step
A clear update tells stakeholders what happened, why it matters, and what will happen next — a frequently asked analyst interview question.
Practice all of this — free, in one screen
300+ SQL, Power BI, Excel, Finance, and Communication interview questions and answers, with instant explanations and real workplace examples.
Start Practice NowhummPrep · A hummOut product