Data Scientist Interview Questions-Wipro(2-5 Years)

✅ SQL & Database Questions
1. What are different types of SQL joins?
2. How do you find duplicate records in a table?
3. What is a window function in SQL? Give examples.
4. How do you optimize a slow SQL query?
5. Explain the difference between a CTE and a subquery.
6. How would you design a normalized database schema?
7. What is the use of indexing in SQL?

✅ Python for Data Analysis
8. How do you handle missing values in a dataset using Pandas?
9. What is the difference between a list and a tuple in Python?
10. How do you remove duplicate rows from a DataFrame?
11. Explain the difference between apply() and map() functions in Pandas.
12. How do you perform group-by operations in Python?
13. How do you automate a data cleaning task using Python?
14. Explain lambda functions and their use in data analysis.

✅ Data Visualization & BI Tools
15. How do you create a dashboard in Power BI?
16. What is the difference between Power BI and Tableau?
17. Explain DAX functions and their use in Power BI.
18. How do you handle real-time data updates in Power BI?
19. What are the best practices for report performance optimization in Power BI?
20. How do you implement row-level security in Power BI?

✅ Statistical & Analytical Thinking
21. What are the key differences between descriptive and inferential statistics?
22. How do you detect and handle outliers in a dataset?
23. What is correlation? How do you measure it?
24. Explain hypothesis testing and its significance in data analysis.
25. How would you analyze sales data to find patterns?

✅ Business & Scenario-Based Questions
26. Suppose you’re given raw customer transaction data. How would you analyze it?
27. How do you present insights from data to non-technical stakeholders?
28. What key metrics would you track for an e-commerce company?
29. How would you automate a weekly sales report in Power BI?
30. What steps would you take to validate data accuracy before creating a report?