Data analyst interview questions for freshers (India)

Technical and role questions

1. 1. What is the difference between mean, median, and mode?

   Mean is the average of all numbers, median is the middle value when data is sorted, and mode is the most frequently occurring value. Median is useful for skewed data, while mean is affected by outliers.

2. 2. Explain the concept of normalization in databases.

   Normalization organizes data to reduce redundancy and improve integrity by dividing tables and defining relationships. It ensures efficient storage and avoids update anomalies.

3. 3. What is a primary key in a database?

   A primary key uniquely identifies each record in a table. It cannot be null and must contain unique values to ensure each row is distinct.

4. 4. How do you handle missing data in a dataset?

   You can handle missing data by removing rows, imputing values using mean/median/mode, or using algorithms that support missing values, depending on the context and data size.

5. 5. Write an SQL query to find the second highest salary from an employee table.

   To find the second highest salary, you can use a subquery to first find the maximum salary, then select the maximum salary that is less than that. Alternatively, use `DENSE_RANK()` or `ROW_NUMBER()` with an `ORDER BY` clause and filter for the second rank.

6. 6. What is the difference between INNER JOIN and LEFT JOIN in SQL?

   INNER JOIN returns rows with matching keys in both tables, while LEFT JOIN returns all rows from the left table and matched rows from the right, filling NULL if no match.

7. 7. Explain the term ‘data cleaning’ and why it is important.

   Data cleaning involves fixing or removing incorrect, incomplete, or irrelevant data. It improves data quality and ensures accurate analysis results.

8. 8. What are outliers and how can you detect them?

   Outliers are data points significantly different from others. They can be detected using statistical methods like Z-score, IQR, or visualization tools like box plots.

9. 9. Describe the difference between structured and unstructured data.

   Structured data is organized in rows and columns, like databases. Unstructured data includes text, images, or videos without a predefined format.

10. 10. What is a pivot table and how is it useful in Excel?

    A pivot table summarizes large data sets by grouping and aggregating data, making it easier to analyze patterns and trends quickly.

11. 11. How do you calculate correlation between two variables?

    Correlation measures the strength and direction of a linear relationship between two variables, calculated using Pearson’s correlation coefficient formula.

12. 12. Explain the difference between COUNT, COUNT DISTINCT, and COUNT(*) in SQL.

    COUNT(*) counts all rows, including duplicates and nulls. COUNT(column_name) counts non-null values in a specified column. COUNT(DISTINCT column_name) counts only unique, non-null values in a specified column. Each serves different aggregation needs.

13. 13. What is data visualization and why is it important?

    Data visualization presents data graphically, helping to identify patterns, trends, and insights that are harder to see in raw data.

14. 14. How would you approach analyzing a dataset with multiple categorical variables?

    I would use frequency tables, cross-tabulations, and visualization like bar charts or heatmaps to understand relationships between categorical variables.

15. 15. Explain the concept of hypothesis testing in statistics.

    Hypothesis testing evaluates if a claim about a population parameter is true using sample data, by comparing p-value against a significance level.

16. 16. What is the difference between a clustered and non-clustered index in databases?

    A clustered index physically sorts and stores the data rows in the table based on the index key, meaning the data itself is stored in the index order. A non-clustered index creates a separate logical structure containing the index key and pointers to the actual data rows, which are stored elsewhere.

17. 17. How do you optimize a slow SQL query?

    I analyze the query plan, add indexes on filtered columns, avoid SELECT *, and reduce joins or subqueries where possible.

18. 18. What is the use of the GROUP BY clause in SQL?

    GROUP BY groups rows sharing a value in specified columns to perform aggregate functions like SUM, COUNT, or AVG on each group.

19. 19. Describe the difference between data mining and data analysis.

    Data mining discovers hidden patterns and relationships in large datasets, while data analysis interprets and summarizes data to answer specific questions.

20. 20. What is a data warehouse and how is it different from a database?

    A data warehouse stores integrated historical data from multiple sources optimized for analysis, while a database is designed for transaction processing.

Project and internship questions

1. 21. Describe your final year project and your role in it.

   In [your project], I collected and cleaned data, performed analysis using Excel and SQL, and created visualizations to present key findings.

2. 22. What challenges did you face during your project and how did you overcome them?

   During [your project], data quality was poor. I handled it by cleaning missing values and validating data sources, improving analysis accuracy.

3. 23. Which tools and techniques did you use in your project?

   I used Excel for data cleaning and pivot tables, SQL for querying data, and Tableau/Power BI for visualization to communicate results.

4. 24. How did your project impact or benefit others?

   My project [your project] helped identify trends that improved decision-making for the team, leading to better resource allocation.

5. 25. What would you do differently if you had more time for your project?

   I would incorporate more advanced analytics like predictive modeling and automate data pipelines to increase efficiency.

6. 26. How did you validate the results of your project analysis?

   I cross-checked results with multiple data sources and used statistical tests to ensure accuracy and reliability of my findings.

HR and behavioural questions

1. 27. Tell me about yourself.

   Start with your education background, mention relevant skills like SQL and Excel, briefly describe your internship or projects, and conclude with your interest in data analysis.

2. 28. Why do you want to work as a data analyst?

   I enjoy working with data to find insights that help decision-making. My skills in statistics and tools like Excel motivate me to build a career in data analysis.

3. 29. How do you handle failure or setbacks?

   I analyze what went wrong, learn from mistakes, and adjust my approach. For example, during [your project], I improved after initial errors by seeking feedback.

4. 30. What are your strengths and weaknesses?

   My strength is attention to detail and problem-solving. A weakness I’m working on is public speaking, so I practice presentations to improve confidence.

5. 31. Are you willing to relocate if required?

   Yes, I am open to relocation as it offers new learning opportunities and growth in my data analyst career.

6. 32. Where do you see yourself in five years?

   In five years, I aim to be a skilled data analyst handling complex projects and contributing to business decisions with advanced analytics.

Find data analyst openings

Practise these, then apply where hiring is live: Data analyst jobs in India, fresher data analyst jobs and remote roles open to India. Before you apply, check your resume with the free ATS resume checker and draft a letter with the free cover letter generator.