✅ 20 Data Analyst Interview Questions

1. What is data analysis
The process of inspecting, cleaning, transforming, and modeling data to discover useful information and support decision-making.

2. What tools do data analysts commonly use
Excel, SQL, Python, R, Tableau, Power BI, SAS, and Google Sheets. Each tool serves different purposes like querying, visualization, or statistical analysis.

3. What is the difference between data analyst and data scientist
• Data Analyst: Focuses on interpreting existing data and generating reports
• Data Scientist: Builds predictive models and algorithms using advanced techniques

4. How do you handle missing data
• Remove rows
• Impute values (mean, median, mode)
• Use algorithms that handle missing data
• Flag missing values for analysis

5. What is the difference between INNER JOIN and LEFT JOIN in SQL
• INNER JOIN: Returns only matching rows
• LEFT JOIN: Returns all rows from the left table and matching rows from the right

6. What is normalization in databases
Organizing data to reduce redundancy and improve integrity. Common forms: 1NF, 2NF, 3NF.

7. How do you ensure data quality
• Validate data sources
• Check for duplicates and missing values
• Use consistency checks
• Automate data cleaning pipelines

8. What is the difference between structured and unstructured data
• Structured: Organized in rows and columns (e.g., SQL tables)
• Unstructured: No fixed format (e.g., images, emails, social media)

9. What is exploratory data analysis (EDA)
Initial investigation of data using visualizations and statistics to uncover patterns, anomalies, and relationships.

10. How do you visualize data effectively
Choose the right chart type (bar, line, pie, scatter), use clear labels, avoid clutter, and highlight key insights.

11. What is the difference between COUNT, COUNT(*) and COUNT(column) in SQL
• COUNT(*): Counts all rows
• COUNT(column): Counts non-null values in that column

12. What is a pivot table
A tool in Excel or BI platforms that summarizes data by grouping and aggregating values dynamically.

13. How do you calculate correlation between two variables
Use Pearson correlation coefficient in Python (df.corr()), R, or Excel. Values range from -1 to +1.

14. What is the difference between a dashboard and a report
• Dashboard: Interactive, real-time visual summary
• Report: Static or scheduled document with detailed analysis

15. What is the purpose of GROUP BY in SQL
Used to aggregate data across rows that share a common value in one or more columns.

16. What is the difference between WHERE and HAVING in SQL
• WHERE: Filters rows before aggregation
• HAVING: Filters groups after aggregation

17. How do you handle outliers in data
• Remove or cap them
• Use robust statistical methods
• Transform data (e.g., log scale)

18. What is the difference between mean, median, and mode
• Mean: Average
• Median: Middle value
• Mode: Most frequent value

19. What is time series analysis
Analyzing data points collected over time to identify trends, seasonality, and make forecasts.

20. How do you communicate insights to non-technical stakeholders
Use simple language, visualizations, storytelling, and focus on business impact rather than technical jargon.

👍 React for more Interview Resources