Key takeaways
- Fresher interviews test basics and clear thinking more than advanced tricks.
- Expect simple SQL (joins, GROUP BY), Excel (lookups, PivotTables) and statistics (mean, median).
- Project questions are common, so know every step of your projects.
- HR questions check motivation, teamwork and learning attitude.
- Short, honest answers with one example are better than long memorised ones.
What is data analyst interview questions for freshers?
What do interviewers want from freshers?
They look for a clear understanding of basics, a habit of checking results and the ability to learn. They do not expect years of experience. Answer in two or three sentences, give a small example and stop. If you do not know, say how you would find out.
What basic concept questions come up?
What is data analysis? Collecting, cleaning and examining data to find patterns that support decisions. Checks: can you explain simply.
Structured versus unstructured data? Structured data fits tables with fixed columns, such as sales records. Unstructured data has no fixed form, such as emails or images.
What is data cleaning? Fixing or removing wrong, missing or duplicate data so that analysis is reliable, for example standardising date formats and removing repeated rows.
What is an outlier? A value far from the others. Check whether it is an error or a real event before removing it.
Mean, median and mode? The mean is the average, the median is the middle value and the mode is the most common. Use the median when a few very large values distort the mean.
What is a KPI? A key performance indicator is a measure tied to a goal, such as conversion rate or monthly revenue.
What SQL questions are common?
Difference between WHERE and HAVING? WHERE filters rows before grouping. HAVING filters groups after aggregation.
Inner join versus left join? An inner join keeps only matching rows. A left join keeps all rows from the left table and shows NULL where no match exists.
How do you find duplicates? Group by the columns that should be unique and keep groups where the count is greater than one.
What is a primary key? A column or set of columns that uniquely identifies each row and cannot be NULL.
What Excel questions are common?
VLOOKUP versus XLOOKUP? Both look up a value; XLOOKUP is more flexible because it searches any column and does not break when columns move.
What is a PivotTable? A tool that summarises data by dragging fields into rows, columns and values, without writing formulas.
How do you handle blanks? Decide whether they mean zero or unknown, then filter, fill or flag them, and record the choice.
What chart questions come up?
Which chart for a trend? A line chart. For comparing categories? A bar chart. Why avoid 3D charts? They distort sizes and make values hard to read.
What project questions should I prepare?
Be ready to explain the question, the data source, the cleaning steps, the main result and the limits for each project. Examples of follow-ups: "Why did you choose that chart?", "How did you check your numbers?" and "What would you do differently?" Answer with specific steps from your own work.
What HR questions are common?
Tell me about yourself. Give your background, your skills and why you chose analytics, in under a minute. Why this company? Mention the product, the data work or the learning opportunity, with one true reason. Describe a mistake and what you learned. Pick a small real one, explain how you fixed it and what you now do to prevent it. Where do you see yourself in a few years? Say that you want to grow your skills and take on more responsibility.
How should I handle a question I cannot answer?
Say "I have not worked with that, but I would approach it like this", then give a sensible first step. Never invent experience.
How do I explain a project in two minutes?
Use five parts: the question, the data, what you did, the result and what you would improve. For example: "I analysed monthly sales of a made-up store to find which categories drive revenue. I cleaned dates and duplicates in Python, grouped sales by category and month, and built a bar chart and a trend line. Electronics and clothing made up most revenue, with a peak before festivals. Next time I would add customer data to look at repeat purchases." Practise it aloud until it sounds natural.
What simple practical tasks are asked?
Typical tasks are: write a query to find the top three products by sales, compute the average order value, count customers per city, remove duplicate rows in Excel or create a PivotTable that shows revenue by month. Practise each on a small sample so that you can finish in five to ten minutes and explain the steps while you work.
What attitude helps in a fresher interview?
Show curiosity and honesty. Ask clarifying questions, say when you are unsure, and show how you would check results. Mention what you are learning at the moment and how you practise. Interviewers know freshers are still learning; they hire people who learn quickly and communicate well.
Download Data Analyst Interview Questions for Freshers PDF
Data Analyst Interview Questions for Freshers PDF
The PDF carries the same content as this page in a clean, print-ready layout, so you can read it offline and keep it for revision.
4 pages · 93 KB · PDF · Updated 5 Nov 2026