1.What are the key responsibilities of a data analyst?
2.How do you handle missing or incomplete data?
3.What is the difference between data cleaning and data transformation?
4.How do you prioritize tasks when working on multiple projects?
5.Describe a challenging data analysis project you worked on.
š¹ SQL Interview Questions
1.What is the difference between WHERE and HAVING clauses?
2.What is a window function? Give an example.
3.How would you find duplicate records in a table?
4.How do you perform a left join vs inner join?
5.Write a query to get the second highest salary from a table.
6.What are aggregate functions in SQL?
7.How do you optimize a slow SQL query?
8.What is a CTE (Common Table Expression)?
9.What are indexes and how do they impact performance?
10.How would you handle NULL values in SQL queries?
š¹ Excel & Spreadsheet-Based Questions
1.What are pivot tables and when would you use them?
2.Explain VLOOKUP, HLOOKUP, and INDEX-MATCH.
3.How do you remove duplicates in Excel?
4.What is the difference between absolute and relative references?
5.How do you use conditional formatting?
š¹ Data Visualization / BI Tools (Power BI, Tableau, etc.)
1.How do you choose the right chart for your data?
2.What are slicers in Power BI or Tableau?
3.Explain calculated columns vs measures in Power BI.
4.How do you handle large datasets in visualization tools?
5.What are some best practices for dashboard design?
š¹ Statistics & Data Interpretation
1.What is the difference between correlation and causation?
2.What is a p-value?
3.Explain standard deviation and variance.
4.What is regression analysis?
5.What is the Central Limit Theorem?
š¹ Business & Domain Knowledge
1.How do you define and track KPIs?
2.Describe how you would analyze customer churn.
3.How do you balance business requirements with technical constraints?
4.How do you explain your findings to non-technical stakeholders?
5.Give an example of a time your analysis impacted a business decision
š¹ Scenario-Based Questions
1.A dataset has 30% missing values ā what steps would you take?
2.You are asked to reduce report delivery time by 50% ā what do you do?
3.Management questions the accuracy of your report ā how do you handle it?
4.How would you identify sales trends over time?
5.You discover a major data quality issue. What are your next steps?
Data Scientist Interview Questions-TCS
By Siva
Published On:
---Advertisement---
