⚡ Short answer
Most data analyst interviews in Hyderabad test SQL (the most heavily), Excel, one BI tool, basic statistics and how you explain your projects. Practise writing queries by hand, prepare a 2-minute story for each project and expect at least one business scenario question.
Interview rounds
Data analyst interview questions: what each round looks like
The exact format varies by company, but most follow a similar flow.
01
Online test or screening
Aptitude, Excel and SQL questions, often on a timed platform.
02
Technical round
Live SQL, Excel or BI tasks plus questions about your projects.
03
Case or business round
A business problem where you explain how you would analyse it and which metrics matter.
04
HR and culture fit
Motivation, communication, salary expectations and notice period.
Excel questions
Excel interview questions
Excel is often the first filter, especially for freshers and reporting roles.
Excel
VLOOKUP vs XLOOKUP vs INDEX-MATCH?
VLOOKUP only looks right and breaks when columns move. INDEX-MATCH and XLOOKUP look in any direction; XLOOKUP is simpler and handles not-found values.
Excel
What is a pivot table used for?
To summarise large data quickly: totals, averages and counts by category, with filters and drill-down, without writing formulas.
Excel
How do you remove duplicates and clean data?
Remove Duplicates, TRIM, PROPER, Text to Columns, Find and Replace, and Power Query for repeatable cleaning.
Excel
What is conditional formatting?
Formatting cells automatically based on rules, such as highlighting values above target, to make patterns visible.
SQL questions
SQL interview questions
Expect the most time here. Interviewers often ask you to write the query live.
SQL
WHERE vs HAVING?
WHERE filters rows before grouping; HAVING filters groups after GROUP BY, so it can use aggregates like SUM or COUNT.
SQL
Explain the types of JOIN.
INNER returns matches only; LEFT keeps all left rows; RIGHT keeps all right rows; FULL keeps both; CROSS returns every combination.
SQL
How do you find the second-highest salary?
Use DENSE_RANK() OVER (ORDER BY salary DESC) and filter rank = 2, or a subquery with MAX below the overall MAX.
SQL
RANK vs DENSE_RANK vs ROW_NUMBER?
ROW_NUMBER is always unique; RANK leaves gaps after ties; DENSE_RANK gives ties the same rank without gaps.
SQL
What is a CTE and why use it?
A named temporary result defined with WITH. It makes complex queries readable and allows recursion.
SQL
How do you find duplicate records?
GROUP BY the key columns with HAVING COUNT(*) > 1, or use ROW_NUMBER() partitioned by those columns.
💡 Want 25+ more with full queries? Read our dedicated SQL interview questions guide.
Reading answers is not the same as saying them under pressure. Book a mock interview with a trainer.
Book a free demoPower BI and Tableau
BI tool interview questions
Expect conceptual questions plus "walk me through your dashboard".
Power BI
Calculated column vs measure?
A calculated column is computed row by row and stored in the model; a measure is calculated on the fly based on filter context. Prefer measures for aggregations.
Power BI
What is a star schema?
A central fact table (transactions) linked to dimension tables (date, product, customer). It keeps models fast and DAX simple.
Power BI
What does CALCULATE do?
It evaluates an expression under a modified filter context, which is the foundation of most advanced DAX measures.
Tableau
Dimensions vs measures in Tableau?
Dimensions are categorical fields that slice data; measures are numeric fields that get aggregated. Blue pills are discrete, green pills are continuous.
Statistics and Python
Statistics and Python questions
Usually lighter for fresher roles, but a clear answer here makes you stand out.
Statistics
Mean vs median: when to use which?
Use the median when data is skewed or has outliers (such as salaries); the mean when data is roughly symmetric.
Statistics
Correlation vs causation?
Correlation means two variables move together; causation means one causes the other. Proving causation needs experiments or careful analysis.
Python
How do you handle missing values in Pandas?
Inspect with isna().sum(), then drop with dropna() or fill with fillna() using a sensible value, and explain why you chose that approach.
Python
merge vs concat in Pandas?
merge joins tables on key columns like a SQL JOIN; concat stacks DataFrames vertically or side by side.
Scenario and HR
Scenario questions and how to approach them
There is rarely one right answer. Interviewers want to see structured thinking.
Question
How to approach it
"Sales dropped 20% last month. Why?"
Check data quality first, then break the drop down by region, product, channel and time to isolate the cause.
"Which KPIs would you track for an e-commerce app?"
Conversion rate, average order value, repeat purchase rate, cart abandonment and customer acquisition cost, tied to business goals.
"Walk me through your best project."
Problem, data, approach, tools, key insight and business impact, in about two minutes.
"How do you handle messy data?"
Describe a real example: profiling, fixing types, handling nulls and duplicates, and validating results.
"Why data analytics?"
Connect your background to a genuine interest in solving problems with data, with a specific example.
Your pre-interview checklist
✓ Practise 20+ SQL problems by writing queries without autocomplete
✓ Prepare a 2-minute story for each portfolio project
✓ Research the company's business and likely KPIs
✓ Keep your dashboard or GitHub links ready to share
✓ Prepare two thoughtful questions to ask the interviewer
FAQs
Interview prep questions, answered
Which topic is most important for a data analyst interview?
SQL. It appears in almost every technical round. After that, Excel and one BI tool.
Do freshers get asked Python questions?
Sometimes, usually basic Pandas. Many fresher roles focus on SQL, Excel and Power BI instead.
How should I explain a project with no work experience?
Treat it like real work: the business question, the data, your process, the insight and what decision it would support.
Are there take-home assignments?
Some companies give a dataset and ask for a short analysis or dashboard within a day or two. Keep it simple and clearly explained.
How many interviews does it usually take to get an offer?
It varies widely. Treat each interview as practice, note what you struggled with, and fix it before the next one.
Do you offer mock interviews?
Yes. Mock interviews and resume reviews are part of our data analytics course and placement support.