Post #2388

✅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